public ActionResult Create([Bind(Include = "JOBNO,SDATE,EDATE,STAFFCODE,REM,ROWNO,STAMP")] CSJOBSTF cSJOBSTF)
{
if (ModelState.IsValid)
{
CSJOBSTF lastRec = db.CSJOBSTFs.Where(x => x.JOBNO == cSJOBSTF.JOBNO).OrderByDescending(z => z.ROWNO).FirstOrDefault();
int rowno = 1;
if (lastRec != null)
{
rowno = lastRec.ROWNO + 1;
lastRec.EDATE = cSJOBSTF.SDATE;
lastRec.STAMP = lastRec.STAMP + 1;
db.Entry(lastRec).State = EntityState.Modified;
}
cSJOBSTF.STAMP = 0;
cSJOBSTF.ROWNO = rowno;
CSJOBM cSJOBM = db.CSJOBMs.Find(cSJOBSTF.JOBNO);
cSJOBM.JOBSTAFF = cSJOBSTF.STAFFCODE;
cSJOBM.STAMP = cSJOBM.STAMP + 1;
try
{
db.Entry(cSJOBM).State = EntityState.Modified;
db.CSJOBSTFs.Add(cSJOBSTF);
db.SaveChanges();
int page = (int)Session["CSJOBDPage"];
return(RedirectToAction("Index", "CSJOBDs", new { page = page }));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
}
ViewBag.STAFFCODE = new SelectList(db.HKSTAFFs, "STAFFCODE", "STAFFDESC", cSJOBSTF.STAFFCODE);
return(View(cSJOBSTF));
}
protected void RemoveProduct_Click(object sender, EventArgs e)
{
//on an update, you MUST ENSURE that the primary key value
// exists for use by the update
int productid = 0;
if (!int.TryParse(ProductID.Text.Trim(), out productid))
{
errormsgs.Add("Invalid or missing Product ID");
}
//all code behind logical validation errors are
// captured and reported at once
if (errormsgs.Count() > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
//connect to the appropriate BLL controller
ProductController sysmgr = new ProductController();
//issue a call to the appropriate BLL controller method
int rowsaffected = sysmgr.Product_Delete(int.Parse(ProductID.Text.Trim()));
//Handle results
if (rowsaffected == 0)
{
errormsgs.Add(ProductName.Text + " has been not been discontinued. Search for product again.");
LoadMessageDisplay(errormsgs, "alert alert-warning");
BindProductList();
}
else
{
errormsgs.Add(ProductName.Text + " has been discontinued");
LoadMessageDisplay(errormsgs, "alert alert-success");
BindProductList();
//ONLY if it is a LOGOICAL DELETE
ProductList.SelectedValue = ProductID.Text;
Discontinued.Checked = true;
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
protected void AddProduct_Click(object sender, EventArgs e)
{
//ensure validation is still good
if (Page.IsValid)
{
//event code validation that was not accomplished on
// the web form
//examples
//Assume that the CategoryID is required
if (CategoryList.SelectedIndex == 0)
{
errormsgs.Add("Category is required");
}
if (QuantityPerUnit.Text.Length > 20)
{
errormsgs.Add("Quantity per Unit is limited to 20 characters");
}
//check if click event validation is good
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
//assume taht the data is validate to our knowledge
try
{
//standard add to a database
//connect to the appropriate controller
ProductController sysmgr = new ProductController();
//create and load an instance of the entity record
// since there was no constructor placed in the
// entity, when one creaes the instance the
// default system construtor will be used
Product item = new Product();
//what about ProductID??
// since ProductID is an identity field it does NOT
// need to be loaded into the new instance
item.ProductName = ProductName.Text.Trim();
if (CategoryList.SelectedIndex == 0)
{
item.CategoryID = null;
}
else
{
item.CategoryID = int.Parse(CategoryList.SelectedValue);
}
if (SupplierList.SelectedIndex == 0)
{
item.SupplierID = null;
}
else
{
item.SupplierID = int.Parse(SupplierList.SelectedValue);
}
item.QuantityPerUnit =
string.IsNullOrEmpty(QuantityPerUnit.Text) ? null : QuantityPerUnit.Text;
if (string.IsNullOrEmpty(UnitPrice.Text))
{
item.UnitPrice = null;
}
else
{
item.UnitPrice = decimal.Parse(UnitPrice.Text);
}
if (string.IsNullOrEmpty(UnitsInStock.Text))
{
item.UnitsInStock = null;
}
else
{
item.UnitsInStock = Int16.Parse(UnitsInStock.Text);
}
if (string.IsNullOrEmpty(UnitsOnOrder.Text))
{
item.UnitsOnOrder = null;
}
else
{
item.UnitsOnOrder = Int16.Parse(UnitsOnOrder.Text);
}
if (string.IsNullOrEmpty(ReorderLevel.Text))
{
item.ReorderLevel = null;
}
else
{
item.ReorderLevel = Int16.Parse(ReorderLevel.Text);
}
//what about Discontinued??
item.Discontinued = false;
//issue the BLL call
int newProductID = sysmgr.Products_Add(item);
//give feedback
//if you get to execute the feedback code, it means
// that the product has been successfully added to
// the database
ProductID.Text = newProductID.ToString();
errormsgs.Add("Product has been added");
LoadMessageDisplay(errormsgs, "alert alert-success");
//is there any other controls on the form that need to be refreshed
BindProductList(); //by default, list will be at index 0
ProductList.SelectedValue = ProductID.Text;
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
}
protected void RemoveProduct_Click(object sender, EventArgs e)
{
//on the update you MUST ensure that the record's pkey value is present
if (string.IsNullOrEmpty(ProductID.Text.Trim()))
{
errormsgs.Add("Search for the product to be maintained.");
}
//did one pass all logic validation
if (errormsgs.Count() > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
//connect to appropriate BLL class
ProductController sysgmr = new ProductController();
//issue a call to the appropriate BLL method passing
// the instance of <T>
int rowsaffected = sysgmr.Product_Delete(int.Parse(ProductID.Text.Trim()));
//handle the results
if (rowsaffected == 0)
{
errormsgs.Add(ProductName.Text + " has not been discontinued. Search the product again");
LoadMessageDisplay(errormsgs, "alert alert-warning");
//consider refreshing the necessary controls on your form
BindProductList();
ProductID.Text = "";
}
else
{
errormsgs.Add(ProductName.Text + " has been discontinued");
LoadMessageDisplay(errormsgs, "alert alert-success");
//consider refreshing the necessary controls on your form
////physical delete
//BindProductList();
//ProductID.Text = "";
////optionally, clear the form, client decision
//Clear_Click(sender, new EventArgs());
//logical delete
BindProductList();
//refresh form controls to indicate removal
Discontinued.Checked = true;
ProductList.SelectedValue = ProductID.Text;
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
protected void AddProduct_Click(object sender, EventArgs e)
{
//if (Page.IsValid)
//{
//add any addition logic validation required for
// processing
//in this example we will assume the supplier id
// and category id are required
if (SupplierList.SelectedIndex == 0)
{
errormsgs.Add("Please select a supplier");
}
if (CategoryList.SelectedIndex == 0)
{
errormsgs.Add("Please select a category");
}
//all code behind logical validation errors are
// captured and reported at once
if(errormsgs.Count() > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
//create an instance of Product
Product item = new Product();
//collect the data from the web form and place
// in the Product instance
item.ProductName = ProductName.Text;
item.SupplierID = int.Parse(SupplierList.SelectedValue);
item.CategoryID = int.Parse(CategoryList.SelectedValue);
item.QuantityPerUnit = string.IsNullOrEmpty(QuantityPerUnit.Text.Trim()) ? null : QuantityPerUnit.Text.Trim();
if (string.IsNullOrEmpty(UnitPrice.Text))
{
item.UnitPrice = null;
}
else
{
item.UnitPrice = decimal.Parse(UnitPrice.Text);
}
if (string.IsNullOrEmpty(UnitsInStock.Text))
{
item.UnitsInStock = null;
}
else
{
item.UnitsInStock = Int16.Parse(UnitsInStock.Text);
}
if (string.IsNullOrEmpty(UnitsOnOrder.Text))
{
item.UnitsOnOrder = null;
}
else
{
item.UnitsOnOrder = Int16.Parse(UnitsOnOrder.Text);
}
if (string.IsNullOrEmpty(ReorderLevel.Text))
{
item.ReorderLevel = null;
}
else
{
item.ReorderLevel = Int16.Parse(ReorderLevel.Text);
}
//handling of the Discontinued can be done manually
// or logically
item.Discontinued = false;
//connect to the appropriate BLL controller
ProductController sysmgr = new ProductController();
//issue a call to the appropriate BLL controller method
int newProductID = sysmgr.Product_Add(item);
//Handle results
errormsgs.Add(ProductName.Text + " has been added to the database with a key of " + newProductID.ToString());
LoadMessageDisplay(errormsgs, "alert alert-success");
//also if any control on this form uses this new instance
// for a query or other action, you must update (refresh)
// that control
BindProductList();
ProductID.Text = newProductID.ToString();
ProductList.SelectedValue = ProductID.Text;
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
//}
}
public ActionResult Create([Bind(Include = "CONO,EFFDATE,EQCODE,EQCONSIDER,NOOFSHARES,NOMINAL,PAIDAMT,DUEAMT,PREMIUM,NCDETStr,NCDET,ENDDATE,ROWNO,STAMP")] CSCOPUK cSCOPUK)
{
if (ModelState.IsValid)
{
int lastRowNo = 0;
try
{
lastRowNo = db.CSCOPUKs.Where(m => m.CONO == cSCOPUK.CONO).Max(n => n.ROWNO);
}
catch (Exception e) { lastRowNo = 0; }
finally { };
try
{
cSCOPUK.ROWNO = lastRowNo + 1;
cSCOPUK.STAMP = 0;
db.CSCOPUKs.Add(cSCOPUK);
db.SaveChanges();
return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOPUK.CONO) }) + "#PaidUp"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
}
ViewBag.EQCODE = new SelectList(db.CSEQs, "EQCODE", "EQDESC", cSCOPUK.EQCODE);
ViewBag.EQCONSIDER = cSCOPUK.consideration;
cSCOPUK.CSCOMSTR = db.CSCOMSTRs.Find(cSCOPUK.CONO);
return(View(cSCOPUK));
}
protected void AddProduct_Click(object sender, EventArgs e)
{
//execute your form validation
//if (Page.IsValid)
//{
//any logic validation on covered by form validation
//for this example, I will assume that the CategoryID
// and SupplierID are needed
if (SupplierList.SelectedIndex == 0)
{
errormsgs.Add("Select a supplier");
}
if (CategoryList.SelectedIndex == 0)
{
errormsgs.Add("Select a category");
}
//did one pass all logic validation
if (errormsgs.Count() > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
//create an instance of <T>
Product item = new Product();
//extract data from form and load <T>
item.ProductName = ProductName.Text;
item.SupplierID = int.Parse(SupplierList.SelectedValue);
item.CategoryID = int.Parse(CategoryList.SelectedValue);
item.QuantityPerUnit = string.IsNullOrEmpty(QuantityPerUnit.Text.Trim()) ?
null : QuantityPerUnit.Text;
if (string.IsNullOrEmpty(UnitPrice.Text.Trim()))
{
item.UnitPrice = null;
}
else
{
item.UnitPrice = decimal.Parse(UnitPrice.Text.Trim());
}
if (string.IsNullOrEmpty(UnitsInStock.Text.Trim()))
{
item.UnitsInStock = null;
}
else
{
item.UnitsInStock = Int16.Parse(UnitsInStock.Text.Trim());
}
if (string.IsNullOrEmpty(UnitsOnOrder.Text.Trim()))
{
item.UnitsOnOrder = null;
}
else
{
item.UnitsOnOrder = Int16.Parse(UnitsOnOrder.Text.Trim());
}
if (string.IsNullOrEmpty(ReorderLevel.Text.Trim()))
{
item.ReorderLevel = null;
}
else
{
item.ReorderLevel = Int16.Parse(ReorderLevel.Text.Trim());
}
//logically this is a new product, therefore discontinued can
// be set for the user to false
item.Discontinued = false;
//connect to appropriate BLL class
ProductController sysgmr = new ProductController();
//issue a call to the appropriate BLL method passing
// the instance of <T>
int newProductID = sysgmr.Product_Add(item);
//handle the results
errormsgs.Add(ProductName.Text + " has been added to the database with an id of " + newProductID.ToString());
LoadMessageDisplay(errormsgs, "alert alert-success");
//refresh of the web page/web controls
//display the new productid in its field
ProductID.Text = newProductID.ToString();
BindProductList();
ProductList.SelectedValue = ProductID.Text;
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
//}
}
protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (GuardianID.SelectedIndex == 0)
{
errormsgs.Add("Category is required");
}
if (TeamID.SelectedIndex == 0)
{
errormsgs.Add("Category is required");
}
if (PlayerGender.SelectedIndex != 0 && PlayerGender.SelectedIndex != 1)
{
errormsgs.Add("A Player Gender is required.");
}
int playerid = 0;
if (string.IsNullOrEmpty(PlayerID.Text))
{
errormsgs.Add("Search for a player to update");
}
else if (!int.TryParse(PlayerID.Text, out playerid))
{
errormsgs.Add("Player id is invalid");
}
else if (playerid < 1)
{
errormsgs.Add("Player id is invalid");
}
//is data still good
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
PlayerController sysmgr = new PlayerController();
Player item = new Player();
item.PlayerID = playerid;
item.GuardianID = int.Parse(GuardianID.SelectedValue);
item.TeamId = int.Parse(TeamID.SelectedValue);
item.FirstName = FirstName.Text.Trim();
item.LastName = LastName.Text.Trim();
item.Age = int.Parse(PlayerAge.Text);
item.Gender = PlayerAge.Text.Trim();
item.AlbertaHealthCareNumber = AlbertaHealthCareNumber.Text.Trim();
item.MedicalAlertDetails =
string.IsNullOrEmpty(MedicalAlerts.Text) ? null : MedicalAlerts.Text.Trim();
//issue the BLL call
int rowsaffected = sysmgr.Products_Update(item);
//give feedback
if (rowsaffected > 0)
{
errormsgs.Add("Product has been updated");
LoadMessageDisplay(errormsgs, "alert alert-success");
//is there any other controls on the form that
// need to be refreshed??
BindPlayerList(); //by default, list will be at index 0
PlayerSearch.SelectedValue = PlayerID.Text;
}
else
{
errormsgs.Add("Product has not been updated. Product was not found");
LoadMessageDisplay(errormsgs, "alert alert-warning");
BindPlayerList();
//optionally you could clear your fields
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
}
protected void Delete_Click(object sender, EventArgs e)
{
int playerid = 0;
if (string.IsNullOrEmpty(PlayerID.Text))
{
errormsgs.Add("Search for a product to update");
}
else if (!int.TryParse(PlayerID.Text, out playerid))
{
errormsgs.Add("Product id is invalid");
}
else if (playerid < 1)
{
errormsgs.Add("Product id is invalid");
}
//is data still good
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
PlayerController sysmgr = new PlayerController();
int rowsaffected = sysmgr.Players_Delete(playerid);
if (rowsaffected > 0)
{
errormsgs.Add("Player has been removed");
LoadMessageDisplay(errormsgs, "alert alert-success");
}
else
{
errormsgs.Add("Player already removed");
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
public ActionResult Edit([Bind(Include = "PRSCODE,CTRYCODE,REGTYPE,REGNO,REM,STAMP")] CSPRSREG cSPRSREG)
{
if (ModelState.IsValid)
{
cSPRSREG.STAMP = cSPRSREG.STAMP + 1;
try
{
bool changed = false;
CSPRSREG csOrig = (CSPRSREG)Session["CSPRSREG_ORIG"];
if (csOrig.CTRYCODE != cSPRSREG.CTRYCODE)
{
changed = true;
}
if (csOrig.REGTYPE != cSPRSREG.REGTYPE)
{
changed = true;
}
if (csOrig.REGNO != cSPRSREG.REGNO)
{
changed = true;
}
if (changed)
{
CSPRSREG csDel = db.CSPRSREGs.Find(csOrig.PRSCODE, csOrig.CTRYCODE, csOrig.REGTYPE, csOrig.REGNO);;
db.CSPRSREGs.Remove(csDel);
db.CSPRSREGs.Add(cSPRSREG);
}
else
{
db.Entry(cSPRSREG).State = EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("Edit", "CSPRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSPRSREG.PRSCODE) }));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
}
ViewBag.PRSCODE = MyHtmlHelpers.ConvertByteStrToId(cSPRSREG.PRSCODE);
ViewBag.REGTYPE = new SelectList(db.HKREGTYPEs.Select(x => new { REGTYPE = x.REGTYPE, REGDESC = x.CTRYOPR + " | " + x.REGTYPE }), "REGTYPE", "REGDESC");
ViewBag.CTRYCODE = new SelectList(db.HKCTRies.OrderBy(x => x.CTRYCODE), "CTRYCODE", "CTRYDESC", cSPRSREG.CTRYCODE);
return(View(cSPRSREG));
}
protected void Add_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (GuardianID.SelectedIndex == 0)
{
errormsgs.Add("Category is required");
}
if (TeamID.SelectedIndex == 0)
{
errormsgs.Add("Category is required");
}
if (PlayerGender.SelectedIndex != 0 && PlayerGender.SelectedIndex != 1)
{
errormsgs.Add("A Player Gender is required.");
}
//is data still good
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
PlayerController sysmgr = new PlayerController();
Player item = new Player();
item.GuardianID = int.Parse(GuardianID.SelectedValue);
item.TeamId = int.Parse(TeamID.SelectedValue);
item.FirstName = FirstName.Text.Trim();
item.LastName = LastName.Text.Trim();
item.Age = int.Parse(PlayerAge.Text);
item.Gender = PlayerAge.Text.Trim();
item.AlbertaHealthCareNumber = AlbertaHealthCareNumber.Text.Trim();
item.MedicalAlertDetails =
string.IsNullOrEmpty(MedicalAlerts.Text) ? null : MedicalAlerts.Text.Trim();
int newPlayerID = sysmgr.Player_Add(item);
PlayerID.Text = newPlayerID.ToString();
errormsgs.Add("Player has been added");
LoadMessageDisplay(errormsgs, "alert alert-success");
BindPlayerList();
PlayerSearch.SelectedValue = PlayerID.Text;
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
}
protected void RemoveProduct_Click(object sender, EventArgs e)
{
//event code validation that was not accomplished on
// the web form
//examples
//Assume that the CategoryID is required
//on delete, ensure you have your primary key value
int productid = 0;
if (string.IsNullOrEmpty(ProductID.Text))
{
errormsgs.Add("Search for a product to update");
}
else if (!int.TryParse(ProductID.Text, out productid))
{
errormsgs.Add("Product id is invalid");
}
else if (productid < 1)
{
errormsgs.Add("Product id is invalid");
}
//check if click event validation is good
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
//assume taht the data is validate to our knowledge
try
{
//standard delete to a database
//connect to the appropriate controller
ProductController sysmgr = new ProductController();
//issue the BLL call
int rowsaffected = sysmgr.Products_Delete(productid);
//give feedback
if (rowsaffected > 0)
{
errormsgs.Add("Product has been discontinued");
LoadMessageDisplay(errormsgs, "alert alert-success");
//is there any other controls on the form that need to be refreshed
BindProductList(); //by default, list will be at index 0
ProductList.SelectedValue = ProductID.Text; //logical delete
Discontinued.Checked = true; //logical delete
}
else
{
errormsgs.Add("Product has not been discontinued. Product was not found");
LoadMessageDisplay(errormsgs, "alert alert-warning");
//is there any other controls on the form that need to be refreshed
BindProductList(); //by default, list will be at index 0
//optionally you could clear your fields
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
public ActionResult Edit([Bind(Include = "CASECODE,CASEDESC,MAPSFIX,STAMP")] CSCASE cSCASE)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCASE curRec = newdb.CSCASEs.Find(cSCASE.CASECODE);
if (curRec.STAMP == cSCASE.STAMP)
{
cSCASE.STAMP = cSCASE.STAMP + 1;
db.Entry(cSCASE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
return(View(cSCASE));
}
protected void OnUpdateException(
ExceptionEventArgs args)
{
UpdateException?.Invoke(args);
}
public ActionResult Edit([Bind(Include = "CONO,PRSCODE,ADATE,RDATE,ENDDATE,REM,ROWNO,STAMP")] CSCODR cSCODR)
{
if (ModelState.IsValid)
{
try
{
bool changed = false;
CSCODR csOrig = (CSCODR)Session["CSCODR_ORIG"];
if (csOrig.PRSCODE != cSCODR.PRSCODE)
{
changed = true;
}
if (csOrig.ADATE != cSCODR.ADATE)
{
changed = true;
}
if (changed)
{
CSCODR csDel = db.CSCODRs.Find(csOrig.CONO, csOrig.PRSCODE, csOrig.ADATE);
db.CSCODRs.Remove(csDel);
db.CSCODRs.Add(cSCODR);
}
else
{
db.Entry(cSCODR).State = EntityState.Modified;
}
cSCODR.STAMP = cSCODR.STAMP + 1;
db.SaveChanges();
return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCODR.CONO) }) + "#Director"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
}
cSCODR.CSCOMSTR = db.CSCOMSTRs.Find(cSCODR.CONO);
cSCODR.CSCODRCHGs = db.CSCODRCHGs.Where(x => x.CONO == cSCODR.CONO && x.PRSCODE == cSCODR.PRSCODE && x.ADATE == cSCODR.ADATE).ToList();
ViewBag.PRSCODE = new SelectList(db.CSPRS.Where(x => x.HKCONST.CONSTTYPE == "Individual").OrderBy(x => x.PRSNAME), "PRSCODE", "PRSNAME", cSCODR.PRSCODE);
return(View(cSCODR));
}
public ActionResult Create([Bind(Include = "CONO,PRSCODE,ADATE,CHGEFFDATE,CHGREM,PRSNAME,NATION,RACE,ADDRID,OCCUPATION,REGCTRY1,REGTYPE1,REGID1,REGCTRY2,REGTYPE2,REGID2,REM,ROWNO,STAMP")] CSCOAGTCHG cSCOAGTCHG)
{
if (ModelState.IsValid)
{
try
{
int lastRowNo = 0;
try
{
lastRowNo = db.CSCOAGTCHGs.Where(m => m.CONO == cSCOAGTCHG.CONO && m.PRSCODE == cSCOAGTCHG.PRSCODE && m.ADATE == cSCOAGTCHG.ADATE).Max(n => n.ROWNO);
}
catch (Exception e) { lastRowNo = 0; }
finally { };
cSCOAGTCHG.ROWNO = lastRowNo + 1;
cSCOAGTCHG.STAMP = 0;
db.CSCOAGTCHGs.Add(cSCOAGTCHG);
db.SaveChanges();
return(new RedirectResult(Url.Action("Edit", "CSCOAGTs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOAGTCHG.CONO), person = cSCOAGTCHG.PRSCODE, adate = cSCOAGTCHG.ADATE })));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
}
ViewBag.NATION = new SelectList(db.HKNATIONs, "NATION", "NATION", cSCOAGTCHG.NATION);
ViewBag.RACE = new SelectList(db.HKRACEs, "RACE", "RACE", cSCOAGTCHG.RACE);
ViewBag.CHGREM = new SelectList(db.CSCHGREMs.OrderBy(x => x.CHGREM), "CHGREM", "CHGREM", cSCOAGTCHG.CHGREM);
ViewBag.ADDRID = new SelectList(db.CSPRSADDRs.Where(x => x.PRSCODE == cSCOAGTCHG.PRSCODE).OrderBy(y => y.ADDRID).Select(z => new { ADDRID = z.ADDRID, MAILDET = z.ADDRID + " | " + z.MAILADDR + " | " + z.ADDRTYPE + " | " + z.ADDR1 + z.ADDR2 + z.ADDR3 }), "ADDRID", "MAILDET", cSCOAGTCHG.ADDRID);
ViewBag.REGID1 = new SelectList(db.CSPRSREGs.Where(x => x.PRSCODE == cSCOAGTCHG.PRSCODE).Select(x => new { REGNO = x.REGNO, PRSNAME = x.CTRYCODE + " | " + x.REGTYPE + " | " + x.REGNO }), "REGNO", "PRSNAME", cSCOAGTCHG.REGID1);
ViewBag.REGID2 = new SelectList(db.CSPRSREGs.Where(x => x.PRSCODE == cSCOAGTCHG.PRSCODE).Select(x => new { REGNO = x.REGNO, PRSNAME = x.CTRYCODE + " | " + x.REGTYPE + " | " + x.REGNO }), "REGNO", "PRSNAME", cSCOAGTCHG.REGID2);
return(View(cSCOAGTCHG));
}
public ActionResult Create([Bind(Include = "CONO,PRSCODE,ADATE,RDATE,ENDDATE,REM,ROWNO,STAMP")] CSCODR cSCODR)
{
if (ModelState.IsValid)
{
int lastRowNo = 0;
try
{
lastRowNo = db.CSCODRs.Where(m => m.CONO == cSCODR.CONO).Max(n => n.ROWNO);
}
catch (Exception e) { lastRowNo = 0; }
finally { };
cSCODR.STAMP = 0;
try
{
cSCODR.ROWNO = lastRowNo + 1;
db.CSCODRs.Add(cSCODR);
db.SaveChanges();
return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCODR.CONO) }) + "#Director"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
}
cSCODR.CSCOMSTR = db.CSCOMSTRs.Find(cSCODR.CONO);
ViewBag.PRSCODE = new SelectList(db.CSPRS.Where(x => x.HKCONST.CONSTTYPE == "Individual").OrderBy(x => x.PRSNAME), "PRSCODE", "PRSNAME", cSCODR.PRSCODE);
return(View(cSCODR));
}
public ActionResult Create([Bind(Include = "CONO,SDATE,COSTAT,FILETYPE,FILELOC,SEALLOC,EDATE,ROWNO,STAMP")] CSCOSTAT cSCOSTAT)
{
if (ModelState.IsValid)
{
int lastRowNo = 0;
try
{
lastRowNo = db.CSCOSTATs.Where(m => m.CONO == cSCOSTAT.CONO).Max(n => n.ROWNO);
}
catch (Exception e) { lastRowNo = 0; }
finally { };
try
{
cSCOSTAT.STAMP = 0;
cSCOSTAT.EDATE = new DateTime(3000, 1, 1);
cSCOSTAT.ROWNO = lastRowNo + 1;
db.CSCOSTATs.Add(cSCOSTAT);
UpdateCompany(cSCOSTAT);
UpdatePreviousRow(cSCOSTAT);
db.SaveChanges();
//return RedirectToAction("Details","CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) });
return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) }) + "#Status"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
}
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View(cSCOSTAT));
}
protected void InsertTeam_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (errormsgs.Count() > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
//create an instance of product
Team item = new Team();
//collect the data from the web form and place in the product instance
item.TeamName = TeamNameV2.Text;
item.Coach = CoachNameV2.Text;
item.AssistantCoach = AssistantCoachV2.Text;
if (string.IsNullOrEmpty(WinsV2.Text))
{
item.Wins = 0;
}
else
{
item.Wins = int.Parse(WinsV2.Text);
}
if (string.IsNullOrEmpty(LossesV2.Text))
{
item.Losses = 0;
}
else
{
item.Losses = int.Parse(LossesV2.Text);
}
TeamController sysmgr = new TeamController();
//Issue a call to the apropriate BLL controller method
int newTeamID = sysmgr.Team_Add(item);
//handle results
errormsgs.Add(TeamNameV2.Text + " has been added to the database with a key of " + newTeamID.ToString());
LoadMessageDisplay(errormsgs, "alert alert-success");
// also if any controll uses this new instance for a query or other action, you must update (refresh) that control
BindTeamList();
TeamListV2.SelectedValue = newTeamID.ToString();
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
}
public ActionResult Create1([Bind(Include = "CONO,SDATE,COSTAT,FILETYPE,FILELOC,SEALLOC,EDATE,ROWNO,STAMP")] CSCOSTAT cSCOSTAT)
{
int page = (int)Session["CSCOSTATPage"];
if (ModelState.IsValid)
{
int lastRowNo = 0;
try
{
lastRowNo = db.CSCOSTATs.Where(m => m.CONO == cSCOSTAT.CONO).Max(n => n.ROWNO);
}
catch (Exception e) { lastRowNo = -1; }
finally { };
try
{
cSCOSTAT.STAMP = 0;
cSCOSTAT.EDATE = new DateTime(3000, 1, 1);
cSCOSTAT.ROWNO = lastRowNo + 1;
db.CSCOSTATs.Add(cSCOSTAT);
UpdateCompany(cSCOSTAT);
UpdatePreviousRow(cSCOSTAT);
db.SaveChanges();
return(RedirectToAction("Index", new { page = page }));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
}
ViewBag.CONO = new SelectList(db.CSCOMSTRs.Select(x => new { CONO = x.CONO, CONAME = x.CONAME + " (" + x.CONO + ")" }).OrderBy(y => y.CONAME), "CONO", "CONAME");
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
ViewBag.page = page;
ViewBag.Title = "Add Company Change Status";
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View(cSCOSTAT));
}
protected void UpdateProduct_Click(object sender, EventArgs e)
{
//execute your form validation
//if (Page.IsValid)
//{
//any logic validation on covered by form validation
//for this example, I will assume that the CategoryID
// and SupplierID are needed
if (SupplierList.SelectedIndex == 0)
{
errormsgs.Add("Select a supplier");
}
if (CategoryList.SelectedIndex == 0)
{
errormsgs.Add("Select a category");
}
//on the update you MUST ensure that the record's pkey value is present
if (string.IsNullOrEmpty(ProductID.Text.Trim()))
{
errormsgs.Add("Search for the product to be maintained.");
}
//did one pass all logic validation
if (errormsgs.Count() > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
//create an instance of <T>
Product item = new Product();
//extract data from form and load <T>
//on the update you MUST ensure that the record's pkey value
// is loaded to the instance
item.ProductID = int.Parse(ProductID.Text.Trim());
item.ProductName = ProductName.Text;
item.SupplierID = int.Parse(SupplierList.SelectedValue);
item.CategoryID = int.Parse(CategoryList.SelectedValue);
item.QuantityPerUnit = string.IsNullOrEmpty(QuantityPerUnit.Text.Trim()) ?
null : QuantityPerUnit.Text;
if (string.IsNullOrEmpty(UnitPrice.Text.Trim()))
{
item.UnitPrice = null;
}
else
{
item.UnitPrice = decimal.Parse(UnitPrice.Text.Trim());
}
if (string.IsNullOrEmpty(UnitsInStock.Text.Trim()))
{
item.UnitsInStock = null;
}
else
{
item.UnitsInStock = Int16.Parse(UnitsInStock.Text.Trim());
}
if (string.IsNullOrEmpty(UnitsOnOrder.Text.Trim()))
{
item.UnitsOnOrder = null;
}
else
{
item.UnitsOnOrder = Int16.Parse(UnitsOnOrder.Text.Trim());
}
if (string.IsNullOrEmpty(ReorderLevel.Text.Trim()))
{
item.ReorderLevel = null;
}
else
{
item.ReorderLevel = Int16.Parse(ReorderLevel.Text.Trim());
}
//on an update, you take the value from the control
item.Discontinued = Discontinued.Checked;
//connect to appropriate BLL class
ProductController sysgmr = new ProductController();
//issue a call to the appropriate BLL method passing
// the instance of <T>
int rowsaffected = sysgmr.Product_Update(item);
//handle the results
if (rowsaffected == 0)
{
errormsgs.Add(ProductName.Text + " has not been updated. Search the product again");
LoadMessageDisplay(errormsgs, "alert alert-warning");
//consider refreshing the necessary controls on your form
BindProductList();
ProductID.Text = "";
}
else
{
errormsgs.Add(ProductName.Text + " has been updated");
LoadMessageDisplay(errormsgs, "alert alert-success");
//consider refreshing the necessary controls on your form
BindProductList();
ProductList.SelectedValue = ProductID.Text;
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
//}
}
public ActionResult Edit([Bind(Include = "CONO,SDATE,COSTAT,FILETYPE,FILELOC,SEALLOC,EDATE,ROWNO,STAMP")] CSCOSTAT cSCOSTAT)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
CSCOSTAT curRec = newdb.CSCOSTATs.Find(cSCOSTAT.CONO, cSCOSTAT.ROWNO);
if (curRec.STAMP == cSCOSTAT.STAMP)
{
cSCOSTAT.STAMP = cSCOSTAT.STAMP + 1;
// only update the latest record
if (db.CSCOSTATs.Where(x => x.CONO == cSCOSTAT.CONO).OrderByDescending(x => x.ROWNO).Select(x => x.ROWNO).FirstOrDefault() == cSCOSTAT.ROWNO)
{
UpdateCompany(cSCOSTAT);
}
UpdatePreviousRow(cSCOSTAT);
db.Entry(cSCOSTAT).State = EntityState.Modified;
db.SaveChanges();
// return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) });
return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) }) + "#Status"));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View(cSCOSTAT));
}
protected void Search_Click(object sender, EventArgs e)
{
if ( ProductList.SelectedIndex == 0)
{
errormsgs.Add("Select a product from the list to search");
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
ProductController sysmgr = new ProductController();
Product datainfo = sysmgr.Product_Get(int.Parse(ProductList.SelectedValue));
if (datainfo == null)
{
errormsgs.Add(ProductList.SelectedItem.Text + " cannot be found. Make another selection");
LoadMessageDisplay(errormsgs, "alert alert-info");
Clear_Click(sender, e);
}
else
{
ProductID.Text = datainfo.ProductID.ToString();
ProductName.Text = datainfo.ProductName;
QuantityPerUnit.Text = string.IsNullOrEmpty(datainfo.QuantityPerUnit)? "" : datainfo.QuantityPerUnit;
UnitPrice.Text = string.IsNullOrEmpty(datainfo.UnitPrice.ToString()) ? "" : string.Format("{0:0.00}",datainfo.UnitPrice);
UnitsInStock.Text = string.IsNullOrEmpty(datainfo.UnitsInStock.ToString()) ? "" : datainfo.UnitsInStock.ToString();
UnitsOnOrder.Text = string.IsNullOrEmpty(datainfo.UnitsOnOrder.ToString()) ? "" : datainfo.UnitsOnOrder.ToString();
ReorderLevel.Text = string.IsNullOrEmpty(datainfo.ReorderLevel.ToString()) ? "" : datainfo.ReorderLevel.ToString();
if (string.IsNullOrEmpty(datainfo.CategoryID.ToString()))
{
CategoryList.SelectedIndex = 0;
}
else
{
CategoryList.SelectedValue = datainfo.CategoryID.ToString();
}
if (string.IsNullOrEmpty(datainfo.SupplierID.ToString()))
{
SupplierList.SelectedIndex = 0;
}
else
{
SupplierList.SelectedValue = datainfo.SupplierID.ToString();
}
Discontinued.Checked = datainfo.Discontinued;
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
public ActionResult Edit1([Bind(Include = "CONO,SDATE,COSTAT,FILETYPE,FILELOC,SEALLOC,EDATE,ROWNO,STAMP")] CSCOSTAT cSCOSTAT)
{
if (ModelState.IsValid)
{
ASIDBConnection newdb = new ASIDBConnection();
try
{
string oldKey = (string)Session["CSCOSTAT_OLDCONO"];
CSCOSTAT curRec = db.CSCOSTATs.Find(oldKey, cSCOSTAT.ROWNO); //allowing for key change
if (curRec.STAMP == cSCOSTAT.STAMP)
{
cSCOSTAT.STAMP = cSCOSTAT.STAMP + 1;
if (oldKey != cSCOSTAT.CONO)
{
curRec.SDATE = new DateTime(3000, 1, 2); // make sure the old previous row date gets reversed
UpdatePreviousRow(curRec);
db.CSCOSTATs.Remove(curRec);
int lastRowNo = 0;
try
{
lastRowNo = db.CSCOSTATs.Where(m => m.CONO == cSCOSTAT.CONO).Max(n => n.ROWNO);
}
catch (Exception e) { lastRowNo = -1; }
finally { };
cSCOSTAT.ROWNO = lastRowNo + 1;
db.CSCOSTATs.Add(cSCOSTAT);
}
else
{
db.Entry(cSCOSTAT).State = EntityState.Modified;
}
if (db.CSCOSTATs.Where(x => x.CONO == cSCOSTAT.CONO).OrderByDescending(x => x.ROWNO).Select(x => x.ROWNO).FirstOrDefault() == cSCOSTAT.ROWNO)
{
UpdateCompany(cSCOSTAT);
}
UpdatePreviousRow(cSCOSTAT); // will always do this for the current record
db.SaveChanges();
// return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) });
//return new RedirectResult(Url.Action("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) }) + "#Status");
int page = (int)Session["CSCOSTATPage"];
return(RedirectToAction("Index", new { page = page }));
}
else
{
ModelState.AddModelError(string.Empty, "Record is modified");
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
finally
{
newdb.Dispose();
}
}
ViewBag.CONO = new SelectList(db.CSCOMSTRs.Select(x => new { CONO = x.CONO, CONAME = x.CONAME + " (" + x.CONO + ")" }).OrderBy(y => y.CONAME), "CONO", "CONAME", cSCOSTAT.CONO);
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View(cSCOSTAT));
}
protected void UpdateProduct_Click(object sender, EventArgs e)
{
//if (Page.IsValid)
//{
//add any addition logic validation required for
// processing
//in this example we will assume the supplier id
// and category id are required
if (SupplierList.SelectedIndex == 0)
{
errormsgs.Add("Please select a supplier");
}
if (CategoryList.SelectedIndex == 0)
{
errormsgs.Add("Please select a category");
}
//on an update, you MUST ENSURE that the primary key value
// exists for use by the update
int productid = 0;
if (!int.TryParse(ProductID.Text.Trim(), out productid))
{
errormsgs.Add("Invalid or missing Product ID");
}
//all code behind logical validation errors are
// captured and reported at once
if (errormsgs.Count() > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
//create an instance of Product
Product item = new Product();
//collect the data from the web form and place
// in the Product instance
//on the update, the primary identity key value
// MUST ALSO be loaded to the instance
item.ProductID = int.Parse(ProductID.Text.Trim());
item.ProductName = ProductName.Text;
item.SupplierID = int.Parse(SupplierList.SelectedValue);
item.CategoryID = int.Parse(CategoryList.SelectedValue);
item.QuantityPerUnit = string.IsNullOrEmpty(QuantityPerUnit.Text.Trim()) ? null : QuantityPerUnit.Text.Trim();
if (string.IsNullOrEmpty(UnitPrice.Text))
{
item.UnitPrice = null;
}
else
{
item.UnitPrice = decimal.Parse(UnitPrice.Text);
}
if (string.IsNullOrEmpty(UnitsInStock.Text))
{
item.UnitsInStock = null;
}
else
{
item.UnitsInStock = Int16.Parse(UnitsInStock.Text);
}
if (string.IsNullOrEmpty(UnitsOnOrder.Text))
{
item.UnitsOnOrder = null;
}
else
{
item.UnitsOnOrder = Int16.Parse(UnitsOnOrder.Text);
}
if (string.IsNullOrEmpty(ReorderLevel.Text))
{
item.ReorderLevel = null;
}
else
{
item.ReorderLevel = Int16.Parse(ReorderLevel.Text);
}
//handling of the Discontinued needs to take the current
// value from the form
item.Discontinued = Discontinued.Checked;
//connect to the appropriate BLL controller
ProductController sysmgr = new ProductController();
//issue a call to the appropriate BLL controller method
int rowsaffected = sysmgr.Product_Update(item);
//Handle results
if (rowsaffected == 0)
{
errormsgs.Add(ProductName.Text + " has been not been updated. Search for product again.");
LoadMessageDisplay(errormsgs, "alert alert-warning");
BindProductList();
}
else
{
errormsgs.Add(ProductName.Text + " has been updated");
LoadMessageDisplay(errormsgs, "alert alert-success");
BindProductList();
ProductList.SelectedValue = ProductID.Text;
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
//}
}
public ActionResult DeleteConfirmed(string id, int row)
{
CSCOSTAT cSCOSTAT = db.CSCOSTATs.Find(MyHtmlHelpers.ConvertByteStrToId(id), row);
CSCOSTAT curRec = UpdatePreviousRow(cSCOSTAT);
if (curRec != null)
{
try
{
if (db.CSCOSTATs.Where(x => x.CONO == cSCOSTAT.CONO).OrderByDescending(x => x.ROWNO).Select(x => x.ROWNO).FirstOrDefault() == cSCOSTAT.ROWNO)
{
UpdateCompany(curRec);
}
db.CSCOSTATs.Remove(cSCOSTAT);
db.SaveChanges();
// return RedirectToAction("Details", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) });
return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSTAT.CONO) }) + "#Status"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, "Cannot delete the only status record");
}
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
ViewBag.Title = "Delete Company Change Status";
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View(cSCOSTAT));
}
private void button6_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow dgv in dataGridView1.Rows)
{
if (dataGridView2.Rows.Count > 0)
{
foreach (DataGridViewRow dv in dataGridView2.Rows)
{
var ems = data.foods.Find(int.Parse(dv.Cells[0].Value.ToString()));
try
{
data.foods.Remove(ems);
}
catch (Exception ex) { }
}
}
int rawId = int.Parse(dgv.Cells[1].Value.ToString());
var aa = data.foods.Where(x => x.foodid.Equals(rawId)).Count();
if (aa > 0)
{
var em = data.foods.Where(x => x.foodid.Equals(rawId)).First();
em.foodname = dgv.Cells[2].Value.ToString();
em.description = dgv.Cells[3].Value.ToString();
em.price = int.Parse(dgv.Cells[4].Value.ToString());
em.status = "A";
try
{
data.SaveChanges();
}
catch (DbUpdateException ex)
{
UpdateException updateEx = (UpdateException)ex.InnerException;
SqlException sqlEx = (SqlException)updateEx.InnerException;
foreach (SqlError a in sqlEx.Errors)
{
MessageBox.Show(a.Message);
}
continue;
}
}
else
{
food em = new food();
em.foodid = int.Parse(dgv.Cells[1].Value.ToString());
em.foodname = dgv.Cells[2].Value.ToString();
em.description = dgv.Cells[3].Value.ToString();
em.price = int.Parse(dgv.Cells[4].Value.ToString());
em.status = "A";
try
{
data.foods.Add(em);
data.SaveChanges();
}
catch (DbUpdateException ex)
{
UpdateException updateEx = (UpdateException)ex.InnerException;
SqlException sqlEx = (SqlException)updateEx.InnerException;
foreach (SqlError a in sqlEx.Errors)
{
MessageBox.Show(a.Message);
}
continue;
}
}
}
MessageBox.Show("Data updated!");
loadFood();
}
public ActionResult Delete1Confirmed(string id, int row, int?page)
{
CSCOSTAT cSCOSTAT = db.CSCOSTATs.Find(MyHtmlHelpers.ConvertByteStrToId(id), row);
CSCOSTAT curRec = UpdatePreviousRow(cSCOSTAT);
if (curRec != null)
{
try
{
if (db.CSCOSTATs.Where(x => x.CONO == cSCOSTAT.CONO).OrderByDescending(x => x.ROWNO).Select(x => x.ROWNO).FirstOrDefault() == cSCOSTAT.ROWNO)
{
UpdateCompany(curRec);
}
db.CSCOSTATs.Remove(cSCOSTAT);
db.SaveChanges();
return(RedirectToAction("Index", new { page = page }));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, "Cannot delete the only status record");
}
Session["CSCOSTATPage"] = page ?? 1;
Session["CSCOSTAT_OLDCONO"] = cSCOSTAT.CONO; // storing the old no so that can allow change of cono
ViewBag.CONO = new SelectList(db.CSCOMSTRs.Select(x => new { CONO = x.CONO, CONAME = x.CONAME + " (" + x.CONO + ")" }).OrderBy(y => y.CONAME), "CONO", "CONAME", cSCOSTAT.CONO);
ViewBag.COSTAT = new SelectList(db.CSSTATs, "COSTAT", "COSTAT", cSCOSTAT.COSTAT);
ViewBag.page = page ?? 1;
ViewBag.Title = "Delete Company Change Status";
cSCOSTAT.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSTAT.CONO);
return(View("Edit1", cSCOSTAT));
}
protected void UpdateProduct_Click(object sender, EventArgs e)
{
//ensure validation is still good
if (Page.IsValid)
{
//event code validation that was not accomplished on
// the web form
//examples
//Assume that the CategoryID is required
if (CategoryList.SelectedIndex == 0)
{
errormsgs.Add("Category is required");
}
if (QuantityPerUnit.Text.Length > 20)
{
errormsgs.Add("Quantity per Unit is limited to 20 characters");
}
//on updae, ensure you have your primary key value
int productid = 0;
if (string.IsNullOrEmpty(ProductID.Text))
{
errormsgs.Add("Search for a product to update");
}
else if (!int.TryParse(ProductID.Text, out productid))
{
errormsgs.Add("Product id is invalid");
}
else if (productid < 1)
{
errormsgs.Add("Product id is invalid");
}
//check if click event validation is good
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
//assume taht the data is validate to our knowledge
try
{
//standard update to a database
//connect to the appropriate controller
ProductController sysmgr = new ProductController();
//create and load an instance of the entity record
// since there was no constructor placed in the
// entity, when one creaes the instance the
// default system construtor will be used
Product item = new Product();
//ensure yo include the primary key
item.ProductID = productid;
item.ProductName = ProductName.Text.Trim();
if (CategoryList.SelectedIndex == 0)
{
item.CategoryID = null;
}
else
{
item.CategoryID = int.Parse(CategoryList.SelectedValue);
}
if (SupplierList.SelectedIndex == 0)
{
item.SupplierID = null;
}
else
{
item.SupplierID = int.Parse(SupplierList.SelectedValue);
}
item.QuantityPerUnit =
string.IsNullOrEmpty(QuantityPerUnit.Text) ? null : QuantityPerUnit.Text;
if (string.IsNullOrEmpty(UnitPrice.Text))
{
item.UnitPrice = null;
}
else
{
item.UnitPrice = decimal.Parse(UnitPrice.Text);
}
if (string.IsNullOrEmpty(UnitsInStock.Text))
{
item.UnitsInStock = null;
}
else
{
item.UnitsInStock = Int16.Parse(UnitsInStock.Text);
}
if (string.IsNullOrEmpty(UnitsOnOrder.Text))
{
item.UnitsOnOrder = null;
}
else
{
item.UnitsOnOrder = Int16.Parse(UnitsOnOrder.Text);
}
if (string.IsNullOrEmpty(ReorderLevel.Text))
{
item.ReorderLevel = null;
}
else
{
item.ReorderLevel = Int16.Parse(ReorderLevel.Text);
}
//actually current valud of discontinued is needed
item.Discontinued = Discontinued.Checked;
//issue the BLL call
int rowsaffected = sysmgr.Products_Update(item);
//give feedback
if (rowsaffected > 0)
{
errormsgs.Add("Product has been updated");
LoadMessageDisplay(errormsgs, "alert alert-success");
//is there any other controls on the form that need to be refreshed
BindProductList(); //by default, list will be at index 0
ProductList.SelectedValue = ProductID.Text;
}
else
{
errormsgs.Add("Product has not been updated. Product was not found");
LoadMessageDisplay(errormsgs, "alert alert-info");
//is there any other controls on the form that need to be refreshed
BindProductList(); //by default, list will be at index 0
//optionally you could clear your fields
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException.InnerException != null)
{
errormsgs.Add(updateException.InnerException.Message.ToString());
}
else
{
errormsgs.Add(updateException.Message);
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
errormsgs.Add(validationError.ErrorMessage);
}
}
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
}
public ActionResult DeleteConfirmed(string id)
{
int page = (int)Session["CSPRSPage"];
CSPR cSPR = db.CSPRS.Find(MyHtmlHelpers.ConvertByteStrToId(id));
try
{
db.CSPRS.Remove(cSPR);
db.SaveChanges();
return(RedirectToAction("Index", new { page = page }));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
//string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
UpdateException updateException = (UpdateException)ex.InnerException;
if (updateException != null)
{
if (updateException.InnerException != null)
{
var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;
foreach (var error in sqlException.Errors)
{
if (error.Message != null)
{
ModelState.AddModelError(string.Empty, error.Message);
}
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, updateException.Message);
}
}
ViewBag.SEX = cSPR.gender;
ViewBag.CONSTCODE = new SelectList(db.HKCONSTs.OrderBy(x => x.CONSTCODE).Select(x => new { CONSTCODE = x.CONSTCODE, CONSTDESC = x.CONSTCODE + " | " + x.CONSTDESC + " | " + x.CONSTTYPE }), "CONSTCODE", "CONSTDESC", cSPR.CONSTCODE);
ViewBag.PRSTITLE = new SelectList(db.HKTITLEs, "TITLE", "TITLE", cSPR.PRSTITLE);
ViewBag.NATION = new SelectList(db.HKNATIONs, "NATION", "NATION", cSPR.NATION);
ViewBag.RACE = new SelectList(db.HKRACEs, "RACE", "RACE", cSPR.RACE);
ViewBag.CTRYINC = new SelectList(db.HKCTRies, "CTRYCODE", "CTRYDESC", cSPR.CTRYINC);
ViewBag.Title = "Delete Entity ";
ViewBag.page = page;
return(View("Edit", cSPR));
}
