/// <summary> /// delete to company /// </summary> /// <param name="companytoDelete"></param> /// <returns>bool</returns> public bool deleteCompany(Tbl_Company companytoDelete) { using (var repository = RepositoryFactory.CreateRepository()) { return(repository.delete <Tbl_Company>(companytoDelete)); } }
/// <summary> /// returns company details using its id /// </summary> /// <param name="id"></param> /// <returns></returns> public CompanyVM GetById(object id) { CompanyVM result = new CompanyVM(); try { using (var context = new CMS_DbEntities()) { Tbl_Company company = context.UserSP_CompanyById((int)id).FirstOrDefault(); converter.ConvertToModel(company, result); } } catch (Exception ex) { throw; } return(result); }
/// <summary> /// Update existing Company details /// </summary> /// <param name="companyVm"></param> /// <returns></returns> public int Update(CompanyVM companyVm) { int result = 0; try { using (var context = new CMS_DbEntities()) { Tbl_Company company = context.UserSP_CompanyById(companyVm.ID).FirstOrDefault(); converter.ConvertToEntity(companyVm, company); //will execute UserSP_UpdateCompany context.SaveChanges(); } } catch (Exception ex) { throw; } return(result); }
/// <summary> /// ///delete for end user but changing Delete column /// </summary> /// <param name="id"></param> /// <returns></returns> public int Delete(object id) { int result = 0; try { using (var context = new CMS_DbEntities()) { //Get company using SP UserSP_CompanyById Tbl_Company company = context.UserSP_CompanyById((int)id).FirstOrDefault(); // my storeprocedure change delete status in database for Delete context.Tbl_Company.Remove(company); //will execute sp_DeleteStudentInfo context.SaveChanges(); } } catch (Exception ex) { throw; } return(result); }