private void loadUSDACategory() { try { lblMessage.Text = ""; if (Request.QueryString["id"] != null) id = int.Parse(Request.QueryString["id"]); else Response.Redirect("default.aspx"); using (CCSEntities db = new CCSEntities()) { uc = (from category in db.USDACategories where category.USDAID == id select category).FirstOrDefault(); } if (uc != null) { lblID.Text = id.ToString(); txtDescription.Text = uc.Description; txtUSDANumber.Text = uc.USDANumber; txtCaseWeight.Text = uc.CaseWeight.ToString(); } else lblMessage.Text = "The USDA Category with ID " + id + " could not be found."; } catch (System.Threading.ThreadAbortException) { } catch (Exception ex) { LogError.logError(ex); Response.Redirect("../errorpages/error.aspx"); } }
private void removeUSDACategory() { try { lblMessage.Text = ""; id = Int16.Parse(lblID.Text); using (CCSEntities db = new CCSEntities()) { // ensure that the record is selected uc = (from category in db.USDACategories where category.USDAID == id select category).FirstOrDefault(); if (uc != null) { String categoryName = uc.Description; // saved for logging purposes db.USDACategories.Remove(uc); // remove specified record db.SaveChanges(); // commit changes LogChange.logChange("Removed USDA category called " + categoryName + ".", DateTime.Now, short.Parse(Session["UserID"].ToString())); Response.Redirect("default.aspx"); } else lblMessage.Text = "An unexpected problem occurred: Please try again later."; } } catch (System.Threading.ThreadAbortException) { } catch (Exception ex) { LogError.logError(ex); Response.Redirect("../errorpages/error.aspx"); } }
private void updateUSDACategory() { try { lblMessage.Text = ""; id = Int16.Parse(lblID.Text); Decimal caseWeight; using (CCSEntities db = new CCSEntities()) { // ensure that the record is selected uc = (from category in db.USDACategories where category.USDAID == id select category).FirstOrDefault(); if (uc != null) { if (txtDescription.Text.Length == 0) // cannot enter a blank usda name lblMessage.Text = "You must enter a USDA Category Name"; else if (txtDescription.Text.Length > 30) // usda name is too long for database lblMessage.Text = "The USDA Category Name cannot be longer than 30 characters in length."; else if (txtUSDANumber.Text.Length == 0) // cannot enter a blank usda number lblMessage.Text = "You must enter a USDA Category Number"; else if (txtUSDANumber.Text.Length > 20) // usda number is too long for database lblMessage.Text = "The USDA Category Number cannot be longer than 20 characters in length."; else if (txtCaseWeight.Text.Length == 0) // CaseWeight can't be empty lblMessage.Text = "You must enter a valid weight per case."; else if (!Decimal.TryParse(txtCaseWeight.Text, out caseWeight)) // CaseWeight must be a decimal lblMessage.Text = "You must enter a valid weight per case."; else if (caseWeight < 0) // CaseWeight must be positive lblMessage.Text = "You must enter a valid weight per case."; else // passes validation { uc.Description = txtDescription.Text; // update name uc.USDANumber = txtUSDANumber.Text; // update USDA number uc.CaseWeight = Decimal.Parse(txtCaseWeight.Text); // update the weight per case db.SaveChanges(); // commit LogChange.logChange("Edited USDA category called " + uc.Description + ".", DateTime.Now, short.Parse(Session["UserID"].ToString())); Response.Redirect("default.aspx"); } } else lblMessage.Text = "An unexpected problem occurred: Please try again later."; } } catch (System.Threading.ThreadAbortException) { } catch (Exception ex) { LogError.logError(ex); Response.Redirect("../errorpages/error.aspx"); } }
private void addUSDAType() { try { lblMessage.Text = ""; Decimal caseWeight; using (CCSEntities db = new CCSEntities()) { USDACategory uc = new USDACategory(); // create a new food category with the specified name if (txtUSDADescription.Text.Length == 0) // cannot enter a blank usda name lblMessage.Text = "You must enter a USDA Category Name"; else if (txtUSDADescription.Text.Length > 30) // usda name is too long for database lblMessage.Text = "The USDA Category Name cannot be longer than 30 characters in length."; else if (txtUSDANumber.Text.Length == 0) // cannot enter a blank usda number lblMessage.Text = "You must enter a USDA Category Number"; else if (txtUSDANumber.Text.Length > 20) // usda number is too long for database lblMessage.Text = "The USDA Category Number cannot be longer than 20 characters in length."; else if (txtCaseWeight.Text.Length == 0) // CaseWeight can't be empty lblMessage.Text = "You must enter a valid weight per case."; else if (isUSDACategoryPresent(txtUSDADescription.Text)) lblMessage.Text = "A USDA Cateogry with that name already exists."; else if (isUSDANumberPresent(txtUSDANumber.Text)) lblMessage.Text = "A USDA Cateogry with that number already exists."; else if (txtCaseWeight.Text.Length == 0) // CaseWeight can't be empty lblMessage.Text = "You must enter a valid weight per case."; else if (!Decimal.TryParse(txtCaseWeight.Text, out caseWeight)) // CaseWeight must be a decimal lblMessage.Text = "You must enter a valid weight per case."; else if (caseWeight < 0) // CaseWeight must be positive lblMessage.Text = "You must enter a valid weight per case."; else { uc.Description = txtUSDADescription.Text; uc.USDANumber = txtUSDANumber.Text; uc.CaseWeight = Decimal.Parse(txtCaseWeight.Text); db.USDACategories.Add(uc); // add the new usda category record db.SaveChanges(); LogChange.logChange("Added USDA category called " + uc.Description + ".", DateTime.Now, short.Parse(Session["UserID"].ToString())); if (pageTarget != null) { if (passedfoodInInfo != null) { Session["PassedFoodInInfo"] = passedfoodInInfo; } Response.Redirect(pageTarget); } else { Response.Redirect("default.aspx"); } } } } catch (System.Threading.ThreadAbortException) { } catch (Exception ex) { LogError.logError(ex); Response.Redirect("../errorpages/error.aspx"); } }