protected string FormatCrew(Sling.CalendarEvent Shift) { string htmlCrew = string.Empty; if (Shift.User != null) { int hr = Shift.Beg.Hour; string ap = "am"; if (hr >= 12) { ap = "pm"; if (hr > 12) { hr -= 12; } } string min = "0" + Shift.Beg.Minute.ToString(); min = min.Substring(min.Length - 2, 2); htmlCrew = string.Format("{0}:{1}{2} {3} {4}<br/>\n", hr, min, ap, Shift.User.FirstName, (Shift.User.LastName != null && Shift.User.LastName.Length > 0 ? Shift.User.LastName.Substring(0, 1) : string.Empty)); } return(htmlCrew); }
protected string FormatCrew(Sling.CalendarEvent Shift) { string htmlCrew = string.Format("<div class=\"Name\">{0} {1}</div>", Shift.User.FirstName, (Shift.User.LastName != null && Shift.User.LastName.Length > 0 ? Shift.User.LastName.Substring(0, 1) : string.Empty)) + string.Format("<div class=\"Time\">{0}-{1}</div>", FmtDateTime(Shift.Beg), FmtDateTime(Shift.End)) + "<div class=\"Reset\"></div>"; return(htmlCrew); }
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()); } }