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