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(); } }