public int UpdateBeneficiaryCheckDuplicate(BusinessObject.Beneficiary beneficiary) { try { //Re-Map Object to Entity Object var myEntityObj = BeneficiaryMapper.Map <BusinessObject.Beneficiary, Beneficiary>(beneficiary); if (myEntityObj == null) { return(-2); } using (var db = new ExpenseManagerDBEntities()) { if (db.Beneficiaries.Any()) { if (db.Beneficiaries.Count(m => m.FullName.ToLower().Replace(" ", string.Empty) == beneficiary.FullName.ToLower().Replace(" ", string.Empty) && m.CompanyName.ToLower().Replace(" ", string.Empty) == beneficiary.CompanyName.ToLower().Replace(" ", string.Empty) && m.BeneficiaryId != beneficiary.BeneficiaryId) > 0) { return(-3); } if (db.Beneficiaries.Count(m => m.GSMNO1 == beneficiary.GSMNO1 && m.BeneficiaryId != beneficiary.BeneficiaryId) > 0) { return(-4); } if (db.Beneficiaries.Count(m => m.Email == beneficiary.Email && m.BeneficiaryId != beneficiary.BeneficiaryId) > 0) { return(-5); } } db.Beneficiaries.Attach(myEntityObj); db.ObjectStateManager.ChangeObjectState(myEntityObj, EntityState.Modified); db.SaveChanges(); return(1); } } catch (Exception ex) { ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message); return(0); } }
public int AddBeneficiary(BusinessObject.Beneficiary beneficiary) { try { //Re-Map Object to Entity Object var myEntityObj = BeneficiaryMapper.Map <BusinessObject.Beneficiary, Beneficiary>(beneficiary); if (myEntityObj == null) { return(-2); } using (var db = new ExpenseManagerDBEntities()) { db.AddToBeneficiaries(myEntityObj); db.SaveChanges(); beneficiary.BeneficiaryId = myEntityObj.BeneficiaryId; return(beneficiary.BeneficiaryId); } } catch (Exception ex) { ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message); return(0); } }