public static Task <List <tblChargeMonthly> > GetData(int personnelId) { var dbLoanEntities = new dbLoanEntities(); return(Task.Run(() => dbLoanEntities.tblChargeMonthly .Where(x => x.ChargeMonthly_Personnel_Id == personnelId).ToList())); }
public static void SetSecurityAccess() { var dbLoanEntities = new dbLoanEntities(); var result = dbLoanEntities.tblSecurityAccess.FirstOrDefault(x => x.Id == 1); if (result == null) { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Time = PersianDateTime.Now.AddMinutes(-10).ToString(), Counter = "0" }; dbLoanEntities.tblSecurityAccess.Add(tblSecurityAccess); dbLoanEntities.SaveChanges(); } else if (result.Time == null) { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Time = PersianDateTime.Now.AddMinutes(-10).ToString() }; using (dbLoanEntities) { dbLoanEntities.tblSecurityAccess.Attach(tblSecurityAccess); dbLoanEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true; dbLoanEntities.SaveChanges(); } } }
public static Task <List <tblGuarantor> > GetInfoGuaData(int?infoId) { var dbLoanEntities = new dbLoanEntities(); return(Task.Run(() => dbLoanEntities.tblGuarantor.Where(x => x.Guarantor_Info_Id == infoId).ToList())); //return Task.Run(() => dbLoanEntities.spSelectInfoGuarantor(infoId).ToList()); }
public void AddPayment() { var tblInstallment = new tblInstallment { Id = DId, Installment_PaymentType_Id = DPaymentTypeId, InstallmentAmount = DAmount, InstallmentReceiptNumber = DReceiptNumber, InstallmentTotalPaid = DTotalPaid, InstallmentRemaining = DRemaining, InstallmentPaymentDate = DPaymentDate, InstallmentDelayDay = DDelayDay, InstallmentDescription = DDescription }; using (var dbLoanEntities = new dbLoanEntities()) { dbLoanEntities.tblInstallment.Attach(tblInstallment); dbLoanEntities.Entry(tblInstallment).Property(x => x.Installment_PaymentType_Id).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentAmount).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentReceiptNumber).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentTotalPaid).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentRemaining).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentPaymentDate).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentDelayDay).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentDescription).IsModified = true; dbLoanEntities.SaveChanges(); } }
public static Task <bool> CheckGuaBlock(int infoId) { var dbLoanEntities = new dbLoanEntities(); var result = dbLoanEntities.tblGuarantor.FirstOrDefault(x => x.Guarantor_Info_Id == infoId && x.GuarantorBlock == true); return(result == null?Task.Run(() => false) : Task.Run(() => true)); }
public static Task <bool> CheckAccountNumber(string accountNumber) { var dbLoanEntities = new dbLoanEntities(); var result = dbLoanEntities.tblPerAccType.SingleOrDefault(x => x.PerAccTypeAccountNumber == accountNumber); return(result == null?Task.Run(() => true) : Task.Run(() => false)); }
public static Task <bool> CheckPersonnelId(string personnelId) { var dbLoanEntities = new dbLoanEntities(); var result = dbLoanEntities.tblPersonnel.SingleOrDefault(x => x.PersonnelId == personnelId); return(result == null?Task.Run(() => true) : Task.Run(() => false)); }
public static bool?ChekAdminRegistered() { var dbLoanEntities = new dbLoanEntities(); var result = dbLoanEntities.tblSundry.FirstOrDefault(x => x.Id == 1); if (result == null) { return(false); } return(result.RegisteredAdminPassword); }
public DIntroducer(int cId, int cLoanId, byte cIntroducerTypeId, int?cInfoId, short?cInstitutionId, string cDescription) { _dbLoanEntities = new dbLoanEntities(); DId = cId; DLoanId = cLoanId; DIntroducerTypeId = cIntroducerTypeId; DInfoId = cInfoId; DInstitutionId = cInstitutionId; DDescription = cDescription; }
public static PersianDateTime Date() { var dbLoanEntities = new dbLoanEntities(); var firstOrDefault = dbLoanEntities.tblSecurityAccess.FirstOrDefault(); //khandan etela-at file if (firstOrDefault == null) { return(PersianDateTime.Now); } var saveDate = firstOrDefault.Time.Split(' '); return(PersianDateTime.Parse(saveDate[0], saveDate[1]).AddMinutes(+5)); }
public DPersonnel(int cId, int cInfoId, string cPersonnelId, string cPersonnelMembership, string cPersonnelMembershipDate, string cPersonnelBarCode, string cPersonnelQrCode, string cPersonnelSignature) { _dbLoanEntities = new dbLoanEntities(); DId = cId; DInfoId = cInfoId; DPersonnelId = cPersonnelId; DPersonnelMembership = cPersonnelMembership; DPersonnelMembershipDate = cPersonnelMembershipDate; DPersonnelBarCode = cPersonnelBarCode; DPersonnelQrCode = cPersonnelQrCode; DPersonnelSignature = cPersonnelSignature; }
public static void SaveCounter(int num)//zakhire tedad mavared vorod eshtebah { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Counter = num.ToString() }; using (var dbLoanEntities = new dbLoanEntities()) { dbLoanEntities.tblSecurityAccess.Attach(tblSecurityAccess); dbLoanEntities.Entry(tblSecurityAccess).Property(x => x.Counter).IsModified = true; dbLoanEntities.SaveChanges(); } }
public void EditGuarantorBlock() { var tblGuarantor = new tblGuarantor { id = DId, GuarantorBlock = DBlock }; using (var dbLoanEntities = new dbLoanEntities()) { dbLoanEntities.tblGuarantor.Attach(tblGuarantor); dbLoanEntities.Entry(tblGuarantor).Property(x => x.GuarantorBlock).IsModified = true; dbLoanEntities.SaveChanges(); } }
public static Task <int?> CheckInfoIsPer(int infoId) { var dbLoanEntities = new dbLoanEntities(); var firstOrDefault = dbLoanEntities.tblPersonnel.FirstOrDefault(x => x.Personnel_Info_Id == infoId); if (firstOrDefault == null) { return(null); } int?result = firstOrDefault.Id; return(Task.Run(() => result)); //return Task.Run(() => dbLoanEntities.spChekInfoIsPer(infoId).FirstOrDefault()); }
public void ChangePassword() { var tblUser = new tblUser { UserName = DUserName, UserPassword = BCrypt.Net.BCrypt.HashPassword(DPassword) }; using (var dbLoanEntities = new dbLoanEntities()) { dbLoanEntities.tblUser.Attach(tblUser); dbLoanEntities.Entry(tblUser).Property(x => x.UserPassword).IsModified = true; dbLoanEntities.SaveChanges(); } }
public void EditPayOff() { var tblLoan = new tblLoan { Id = DId, LoanPayOff = DPayOff }; using (var dbLoanEntities = new dbLoanEntities()) { dbLoanEntities.tblLoan.Attach(tblLoan); dbLoanEntities.Entry(tblLoan).Property(x => x.LoanPayOff).IsModified = true; dbLoanEntities.SaveChanges(); } }
public void StartSecurityTimeAccess()//taeen zaman vorod eshtebah { var tblSecurityAccess = new tblSecurityAccess { Id = 1, Time = PersianDateTime.Now.ToString() }; using (var dbLoanEntities = new dbLoanEntities()) { dbLoanEntities.tblSecurityAccess.Attach(tblSecurityAccess); dbLoanEntities.Entry(tblSecurityAccess).Property(x => x.Time).IsModified = true; dbLoanEntities.SaveChanges(); } }
public static int SecurityAccess(ref int counter)//taeen modat zamani ke az 5 bar eshtbah gozashteh ast { var dbLoanEntities = new dbLoanEntities(); var firstOrDefault = dbLoanEntities.tblSecurityAccess.FirstOrDefault(); //khandan etela-at file if (firstOrDefault == null) { return(5); } counter = int.Parse(firstOrDefault.Counter);//zakhireh tedad vorod eshtebah var saveDate = firstOrDefault.Time.Split(' '); var result = PersianDateTime.Now - PersianDateTime.Parse(saveDate[0], saveDate[1]); var checkTimeMinutes = result.Minutes; var checkTimeHours = result.Hours; var checkTimeDays = result.Days; if (checkTimeHours == 0 && checkTimeDays == 0) { return(checkTimeMinutes); } return(5); }
public DIntroducer() { _dbLoanEntities = new dbLoanEntities(); }
public DUserLogin() { _dbLoanEntities = new dbLoanEntities(); }
public static Task <List <tblInstallment> > GetData(int loanId) { var dbLoanEntities = new dbLoanEntities(); return(Task.Run(() => dbLoanEntities.tblInstallment.Where(x => x.Installment_Loan_Id == loanId).ToList())); }
public DInstallment() { _dbLoanEntities = new dbLoanEntities(); }
public DChargeMonthly() { _dbLoanEntities = new dbLoanEntities(); }
public static Task <List <tblBankAccount> > GetData() { var dbLoanEntities = new dbLoanEntities(); return(Task.Run(() => dbLoanEntities.tblBankAccount.ToList())); }
public DBankAccount() { _dbLoanEntities = new dbLoanEntities(); }
public static Task <List <spSelectFeeIncomeInfo_Result> > GetData() { var dbLoanEntities = new dbLoanEntities(); return(Task.Run(() => dbLoanEntities.spSelectFeeIncomeInfo().ToList())); }
public DFeeIncome() { _dbLoanEntities = new dbLoanEntities(); }
public static Task <List <tblPerAccType> > GetData(int personnelId) { var dbLoanEntities = new dbLoanEntities(); return(Task.Run(() => dbLoanEntities.tblPerAccType.Where(x => x.PerAccType_Personnel_Id == personnelId).ToList())); }
public static Task <List <tblIntroducer> > GetInfoIntroData(int?infoId) { var dbLoanEntities = new dbLoanEntities(); return(Task.Run(() => dbLoanEntities.tblIntroducer.Where(x => x.Introducer_Info_Id == infoId).ToList())); }
public DPerAccType() { _dbLoanEntities = new dbLoanEntities(); }