private void WebsiteJobs(Sling Sling, DateTime dtBeg, DateTime dtEnd) { string Sql = string.Format( "Select JobRno, SlingShiftId, JobDate, Crew " + "From mcJobs " + "Where JobDate Between {0} and {1} " + "And IsNull(Crew, '') <> '' " + "And IsNull(ProposalFlg, 0) = 0 " + "Order By JobDate", DB.Put(dtBeg), DB.Put(dtEnd.AddDays(1).AddSeconds(-1))); try { StringBuilder sbHtml = new StringBuilder(); sbHtml.AppendLine("<tr><td colspan=\"4\"><h2 class=\"section\">Jobs Missing Sling Shift</h2></td></tr>"); sbHtml.AppendFormat("<tr><th>Date</th><th>Job #</th><th>Sling Shift</th><th>Add Shift</th><td><label class=\"TextLink All Jobs\">All</label> <label class=\"TextLink None Jobs\">None</label></td></tr>\n"); int i = 0; DataTable dt = db.DataTable(Sql); foreach (DataRow dr in dt.Rows) { Int32 JobRno = DB.Int32(dr["JobRno"]); string SlingShiftId = DB.Str(dr["SlingShiftId"]); DateTime JobDt = DB.DtTm(dr["JobDate"]); MarvellJobs.Add(JobRno, SlingShiftId); Sling.CalendarEvent Shift = null; if (SlingShiftId.Length > 0) { Shift = Sling.FindShift(SlingShiftId); } if (Shift == null) { sbHtml.AppendFormat("<tr><td>{0}</td><td><a href='Job.aspx?JobRno={1}' target='Job'>{1}</a></td><td>{2}</td><td class=\"checkbox\"><input type=checkbox name=\"JobId_{3}\" value=\"{1}\" checked=\"checked\" class=\"Job\"></td></tr>\n", JobDt.ToShortDateString(), JobRno, SlingShiftId, ++i); } } ltlData.Text = sbHtml.ToString(); hfNumJobsIDs.Value = i.ToString(); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }