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