private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Shopping.Title;
// if an ingred rno passed in then well setup for a new receipt for the ingredient on today with No Vendor
NewIngredRno = Parm.Int("IngredRno");
if (NewIngredRno != 0)
{
IngredReceipt(NewIngredRno);
LoadList();
hfTab.Value = "1";
}
else
{
Setup();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Accounting.Title;
//Setup();
}
else
{
DateTime Tm = DateTime.Now;
// Paid In Full jobs
int Count = Str.Num(Request.Params["Count"]);
for (int i = 1; i <= Count; i++)
{
int JobRno = Str.Num(Request.Params["chkProc" + i]);
if (JobRno > 0)
{
string Sql = "Update mcJobs Set " +
"PaidInFullDtTm = " + DB.PutDtTm(Tm) + ", " +
"PaidInFullUser = "******", " +
"UpdatedDtTm = " + DB.PutDtTm(Tm) + ", " +
"UpdatedUser = "******" " +
"Where JobRno = " + JobRno;
db.Exec(Sql);
}
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
JobRno = Pg.JobRno();
pnlPreview.CssClass = "PdfPreview";
//pnlPreview.Visible = false;
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Jobs.Title;
}
else
{
if (hfEmail.Value == "true")
{
SaveAttachment();
SendEmail();
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Setup();
}
}
protected void Page_Load(object sender, EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.MenuSetup.Title;
Setup();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.JobSetup.Title;
}
else
{
SaveUpdates();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Recipes.Title;
}
RecipeRno = Parm.Int("Rno");
Scale();
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Reports.Title;
Setup();
}
//WebConfig wc = new WebConfig();
//SlingEmail = wc.Str("SlingEmail");
//SlingPassword = wc.Str("SlingPassword");
//SlingOrgId = wc.Str("SlingOrgId");
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
JobRno = Pg.JobRno();
cServices = Str.Num(txtcServices.Text);
cShowServices = Str.Num(txtcShowServices.Text);
AddLines();
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Jobs.Title;
Setup();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
if (Request.QueryString["JobRno"] != null)
{
string sJobRno = Request.QueryString["JobRno"];
JobRno = Misc.UnMangleNumber(sJobRno);
if (JobRno == 0)
{
JobRno = Str.Num(sJobRno);
}
if (JobRno != 0)
{
fReport = true;
fSingleJob = true;
}
}
Pg = new WebPage("Images");
if (JobRno == 0)
{
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
}
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Reports.Title;
Setup();
}
else
{
fLetterSize = rdoLetter.Checked;
}
//WebConfig wc = new WebConfig();
//// has to be the system parm sling user so we can see the pending assignments
SlingEmail = SysParm.Get(Misc.cnSlingUserEmail);
SlingPassword = SysParm.Get(Misc.cnSlingUserPassword);
//SlingOrgId = wc.Str("SlingOrgId");
}
private void Page_Load(object sender, System.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)
{
ClearData();
Setup();
// handle a particular menu item being edited
int MenuItemRno = Parm.Int("Rno");
if (MenuItemRno != 0)
{
GetData(MenuItemRno);
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Contacts.Title;
int Rno = Str.Num((string)Request.QueryString["ContactRno"]);
if (Rno != 0)
{
fStartHere = true;
StartHere = Rno.ToString();
}
FillCustomers();
Setup();
}
}
private async void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Sling.Title;
try
{
await LoadData();
}
catch (Exception Ex)
{
Err Err = new Err(Ex);
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 Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
JobRno = Pg.JobRno();
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Jobs.Title;
//cItems = Str.Num(hfNumItems.Value);
//cItems = Str.Num(txtcItems.Text);
//AddLines();
// setup the food category/item list
Setup();
}
else
{
//Update();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Shopping.Title;
//Setup();
string Sql = string.Empty;
try
{
// ingredient without a receipt price
Sql =
"Select IngredRno, Name From Ingredients " +
"Where IsNull(HideFlg, 0) = 0 " +
"And IsNull(NonPurchaseFlg, 0) = 0 " +
"And IngredRno Not In (Select Distinct IngredRno From PurchaseDetails Where IngredRno Is Not Null) " +
"And IngredRno In (Select IngredRno From RecipeIngredXref) " +
"Order By Name";
DataTable dt = db.DataTable(Sql);
foreach (DataRow dr in dt.Rows)
{
int IngredRno = DB.Int32(dr["IngredRno"]);
HtmlTableRow tr = new HtmlTableRow();
HtmlTableCell td = new HtmlTableCell();
td.InnerText = DB.Str(dr["Name"]);
tr.Controls.Add(td);
td = new HtmlTableCell();
HtmlAnchor a = new HtmlAnchor();
a.HRef = string.Format("Purchases.aspx?IngredRno={0}", DB.Int32(dr["IngredRno"]));
a.InnerText = "Enter Receipt";
a.Attributes.Add("title", "Go to the Receipt page to enter a price.");
a.Target = "Fix";
td.Controls.Add(a);
td.Attributes.Add("class", "select");
tr.Controls.Add(td);
// non-purchase
td = new HtmlTableCell();
CheckBox chk = new CheckBox();
chk.CssClass = "set-non-purchase";
chk.ToolTip = "Set Ingredient as Non-Purchased";
chk.Attributes.Add("data-ingredient-rno", IngredRno.ToString());
td.Controls.Add(chk);
// edit ingredient icon
a = new HtmlAnchor();
a.HRef = string.Format("Ingredients.aspx?Rno={0}", IngredRno);
a.Target = "Fix";
HtmlGenericControl i = new HtmlGenericControl("i");
i.Attributes.Add("class", "icon-edit");
i.Attributes.Add("title", "Edit this ingredient");
a.Controls.Add(i);
td.Controls.Add(a);
tr.Controls.Add(td);
tblIngreds.Rows.Add(tr);
}
divIngreds.Visible = (dt.Rows.Count > 0);
// ingredient purchase units
Sql =
"Select i.IngredRno, i.Name, x.UnitRno, d.PurchaseUnitRno, " +
"(Select UnitSingle From Units Where UnitRno = x.UnitRno) As Unit, " +
"(Select UnitSingle From Units Where UnitRno = d.PurchaseUnitRno) As PurchaseUnit " +
"From RecipeIngredXref x " +
"Inner Join PurchaseDetails d On d.IngredRno = x.IngredRno And d.PurchaseRno = (Select Max(PurchaseRno) From PurchaseDetails Where IngredRno = x.IngredRno) " +
"Inner Join Recipes r On r.RecipeRno = x.RecipeRno " +
"Inner Join Ingredients i On i.IngredRno = x.IngredRno " +
"Where x.UnitRno <> d.PurchaseUnitRno " +
"And IsNull(r.HideFlg, 0) = 0 " +
"And IsNull(i.MenuItemAsIsFlg, 0) = 0 " +
"Group By i.Name, x.UnitRno, i.IngredRno, d.PurchaseUnitRno " +
"Order By i.Name";
dt = db.DataTable(Sql);
Ingred Ingred = new Ingred(0);
int cProblems = 0;
foreach (DataRow dr in dt.Rows)
{
int IngredRno = DB.Int32(dr["IngredRno"]);
Ingred = new Ingred(IngredRno);
decimal ConversionScaler = Ingred.ConversionScaler(DB.Int32(dr["UnitRno"]), DB.Int32(dr["PurchaseUnitRno"]));
if (ConversionScaler == 0)
{
cProblems++;
HtmlTableRow tr = new HtmlTableRow();
HtmlTableCell td = new HtmlTableCell();
HtmlAnchor a = new HtmlAnchor();
a.HRef = string.Format("Ingredients.aspx?Rno={0}", IngredRno);
a.InnerText = DB.Str(dr["Name"]);
a.Target = "Fix";
td.Controls.Add(a);
tr.Controls.Add(td);
td = new HtmlTableCell();
td.InnerText = DB.Str(dr["Unit"]);;
tr.Controls.Add(td);
td = new HtmlTableCell();
td.InnerText = DB.Str(dr["PurchaseUnit"]);;
tr.Controls.Add(td);
tblPurchaseUnits.Rows.Add(tr);
}
}
divPurchaseUnits.Visible = (cProblems > 0);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Recipes.Title;
//Setup();
string Sql = string.Empty;
try
{
// get list of recipes for menu items
Sql = "Select Name, RecipeRno From Recipes Where IsNull(HideFlg, 0) = 0 Order By Name";
DataTable dtRecipes = db.DataTable(Sql);
// menu item with a recipe or marked As Is
Sql =
"Select MenuItemRno, Category, MenuItem " +
"From mcJobMenuItems " +
"Where RecipeRno Is Null " +
"And IsNull(HideFlg, 0) = 0 " +
"And IsNull(AsIsFlg, 0) = 0 " +
"And MenuItem <> '' " +
"And Category <> '' " +
"And Category In (Select Category From mcJobMenuCategories Where IsNull(HideFlg, 0) = 0) " +
"Order By MenuItem, Category";
DataTable dt = db.DataTable(Sql);
foreach (DataRow dr in dt.Rows)
{
int MenuItemRno = DB.Int32(dr["MenuItemRno"]);
// category
HtmlTableRow tr = new HtmlTableRow();
HtmlTableCell td = new HtmlTableCell();
td.InnerText = DB.Str(dr["Category"]);
td.Attributes.Add("class", "category");
tr.Controls.Add(td);
// menu item
td = new HtmlTableCell();
td.Attributes.Add("class", "menu-item");
td.Attributes.Add("data-name", DB.Str(dr["MenuItem"]));
td.InnerText = DB.Str(dr["MenuItem"]);
tr.Controls.Add(td);
// Hide
td = new HtmlTableCell();
CheckBox chk = new CheckBox();
chk.CssClass = "set-as-hidden";
chk.ToolTip = "Hide this menu item";
chk.Attributes.Add("data-item-menu-rno", MenuItemRno.ToString());
td.Controls.Add(chk);
tr.Controls.Add(td);
// as is
td = new HtmlTableCell();
chk = new CheckBox();
chk.CssClass = "mark-as-is";
chk.ToolTip = "Set menu item As Is";
chk.Attributes.Add("data-item-menu-rno", MenuItemRno.ToString());
td.Controls.Add(chk);
// edit menu item icon
HtmlAnchor a = new HtmlAnchor();
a.HRef = string.Format("SetupMenuItems.aspx?Rno={0}", MenuItemRno);
a.Target = "Fix";
HtmlGenericControl i = new HtmlGenericControl("i");
i.Attributes.Add("class", "icon-edit");
i.Attributes.Add("title", "Edit the menu item");
a.Controls.Add(i);
td.Controls.Add(a);
tr.Controls.Add(td);
// recipe
td = new HtmlTableCell();
HtmlGenericControl s = new HtmlGenericControl("select");
s.Attributes.Add("class", "select-recipe");
s.Attributes.Add("data-item-menu-rno", MenuItemRno.ToString());
HtmlGenericControl o = new HtmlGenericControl("option");
o.InnerText = "Select Recipe";
o.Attributes.Add("value", "0");
o.Attributes.Add("style", "color: #888;");
s.Controls.Add(o);
foreach (DataRow drRecipe in dtRecipes.Rows)
{
o = new HtmlGenericControl("option");
o.InnerText = DB.Str(drRecipe["Name"]);
o.Attributes.Add("value", DB.Int32(drRecipe["RecipeRno"]).ToString());
s.Controls.Add(o);
}
td.Controls.Add(s);
a = new HtmlAnchor();
a.HRef = "Recipes.aspx";
a.Target = "Fix";
i = new HtmlGenericControl("i");
i.Attributes.Add("class", "icon-edit");
i.Attributes.Add("title", "Create a recipe for this menu item.");
a.Controls.Add(i);
td.Controls.Add(a);
td.Attributes.Add("class", "select");
tr.Controls.Add(td);
tblMenuItems.Rows.Add(tr);
}
divMenuItems.Visible = (dt.Rows.Count > 0);
// subrecipe with mismatched units
Sql =
"Select r.RecipeRno, r.Name As RecipeName, sr.Name As SubrecipeName, x.SubrecipeRno, x.UnitRno, sr.YieldUnitRno, " +
"(Select UnitSingle From Units Where UnitRno = x.UnitRno) As Unit, " +
"(Select UnitSingle From Units Where UnitRno = sr.YieldUnitRno) As YieldUnit " +
"From RecipeIngredXref x " +
"Inner Join Recipes sr On sr.RecipeRno = x.SubrecipeRno " +
"Inner Join Recipes r On r.RecipeRno = x.RecipeRno " +
"Where SubrecipeRno Is Not Null " +
"And x.UnitRno <> sr.YieldUnitRno " +
"And IsNull(r.HideFlg, 0) = 0 " +
"Order By r.Name, sr.Name";
dt = db.DataTable(Sql);
Ingred Ingred = new Ingred(0);
int cProblems = 0;
foreach (DataRow dr in dt.Rows)
{
decimal ConversionScaler = Ingred.ConversionScaler(DB.Int32(dr["UnitRno"]), DB.Int32(dr["YieldUnitRno"]));
if (ConversionScaler == 0)
{
cProblems++;
HtmlTableRow tr = new HtmlTableRow();
HtmlTableCell td = new HtmlTableCell();
HtmlAnchor a = new HtmlAnchor();
a.HRef = string.Format("Recipes.aspx?Rno={0}", DB.Int32(dr["RecipeRno"]));
a.InnerText = DB.Str(dr["RecipeName"]);
a.Target = "Fix";
td.Controls.Add(a);
tr.Controls.Add(td);
td = new HtmlTableCell();
td.InnerText = DB.Str(dr["Unit"]);;
tr.Controls.Add(td);
td = new HtmlTableCell();
td.InnerText = DB.Str(dr["YieldUnit"]);;
tr.Controls.Add(td);
td = new HtmlTableCell();
td.InnerText = DB.Str(dr["SubrecipeName"]);;
tr.Controls.Add(td);
tblSubrecipe.Rows.Add(tr);
}
}
divSubrecipe.Visible = (cProblems > 0);
// zero servings recipes
Sql =
"Select RecipeRno, Name From Recipes Where IsNull(NumServings, 0) = 0 " +
"And IsNull(SubrecipeFlg, 0) = 0 " +
"And IsNull(HideFlg, 0) = 0 " +
"Order By Name";
dt = db.DataTable(Sql);
foreach (DataRow dr in dt.Rows)
{
HtmlTableRow tr = new HtmlTableRow();
HtmlTableCell td = new HtmlTableCell();
HtmlAnchor a = new HtmlAnchor();
a.HRef = string.Format("Recipes.aspx?Rno={0}", DB.Int32(dr["RecipeRno"]));
a.InnerText = DB.Str(dr["Name"]);
a.Target = "Fix";
td.Controls.Add(a);
tr.Controls.Add(td);
tblRecipes.Rows.Add(tr);
}
divRecipes.Visible = (dt.Rows.Count > 0);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
db = new DB();
Pg = new WebPage("Images");
Pg.CheckLogin(Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath));
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
Session["Menu"] = WebPage.Accounting.Title;
//Setup();
}
else
{
DateTime Tm = DateTime.Now;
// Recently edited finalized jobs
int Count = Str.Num(Request.Params["ReCount"]);
for (int i = 1; i <= Count; i++)
{
int JobRno = Str.Num(Request.Params["chkReProc" + i]);
if (JobRno > 0)
{
//string Sql = "Select CCNum1, CCNum2, CCNum3 From mcJobs Where JobRno = " + JobRno;
//DataRow dr = db.DataRow(Sql);
//string CCNum1 = DecryptCCNum(dr, "1");
//string CCNum2 = DecryptCCNum(dr, "2");
//string CCNum3 = DecryptCCNum(dr, "3");
//if (CCNum1.Length > 0)
//{
// CCNum1 = "x" + Str.Right(CCNum1, 4);
//}
//if (CCNum2.Length > 0)
//{
// CCNum2 = "x" + Str.Right(CCNum2, 4);
//}
//if (CCNum3.Length > 0)
//{
// CCNum3 = "x" + Str.Right(CCNum3, 4);
//}
string Sql = "Update mcJobs Set " +
"EditProcessedDtTm = Null, " +
"EditProcessedUser = Null, " +
//"CCSecCode1 = Null, CCSecCode2 = Null, CCSecCode3 = Null, " +
//"CCNum1 = " + DB.PutStr(CCNum1) + ", " +
//"CCNum2 = " + DB.PutStr(CCNum2) + ", " +
//"CCNum3 = " + DB.PutStr(CCNum3) + ", " +
"UpdatedDtTm = " + DB.PutDtTm(Tm) + ", " +
"UpdatedUser = "******" " +
"Where JobRno = " + JobRno;
db.Exec(Sql);
}
}
// Finalized jobs
Count = Str.Num(Request.Params["Count"]);
for (int i = 1; i <= Count; i++)
{
int JobRno = Str.Num(Request.Params["chkProc" + i]);
if (JobRno > 0)
{
//string Sql = "Select CCNum1, CCNum2, CCNum3 From mcJobs Where JobRno = " + JobRno;
//DataRow dr = db.DataRow(Sql);
//string CCNum1 = DecryptCCNum(dr, "1");
//string CCNum2 = DecryptCCNum(dr, "2");
//string CCNum3 = DecryptCCNum(dr, "3");
//if (CCNum1.Length > 0)
//{
// CCNum1 = "x" + Str.Right(CCNum1, 4);
//}
//if (CCNum2.Length > 0)
//{
// CCNum2 = "x" + Str.Right(CCNum2, 4);
//}
//if (CCNum3.Length > 0)
//{
// CCNum3 = "x" + Str.Right(CCNum3, 4);
//}
string Sql = "Update mcJobs Set " +
"ProcessedDtTm = " + DB.PutDtTm(Tm) + ", " +
"ProcessedUser = "******", " +
//"CCSecCode1 = Null, CCSecCode2 = Null, CCSecCode3 = Null, " +
//"CCNum1 = " + DB.PutStr(CCNum1) + ", " +
//"CCNum2 = " + DB.PutStr(CCNum2) + ", " +
//"CCNum3 = " + DB.PutStr(CCNum3) + ", " +
"UpdatedDtTm = " + DB.PutDtTm(Tm) + ", " +
"UpdatedUser = "******" " +
"Where JobRno = " + JobRno;
db.Exec(Sql);
}
}
}
}
