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