public CompanyItem SaveCompany(CompanyItem companyItem) { try { Company company = null; switch (companyItem.InitializationType) { case InitializationTypes.Insert: company = new Company { CompanyName = companyItem.CompanyName }; db.Companys.Add(company); break; case InitializationTypes.Update: company = new Company { CompanyID = companyItem.CompanyID, CompanyName = companyItem.CompanyName }; db.Companys.Attach(company); db.Entry(company).State = EntityState.Modified; break; } db.SaveChanges(); companyItem.CompanyID = company.CompanyID; return(companyItem); } catch (Exception ex) { exception = ex; return(null); } }
public CompanyItem GetCompanyItem(int?companyID = null) { try { if (companyID != null) { Company company = db.Companys.Find(companyID); CompanyItem item = new CompanyItem { CompanyID = company.CompanyID, CompanyName = company.CompanyName, InitializationType = InitializationTypes.Update, }; return(item); } else { var item = new CompanyItem { InitializationType = InitializationTypes.Insert, }; return(item); } } catch (Exception ex) { exception = ex; return(null); } }
public void DeleteCompany(CompanyItem companyItem) { var entity = new Company { CompanyID = companyItem.CompanyID }; db.Companys.Attach(entity); db.Companys.Remove(entity); db.SaveChanges(); }
public void CreateCompany(CompanyItem companyItem) { var entity = new Company { CompanyName = companyItem.CompanyName }; db.Companys.Add(entity); db.SaveChanges(); companyItem.CompanyID = entity.CompanyID; }
public void UpdateCompany(CompanyItem companyItem) { var entity = new Company { CompanyID = companyItem.CompanyID, CompanyName = companyItem.CompanyName }; db.Companys.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); }