protected void btnSubmit_Click(object sender, EventArgs e) { try { if (hid.Value == "Update") { DriverEmployer coy = null; bool rst = false; coy = LookUpBLL.GetDriverEmployer(Convert.ToInt32(txtID.Text)); if (coy != null) { coy.Name = txtDept.Text.ToUpper();; rst = LookUpBLL.UpdateDriverEmployer(coy); if (rst != false) { BindGrid(); success.Visible = true; success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!."; return; } } else { error.Visible = true; error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!."; } } else { string com = ""; com = txtDept.Text; bool result = false; DriverEmployer coy = new DriverEmployer(); coy.Name = com.ToUpper(); result = LookUpBLL.AddDriverEmployer(coy); if (result) { BindGrid(); txtDept.Text = ""; success.Visible = true; success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!."; return; } else { error.Visible = true; error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!."; } } } catch (Exception ex) { error.Visible = true; error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!"; Utility.WriteError("Error: " + ex.Message); } }
public static bool AddDriverEmployer(DriverEmployer coy) { try { using (FleetMgtSysDBEntities db = new FleetMgtSysDBEntities()) { db.DriverEmployers.Add(coy); db.SaveChanges(); return(true); } } catch (Exception ex) { // Utility.WriteError("Error Msg: " + ex.Message); throw ex; } }
public static bool UpdateDriverEmployer(DriverEmployer coy) { try { bool rst = false; using (var db = new FleetMgtSysDBEntities()) { db.DriverEmployers.Attach(coy); db.Entry(coy).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); rst = true; } return(rst); } catch (Exception ex) { Utility.WriteError("Error Msg: " + ex.InnerException); throw ex; } }