public void SaveRecord(pfm_Scheme_FundRepo pfm_schemefundrepo)
{
try
{
var param = new DynamicParameters();
pfm_schemefundrepo.Auth_Status = "AUTHORIZED";
pfm_schemefundrepo.Scheme_Fund_Status = "ACTIVE";
param.Add(name: "P_SCHEME_ID", value: pfm_schemefundrepo.Scheme_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_FUND_ID", value: pfm_schemefundrepo.Fund_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_UNIT_PRICE", value: pfm_schemefundrepo.Unit_Price, dbType: DbType.Decimal, direction: ParameterDirection.Input);
param.Add(name: "P_SCHEME_FUND_STATUS", value: pfm_schemefundrepo.Scheme_Fund_Status, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_MAKER_ID", value: pfm_schemefundrepo.Maker_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_MAKE_DATE", value: pfm_schemefundrepo.Make_Date, dbType: DbType.Date, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_STATUS", value: pfm_schemefundrepo.Auth_Status, dbType: DbType.String, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "SETUP_PROCEDURES.ADD_PFM_SCHEME_FUND", param: param, commandType: CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
}
public void ApproveRecord(pfm_Scheme_FundRepo pfm_schemefundrepo)
{
try
{
var param = new DynamicParameters();
if (string.IsNullOrEmpty(pfm_schemefundrepo.Scheme_Fund_Id))
{
pfm_schemefundrepo.Auth_Status = "AUTHORIZED";
param.Add(name: "P_SCHEME_FUND_ID", value: pfm_schemefundrepo.Scheme_Fund_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_STATUS", value: pfm_schemefundrepo.Auth_Status, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_ID", value: pfm_schemefundrepo.Auth_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_DATE", value: pfm_schemefundrepo.Auth_Date, dbType: DbType.Date, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "SETUP_PROCEDURES.APP_PFM_FUND", param: param, commandType: CommandType.StoredProcedure);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
}
public void SaveRecordGL(pfm_Scheme_FundRepo pfm_schemefundrepo)
{
try
{
var param = new DynamicParameters();
param.Add(name: "P_SCHEME_ID", value: pfm_schemefundrepo.Scheme_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_GL_ACCOUNT_ID", value: pfm_schemefundrepo.GL_Account_No, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_ACCOUNT_NAME", value: pfm_schemefundrepo.Account_Name, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_MAKER_ID", value: pfm_schemefundrepo.Maker_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_MAKE_DATE", value: pfm_schemefundrepo.Make_Date, dbType: DbType.Date, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "ADD_MERGE_GL_SCHEME", param: param, commandType: CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
}
