public void Insert(UserEntity userEntity) { using (var dbContext = new LoanManagementSystemEntities()) { tbl_LMSUser dbUser = new tbl_LMSUser(); dbUser.Name = userEntity.Name; dbUser.Password = userEntity.Password; dbUser.MobileNo = userEntity.MobileNo; dbUser.EmailId = userEntity.EmailId; dbUser.Role = userEntity.Role; dbUser.IsActive = userEntity.IsActive; dbUser.IsLocked = userEntity.IsLocked; dbUser.SecurityQuestionId = userEntity.SecurityQuestionId; dbUser.Answer = userEntity.Answer; dbContext.tbl_LMSUser.Add(dbUser); dbContext.SaveChanges(); } }
public void Update(UserEntity userEntity) { using (var dbContext = new LoanManagementSystemEntities()) { var existingDBUser = dbContext.tbl_LMSUser.Where(u => u.Id == userEntity.Id).FirstOrDefault(); UpdateDBUserInfo(ref existingDBUser, ref userEntity); //existingDBUser.Name = userEntity.Name; //existingDBUser.Password = userEntity.Password; //existingDBUser.MobileNo = userEntity.MobileNo; //existingDBUser.EmailId = userEntity.EmailId; //existingDBUser.Role = userEntity.Role; //existingDBUser.IsActive = userEntity.IsActive; //existingDBUser.IsLocked = userEntity.IsLocked; //existingDBUser.SecurityQuestionId = userEntity.SecurityQuestionId; //existingDBUser.Answer = userEntity.Answer; //existingDBUser.CreatedDate = DateTime.Now; //existingDBUser.CreatedBy="1"; dbContext.SaveChanges(); } }
public bool Save(CustomerBusinessEntity customer) { tbl_Customer dbCustomer; if (customer.ID == -1) { dbCustomer = new tbl_Customer(); } else { dbCustomer = Get(customer.ID); } AssignValueToDBCustomer(ref dbCustomer, ref customer); using (var dbContext = new LoanManagementSystemEntities()) { dbContext.tbl_Customer.Add(dbCustomer); dbContext.SaveChanges(); } return(true); }
public bool Save(LoanBusinessEntity loanBusinessEntity) { tbl_Loan Dbloan; if (loanBusinessEntity.Id == -1) { Dbloan = new tbl_Loan(); } else { Dbloan = GetLoan(loanBusinessEntity.Id); } AssignValues(ref Dbloan, ref loanBusinessEntity); using (var dbContext = new LoanManagementSystemEntities()) { dbContext.tbl_Loan.Add(Dbloan); dbContext.SaveChanges(); } return(true); }