I needed to get essentially a summary by case statement for a given date. As you can see I have defined the MAX date into a variable. This example also shows using a substring of the first character in a LET statement DateTime? maxDate = (from a in context.tbl_tslog orderby a.CurrentTime select (DateTime?) a.CurrentTime ).Max(); var dbRecords = (from c in context.tbl_testlog where (c.CurrentTime >=maxDate) let range = ( c.Usr.ToUpper().Substring(0,1) == "B" ? "US" : ...
One way to do it when you have two lists (repYearlyData and otherdata) foreach (var yd in repYearlyData) { for(int d=0;d<otherdata.Count;d++) { if (yd.AssignedRep == otherdata[d].AssignedRep) { otherdata.RemoveAt(d); } } } var result = peopleList2 . Where ( p => ! peopleList1 . Any ( p2 => p2 . ID == p . ID )); public List<TeamAverages> GetRepMonthlyAverages() ...
Windows Forms using the ClientID $("#<%=chkMinCedProgramManagers.ClientID %>").find('input[type="checkbox"]').click(function () { $("#<%=btnSaveSubGroup.ClientID %>").removeAttr("disabled"); //Identify How many checkboxes are checked so that we can toggle the button var prgchecked = $('#<%=chkMinCedProgramManagers.ClientID%>').find('input[type="checkbox"]:checked').length; //Disable button if we have zero checked if (prgchecked===0) { $("#<%=btnSaveSubGroup.ClientID %>").attr("disabled", "disabled"); }; });
Comments