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");
}
}
