protected void MarkConfirm() { int cRows = Str.Num(hfRow.Value); for (int iRow = 0; iRow < cRows; iRow++) { bool fConfirmed = Str.Bool(Request.Params["chkConfirmed" + iRow.ToString()]); int JobRno = Str.Num(Request.Params["hfJobRno" + iRow]); if (fConfirmed && JobRno != 0) { DateTime Tm = DateTime.Now; string Sql = "Update mcJobs Set " + "ConfirmedDtTm = " + DB.Put(Tm) + ", " + "ConfirmedBy = " + DB.Put(g.User) + ", " + "UpdatedDtTm = " + DB.PutDtTm(Tm) + ", " + "UpdatedUser = "******" " + "Where JobRno = " + JobRno; try { db.Exec(Sql); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } } } }
protected void SendConfirmEmail() { int cRows = Str.Num(hfRow.Value); for (int iRow = 0; iRow < cRows; iRow++) { bool fSend = Str.Bool(Request.Params["chkSend" + iRow.ToString()]); int JobRno = Str.Num(Request.Params["hfJobRno" + iRow]); if (fSend && JobRno != 0) { string Sql = string.Format( "Select c.Email, JobDate, Guid, Coalesce(cu.Name, c.Name) as Customer, Location, GuestArrivalTime, MealTime, EndTime, NumMenServing, NumWomenServing, NumChildServing " + "From mcJobs j " + "Inner Join Contacts c on j.ContactRno = c.ContactRno " + "Left Join Customers cu on c.CustomerRno = cu.CustomerRno " + "Where JobRno = {0}", JobRno); try { DataRow dr = db.DataRow(Sql); if (dr != null) { string Email = DB.Str(dr["Email"]); if (Email != null && Email.Length > 0) { string Subject = string.Format("Catering Confirmation for Event #{0}", JobRno); string Guid = DB.Str(dr["Guid"]); if (Guid == string.Empty) { Sql = string.Format("Update mcJobs Set Guid = NewID() Where JobRno = {0}; Select Guid From mcJobs Where JobRno = {0}", JobRno); Guid = db.SqlStr(Sql); } DateTime dtJob = DB.DtTm(dr["JobDate"]); DateTime dtDeadline = Misc.ConfirmationDeadline(dtJob); string Customer = DB.Str(dr["Customer"]); string Location = DB.Str(dr["Location"]); DateTime GuestTime = DB.DtTm(dr["GuestArrivalTime"]); DateTime BegTime = DB.DtTm(dr["MealTime"]); DateTime EndTime = DB.DtTm(dr["EndTime"]); if (GuestTime != DateTime.MinValue && GuestTime < BegTime) { BegTime = GuestTime; } string EventTime; if (EndTime == DateTime.MinValue) { EventTime = BegTime.ToString("h:mm tt").ToLower(); } else { EventTime = string.Format("{0} - {1}", BegTime.ToString("h:mm tt"), EndTime.ToString("h:mm tt")).ToLower(); } int NumServings = DB.Int32(dr["NumMenServing"]) + DB.Int32(dr["NumWomenServing"]) + DB.Int32(dr["NumChildServing"]); string eMailBody = string.Format( "Thank you for booking with us! We need to do a final confirmation for your upcoming event on {2}.\n\n" + "Please review the details on this <a href=\"{0}/CustomerConfirmation.aspx?id={1}\">confirmation page</a> " + "and confirm your event by {3}.\n\n" + "<table border=\"0\">" + "<tr><td>" + "<u>Job Information</u>" + "</td></tr>" + "<tr><td style=\"margin-right: 20px;\">" + "Event: #{4}\n" + "Customer: {5}\n" + "Date: {2}\n" + //"</td><td>" + "Location: {6}\n" + "Event Time: {7}\n" + "Guest Count: {8}</div>" + "</td></tr>" + "</table>", Request.Url.GetLeftPart(UriPartial.Authority), Guid, Fmt.DtNth(dtJob), Fmt.DtTm12Hr(dtDeadline), JobRno, Customer, Location, EventTime, NumServings); Misc.SendCustomerConfirmationEmail(Page, db, JobRno, Email, Subject, eMailBody); } } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } } } }