public LoanBusinessEntity GetLoanNo(LoanBusinessEntity loanBusinessEntity)
{
int counts;
string last = "";
tbl_Loan lastloan;
using (var count = new LoanManagementSystemEntities())
{
counts = count.tbl_Loan.Count();
}
if (counts == 0)
{
last = "L000001";
}
else
{
using (var dbContext = new LoanManagementSystemEntities())
{
var lnk = dbContext.tbl_Loan.OrderByDescending(x => x.LoanNo).Take(1);
lastloan = lnk.First();
last = lastloan.LoanNo;
}
//int number = Convert.ToInt32(last.Substring(1)) + 1;
int number = int.Parse(last.Substring(1));
number += 1;
string symbol = last.Substring(0, 1);
last = symbol + number.ToString("D6"); /////great formating solution
}
loanBusinessEntity.LoanNo = last;
return(loanBusinessEntity);
}
public CustomerBusinessEntity GetCustomerById(int ID)
{
CustomerBusinessEntity customer = new CustomerBusinessEntity();
try
{
using (var dbContext = new LoanManagementSystemEntities())
{
tbl_Customer cust = dbContext.tbl_Customer.Where(c => c.Id == ID).FirstOrDefault();
if (cust != null)
{
customer.ID = cust.Id;
customer.Name = cust.Name;
customer.PanCard = cust.PANCard;
}
}
}
catch (Exception ex)
{
}
finally
{
}
return(customer);
}
public List <CustomerBusinessEntity> List()
{
List <CustomerBusinessEntity> customers = new List <CustomerBusinessEntity>();
try
{
using (var dbContext = new LoanManagementSystemEntities())
{
var dbCustomers = dbContext.tbl_Customer.ToList();
customers = dbCustomers.Select(db => new CustomerBusinessEntity()
{
ID = db.Id,
Name = db.Name,
AnnualIncome = (double)db.AnnualIncome,
PanCard = db.PANCard
}).ToList();
}
}
catch
{
}
finally
{
}
return(customers);
}
public List <LoanBusinessEntity> GetLoans()
{
List <LoanBusinessEntity> loans = new List <LoanBusinessEntity>();
try
{
using (var dbContext = new LoanManagementSystemEntities())
{
var dbLoanObj = dbContext.tbl_Loan.ToList();
foreach (var loan in dbLoanObj)
{
LoanBusinessEntity loanBusinessEntity = new LoanBusinessEntity();
loanBusinessEntity.Id = loan.Id;
loanBusinessEntity.LoanNo = loan.LoanNo;
loanBusinessEntity.LoanStatus = loan.LoanStatus;
loanBusinessEntity.LoanTypeId = loan.LoanTypeId;
loanBusinessEntity.Amount = (double)loan.Amount;
loanBusinessEntity.CustomerId = (int)loan.CustomerId;
loans.Add(loanBusinessEntity);
}
}
}
catch
{
throw;
}
finally
{
}
return(loans);
}
private tbl_Loan GetLoan(int ID)
{
var dbloan = new tbl_Loan();
using (var dbContext = new LoanManagementSystemEntities())
{
dbloan = dbContext.tbl_Loan.Where(loan => loan.Id == ID).FirstOrDefault();
return(dbloan);
}
}
private tbl_Customer Get(int id)
{
tbl_Customer dbcust;
using (var dbContext = new LoanManagementSystemEntities())
{
dbcust = dbContext.
tbl_Customer.
Where(cust => cust.Id == id).FirstOrDefault();
}
return(dbcust);
}
} //end of method
public UserEntity Get(int id)
{
UserEntity userEntity = new UserEntity();
using (var dbContext = new LoanManagementSystemEntities())
{
var dbUser = dbContext.tbl_LMSUser.Where(user => user.Id == id).FirstOrDefault();
userEntity.Id = dbUser.Id;
userEntity.Name = dbUser.Name;
userEntity.Password = dbUser.Password;
userEntity.MobileNo = dbUser.MobileNo;
userEntity.EmailId = dbUser.EmailId;
userEntity.Role = dbUser.Role;
userEntity.SecurityQuestionId = dbUser.SecurityQuestionId.Value;
userEntity.Answer = dbUser.Answer;
}
return(userEntity);
}
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 List <LoanTypeEntity> GetLoanTypes()
{
List <LoanTypeEntity> loantypes = new List <LoanTypeEntity>();
using (var dbLMSEntities = new LoanManagementSystemEntities())
{
var dbLoanTypes = dbLMSEntities.tbl_LoanTypes.ToList();
foreach (var dbLoanType in dbLoanTypes)
{
LoanTypeEntity loanTypeEntity = new LoanTypeEntity();
loanTypeEntity.Id = dbLoanType.Id;
loanTypeEntity.LoanName = dbLoanType.LoanName;
loanTypeEntity.IntrestRate = (double)dbLoanType.IntrestRate;
loanTypeEntity.MaxInstallments = (int)dbLoanType.MaxInstallments;
loanTypeEntity.MaxAmount = (decimal)dbLoanType.MaxAmount;
loantypes.Add(loanTypeEntity);
}
}
return(loantypes);
}
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 List <UserEntity> List()
{
List <UserEntity> users = new List <UserEntity>();
using (var dbContext = new LoanManagementSystemEntities())
{
var dbUsers = dbContext.tbl_LMSUser.ToList();
foreach (var dbUser in dbUsers)
{
UserEntity userEntity = new UserEntity();
userEntity.Name = dbUser.Name;
userEntity.MobileNo = dbUser.MobileNo;
userEntity.EmailId = dbUser.EmailId;
userEntity.Id = dbUser.Id;
users.Add(userEntity);
} // end of for
} // end of using
return(users);
} //end of method
public List <QuestionEntity> GetQuestions()
{
List <QuestionEntity> questions = new List <QuestionEntity>();
using (var dbLMSEntities = new LoanManagementSystemEntities())
{
using (var sw = new StreamWriter(@"C:\Users\NIHAR-PC\OneDrive\Attachments\log.txt"))
{
dbLMSEntities.Database.Log = sw.WriteLine;
var dbQuestions = dbLMSEntities.Questions.ToList();
foreach (var dbQuestion in dbQuestions)
{
QuestionEntity questionEntity = new QuestionEntity();
questionEntity.Id = dbQuestion.id;
questionEntity.QuestionName = dbQuestion.QuestionName;
questions.Add(questionEntity);
}
}
}
return(questions);
}
public LoanBusinessEntity GetCustName(LoanBusinessEntity loanBusinessEntity)
{
try
{
using (var dbContext = new LoanManagementSystemEntities())
{
tbl_Customer cust = dbContext.tbl_Customer.Where(c => c.Id == loanBusinessEntity.CustomerId).FirstOrDefault();
if (cust != null)
{
loanBusinessEntity.CustomerName = cust.Name;
}
}
}
catch (Exception ex)
{
}
finally
{
}
return(loanBusinessEntity);
}
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);
}