//User KYC Log
public void CreateKYCLog(KYCLogModel model)
{
using (IDbConnection connection = new NpgsqlConnection(GlobalConfig.getDatabaseConnectionString()))
{
connection.ExecuteScalar <int>($"insert into user_kyc_log values(default,{model.user_id},'{model.related_aadhar}','{model.related_pan}',default)");
}
}
//CAR
public void CreateCar(CarModel model, UserModel user)
{
CreateDocument(model.documentModel);
CreateApplicant(model.applicantModel);
CreateGurantor(model.gurantorModel);
CreateAccount(model.accountModel);
foreach (LoanModel loan in model.loanModel)
{
CreateLoan(loan);
}
KYCLogModel log = new KYCLogModel();
log.user_id = user.user_id;
log.related_pan = model.documentModel.document_pan;
log.related_aadhar = model.documentModel.document_aadhar;
CreateKYCLog(log);
}
public UserModel GetUser_ByPan(string aadhar, string pan)
{
List <KYCLogModel> userList = new List <KYCLogModel>();
KYCLogModel user = new KYCLogModel();
using (IDbConnection connection = new NpgsqlConnection(GlobalConfig.getDatabaseConnectionString()))
{
userList = connection.Query <KYCLogModel>($"select * from user_kyc_log where related_aadhar = '{aadhar}' and related_pan = '{pan}'").ToList();
if (userList.Count != 0)
{
user = userList[0];
UserModel u = new UserModel();
List <UserModel> uList = new List <UserModel>();
uList = connection.Query <UserModel>($"select * from login where user_id = {user.user_id}").ToList();
u = uList[0];
return(u);
}
else
{
return(null);
}
}
}
