//update CompanyDetails public static bool UpdateCompanyDetails(CompanyDetail companyDetail) { bool status; try { CompanyDetail prodItem = DbContext.CompanyDetails.Where(p => p.CompanyID == companyDetail.CompanyID).FirstOrDefault(); if (prodItem != null) { prodItem.CompanyIndex = companyDetail.CompanyIndex; prodItem.CompanyName = companyDetail.CompanyName; prodItem.CompanyAddress = companyDetail.CompanyAddress; prodItem.CompanyEmail = companyDetail.CompanyEmail; prodItem.CompanyPhoneNo = companyDetail.CompanyPhoneNo; prodItem.CompanyContactPerson = companyDetail.CompanyContactPerson; DbContext.SaveChanges(); } status = true; } catch (Exception) { status = false; } return(status); }
//Add Company Details public static bool AddCompanyDetails(CompanyDetail companyDetail) { bool status; try { DbContext.CompanyDetails.Add(companyDetail); DbContext.SaveChanges(); status = true; } catch (DbUpdateException ex) { status = false; throw ex; } return(status); }
//Delete CompanyDetails public static bool DeleteCompanyDetails(int id) { bool status; try { CompanyDetail prodItem = DbContext.CompanyDetails.Where(p => p.CompanyID == id).FirstOrDefault(); if (prodItem != null) { DbContext.CompanyDetails.Remove(prodItem); DbContext.SaveChanges(); } status = true; } catch (Exception) { status = false; } return(status); }