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