public void Create_Units(Remit_Unit_MigrateRepo remitConLogdetailsrepo)
{
try
{
//Get Connection
AppSettings app = new AppSettings();
conn = app.GetConnection();
DynamicParameters param = new DynamicParameters();
param.Add(name: "p_PURCHASE_LOG_ID", value: remitConLogdetailsrepo.Purchase_Log_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_ESF_ID", value: remitConLogdetailsrepo.Esf_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Employer_Units", value: remitConLogdetailsrepo.Employer_Units, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Employee_Units", value: remitConLogdetailsrepo.Employee_Units, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "p_Purchase_Type", value: "MIGRATED UNIT", dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_Unit_Price", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input);
conn.Execute("MIGRATE_UNIT_PURCHASES", param, commandType: CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
if (conn != null)
{
conn = null;
}
}
}
}
public bool getPurchaseLog(Remit_Unit_MigrateRepo remitConLogdetailsrepo)
{
try
{
//Get connection
var con = new AppSettings();
var param = new DynamicParameters();
param.Add("P_PURCHASE_LOG_ID", remitConLogdetailsrepo.Purchase_Log_Id, DbType.String, ParameterDirection.Input);
param.Add("VDATA", null, DbType.Int32, ParameterDirection.Output);
con.GetConnection().Execute("SEL__MIG_PURCHASE_ID", param, commandType: CommandType.StoredProcedure);
int paramoption = param.Get <int>("VDATA");
if (paramoption <= 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}