public void Add_Ut() { Company dpCompany = new Company(); SETUP_Company mdlCompany = new SETUP_Company(); mdlCompany.Comp_Desc = "Demo Company4"; mdlCompany.Comp_Code = "0004"; mdlCompany.Comp_EMail = "*****@*****.**"; mdlCompany.Comp_Mobile1 = "03346024022"; mdlCompany.Comp_Address1 = "Test Address4"; dpCompany.Add(mdlCompany); }
public void Update_Ut() { Company dpCompany = new Company(); SETUP_Company mdlCompany = new SETUP_Company(); mdlCompany.Comp_Id = 3; mdlCompany.Comp_Desc = "Demo Company7"; mdlCompany.Comp_Code = "0003"; mdlCompany.Comp_EMail = "*****@*****.**"; mdlCompany.Comp_Mobile1 = "03104423653"; mdlCompany.Comp_Address1 = "Test Address3"; mdlCompany.Comp_Fax = "0000000003"; dpCompany.Update(mdlCompany); }
public ActionResult Update(SETUP_Company company) { Company dpCompany = new Company(); bool updated = dpCompany.Update(company); if (updated) { return(RedirectToAction("ViewDetail", "Company", new { id = company.Comp_Id })); } else { TempData["error"] = "Opps! Somthing went wrong!"; return(RedirectToAction("Edit", "Company", new { id = company.Comp_Id })); } }
public ActionResult Add(SETUP_Company company) { Company dpCompany = new Company(); int id = dpCompany.Add(company); if (id > 0) { return(RedirectToAction("Index", "Company")); } else { TempData["error"] = "Opps! Somthing went wrong!"; return(RedirectToAction("Add", "Company")); } }
/// <summary> /// Updates modified values of company to the database.... /// </summary> /// <param name="company"></param> /// <returns>Returns true if updated successfully else returns false.</returns> public bool Update(SETUP_Company company) { using (eSuiteEntities db = new eSuiteEntities()) { try { db.Entry(company).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); } catch { return(false); } } }
/// <summary> /// Adds new company to the database.... /// </summary> /// <param name="company"></param> /// <returns>Returns new company id if saved successfully else returns 0</returns> public int Add(SETUP_Company company) { using (eSuiteEntities db = new eSuiteEntities()) { try { db.Entry(company).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); return(company.Comp_Id); } catch { return(0); } } }
public int SaveCompany(SETUP_Company newSetupCompanyRow) { try { SCMSDataContext dbSCMS = Connection.Create(); SETUP_Company existingSetupCompanyRow = dbSCMS.SETUP_Companies.Where(c => c.Cmp_Id.Equals(newSetupCompanyRow.Cmp_Id)).SingleOrDefault(); if (existingSetupCompanyRow != null) { existingSetupCompanyRow.Cmp_Title = newSetupCompanyRow.Cmp_Title; existingSetupCompanyRow.Cmp_Address1 = newSetupCompanyRow.Cmp_Address1; existingSetupCompanyRow.Cmp_Address2 = newSetupCompanyRow.Cmp_Address2; existingSetupCompanyRow.Cmp_Email = newSetupCompanyRow.Cmp_Email; existingSetupCompanyRow.Cmp_Phone = newSetupCompanyRow.Cmp_Phone; existingSetupCompanyRow.Cmp_Fax = newSetupCompanyRow.Cmp_Fax; } else { dbSCMS.SETUP_Companies.InsertOnSubmit(newSetupCompanyRow); } dbSCMS.SubmitChanges(); return Convert.ToInt32(newSetupCompanyRow.Cmp_Id); } catch { return 0; } }
public ActionResult SaveCompany(String Code, String Name, String Address1, String Address2, String Email, String Phone, String Fax) { SETUP_Company setupCompanyRow = new SETUP_Company(); String ls_Action = "Edit", IsAuditTrail = "", ls_UserId = ""; String[] ls_Lable = new String[7], ls_Data = new String[7]; Int32 li_ReturnValue = 0; try { if (String.IsNullOrEmpty(Code)) { if (DALCommon.AutoCodeGeneration("SETUP_Company") == 1) { Code = DALCommon.GetMaximumCode("SETUP_Company"); ls_Action = "Add"; } } if (!String.IsNullOrEmpty(Code)) { setupCompanyRow.Cmp_Id = Code; setupCompanyRow.Cmp_Code = Code; setupCompanyRow.Cmp_Title = Name; setupCompanyRow.Cmp_Address1 = Address1; setupCompanyRow.Cmp_Address2 = Address2; setupCompanyRow.Cmp_Email = Email; setupCompanyRow.Cmp_Phone = Phone; setupCompanyRow.Cmp_Fax = Fax; setupCompanyRow.Cmp_Active = 1; li_ReturnValue = objDalCompany.SaveCompany(setupCompanyRow); ViewData["SaveResult"] = li_ReturnValue; IsAuditTrail = System.Configuration.ConfigurationManager.AppSettings.GetValues("IsAuditTrail")[0]; // Save Audit Log if (li_ReturnValue > 0 && IsAuditTrail == "1") { DALAuditLog objAuditLog = new DALAuditLog(); ls_UserId = ((SECURITY_User)Session["user"]).User_Id; ls_Lable[0] = "Code"; ls_Lable[1] = "Title"; ls_Lable[2] = "Address"; ls_Lable[3] = " "; ls_Lable[4] = "Email"; ls_Lable[5] = "Phone"; ls_Lable[6] = "Fax"; ls_Data[0] = Code; ls_Data[1] = Name; ls_Data[2] = Address1; ls_Data[3] = Address2; ls_Data[4] = Email; ls_Data[5] = Phone; ls_Data[6] = Fax; objAuditLog.SaveRecord(1, ls_UserId, ls_Action, ls_Lable, ls_Data); } } return PartialView("GridData"); } catch { return PartialView("GridData"); } }