public void ApproveRecord(pfm_FundRepo pfm_fundrepo)
{
try
{
var param = new DynamicParameters();
if (string.IsNullOrEmpty(pfm_fundrepo.Fund_Id))
{
pfm_fundrepo.Auth_Status = "AUTHORIZED";
param.Add(name: "P_FUND_ID", value: pfm_fundrepo.Fund_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_STATUS", value: pfm_fundrepo.Auth_Status, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_ID", value: pfm_fundrepo.Auth_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_DATE", value: pfm_fundrepo.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 SaveRecord(pfm_FundRepo pfm_fundrepo)
{
try
{
var param = new DynamicParameters();
if (string.IsNullOrEmpty(pfm_fundrepo.Fund_Id))
{
pfm_fundrepo.Auth_Status = "AUTHORIZED";
param.Add(name: "P_FUND_NAME", value: pfm_fundrepo.Fund_Name, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_FUND_DESCRIPTION", value: pfm_fundrepo.Fund_Description, dbType: DbType.String, 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: pfm_fundrepo.Make_Date, dbType: DbType.Date, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_STATUS", value: pfm_fundrepo.Auth_Status, dbType: DbType.String, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "SETUP_PROCEDURES.ADD_PFM_FUND", param: param, commandType: CommandType.StoredProcedure);
}
else
{
pfm_fundrepo.Auth_Status = "AUTHORIZED";
param.Add(name: "P_FUND_ID", value: pfm_fundrepo.Fund_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_FUND_NAME", value: pfm_fundrepo.Fund_Name, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_FUND_DESCRIPTION", value: pfm_fundrepo.Fund_Description, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_UPDATE_ID", value: pfm_fundrepo.Update_Id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "P_UPDATE_DATE", value: pfm_fundrepo.Update_Date, dbType: DbType.Date, direction: ParameterDirection.Input);
param.Add(name: "P_AUTH_STATUS", value: pfm_fundrepo.Auth_Status, dbType: DbType.String, direction: ParameterDirection.Input);
db.GetConnection().Execute(sql: "SETUP_PROCEDURES.UPD_PFM_FUND", param: param, commandType: CommandType.StoredProcedure);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
db.Dispose();
}
}
