// FOR BACK PAY
public void Create_BP_Log_Details_employer(Remit_Con_Log_Details remitconlogDetails)
{
try
{
var param = new DynamicParameters();
///create log for the upload Remit Log
param.Add(name: "p_Employee_Id", value: remitconlogDetails.Employee_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_ESF_ID", value: remitconlogDetails.Esf_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Con_Log_Id", value: remitconlogDetails.Con_Log_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Con", value: remitconlogDetails.Employer_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Con", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Amt_Used", value: remitconlogDetails.Employer_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Amt_Used", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Maker_Id", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Auth_Status", value: "AUTHORIZED", dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Salary", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Sal_Rate", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Req_Con", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Difference", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Req_Status", value: "ACTIVE", dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Con_Type", value: "BACK-PAY", dbType: DbType.String, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "ADD_MIGRATE_CON_DETAILS", param: param, commandType: CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
}
public void Create_Con_Log_Details_BP(Remit_Con_Log_Details remitconlogDetails)
{
try
{
////////////////////////////////////////////////
if (remitconlogDetails.For_Month.ToString().Length == 1)
{
clog = "0" + remitconlogDetails.For_Month;
}
else
{
clog = remitconlogDetails.For_Month.ToString();
}
///////////////////////////////////////////////////
var param = new DynamicParameters();
///create log for the upload Remit Log
param.Add(name: "p_Employee_Id", value: remitconlogDetails.Employee_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_ESF_ID", value: remitconlogDetails.Esf_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Con_Log_Id", value: remitconlogDetails.Con_Log_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Con", value: remitconlogDetails.Employer_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Con", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Amt_Used", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Amt_Used", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Maker_Id", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Make_date", value: GlobalValue.Scheme_Today_Date, dbType: DbType.DateTime, direction: ParameterDirection.Input);
param.Add(name: "p_Auth_Status", value: "AUTHORIZED", dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Salary", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Sal_Rate", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Req_Con", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Difference", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Req_Status", value: "ACTIVE", dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Con_Type", value: "BACKPAY-CONTRIBUTION", dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Trustee_Name", value: "", dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_BatchNo", value: remitconlogDetails.ES_Id + "01", dbType: DbType.String, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "ADD_REMIT_CON_DETAILS_TRANS", param: param, commandType: CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
}
public void Create_Unit_Log_Details_Employer(Remit_Con_Log_Details remitconlogDetails)
{
try
{
var param = new DynamicParameters();
///create log for the upload Remit Log
param.Add(name: "p_ESF_ID", value: remitconlogDetails.Esf_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Amt", value: remitconlogDetails.Employer_Amt, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Amt", value: remitconlogDetails.Employee_Amt, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Purchase_Log_Id", value: remitconlogDetails.Purchase_Log_Id, dbType: DbType.String, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "ADD_MIGRATE_CON_EMPLOYER", param: param, commandType: CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
}