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