private void LoadList() { string Sql = "Select ServiceItem From mcJobServices Where JobRno = 0 Order By ServiceSeq"; string CurrItem = (lstList.SelectedIndex >= 0 ? lstList.SelectedItem.Value : ""); lstList.Items.Clear(); try { DataTable dt = db.DataTable(Sql); foreach (DataRow r in dt.Rows) { ListItem Item = new ListItem(DB.Str(r["ServiceItem"])); if (Item.Value.Length > 0) { Item.Selected = (Item.Value == CurrItem); lstList.Items.Add(Item); } } lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Services"; } catch (Exception Ex) { Err Err = new Err(Ex); Response.Write(Err.Html()); } }
private void DayHeader(DateTime dtRpt, bool fAM, bool fPM, string KitchenLocation) { int cJobs = 0; int cServings = 0; string Sql = "Select Count(*) As Cnt, " + "(IsNull(Sum(NumMenServing), 0) + IsNull(Sum(NumWomenServing), 0) + IsNull(Sum(NumChildServing), 0)) As NumServings " + "From mcJobs Where JobDate = " + DB.PutDtTm(dtRpt) + " " + (fAM ? "And Datepart(hour, Coalesce(DepartureTime, MealTime, '1/1/1 00:00:01')) < 12 " : string.Empty) + (fPM ? "And Datepart(hour, Coalesce(DepartureTime, MealTime, '1/1/1 00:00:01')) >= 12 " : string.Empty) + "And CancelledDtTm Is Null"; try { DataTable dt = db.DataTable(Sql); DataRow dr = dt.Rows[0]; cJobs = DB.Int32(dr["Cnt"]); cServings = DB.Int32(dr["NumServings"]); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } if (cJobs > 0) { if (fNewPage) { Response.Write( "<div style='page-break-before: always;'><img width='1' height='1' src='Images/Space.gif' alt='' /></div>"); } string Desc = KitchenLocation; Response.Write( //WebPage.Table("width='760' align='center'" + (fNewPage ? " style='page-break-before: always;" : "") + "'") + WebPage.Table("width='500' align='center'") + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td width='30%' valign='bottom'>\n" + WebPage.Tabs(3) + WebPage.Span(Desc, "RptNotice") + "\n" + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(2) + "<td align='center'>\n" + WebPage.Tabs(3) + WebPage.Div("Production Sheets", "center", "RptTitle") + WebPage.Tabs(4) + WebPage.Table("class='RptSubTitleBorder' style='padding-left: 2px; padding-right: 2px;'") + WebPage.Tabs(5) + "<tr><td class='RptSubTitle'>" + (fAM ? "AM " : string.Empty) + (fPM ? "PM " : string.Empty) + Fmt.DayOfWeek(dtRpt) + ", " + Fmt.Dt(dtRpt) + "</td></tr>\n" + WebPage.Tabs(3) + WebPage.TableEnd() + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(2) + "<td width='30%' valign='bottom' align='right'>" + WebPage.Span(Fmt.Num(cJobs), "RptNotice") + " Jobs, " + WebPage.Span(Fmt.Num(cServings), "RptNotice") + " Servings</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.TableEnd() + WebPage.SpaceTable(1, 40) ); fNewPage = true; } }
private void LoadList(bool fNext) { string Sql = "Select CustomerRno, Name, InactiveDtTm " + "From Customers c"; if (!chkShowHidden.Checked) { Sql += " Where (InactiveDtTm Is Null)"; } Sql += " Order by Name"; string CurrItem = (lstList.SelectedIndex >= 0 ? lstList.SelectedItem.Value : ""); string NextCurrItem = (lstList.SelectedIndex >= 0 && lstList.SelectedIndex + 1 < lstList.Items.Count ? lstList.Items[lstList.SelectedIndex + 1].Value : string.Empty); if (!fNext && CurrItem.Length > 0) { NextCurrItem = CurrItem; } if (!fNext && fStartHere) { NextCurrItem = StartHere; } lstList.Items.Clear(); LoadListSql(Sql, NextCurrItem); lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Customers"; }
private void LoadListSql(string Sql, string NextCurrItem) { try { DataTable dt = db.DataTable(Sql); foreach (DataRow r in dt.Rows) { string userName = DB.Str(r["userName"]); string userCommonName = DB.Str(r["UserCommonName"]); bool fHidden = DB.Bool(r["DisabledFlg"]); ListItem Item = new ListItem(listFormatStyle(userCommonName, userName)); if (fHidden) { Item.Attributes.Add("class", "Hidden"); } if (Item.Value == NextCurrItem) { Item.Selected = true; userName = Item.Value; GetData(userName); } lstList.Items.Add(Item); } lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Users"; } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
private void LoadList() { string Sql = "Select Distinct CrewMember From mcJobCrew " + "Where CrewMember Is Not Null Order By CrewMember"; string CurrItem = (lstList.SelectedIndex >= 0 ? lstList.SelectedItem.Value : ""); lstList.Items.Clear(); try { DataTable dt = db.DataTable(Sql); foreach (DataRow r in dt.Rows) { ListItem Item = new ListItem(DB.Str(r["CrewMember"])); Item.Selected = (Item.Value == CurrItem); lstList.Items.Add(Item); } lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Crew Members"; } catch (Exception Ex) { Err Err = new Err(Ex); Response.Write(Err.Html()); } }
// prepare the SQL script to retrieve the menu category/items and then fill the list control private void LoadList() { string Sql = ""; string SqlSelect = "Select Distinct c.Category, c.MultSelFlg As CatMultSelFlg, c.SortOrder, " + "i.MenuItemRno, i.MenuItem, i.MultSelFlg, i.MultItems, i.IngredSelFlg, i.RecipeRno, " + "IsNull(i.CategorySortOrder, 0) As ItemSortOrder, i.ServingQuote, i.ServingPrice, i.InaccuratePriceFlg, " + "r.GlutenFreeFlg, r.VeganFlg, r.VegetarianFlg, r.DairyFreeFlg, r.NutsFlg " + "From mcJobMenuItems i Inner Join mcJobMenuCategories c On i.Category = c.Category " + "Left Join Recipes r on i.RecipeRno = r.RecipeRno"; string SqlOrderBy; string[] aCategory = null; string List = ""; if (rbSortCategory.Checked) { SqlOrderBy = " Order By c.SortOrder, c.Category, ItemSortOrder, i.MenuItem"; } else if (rbSortCategoryAlpha.Checked) { SqlOrderBy = " Order By c.Category, ItemSortOrder, i.MenuItem"; //aCategory = new string[] { "Meats", "Sides", "Salads", "Bread", "Desserts", "Drink" }; } else { SqlOrderBy = " Order By i.MenuItem, c.Category"; } string CurrItem = (lstList.SelectedIndex >= 0 ? lstList.SelectedItem.Value : ""); lstList.Items.Clear(); if (aCategory != null) { foreach (string Category in aCategory) { Sql = SqlSelect + "Where Category = " + DB.PutStr(Category) + " And i.HideFlg != 1 " + SqlOrderBy; LoadListSql(Sql, CurrItem); List += ", '" + Category + "'"; } List = List.Substring(2); } Sql = SqlSelect; if (List.Length > 0) { Sql += "Where Category Not In (" + List + ") "; } Sql += (Sql.IndexOf("Where") > -1 ? " And " : " Where ") + "(i.HideFlg = 0 Or i.HideFlg Is Null) And (c.HideFlg = 0 Or c.HideFlg Is Null)"; Sql += SqlOrderBy; LoadListSql(Sql, CurrItem); lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Items"; }
//private void LoadListSql(string Sql, string CurrItem, string NextCurrItem) private void LoadListSql(string Sql, string NextCurrItem) { //Response.Write("looking for [" + NextCurrItem + "]<br/>"); try { DataTable dt = db.DataTable(Sql); foreach (DataRow r in dt.Rows) { string Category = DB.Str(r["Category"]); string MenuItem = DB.Str(r["MenuItem"]); int Rno = DB.Int32(r["MenuItemRno"]); bool fHidden = DB.Bool(r["HideFlg"]); ListItem Item = new ListItem(Category + " - " + MenuItem, Rno.ToString()); Item.Attributes.Add("title", Category + " - " + MenuItem); if (fHidden) { Item.Attributes.Add("class", "Hidden"); } /* * Item.Selected = (Item.Value == CurrItem); * if (Item.Selected) * { * Rno = Str.Num(Item.Value); * GetData(Rno); * btnUpdate.Enabled = true; * * NextCurrItem = string.Empty; * } * else * { */ //Response.Write("Item [" + Item.Text + "]<br/>"); if (Item.Text == NextCurrItem) { //Response.Write("Found it [" + Item.Text + "]<br/>"); Item.Selected = true; Rno = Str.Num(Item.Value); GetData(Rno); btnUpdate.Enabled = btnNext.Enabled = true; } //} lstList.Items.Add(Item); } lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Menu Items"; } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
private void JobInfo() { string Sql = "Select j.NumMenServing, j.NumWomenServing, j.NumChildServing, j.Status, j.EventType, j.ServiceType, j.Location, " + "j.PrintDirectionsFlg, j.LocationDirections, j.JobDate, j.MealTime, j.ArrivalTime, j.DepartureTime, j.PricePerPerson, " + "j.JobNotes, j." + "cu.Name as Customer, c.Name, c.Phone, c.Cell, c.Fax, c.Email, " + "From mcJobs j " + "Left Join Contacts c on j.ContactRno = c.ContactRno " + "Left Join Customers cu on c.CustomerRno = cu.CustomerRno " + "Where JobRno = " + JobRno; try { DataTable dt = db.DataTable(Sql); DataRow r = dt.Rows[0]; Int32 cMen = DB.Int32(r["NumMenServing"]); Int32 cWomen = DB.Int32(r["NumWomenServing"]); Int32 cChild = DB.Int32(r["NumChildServing"]); lblPrinted.Text = String.Format("{0}", DateTime.Now); lblJobRno.Text = JobRno.ToString(); lblStatus.Text = DB.Str(r["Status"]); lblCustomer.Text = DB.Str(r["Customer"]); lblName.Text = DB.Str(r["Name"]); lblPhone.Text = DB.Str(r["Phone"]); lblCell.Text = DB.Str(r["Cell"]); lblFax.Text = DB.Str(r["Fax"]); lblEmail.Text = DB.Str(r["Email"]); lblEventType.Text = DB.Str(r["EventType"]); lblServType.Text = DB.Str(r["ServiceType"]); lblLocation.Text = DB.Str(r["Location"]); if (DB.Bool(r["PrintDirectionsFlg"])) { lblDirections.Text = DB.Str(r["LocationDirections"]).Replace("\n", "<br>"); } lblJobDate.Text = Fmt.Dt(DB.DtTm(r["JobDate"])); lblMealTime.Text = Fmt.Tm12Hr(DB.DtTm(r["MealTime"])); lblArrivalTime.Text = Fmt.Tm12Hr(DB.DtTm(r["ArrivalTime"])); lblDepartureTime.Text = Fmt.Tm12Hr(DB.DtTm(r["DepartureTime"])); lblNumServing.Text = Fmt.Num(cMen + cWomen + cChild); lblNumMenServing.Text = Fmt.Num(cMen); lblNumWomenServing.Text = Fmt.Num(cWomen); lblNumChildServing.Text = Fmt.Num(cChild); lblPricePerPerson.Text = Fmt.Dollar(DB.Dec(r["PricePerPerson"]), false); lblJobNotes.Text = DB.Str(r["JobNotes"]); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
public void JobSubPage(string PageName) { Int32 JobRno = Str.Num((String)Session["JobRno"]); string Sql = ""; string Customer = ""; string JobDate = ""; string EventType = ""; string ServiceType = ""; string NumServings = ""; try { Sql = "Select Coalesce(cu.Name, c.Name) as Customer, JobDate, EventType, ServiceType, " + "IsNull(NumMenServing, 0) + IsNull(NumWomenServing, 0) + IsNull(NumChildServing, 0) As NumServings " + "From mcJobs j " + "Inner Join Contacts c on j.ContactRno = c.ContactRno " + "Left Join Customers cu on c.CustomerRno = cu.CustomerRno " + "Where JobRno = " + JobRno; DB db = new DB(); DataTable dt = db.DataTable(Sql); if (dt.Rows.Count > 0) { DataRow r = dt.Rows[0]; Customer = DB.Str(r["Customer"]); JobDate = Fmt.Dt(DB.DtTm(r["JobDate"])); EventType = DB.Str(r["EventType"]); ServiceType = DB.Str(r["ServiceType"]); this.NumServings = DB.Int32(r["NumServings"]); NumServings = Fmt.Num(this.NumServings); } db.Close(); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } string Html = "<table cellspacing=\"0\" cellpadding=\"0\" align=\"center\" border=\"0\" width=\"100%\" class=\"JobInfo\">\n" + " <tr>\n"+ " <td colspan=\"2\" align=\"center\"><span class=\"FeatureMain\">"+ PageName + "</span></td>\n" + " </tr>\n"+ " <tr>\n"+ " <td>"+ JobDate + " " + Customer + " <span class=\"JobInfoTitle\">Job #</span>" + JobRno + "</td>\n" + " <td align=\"right\">"+ "<span class=\"JobInfoTitle\">Event:</span> " + EventType + " <span class=\"JobInfoTitle\">Service:</span> " + ServiceType + " <span class=\"JobInfoTitle\">Servings:</span> " + NumServings + "</td>\n" + " </tr>\n"+ " <tr><td><img height=\"10\" src=\""+ Images + "/Space.gif\" width=\"1\" alt=\"\" /></td></tr>\n" + "</table>\n"; Response.Write(Html); }
private void LoadShoppingList() { string Sql = "Select s.ShoppingListRno, s.BegDt, v.Name As Vendor " + "From ShoppingLists s Inner Join Vendors v On s.VendorRno = v.VendorRno"; Sql += " Order by " + (rbShoppingDate.Checked ? "s.BegDt, v.Name" : "v.Name, s.BegDt"); string CurrItem = (lstShoppingList.SelectedIndex >= 0 ? lstShoppingList.SelectedItem.Value : ""); lstShoppingList.Items.Clear(); LoadShoppingListSql(Sql, CurrItem); lblShoppingRecCount.Text = Fmt.Num(lstShoppingList.Items.Count, true) + " Shopping Lists"; //btnSave.Enabled = (CurrItem.Length > 0); }
private void LoadList() { string Sql = "Select p.PurchaseRno, p.PurchaseDt, v.Name As Vendor " + "From Purchases p Inner Join Vendors v On p.VendorRno = v.VendorRno"; Sql += " Order by " + (rbDate.Checked ? "p.PurchaseDt Desc, v.Name" : "v.Name, p.PurchaseDt Desc"); string CurrItem = (lstList.SelectedIndex >= 0 ? lstList.SelectedItem.Value : ""); lstList.Items.Clear(); LoadListSql(Sql, CurrItem); lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Purchases"; //btnSave.Enabled = (CurrItem.Length > 0); }
protected void GetData(int Rno) { string Sql = string.Format("Select * From Settings Where SettingRno = {0}", Rno); ClearData(); try { DataTable dt = db.DataTable(Sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; hfRno.Value = Rno.ToString(); txtSubTotTaxPct.Text = Fmt.Num(DB.Dec(dr["SubTotTaxPct"]), 4, false); txtServiceSubTotPct.Text = Fmt.Num(DB.Dec(dr["ServiceSubTotPct"]), 4, false); txtServiceTaxPct.Text = Fmt.Num(DB.Dec(dr["ServiceTaxPct"]), 4, false); txtDeliverySubTotPct.Text = Fmt.Num(DB.Dec(dr["DeliverySubTotPct"]), 4, false); txtDeliveryTaxPct.Text = Fmt.Num(DB.Dec(dr["DeliveryTaxPct"]), 4, false); txtChinaSubTotPct.Text = Fmt.Num(DB.Dec(dr["ChinaSubTotPct"]), 4, false); txtChinaTaxPct.Text = Fmt.Num(DB.Dec(dr["ChinaTaxPct"]), 4, false); txtAddServiceSubTotPct.Text = Fmt.Num(DB.Dec(dr["AddServiceSubTotPct"]), 4, false); txtAddServiceTaxPct.Text = Fmt.Num(DB.Dec(dr["AddServiceTaxPct"]), 4, false); txtFuelTravelSubTotPct.Text = Fmt.Num(DB.Dec(dr["FuelTravelSubTotPct"]), 4, false); txtFuelTravelTaxPct.Text = Fmt.Num(DB.Dec(dr["FuelTravelTaxPct"]), 4, false); txtFacilitySubTotPct.Text = Fmt.Num(DB.Dec(dr["FacilitySubTotPct"]), 4, false); txtFacilityTaxPct.Text = Fmt.Num(DB.Dec(dr["FacilityTaxPct"]), 4, false); txtGratuitySubTotPct.Text = Fmt.Num(DB.Dec(dr["GratuitySubTotPct"]), 4, false); txtGratuityTaxPct.Text = Fmt.Num(DB.Dec(dr["GratuityTaxPct"]), 4, false); txtRentalsSubTotPct.Text = Fmt.Num(DB.Dec(dr["RentalsSubTotPct"]), 4, false); txtRentalsTaxPct.Text = Fmt.Num(DB.Dec(dr["RentalsTaxPct"]), 4, false); txtAdj1TaxPct.Text = Fmt.Num(DB.Dec(dr["Adj1TaxPct"]), 4, false); txtAdj2TaxPct.Text = Fmt.Num(DB.Dec(dr["Adj2TaxPct"]), 4, false); txtCCFeePct.Text = Fmt.Num(DB.Dec(dr["CCFeePct"]), 4, false); txtCCFeeTaxPct.Text = Fmt.Num(DB.Dec(dr["CCFeeTaxPct"]), 4, false); } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
private void LoadList(bool fNext) { string Sql = "Select VendorRno, Name, HideFlg " + "From Vendors v"; if (!chkShowHidden.Checked) { Sql += " Where (HideFlg = 0 Or HideFlg Is Null)"; } Sql += " Order by Name"; string CurrItem = (lstList.SelectedIndex >= 0 ? lstList.SelectedItem.Value : ""); string NextCurrItem = (lstList.SelectedIndex >= 0 && lstList.SelectedIndex + 1 < lstList.Items.Count ? lstList.Items[lstList.SelectedIndex + 1].Value : string.Empty); if (!fNext && CurrItem.Length > 0) { NextCurrItem = CurrItem; } //Response.Write("fStartHere " + fStartHere + "<br/>"); // if a place to start if (!fNext && fStartHere) { NextCurrItem = StartHere; //Response.Write("Start Here [" + StartHere + "]<br/>"); } //if (lstList.SelectedIndex >= 0) Response.Write("Curr " + lstList.SelectedItem.Value + "<br/>"); lstList.Items.Clear(); //Response.Write(Sql + "<br/>"); LoadListSql(Sql, NextCurrItem); lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Vendors"; //btnUpdate.Enabled = (CurrItem.Length > 0); }
private void LoadListSql(string Sql, string NextCurrItem) { //Response.Write("looking for [" + NextCurrItem + "]<br/>"); try { DataTable dt = db.DataTable(Sql); foreach (DataRow dr in dt.Rows) { Int32 Rno = DB.Int32(dr["IngredRno"]); String Name = DB.Str(dr["Name"]); bool fHidden = DB.Bool(dr["HideFlg"]); ListItem Item = new ListItem(Name, Rno.ToString()); if (fHidden) { Item.Attributes.Add("class", "Hidden"); } if (Item.Text == NextCurrItem) { Item.Selected = true; Rno = Str.Num(Item.Value); GetData(Rno); btnUpdate.Enabled = btnNext.Enabled = true; } lstList.Items.Add(Item); } lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Items"; } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
private void LoadListSql(string Sql, string NextCurrItem) { try { DataTable dt = db.DataTable(Sql); foreach (DataRow r in dt.Rows) { string Category = DB.Str(r["Category"]); bool fHidden = DB.Bool(r["HideFlg"]); ListItem Item = new ListItem(Category); if (fHidden) { Item.Attributes.Add("class", "Hidden"); } if (Item.Value == NextCurrItem) { Item.Selected = true; Category = Item.Value; GetData(Category); //btnUpdate.Enabled = //btnNext.Enabled = true; } lstList.Items.Add(Item); } lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Categories"; } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
protected void Page_Load(object sender, EventArgs e) { db = new DB(); Session["Menu"] = WebPage.MenuSetup.Title; Pg = new WebPage("Images"); Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath)); // Put user code to initialize the page here if (!Page.IsPostBack) { tblRpt.Visible = false; string Sql = "Select QuoteDiffPct From Settings"; try { decimal DiffPct = db.SqlDec(Sql); if (DiffPct == 0) { DiffPct = 15; } txtDiffPct.Text = Fmt.Num(DiffPct, 0); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } } else { tblRpt.Visible = true; fields.Visible = false; ProcessReport(); } }
private void LoadList(bool fNext) { string Sql = "Select UnitRno, UnitSingle, UnitPlural, HideFlg " + "From Units "; string SqlWhere = (chkShowHidden.Checked ? string.Empty : "IsNull(HideFlg, 0) = 0"); Sql += DB.Where(SqlWhere); Sql += " Order by UnitSingle"; string CurrItem = (lstList.SelectedIndex >= 0 ? lstList.SelectedItem.Value : ""); string NextCurrItem = (lstList.SelectedIndex >= 0 && lstList.SelectedIndex + 1 < lstList.Items.Count ? lstList.Items[lstList.SelectedIndex + 1].Value : string.Empty); if (!fNext && CurrItem.Length > 0) { NextCurrItem = CurrItem; } //Response.Write("fStartHere " + fStartHere + "<br/>"); // if a place to start if (!fNext && fStartHere) { NextCurrItem = StartHere; //Response.Write("Start Here [" + StartHere + "]<br/>"); } //if (lstList.SelectedIndex >= 0) Response.Write("Curr " + lstList.SelectedItem.Value + "<br/>"); lstList.Items.Clear(); //Response.Write(Sql + "<br/>"); LoadListSql(Sql, NextCurrItem); lblRecCount.Text = Fmt.Num(lstList.Items.Count, true) + " Units"; //btnUpdate.Enabled = (CurrItem.Length > 0); }
protected void Supplies() { string Sql = "Select * From mcJobSupplies " + "Where JobRno = " + JobRno + " " + "Order By SupplySeq"; try { DataTable dt = db.DataTable(Sql); foreach (DataRow r in dt.Rows) { string Html = "<tr>\n" + "\t<td valign=\"top\" class=\"JobItem\">" + DB.Str(r["SupplyItem"]) + "</d>\n" + "\t<td></td>\n" + "\t<td valign=\"top\" align=\"right\">" + Fmt.Num(DB.Int32(r["Qty"]), false) + "</d>\n" + "</tr>\n"; string Note = DB.Str(r["Note"]); if (Note.Length > 0) { Html += "<tr>\n" + "\t<td colspan=\"3\" align=\"right\"><i>" + Note + "</i></td>\n" + "</tr>\n"; } Response.Write(Html); } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
protected void GetData(int Rno) { string Sql = string.Format("Select * From Settings Where SettingRno = {0}", Rno); ClearData(); try { DataTable dt = db.DataTable(Sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; hfRno.Value = Rno.ToString(); txtBaseCostPct.Text = Fmt.Num(DB.Dec(dr["BaseCostPct"]), 4); txtAsIsBaseCostPct.Text = Fmt.Num(DB.Dec(dr["AsIsBaseCostPct"]), 4); } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
private void LoadShowSupply(Table tblShowSupplies, int iRow, int iSupply, DataRow dr) { TableRow tr = tblShowSupplies.Rows[iRow]; CheckBox chkInclude = (CheckBox)tr.FindControl("chkInclude" + iSupply); chkInclude.Checked = DB.Bool(dr["InJob"]); Label lblSupplySeq = (Label)tr.FindControl("lblSupplySeq" + iSupply); lblSupplySeq.Text = Convert.ToString(DB.Int32(dr["SupplySeq"])); Label lblSupplyItem = (Label)tr.FindControl("lblSupplyItem" + iSupply); lblSupplyItem.Text = DB.Str(dr["SupplyItem"]); TextBox txtQty = (TextBox)tr.FindControl("txtQty" + iSupply); txtQty.Text = Fmt.Num(DB.Int32(dr["Qty"]), false); TextBox txtNote = (TextBox)tr.FindControl("txtNote" + iSupply); txtNote.Text = DB.Str(dr["Note"]); }
protected void ReadValues() { ClearValues(); String Sql = "Select j.SubTotTaxPct, j.Adj1Desc, j.Adj2Desc, j.ServiceAmt, j.DeliveryAmt, j.ChinaAmt, j.AddServiceAmt, j.FuelTravelAmt, " + "j.FacilityAmt, j.RentalsAmt, j.Adj1Amt, j.Adj2Amt, j.DepositAmt, j.ServiceTaxPct, j.DeliveryTaxPct, j.ChinaTaxPct, " + "j.AddServiceTaxPct, j.FuelTravelTaxPct, j.FacilityTaxPct, j.RentalsTaxPct, j.Adj1TaxPct, j.Adj2TaxPct, j.ServicePropDesc, " + "j.DeliveryPropDesc, j.ChinaPropDesc, j.AddServicePropDesc, j.FuelTravelPropDesc, j.FacilityPropDesc, j.RentalsPropDesc, " + "j.Adj1PropDesc, j.Adj2PropDesc, j.EstTotPropDesc, j.DepositPropDesc, j.SalesTaxTotAmt, j.InvTotAmt, j.InvBalAmt, j.ServicePropDescCustFlg, " + "j.DeliveryPropDescCustFlg, j.ChinaPropDescCustFlg, j.AddServicePropDescCustFlg, j.FuelTravelPropDescCustFlg, " + "j.FacilityPropDescCustFlg, j.RentalsPropDescCustFlg, j.EstTotPropDescCustFlg, j.DepositPropDescCustFlg, j.ServicePropOptions, " + "j.DeliveryPropOptions, j.ChinaPropOptions, j.AddServicePropOptions, j.FuelTravelPropOptions, j.FacilityPropOptions, " + "j.RentalsPropOptions, j.EstTotPropOptions, j.DepositPropOptions, j.NumMenServing, j.NumWomenServing, j.NumChildServing, " + "j.ProposalFlg, j.PropCreatedDtTm, j.PropEmailedDtTm, j.ConfirmEmailedDtTm, j.JobType, c.Email, j.PropCreatedUser, " + "j.PropUpdatedDtTm, j.PropUpdatedUser, j.PropGeneratedDtTm, j.PropGeneratedUser, j.PropEmailedUser, j.ConfirmEmailedUser " + "From mcJobs j " + "Inner Join Contacts c on j.ContactRno = c.ContactRno " + "Where JobRno = " + JobRno; try { DataRow dr = db.DataRow(Sql); if (dr != null) { //decimal SalesTax = 0; //decimal Total = 0; string Default = string.Empty; string Zero = Fmt.Dollar(0); decimal SubTotTaxPct = DB.Dec(dr["SubTotTaxPct"]); // prices Sql = string.Format("Select * From JobInvoicePrices Where JobRno = {0} Order By Seq", JobRno); DataTable dtPrices = db.DataTable(Sql); foreach (DataRow drPrice in dtPrices.Rows) { int Rno = DB.Int32(drPrice["Rno"]); string PriceType = DB.Str(drPrice["PriceType"]); //string PriceDesc = string.Empty; int Count = 0; decimal Price = 0; decimal ExtPrice = 0; string FmtPrice = string.Empty; //string Desc = string.Empty; string PropDesc = string.Empty; bool fCustomized = false; Default = string.Empty; string Options = string.Empty; switch (PriceType) { case Misc.cnPerPerson: Count = DB.Int32(drPrice["InvPerPersonCount"]); Price = DB.Dec(drPrice["InvPerPersonPrice"]); //ExtPrice = Count * Price; ExtPrice = DB.Dec(drPrice["InvPerPersonExtPrice"]); FmtPrice = Fmt.Dollar(Price); //Desc = DB.Str(drPrice["InvPerPersonDesc"]); //PriceDesc = string.Format("Price per person: {0}", FmtPrice); PropDesc = DB.Str(drPrice["PropPerPersonDesc"]); fCustomized = DB.Bool(drPrice["PropPerPersonDescCustFlg"]); Options = DB.Str(drPrice["PropPerPersonOptions"]); Default = string.Format("Price per person: {0}", FmtPrice); if (!fCustomized && PropDesc.Length > 0 && FmtPrice != Zero) { PropDesc = Default; } break; case Misc.cnPerItem: Count = DB.Int32(drPrice["InvPerItemCount"]); Price = DB.Dec(drPrice["InvPerItemPrice"]); //ExtPrice = Count * Price; ExtPrice = DB.Dec(drPrice["InvPerItemExtPrice"]); FmtPrice = Fmt.Dollar(Count * Price); //Desc = DB.Str(drPrice["InvPerItemDesc"]); //PriceDesc = string.Format("{0} {1} @ {2} per item", // Fmt.Num(Count), // Desc, // Fmt.Dollar(Price)); PropDesc = DB.Str(drPrice["PropPerItemDesc"]); fCustomized = DB.Bool(drPrice["PropPerItemDescCustFlg"]); PriceType = string.Format("{0} {1}", Count, DB.Str(drPrice["InvPerItemDesc"])); Default = string.Format("{0}: {1}", PriceType, FmtPrice); if (!fCustomized && PropDesc.Length > 0 && FmtPrice != Zero) { PropDesc = Default; } break; case Misc.cnAllIncl: Count = 1; Price = DB.Dec(drPrice["InvAllInclPrice"]); //ExtPrice = Price - (Price * (1 - 1 / (1 + SubTotTaxPct / 100))); ExtPrice = DB.Dec(drPrice["InvAllInclExtPrice"]); FmtPrice = Fmt.Dollar(Price); //Desc = DB.Str(drPrice["InvAllInclDesc"]); //PriceDesc = string.Format("All inclusive {0} @ {1}", // Desc, // Fmt.Dollar(Price)); PropDesc = DB.Str(drPrice["PropAllInclDesc"]); fCustomized = DB.Bool(drPrice["PropAllInclDescCustFlg"]); PriceType = DB.Str(drPrice["InvAllInclDesc"]); Default = string.Format("{0}: {1}", PriceType, FmtPrice); if (!fCustomized && PropDesc.Length > 0 && FmtPrice != Zero) { PropDesc = Default; } break; } //if (PropDesc.Length > 0) { HtmlGenericControl tr = new HtmlGenericControl("tr"); HtmlGenericControl td = new HtmlGenericControl("td"); td.Attributes.Add("align", "right"); td.InnerHtml = string.Format("{0} (<span class=\"Amt\">{1}</span>)", PriceType, FmtPrice); tr.Controls.Add(td); td = new HtmlGenericControl("td"); HtmlTextArea txt = new HtmlTextArea(); txt.ID = string.Format("txtPrice_{0}", Rno); txt.Attributes.Add("class", "FeeDesc"); txt.Attributes.Add("data-default", Default); txt.Value = PropDesc; td.Controls.Add(txt); HtmlInputHidden hf = new HtmlInputHidden(); hf.ID = string.Format("hfPriceCustomized_{0}", Rno); hf.Value = Customized(fCustomized); td.Controls.Add(hf); HtmlGenericControl ul = new HtmlGenericControl("ul"); ul.ID = string.Format("ulPrice_{0}", Rno); ul.Attributes.Add("class", "Options"); td.Controls.Add(ul); RenderOptions(ul, PerPerson, Options); tr.Controls.Add(td); td = new HtmlGenericControl("td"); HtmlGenericControl lbl = new HtmlGenericControl("label"); lbl.Attributes.Add("class", "Reset"); lbl.Attributes.Add("title", "Click to reset the description and show all the options."); lbl.InnerText = "Undo Custom"; td.Controls.Add(lbl); lbl = new HtmlGenericControl("label"); lbl.Attributes.Add("class", "SeeOptions"); lbl.InnerText = "click Undo Custom to see available options"; td.Controls.Add(lbl); tr.Controls.Add(td); phPrices.Controls.Add(tr); } //Total += ExtPrice; } //SalesTax += Math.Round(Total * SubTotTaxPct / 100, 2); lblAdj1Desc.Text = DB.Str(dr["Adj1Desc"]); lblAdj2Desc.Text = DB.Str(dr["Adj2Desc"]); decimal ServiceAmt = DB.Dec(dr["ServiceAmt"]); decimal DeliveryAmt = DB.Dec(dr["DeliveryAmt"]); decimal ChinaAmt = DB.Dec(dr["ChinaAmt"]); decimal AddServiceAmt = DB.Dec(dr["AddServiceAmt"]); decimal FuelTravelAmt = DB.Dec(dr["FuelTravelAmt"]); decimal FacilityAmt = DB.Dec(dr["FacilityAmt"]); decimal RentalsAmt = DB.Dec(dr["RentalsAmt"]); decimal Adj1Amt = DB.Dec(dr["Adj1Amt"]); decimal Adj2Amt = DB.Dec(dr["Adj2Amt"]); decimal DepositAmt = DB.Dec(dr["DepositAmt"]); decimal ServicePct = DB.Dec(dr["ServiceTaxPct"]); decimal DeliveryPct = DB.Dec(dr["DeliveryTaxPct"]); decimal ChinaPct = DB.Dec(dr["ChinaTaxPct"]); decimal AddServicePct = DB.Dec(dr["AddServiceTaxPct"]); decimal FuelTravelPct = DB.Dec(dr["FuelTravelTaxPct"]); decimal FacilityPct = DB.Dec(dr["FacilityTaxPct"]); decimal RentalsPct = DB.Dec(dr["RentalsTaxPct"]); decimal Adj1Pct = DB.Dec(dr["Adj1TaxPct"]); decimal Adj2Pct = DB.Dec(dr["Adj2TaxPct"]); lblServiceAmt.Text = Fmt.Dollar(ServiceAmt); lblDeliveryAmt.Text = Fmt.Dollar(DeliveryAmt); lblChinaAmt.Text = Fmt.Dollar(ChinaAmt); lblAddServiceAmt.Text = Fmt.Dollar(AddServiceAmt); lblFuelTravelAmt.Text = Fmt.Dollar(FuelTravelAmt); lblFacilityAmt.Text = Fmt.Dollar(FacilityAmt); lblRentalsAmt.Text = Fmt.Dollar(RentalsAmt); lblAdj1Amt.Text = Fmt.Dollar(Adj1Amt); lblAdj2Amt.Text = Fmt.Dollar(Adj2Amt); lblDepositAmt.Text = Fmt.Dollar(DepositAmt); txtServiceDesc.Text = DB.Str(dr["ServicePropDesc"]); txtDeliveryDesc.Text = DB.Str(dr["DeliveryPropDesc"]); txtChinaDesc.Text = DB.Str(dr["ChinaPropDesc"]); txtAddServiceDesc.Text = DB.Str(dr["AddServicePropDesc"]); txtFuelTravelDesc.Text = DB.Str(dr["FuelTravelPropDesc"]); txtFacilityDesc.Text = DB.Str(dr["FacilityPropDesc"]); txtRentalsDesc.Text = DB.Str(dr["RentalsPropDesc"]); txtAdj1Desc.Text = DB.Str(dr["Adj1PropDesc"]); txtAdj2Desc.Text = DB.Str(dr["Adj2PropDesc"]); txtTotalDesc.Text = DB.Str(dr["EstTotPropDesc"]); txtDepositDesc.Text = DB.Str(dr["DepositPropDesc"]); //SalesTax += // Math.Round(ServiceAmt * ServicePct / 100, 2) + // Math.Round(DeliveryAmt * DeliveryPct / 100, 2) + // Math.Round(ChinaAmt * ChinaPct / 100, 2) + // Math.Round(AddServiceAmt * AddServicePct / 100, 2) + // Math.Round(FuelTravelAmt * FuelTravelPct / 100, 2) + // Math.Round(FacilityAmt * FacilityPct / 100, 2) + // Math.Round(RentalsAmt * RentalsPct / 100, 2) + // Math.Round(Adj1Amt * Adj1Pct / 100, 2) + // Math.Round(Adj2Amt * Adj2Pct / 100, 2); //Total += // ServiceAmt + // DeliveryAmt + // ChinaAmt + // AddServiceAmt + // FuelTravelAmt + // FacilityAmt + // RentalsAmt + // Adj1Amt + // Adj2Amt; //bool fTaxExempt = DB.Bool(dr["TaxExemptFlg"]); //if (!fTaxExempt) //{ // Total += SalesTax; //} //bool fCreditCardPaymentFee = DB.Bool(dr["CCPmtFeeFlg"]); //if (fCreditCardPaymentFee) //{ // decimal CreditCardFeePct = DB.Dec(dr["CCFeePct"]); // decimal CreditCardFeeAmt = Math.Round(Total * CreditCardFeePct / 100, 2); // decimal CreditCardFeeTaxPct = DB.Dec(dr["CCFeeTaxPct"]); // decimal CreditCardFeeTaxAmt = 0; // if (!fTaxExempt) // { // CreditCardFeeTaxAmt = Math.Round(CreditCardFeeAmt * CreditCardFeeTaxPct / 100, 2); // } // SalesTax += CreditCardFeeTaxAmt; // Total += CreditCardFeeAmt + CreditCardFeeTaxAmt; //} decimal SalesTax = DB.Dec(dr["SalesTaxTotAmt"]); decimal Total = DB.Dec(dr["InvTotAmt"]); decimal Balance = Total - DepositAmt; // DB.Dec(dr["InvBalAmt"]); bool fServiceCustomized = DB.Bool(dr["ServicePropDescCustFlg"]); bool fDeliveryCustomized = DB.Bool(dr["DeliveryPropDescCustFlg"]); bool fChinaCustomized = DB.Bool(dr["ChinaPropDescCustFlg"]); bool fAddServiceCustomized = DB.Bool(dr["AddServicePropDescCustFlg"]); bool fFuelTravelCustomized = DB.Bool(dr["FuelTravelPropDescCustFlg"]); bool fFacilityCustomized = DB.Bool(dr["FacilityPropDescCustFlg"]); bool fRentalsCustomized = DB.Bool(dr["RentalsPropDescCustFlg"]); bool fTotalCustomized = DB.Bool(dr["EstTotPropDescCustFlg"]); bool fDepositCustomized = DB.Bool(dr["DepositPropDescCustFlg"]); string ServiceOptions = DB.Str(dr["ServicePropOptions"]); string DeliveryOptions = DB.Str(dr["DeliveryPropOptions"]); string ChinaOptions = DB.Str(dr["ChinaPropOptions"]); string AddServiceOptions = DB.Str(dr["AddServicePropOptions"]); string FuelTravelOptions = DB.Str(dr["FuelTravelPropOptions"]); string FacilityOptions = DB.Str(dr["FacilityPropOptions"]); string RentalsOptions = DB.Str(dr["RentalsPropOptions"]); string TotalOptions = DB.Str(dr["EstTotPropOptions"]); string DepositOptions = DB.Str(dr["DepositPropOptions"]); hfServiceCustomized.Value = Customized(fServiceCustomized); hfDeliveryCustomized.Value = Customized(fDeliveryCustomized); hfChinaCustomized.Value = Customized(fChinaCustomized); hfAddServiceCustomized.Value = Customized(fAddServiceCustomized); hfFuelTravelCustomized.Value = Customized(fFuelTravelCustomized); hfFacilityCustomized.Value = Customized(fFacilityCustomized); hfRentalsCustomized.Value = Customized(fRentalsCustomized); hfTotalCustomized.Value = Customized(fTotalCustomized); hfDepositCustomized.Value = Customized(fDepositCustomized); //trAdj1.Visible = (lblAdj1Desc.Text.Length > 0); //trAdj2.Visible = (lblAdj2Desc.Text.Length > 0); RenderOptions(ulService, Service, ServiceOptions); RenderOptions(ulDelivery, Delivery, DeliveryOptions); RenderOptions(ulChina, China, ChinaOptions); RenderOptions(ulAddService, AddService, AddServiceOptions); RenderOptions(ulFuelTravel, FuelTravel, FuelTravelOptions); RenderOptions(ulFacility, Facility, FacilityOptions); RenderOptions(ulRentals, Rentals, RentalsOptions); Default = (lblServiceAmt.Text != Zero ? string.Format("{0}: {1}", DefaultService + " (gratuity not included)", lblServiceAmt.Text) : string.Empty); txtServiceDesc.Attributes.Add("data-default", Default); if (!fServiceCustomized && lblServiceAmt.Text != Zero) { txtServiceDesc.Text = Default; } Default = (lblDeliveryAmt.Text != Zero ? string.Format("{0}: {1}", DefaultDelivery, lblDeliveryAmt.Text) : string.Empty); txtDeliveryDesc.Attributes.Add("data-default", Default); if (!fDeliveryCustomized && lblDeliveryAmt.Text != Zero) { txtDeliveryDesc.Text = Default; } Default = (lblChinaAmt.Text != Zero ? string.Format("{0}: {1}", DefaultChina, lblChinaAmt.Text) : string.Empty); txtChinaDesc.Attributes.Add("data-default", Default); if (!fChinaCustomized && lblChinaAmt.Text != Zero) { txtChinaDesc.Text = Default; } Default = (lblAddServiceAmt.Text != Zero ? string.Format("{0}: {1}", DefaultAddService, lblAddServiceAmt.Text) : string.Empty); txtAddServiceDesc.Attributes.Add("data-default", Default); if (!fAddServiceCustomized && lblAddServiceAmt.Text != Zero) { txtAddServiceDesc.Text = Default; } Default = (lblFuelTravelAmt.Text != Zero ? string.Format("{0}: {1}", DefaultFuelTravel, lblFuelTravelAmt.Text) : string.Empty); txtFuelTravelDesc.Attributes.Add("data-default", Default); if (!fFuelTravelCustomized && lblFuelTravelAmt.Text != Zero) { txtFuelTravelDesc.Text = Default; } Default = (lblFacilityAmt.Text != Zero ? string.Format("{0}: {1}", DefaultFacility, lblFacilityAmt.Text) : string.Empty); txtFacilityDesc.Attributes.Add("data-default", Default); if (!fFacilityCustomized && lblFacilityAmt.Text != Zero) { txtFacilityDesc.Text = Default; } Default = (lblRentalsAmt.Text != Zero ? string.Format("{0}: {1}", DefaultRentals, lblRentalsAmt.Text) : string.Empty); txtRentalsDesc.Attributes.Add("data-default", Default); if (!fRentalsCustomized && lblRentalsAmt.Text != Zero) { txtRentalsDesc.Text = Default; } Default = (lblAdj1Amt.Text != Zero ? string.Format("{0}: {1}", lblAdj1Desc.Text, lblAdj1Amt.Text) : string.Empty); txtAdj1Desc.Attributes.Add("data-default", Default); if (txtAdj1Desc.Text.Length == 0 && lblAdj1Amt.Text != Zero) { txtAdj1Desc.Text = Default; } Default = (lblAdj2Amt.Text != Zero ? string.Format("{0}: {1}", lblAdj2Desc.Text, lblAdj2Amt.Text) : string.Empty); txtAdj2Desc.Attributes.Add("data-default", Default); if (txtAdj2Desc.Text.Length == 0 && lblAdj2Amt.Text != Zero) { txtAdj2Desc.Text = Default; } int NumServings = DB.Int32(dr["NumMenServing"]) + DB.Int32(dr["NumWomenServing"]) + DB.Int32(dr["NumChildServing"]); lblTotalAmt.Text = Fmt.Dollar(Total); Default = string.Format("Estimated Total: {0} - Based on {1} guests. Price per person and on-site service are subject to change as guest count changes.", Fmt.Dollar(Total), Fmt.Num(NumServings)); txtTotalDesc.Attributes.Add("data-default", Default); if (!fTotalCustomized) { txtTotalDesc.Text = Default; } Default = (lblDepositAmt.Text != Zero ? string.Format("{0}: {1}, remaining Invoice Balance: {2}", DefaultDeposit, lblDepositAmt.Text, Fmt.Dollar(Balance)) : string.Empty); txtDepositDesc.Attributes.Add("data-default", Default); if (txtDepositDesc.Text.Length == 0 && lblDepositAmt.Text != Zero) { txtDepositDesc.Text = Default; } bool fProposal = DB.Bool(dr["ProposalFlg"]); DateTime dtPropCreated = DB.DtTm(dr["PropCreatedDtTm"]); DateTime dtPropEmailed = DB.DtTm(dr["PropEmailedDtTm"]); DateTime dtConfirmEmailed = DB.DtTm(dr["ConfirmEmailedDtTm"]); string JobType = DB.Str(dr["JobType"]); EmailType = (fProposal ? "Proposal" : (JobType == "Private" ? "Private Confirmation" : "Corporate Confirmation")); txtEmail.Text = DB.Str(dr["Email"]); txtSubject.Text = (fProposal ? (dtPropEmailed == DateTime.MinValue ? string.Empty : "Revised ") + "Proposal" : (dtConfirmEmailed == DateTime.MinValue ? string.Empty : "Revised ") + "Confirmation") + " from " + Globals.g.Company.Name; txtMessage.Text = (fProposal ? "Attached is your " + (dtPropEmailed == DateTime.MinValue ? string.Empty : "revised ") + "proposal from " + Globals.g.Company.Name + ".\n\nWe appreciate your business." : (dtConfirmEmailed == DateTime.MinValue ? string.Empty : "Attached is your revised confirmation from " + Globals.g.Company.Name + ".\n\nWe appreciate your business.")); chkTermsOfService.Checked = (JobType == "Private"); btnEmail.Visible = fProposal; btnEmailConfirm.Visible = !fProposal; if (dtPropCreated == DateTime.MinValue) { btnEmail.Attributes.Add("disabled", "disabled"); btnEmail.Attributes.Add("title", "Save Client Pricing and then email."); btnEmailConfirm.Attributes.Add("disabled", "disabled"); btnEmailConfirm.Attributes.Add("title", "Save Client Pricing and then email."); } if (dtPropEmailed != DateTime.MinValue) { btnEmail.Value = "Re-Email Proposal"; } if (dtConfirmEmailed != DateTime.MinValue) { btnEmailConfirm.Value = "Re-Email Confirm"; } txtCreatedDt.Text = Fmt.DtTm(dtPropCreated); txtCreatedUser.Text = DB.Str(dr["PropCreatedUser"]); txtUpdatedDt.Text = Fmt.DtTm(DB.DtTm(dr["PropUpdatedDtTm"])); txtUpdatedUser.Text = DB.Str(dr["PropUpdatedUser"]); txtGeneratedDt.Text = Fmt.DtTm(DB.DtTm(dr["PropGeneratedDtTm"])); txtGeneratedUser.Text = DB.Str(dr["PropGeneratedUser"]); txtPropEmailedDt.Text = Fmt.DtTm(dtPropEmailed); txtPropEmailedUser.Text = DB.Str(dr["PropEmailedUser"]); txtConfirmEmailedDt.Text = Fmt.DtTm(dtConfirmEmailed); txtConfirmEmailedUser.Text = DB.Str(dr["ConfirmEmailedUser"]); pnlPreview.ToolTip = string.Format("{0} Preview", (fProposal ? "Proposal" : "Confirmation")); } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
protected void MenuCategory(string Category) { //FoodCategories FoodCat = new FoodCategories(); //string Sql = String.Format( // "Select Category, MenuItem, JobDate, Customer, " + // "Coalesce(MealTime, ArrivalTime, DepartureTime) As JobTime, " + // "NumMenServing, NumWomenServing, NumChildServing, Qty " + // "From mcJobs j Inner Join mcJobFood f On j.JobRno = f.JobRno " + // "Where JobDate Between {0} And {1} " + // "And Category {2} " + // "And CancelledDtTm Is Null " + // "Order By Category, MenuItem, JobDate, JobTime, Customer", // DB.PutDtTm(dtBeg), // DB.PutDtTm(dtEnd), // (Category.Length > 0 ? // "= " + DB.PutStr(Category) : // //"Not In ('Meats', 'Soup', 'Pasta', 'Sandwich', 'Appetizers', 'Sides', 'Salads', 'Bread', 'Desserts', 'Drink')")); // "Not In (" + FoodCat.SqlList(FoodCategories.Type.Hot) + ", " + FoodCat.SqlList(FoodCategories.Type.Cold) + ")")); string Sql = String.Format( "Select Category, MenuItem, JobDate, Coalesce(cu.Name, c.Name) as Customer, " + "Coalesce(MealTime, ArrivalTime, DepartureTime) As JobTime, " + "NumMenServing, NumWomenServing, NumChildServing, Qty " + "From mcJobs j " + "Inner Join Contacts c On j.ContactRno = c.ContactRno " + "Left Join Customers cu on c.CustomerRno = cu.CustomerRno " + "Inner Join mcJobFood f On j.JobRno = f.JobRno " + "Where JobDate Between {0} And {1} " + "And IsNull(ProposalFlg, 0) = 0 " + "And CancelledDtTm Is Null " + "And Trim(MenuItem) <> '' " + "Order By Category, MenuItem, JobDate, JobTime, Customer", DB.PutDtTm(dtBeg), DB.PutDtTm(dtEnd)); try { string PrevCategory = null; string PrevMenuItem = null; string FirstCategory = "First"; DataTable dt = db.DataTable(Sql); for (int iRow = 0; iRow < dt.Rows.Count; iRow++) { DataRow dr = dt.Rows[iRow]; Category = DB.Str(dr["Category"]); string MenuItem = GetMenuItem(ref dr); int Men; int Women; int Child; int Servings; int Qty; if (MenuItem != PrevMenuItem) { int iBeg = iRow; //int cQty = 0; int cServing = 0; int cMen = 0; int cWomen = 0; int cChild = 0; int cJobs = 0; PrevMenuItem = MenuItem; while (MenuItem == PrevMenuItem && iRow < dt.Rows.Count) { Qty = DB.Int32(dr["Qty"]); Men = DB.Int32(dr["NumMenServing"]); Women = DB.Int32(dr["NumWomenServing"]); Child = DB.Int32(dr["NumChildServing"]); cMen += Men; cWomen += Women; cChild += Child; cServing += (Qty != 0 ? Qty : Men + Women + Child); //cQty += Qty; cJobs++; if (++iRow < dt.Rows.Count) { dr = dt.Rows[iRow]; MenuItem = GetMenuItem(ref dr); } } string sClass = (Category == PrevCategory ? "" : " class=\"" + FirstCategory + "RptCategory\""); string sCategory = (Category == PrevCategory ? "" : "<b>" + Category + "</b>"); Response.Write( WebPage.Tabs(1) + "<tr" + sClass + ">\n" + WebPage.Tabs(2) + "<td>" + sCategory + "</td>\n" + WebPage.Tabs(2) + "<td valign='top' align='right'><img src='Images/Diamond.gif' class='RptBullet'></td>\n" + WebPage.Tabs(2) + "<td colspan='6' class='JobItem'><a href='javascript:ShowDtl(" + iDtl + ", " + (iDtl + cJobs - 1) + ");'>" + PrevMenuItem + "</a></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptNotice'>" + Fmt.Num(cServing, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + //WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num(cMen, false) + "</td>\n" + //WebPage.Tabs(2) + "<td></td>\n" + //WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num(cWomen, false) + "</td>\n" + //WebPage.Tabs(2) + "<td></td>\n" + //WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num(cChild, false) + "</td>\n" + //WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptNotice'>" + Fmt.Num(cJobs, false) + "</td>\n" + WebPage.Tabs(1) + "</tr>\n" ); if (sClass != "") { FirstCategory = ""; } iRow = iBeg; } dr = dt.Rows[iRow]; MenuItem = GetMenuItem(ref dr); Men = DB.Int32(dr["NumMenServing"]); Women = DB.Int32(dr["NumWomenServing"]); Child = DB.Int32(dr["NumChildServing"]); Servings = Men + Women + Child; Qty = DB.Int32(dr["Qty"]); Response.Write( WebPage.Tabs(1) + "<tr id='Dtl" + iDtl++ + "' style='display: none;'>\n" + WebPage.Tabs(2) + "<td colspan='3'></td>\n" + WebPage.Tabs(2) + "<td>" + Fmt.Dt(DB.DtTm(dr["JobDate"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Tm12Hr(DB.DtTm(dr["JobTime"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["Customer"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num((Qty != 0 ? Qty : Servings), false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + //WebPage.Tabs(2) + "<td align='right' class='RptSmall'>" + Fmt.Num(Men, false) + "</td>\n" + //WebPage.Tabs(2) + "<td></td>\n" + //WebPage.Tabs(2) + "<td align='right' class='RptSmall'>" + Fmt.Num(Women, false) + "</td>\n" + //WebPage.Tabs(2) + "<td></td>\n" + //WebPage.Tabs(2) + "<td align='right' class='RptSmall'>" + Fmt.Num(Child, false) + "</td>\n" + //WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'></td>\n" + WebPage.Tabs(1) + "</tr>\n" ); PrevMenuItem = MenuItem; PrevCategory = Category; } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
protected void SaveData() { int Rno = Str.Num(txtRno.Value); string Category = txtCurrCategory.Value; string MenuItem = txtCurrMenuItem.Value; string Sql = string.Empty; try { // setup to check if menu items need to be merged Sql = string.Format("Select Count(*) From mcJobMenuItems Where Category = {0} And MenuItem = {1}", DB.PutStr(ddlCategory.Text), DB.PutStr(txtMenuItem.Text)); // if user has said yes to merging if (hfMerge.Value == "true") { Sql = string.Format( "Begin Transaction\n" + "Update mcJobFood Set Category = {2}, MenuItem = {3} Where Category = {0} And MenuItem = {1}\n" + "Delete From mcJobMenuItems Where Category = {0} And MenuItem = {1}\n" + "Commit Transaction", DB.PutStr(Category), DB.PutStr(MenuItem), DB.PutStr(ddlCategory.Text), DB.PutStr(txtMenuItem.Text)); //Response.Write("Sql " + Sql + "<br />"); db.Exec(Sql); fStartHere = true; StartHere = ddlCategory.Text + " - " + txtMenuItem.Text; hfMerge.Value = "false"; } else // if not a new record and the category or menu item name has changed and the new value already exists then ask if they intend to merge if ((Category.Length > 0 && Category != ddlCategory.Text || MenuItem.Length > 0 && MenuItem != txtMenuItem.Text) && db.SqlNum(Sql) > 0) { fMerging = true; MergeMenuItem = MenuItem; MergeIntoMenuItem = txtMenuItem.Text; MergeCategory = Category; MergeIntoCategory = ddlCategory.Text; Sql = string.Format( "Select Count(*) From mcJobFood Where Category = {0} And MenuItem = {1}", DB.PutStr(Category), DB.PutStr(MenuItem)); AffectedJobs = Fmt.Num(db.SqlNum(Sql)); } else // not merging, simple update { DateTime Tm = DateTime.Now; // if a new menu item if (Rno == 0) { // if the new menu item already exists if (db.SqlNum(Sql) > 0) { fError = true; ErrorMsg = string.Format("There is already a menu item in this category named <b>{0}</b>. Please choose another name.", txtMenuItem.Text); } else { Sql = string.Format( "Insert Into mcJobMenuItems (MenuItem, CategorySortOrder, CreatedDtTm, CreatedUser) Values " + "('temp', (Select Count(*) + 1 From mcJobMenuItems Where Category = {2} And (HideFlg = 0 Or HideFlg Is Null)), {0}, {1}); Select @@Identity", DB.PutDtTm(Tm), DB.PutStr(g.User), DB.PutStr(ddlCategory.Text)); Rno = db.SqlNum(Sql); Category = ddlCategory.Text; MenuItem = txtMenuItem.Text; } } // if there wasn't an error if (!fError) { Misc.SetAsIsData(Rno, chkAsIs.Checked); // update the values Sql = string.Format( "Begin Transaction\n" + "Update mcJobMenuItems Set " + "Category = {1}, " + "MenuItem = {2}, " + "ProposalMenuItem = {3}, " + "ServingQuote = {4}, " + "KitchenLocRno = {5}, " + "AsIsFlg = {6}, " + "MultSelFlg = {7}, " + "MultItems = {8}, " + "IngredSelFlg = {9}, " + "HideFlg = {10}, " + "UpdatedDtTm = {11}, " + "UpdatedUser = {12} " + "Where MenuItemRno = {0}", Rno, DB.PutStr(ddlCategory.Text), DB.PutStr(txtMenuItem.Text), DB.PutStr(txtProposal.Text), Str.Dec(txtServingQuote.Text), ddlLocation.SelectedValue, DB.PutBool(chkAsIs.Checked), DB.PutBool(chkMultiSelect.Checked), DB.PutStr(txtMultItems.Value), DB.PutBool(chkIngredSelect.Checked), DB.PutBool(chkHide.Checked), DB.PutDtTm(Tm), DB.PutStr(g.User)); // if changed, update other areas if (Category != ddlCategory.Text || MenuItem != txtMenuItem.Text) { Sql += string.Format( "Update mcJobFood Set Category = {2}, MenuItem = {3} Where Category = {0} And MenuItem = {1}\n", DB.PutStr(Category), DB.PutStr(MenuItem), DB.PutStr(ddlCategory.Text), DB.PutStr(txtMenuItem.Text)); } Sql += "Commit Transaction"; //Response.Write("Sql " + Sql + "<br />"); db.Exec(Sql); fStartHere = true; StartHere = ddlCategory.Text + " - " + txtMenuItem.Text; } } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
protected void Report() { Response.Write("</head>\n<body class='RptBody'>\n"); int cJobs = 0; int cServings = 0; string Sql = String.Format( "Select Count(*) As Cnt, " + "(Sum(NumMenServing) + Sum(NumWomenServing) + Sum(NumChildServing)) As NumServings " + "From mcJobs Where JobDate Between {0} And {1} " + "And CancelledDtTm Is Null", DB.PutDtTm(dtBeg), DB.PutDtTm(dtEnd)); try { DataTable dt = db.DataTable(Sql); DataRow dr = dt.Rows[0]; cJobs = DB.Int32(dr["Cnt"]); cServings = DB.Int32(dr["NumServings"]); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } string Html = WebPage.Table("align='center' width='100%'") + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td width='30%' valign='bottom'>\n" + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(2) + "<td align='center'>\n" + WebPage.Tabs(3) + WebPage.Div("Ingedients List", "center", "RptTitle") + WebPage.Tabs(5) + WebPage.Div(Fmt.Dt(dtBeg) + " - " + Fmt.Dt(dtEnd), "center", "RptSubTitle") + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(2) + "<td width='30%' valign='bottom' align='right'>" + WebPage.Span(Fmt.Num(cJobs), "RptNotice") + " Jobs, " + WebPage.Span(Fmt.Num(cServings), "RptNotice") + " Servings</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.TableEnd(); Html += WebPage.Table("align='center'") + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td></td>\n" + // category WebPage.Tabs(2) + WebPage.Space(15, 15) + // bullet WebPage.Tabs(2) + WebPage.Space(20, 1) + // space before JobDate WebPage.Tabs(2) + "<td></td>\n" + // JobDate WebPage.Tabs(2) + WebPage.Space(5, 1) + WebPage.Tabs(2) + "<td></td>\n" + // JobTime WebPage.Tabs(2) + WebPage.Space(5, 1) + WebPage.Tabs(2) + "<td></td>\n" + // customer WebPage.Tabs(2) + WebPage.Space(10, 1) + WebPage.Tabs(2) + "<td></td>\n" + // # jobs WebPage.Tabs(2) + WebPage.Space(20, 1) + WebPage.Tabs(2) + "<td></td>\n" + // # servings WebPage.Tabs(2) + WebPage.Space(10, 1) + WebPage.Tabs(2) + "<td></td>\n" + // per serving qty WebPage.Tabs(2) + WebPage.Space(10, 1) + WebPage.Tabs(2) + "<td></td>\n" + // purchase qty WebPage.Tabs(2) + WebPage.Space(10, 1) + WebPage.Tabs(2) + "<td></td>\n" + // Vendor / Store Notes WebPage.Tabs(1) + "</tr>\n"; Html += WebPage.Tabs(1) + "<tr><td colspan='18' align='center'><span class='RptInfo'>Click an ingredient name to show or hide job details for that item.</span></td></tr>\n" + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td colspan='8'>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptHdrBold'><b># Jobs</b></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptHdrBold'><b># Servings</b></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptHdrBold'><b>Per Serving Qty</b></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptHdrBold'><b>Purchase Qty</b></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='center' class='RptHdrBold'><b>Vendor / Store Notes</b></td>\n" + WebPage.Tabs(1) + "</tr>\n"; Response.Write(Html); GetShoppingList(); Response.Write( WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + WebPage.Space(1, 30) + WebPage.Tabs(1) + "</tr>\n" + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td colspan='2'></td>\n" + WebPage.Tabs(2) + "<td colspan='14'>\n" + WebPage.Tabs(3) + "<input type=button value='Show Details' title='Click to show job details for all items.' onClick='ShowAll();' class='RptSmallBtn'>\n" + WebPage.Tabs(3) + "<input type=button value='Hide Details' title='Click to hide job details for all items.' onClick='HideAll();' class='RptSmallBtn'>\n" + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.TableEnd() + "<script lang='javascript'>var iEndDtl = " + --iDtl + ";</script>\n" ); }
protected void PrintJobs() { DateTime PrevDate = DateTime.MinValue; int cDays = 0; int cJobs = 0; int cServ = 0; string SqlWhere = ""; SqlWhere = DB.And(SqlWhere, "CreatedDtTm Between " + DB.PutDtTm(dtBeg) + " And " + DB.PutDtTm(dtEnd)); string Sql = "Select * From mcJobs " + "Where " + SqlWhere + " Order By CreatedDtTm"; try { DataTable dt = db.DataTable(Sql); foreach (DataRow dr in dt.Rows) { JobRno = DB.Int32(dr["JobRno"]); int cMen = DB.Int32(dr["NumMenServing"]); int cWomen = DB.Int32(dr["NumWomenServing"]); int cChild = DB.Int32(dr["NumChildServing"]); int cServings = cMen + cWomen + cChild; DateTime JobDate = DB.DtTm(dr["JobDate"]); if (JobDate != PrevDate) { cDays++; PrevDate = JobDate; } cJobs++; cServ += cServings; Response.Write( WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Dt(DB.DtTm(dr["CreatedDtTm"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Tm12Hr(DB.DtTm(dr["CreatedDtTm"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Dt(JobDate) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Tm12Hr(DB.DtTm(dr["DepartureTime"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Tm12Hr(DB.DtTm(dr["MealTime"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["Customer"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["EventType"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["ServiceType"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num(cServings, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + Fmt.Num(cMen, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + Fmt.Num(cWomen, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + Fmt.Num(cChild, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + JobRno + "</td>\n" + WebPage.Tabs(1) + "</tr>\n" ); } if (dt.Rows.Count == 0) { Response.Write("<br><br><div class='JobSubTitle' align='center'>No Jobs Found to Print</div>\n"); } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } Response.Write(WebPage.Tabs(0) + WebPage.TableEnd()); string sTotals = "<b>" + cDays + "</b> Dates, <b>" + cJobs + "</b> Jobs, <b>" + Fmt.Num(cServ) + "</b> Servings"; Response.Write("<script language='javascript'>oSetStr('Totals', '" + sTotals + "');</script>\n"); }
protected void GetShoppingList() { string Sql = String.Format( "Select i.Category, i.Name As Ingredient, " + "Coalesce(f.Qty, NumMenServing + NumWomenServing + NumChildServing) As Qty, " + "r.OneServQty, i.OrderUnits, j.JobDate, j.Customer, " + "Coalesce(j.MealTime, j.ArrivalTime, j.DepartureTime) As JobTime " + "From mcJobs j " + "Inner Join mcJobFood f On j.JobRno = f.JobRno " + "Inner Join mcJobMenuItems m On f.MenuItem = m.MenuItem " + "Inner Join Recipes r On m.MenuItemRno = r.MenuItemRno " + "Inner Join Ingredients i On r.IngredRno = i.IngredRno " + "Where JobDate Between {0} And {1} " + "And CancelledDtTm Is Null " + "Order By i.Category, i.Name, j.JobDate, JobTime, j.Customer", DB.PutDtTm(dtBeg), DB.PutDtTm(dtEnd)); try { string PrevCategory = null; string PrevIngredient = null; string FirstCategory = "First"; DataTable dt = db.DataTable(Sql); for (int iRow = 0; iRow < dt.Rows.Count; iRow++) { DataRow dr = dt.Rows[iRow]; string Category = DB.Str(dr["Category"]); string Ingredient = GetIngredient(ref dr); int Qty; if (Ingredient != PrevIngredient) { decimal PerServing = DB.Dec(dr["OneServQty"]); string Units = DB.Str(dr["OrderUnits"]); int iBeg = iRow; int cQty = 0; int cJobs = 0; PrevIngredient = Ingredient; while (Ingredient == PrevIngredient && iRow < dt.Rows.Count) { Qty = DB.Int32(dr["Qty"]); cQty += Qty; cJobs++; if (++iRow < dt.Rows.Count) { dr = dt.Rows[iRow]; Ingredient = GetIngredient(ref dr); } } decimal PurchaseQty = cQty * PerServing; string sClass = (Category == PrevCategory ? "" : " class=\"" + FirstCategory + "RptCategory\""); string sCategory = (Category == PrevCategory ? "" : "<b>" + Category + "</b>"); Response.Write( WebPage.Tabs(1) + "<tr" + sClass + ">\n" + WebPage.Tabs(2) + "<td>" + sCategory + "</td>\n" + WebPage.Tabs(2) + "<td valign='top' align='right'><img src='Images/Diamond.gif' class='RptBullet'></td>\n" + WebPage.Tabs(2) + "<td colspan='6' class='JobItem'><a href='javascript:ShowDtl(" + iDtl + ", " + (iDtl + cJobs - 1) + ");'>" + PrevIngredient + "</a></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num(cJobs, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptNotice'>" + Fmt.Num(cQty, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Str.ShowFract(PerServing) + " " + Units + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='RptNotice'>" + Fmt.Num((int)Math.Ceiling(PurchaseQty), false) + " " + Units + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td class='StoreNote'> </td>\n" + WebPage.Tabs(1) + "</tr>\n" ); if (sClass != "") { FirstCategory = ""; } iRow = iBeg; } dr = dt.Rows[iRow]; Ingredient = GetIngredient(ref dr); Qty = DB.Int32(dr["Qty"]); Response.Write( WebPage.Tabs(1) + "<tr id='Dtl" + iDtl++ + "' style='display: none;'>\n" + WebPage.Tabs(2) + "<td colspan='3'></td>\n" + WebPage.Tabs(2) + "<td>" + Fmt.Dt(DB.DtTm(dr["JobDate"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Tm12Hr(DB.DtTm(dr["JobTime"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["Customer"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num(Qty, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'></td>\n" + WebPage.Tabs(1) + "</tr>\n" ); PrevIngredient = Ingredient; PrevCategory = Category; } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } }
//protected void ReportData(FoodType eFoodType, ref DataTable dt) protected void ReportData(ref DataTable dt, int KitchenLocRno, string KitchenLocation) { //this.eFoodType = eFoodType; DateTime PrevDate = DateTime.MinValue; DateTime PrevDepartTime = DateTime.MinValue; int cDays = 0; int cJobs = 0; int cServ = 0; foreach (DataRow dr in dt.Rows) { int JobRno = DB.Int32(dr["JobRno"]); DateTime JobDate = DB.DtTm(dr["JobDate"]); DateTime DepartTime = DB.DtTm(dr["DepartTime"]); if (JobDate != PrevDate || DepartTime.Hour < 12 && !(PrevDepartTime.Hour < 12) || DepartTime.Hour >= 12 && !(PrevDepartTime.Hour >= 12)) { if (JobDate != PrevDate) { cDays++; PrevDate = JobDate; } PrevDepartTime = DepartTime; if (!fSummaryOnly) { DayHeader(JobDate, DepartTime.Hour < 12, DepartTime.Hour >= 12, KitchenLocation); } } if (fSummaryOnly) { //int JobRno = DB.Int32(dr["JobRno"]); int cMen = DB.Int32(dr["NumMenServing"]); int cWomen = DB.Int32(dr["NumWomenServing"]); int cChild = DB.Int32(dr["NumChildServing"]); int cServings = cMen + cWomen + cChild; cJobs++; cServ += cServings; Response.Write( WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Dt(DB.DtTm(dr["JobDate"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Tm12Hr(DB.DtTm(dr["DepartureTime"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Tm12Hr(DB.DtTm(dr["MealTime"])) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["Customer"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["EventType"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td>" + DB.Str(dr["ServiceType"]) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right'>" + Fmt.Num(cServings, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + Fmt.Num(cMen, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + Fmt.Num(cWomen, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + Fmt.Num(cChild, false) + "</td>\n" + WebPage.Tabs(2) + "<td></td>\n" + WebPage.Tabs(2) + "<td align='right' class='SmallPrint'>" + JobRno + "</td>\n" + WebPage.Tabs(1) + "</tr>\n" ); } else { //DayHeader(dtCurr); //each job at the top of the page JobData(dr, KitchenLocRno); } } //if (dt.Rows.Count > 0) //{ // cDays++; //} if (fSummaryOnly) { Response.Write(WebPage.Tabs(0) + WebPage.TableEnd()); string sTotals = "<b>" + cDays + "</b> Dates, <b>" + cJobs + "</b> Jobs, <b>" + Fmt.Num(cServ) + "</b> Servings"; Response.Write("<script language='javascript'>oSetStr('Totals', '" + sTotals + "');</script>\n"); } }
public string FormatJob(DataRow dr) { string sDepart = Fmt.Tm12Hr(DB.DtTm(dr["DepartureTime"])); string sDepartNote = sDepart; string sMeal = Fmt.Tm12Hr(DB.DtTm(dr["MealTime"])); Int32 cMen = DB.Int32(dr["NumMenServing"]); Int32 cWomen = DB.Int32(dr["NumWomenServing"]); Int32 cChild = DB.Int32(dr["NumChildServing"]); if (sDepart.Length == 0) { if (sMeal.Length > 0) { sDepart = sMeal + "<sup>*</sup>"; sDepartNote = sMeal; fNoDepartTime = true; } else { sDepart = "N/A"; // + "<sup>*</sup>"; sDepartNote = "N/A"; // fNoDepartTime = true; } } string Html = WebPage.Tabs(3) + WebPage.Table("width='100%' class='NoBorder'") + WebPage.Tabs(4) + "<tr>\n" + WebPage.Tabs(5) + "<td><span class='CalMainTime'><a href='javascript:ShowJob(" + iJobNum + ");' title='Departure Time: " + sDepartNote + "\nMeal Time: " + sMeal + "\nClick to see details of this job.'>" + sDepart + "</a></span></td>\n" + WebPage.Tabs(5) + "<td> </td>\n" + WebPage.Tabs(5) + "<td align='right'><span class='CalMinorTime'>" + sMeal + "</span></td>\n" + WebPage.Tabs(4) + "</tr>\n" + WebPage.Tabs(3) + WebPage.TableEnd() + WebPage.Tabs(3) + WebPage.Table("class='NoBorder'") + WebPage.Tabs(4) + WebPage.SpaceTr(10, 1) + JobField(dr, "Customer") + WebPage.Tabs(4) + "<tbody id='tblJob" + iJobNum + "' style='display: none;'>\n" + JobField(dr, "Location") + JobField(dr, "EventType") + JobField(dr, "ServiceType") + WebPage.Tabs(4) + "<tr>\n" + WebPage.Tabs(5) + "<td>•</td>\n" + WebPage.Tabs(5) + "<td>" + Fmt.Num(cMen + cWomen + cChild) + "<span class='RptSmall'> (M " + cMen + ", W " + cWomen + ", C " + cChild + ")</span></td>\n" + WebPage.Tabs(4) + "</tr>\n" + WebPage.Tabs(4) + "</tbody>\n" + WebPage.Tabs(3) + WebPage.TableEnd(); iJobNum++; DateTime dtDepart = DB.DtTm(dr["DepartTime"]); sDepart = new DateTime(dtDepart.Year, dtDepart.Month, dtDepart.Day, 0, 0, 0).ToString("M/d/yyyy"); // if this date hasn't seen yet if (scDays.IndexOf(sDepart) < 0) { scDays.Add(sDepart); cDays++; } return(Html); }
protected void Report() { Response.Write("</head>\n<body class='RptBody'>\n"); int cServings = 0; int cJobs = 0; cDays = 0; dtPrevDay = DateTime.MinValue; string Sql = String.Format( "Select Count(*) As Cnt, " + "(IsNull(Sum(NumMenServing), 0) + IsNull(Sum(NumWomenServing), 0) + IsNull(Sum(NumChildServing), 0)) As NumServings " + "From mcJobs Where JobDate Between {0} And {1} " + "And CancelledDtTm Is Null And ProposalFlg <> 1", DB.PutDtTm(dtBeg), DB.PutDtTm(dtEnd)); try { DataTable dt = db.DataTable(Sql); DataRow dr = dt.Rows[0]; cJobs = DB.Int32(dr["Cnt"]); cServings = DB.Int32(dr["NumServings"]); } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } string Html = WebPage.Tabs(0) + WebPage.Table("align='center'") + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td colspan='2' align='center'>\n" + WebPage.Tabs(3) + WebPage.Div("Job Calendar", "center", "RptTitle") + WebPage.Tabs(5) + WebPage.Div("Scheduled Jobs for the<br>" + sPeriod, "center", "RptSubTitle") + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.Tabs(1) + WebPage.SpaceTr(1, 15) + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td><span class='RptInfo'>Click an event depature time to show or hide job details.</span></td>\n" + WebPage.Tabs(2) + "<td valign='bottom' align='right'>" + WebPage.Span(Fmt.Num(cServings), "RptNotice") + " Servings, " + WebPage.Span(Fmt.Num(cJobs), "RptNotice") + " Jobs, " + "<span id='cDays' class='RptNotice'>0</span> Days</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.Tabs(1) + "<tr><td colspan='2' valign='top'>\n" + "<br>\n"; Response.Write(Html); try { fNoDepartTime = false; scDays.Clear(); CalSched Cal = new CalSched(dtBeg, dtEnd); try { Cal.BegTimeStr("11:00am"); Cal.EndTimeStr("4:00pm"); Cal.TimeBlock = 5 * 60; Cal.DBConnection = db.Conn; Cal.SqlDataQuery( "Select Coalesce(DepartureTime, MealTime, JobDate) As DepartTime, DepartureTime, MealTime, Location, EventType, " + "ServiceType, NumMenServing, NumWomenServing, NumChildServing, Coalesce(cu.Name, c.Name) as Customer " + "From mcJobs j " + "Right Join Contacts c On j.ContactRno = c.ContactRno " + "Left Join Customers cu on c.CustomerRno = cu.CustomerRno " + "Where JobDate Between '{0}' And '{1}' And " + "CancelledDtTm Is Null And " + "IsNull(ProposalFlg, 0) = 0" + "Order By JobDate, DepartTime, MealTime", "DepartTime", "DepartTime"); Cal.FormatData = new CalSched.DataFormater(FormatJob); Cal.EndCal = new CalSched.CalEvent(EndCal); Cal.ShowTimeColumn = false; Cal.View(Response, this.CalPeriod); } catch (Exception Ex) { Err Err = new Err(Ex, Cal.SqlQuery); Response.Write(Err.Html()); } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } Html = "<br>\n" + WebPage.Tabs(1) + "</td></tr>\n" + WebPage.Tabs(1) + "<tr><td colspan='2' align='center'>\n" + WebPage.Tabs(2) + "<input type=button value='Show Details' title='Click to show job details for all events.' onClick='ShowAll();' class='RptSmallBtn'> \n" + WebPage.Tabs(2) + "<input type=button value='Hide Details' title='Click to hide job details for all events.' onClick='HideAll();' class='RptSmallBtn'>\n" + WebPage.Tabs(1) + "</td></tr>\n" + WebPage.Tabs(0) + WebPage.TableEnd() + "<script lang='javascript'>\n" + "var EndJobNum = " + --iJobNum + ";\n" + "oSetStr('cDays', '" + Fmt.Num(cDays) + "');\n" + "</script>\n"; Response.Write(Html); }
protected bool ReportCrew(string CrewMember, bool fSingle, bool fMaster) { bool fDataFound = false; int cAssignments = 0; int cJobs = 0; cDays = 0; string Sql = String.Format( "Select Count(*) As Cnt " + "From mcJobCrew c Inner Join mcJobs j On c.JobRno = j.JobRno " + "Where JobDate Between {0} And {1} " + (fMaster ? "" : "And CrewMember = {2} ") + "And CancelledDtTm Is Null", DB.PutDtTm(dtBeg), DB.PutDtTm(dtEnd), DB.PutStr(CrewMember)); cAssignments = db.SqlNum(Sql); Sql = String.Format( "Select Distinct c.JobRno " + "From mcJobCrew c Inner Join mcJobs j On c.JobRno = j.JobRno " + "Where JobDate Between {0} And {1} " + (fMaster ? "" : "And CrewMember = {2} ") + "And CancelledDtTm Is Null", DB.PutDtTm(dtBeg), DB.PutDtTm(dtEnd), DB.PutStr(CrewMember)); try { DataTable dt = db.DataTable(Sql); cJobs = dt.Rows.Count; } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } if (cAssignments > 0 || fSingle) { fDataFound = true; string Html = WebPage.Tabs(0) + WebPage.Table("align='center'" + (fNewPage ? " style='page-break-before: always;'" : "")) + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td colspan='2' align='center'>\n" + WebPage.Tabs(3) + WebPage.Div("Crew Calendar", "center", "RptTitle") + WebPage.Tabs(5) + WebPage.Div("Job Assignments for <span class='RptSubTitle'>" + CrewMember + "</span><br>" + sPeriod, "center", "RptSubTitleSmall") + WebPage.Tabs(2) + "</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.Tabs(1) + WebPage.SpaceTr(1, 15) + WebPage.Tabs(1) + "<tr>\n" + WebPage.Tabs(2) + "<td><span class='RptInfo'>Click an event time to show or hide job details.</span></td>\n" + WebPage.Tabs(2) + "<td valign='bottom' align='right'>" + WebPage.Span(Fmt.Num(cAssignments), "RptNotice") + " Assignments, " + WebPage.Span(Fmt.Num(cJobs), "RptNotice") + " Jobs, " + "<span id='cDays" + ++iCal + "' class='RptNotice'>0</span> Days</td>\n" + WebPage.Tabs(1) + "</tr>\n" + WebPage.Tabs(1) + "<tr><td colspan='2' valign='top'>\n" + "<br>\n"; Response.Write(Html); try { fNoReportTime = false; scDays.Clear(); CalSched Cal = new CalSched(dtBeg, dtEnd); try { Cal.BegTimeStr("11:00am"); Cal.EndTimeStr("4:00pm"); Cal.TimeBlock = 5 * 60; Cal.DBConnection = db.Conn; Cal.SqlDataQuery( "Select Coalesce(ReportTime, MealTime, JobDate) As ReportTm, ReportTime, MealTime, " + "CrewMember, CrewAssignment, Note, Customer, Location, EventType, " + "ServiceType " + "From mcJobCrew c Inner Join mcJobs j On c.JobRno = j.JobRno " + "Where JobDate Between '{0}' And '{1}' " + (fMaster ? "" : "And CrewMember = " + DB.PutStr(CrewMember) + " ") + "And CancelledDtTm Is Null " + "Order By JobDate, ReportTime, MealTime", "ReportTm", "ReportTm"); Cal.FormatData = new CalSched.DataFormater(FormatJob); Cal.EndCal = new CalSched.CalEvent(EndCal); Cal.ShowTimeColumn = false; Cal.View(Response, this.CalPeriod); } catch (Exception Ex) { Err Err = new Err(Ex, Cal.SqlQuery); Response.Write(Err.Html()); } } catch (Exception Ex) { Err Err = new Err(Ex, Sql); Response.Write(Err.Html()); } Html = WebPage.Tabs(1) + "</td></tr>\n" + WebPage.Tabs(1) + WebPage.SpaceTr(1, 20) + WebPage.Tabs(0) + WebPage.TableEnd() + "<script language='javascript'>oSetStr('cDays" + iCal + "', '" + Fmt.Num(cDays) + "');</script>\n"; Response.Write(Html); fNewPage = true; } return(fDataFound); }