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);
}