internal string checklogin(AdminLogin model1)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
if (model1.Username != "" && model1.Password != "")
{
var loginresult = dbContext.AdminLogins.Where(s => s.Username == model1.Username && s.Password == model1.Password).FirstOrDefault();
if (loginresult != null)
{
return("success");
}
else
{
return("False");
}
}
else
{
return("empty");
}
}
catch (Exception)
{
return("False");
throw;
}
}
internal List <BasicDetail> GetOrganiserUsername()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.BasicDetails.ToList <BasicDetail>();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal List <UserContact> GetUserContactDetails()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.UserContacts
.ToList <UserContact>();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal List <LoanDetail> GetNewLoanApplicationDetails()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.LoanDetails
.ToList <LoanDetail>();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal BasicDetail GetBasicDetail()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.BasicDetails
.FirstOrDefault();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal string AddMailMessage(ContactUser model)
{
try
{
GTLOANEntities dbcontext = new GTLOANEntities();
dbcontext.ContactUsers.Add(model);
dbcontext.SaveChanges();
return("success");
}
catch (Exception ex)
{
throw;
}
}
internal BasicDetail GetBasicDetail(string PhoneNumber)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.BasicDetails
.Where(p => p.PhoneNumber == PhoneNumber)
.FirstOrDefault();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal List <LoanDetail> GetLoanList()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.LoanDetails
.Where(e => e.LoanStatus == "Active")
.ToList <LoanDetail>();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal LoanDetail GetLoanDetail()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.LoanDetails
.Where(e => e.LoanStatus == "Active")
.FirstOrDefault();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal string SendNotification(Notification notify)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
dbContext.Notifications.Add(notify);
dbContext.SaveChanges();
return("success");
}
catch (Exception)
{
return("error");
}
}
internal List <Register> GetPaymentsDetail()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.Registers
.ToList <Register>();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal LoanDetail GetLoanDetail(string PhoneNumber)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.LoanDetails
.Where(p => p.PhoneNumber == PhoneNumber && p.LoanStatus.ToLower() == "pending")
.FirstOrDefault();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal Register GetUserInformation(string PhoneNumber)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.Registers
.Where(p => p.PhoneNumber == PhoneNumber)
.FirstOrDefault();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal List <Register> GetRedFlagDetail()
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.Registers
.Where(t => t.LoanDetails.Any(y => y.DueDate.Day <= DateTime.Now.Day && y.DueDate.Month <= DateTime.Now.Month && y.DueDate.Year <= DateTime.Now.Year))
.ToList <Register>();
return(query);
}
catch (Exception ex)
{
throw;
}
}
internal void UpdateStatus(string phoneNumber, string status)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.LoanDetails
.Where(e => e.LoanStatus == "Active")
.FirstOrDefault();
query.LoanStatus = status;
dbContext.Entry(query).State = EntityState.Modified;
dbContext.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
internal string Status(string PhoneNumber, string Status)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.OneTimeFees
.Where(p => p.PhoneNumber == PhoneNumber).FirstOrDefault();
query.Status = Status;
dbContext.Entry(query).State = EntityState.Modified;
dbContext.SaveChanges();
return("success");
}
catch (Exception ex)
{
throw;
}
}
internal string DisApprove(string Phonenumber)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.Registers
.Where(p => p.PhoneNumber == Phonenumber).FirstOrDefault();
query.Status = "rejected";
dbContext.Entry(query).State = EntityState.Modified;
dbContext.SaveChanges();
return("success");
}
catch (Exception ex)
{
throw;
}
}
internal string Approve(string PhoneNumber, string Transaction)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
var query = dbContext.LoanDetails
.Where(p => p.PhoneNumber == PhoneNumber).FirstOrDefault();
query.LoanStatus = "Active";
query.DueDate = DateTime.Now.AddDays(+14);
query.LoanTransactionNo = Transaction;
dbContext.Entry(query).State = EntityState.Modified;
dbContext.SaveChanges();
return("success");
}
catch (Exception ex)
{
throw;
}
}
internal List <BasicDetail> GetUserName(string EmailId)
{
try
{
GTLOANEntities dbContext = new GTLOANEntities();
if (EmailId == "All")
{
var queryAll = dbContext.BasicDetails
.ToList <BasicDetail>();
return(queryAll);
}
var query = dbContext.BasicDetails
.Where(p => p.EmailId == EmailId).ToList <BasicDetail>();
return(query);
}
catch (Exception ex)
{
throw;
}
}
