//check if collection account is available public bool Get_GL_coll(crm_EmployeeSchemeFundRepo ESFRepo) { try { //Get connection var con = new AppSettings(); var param = new DynamicParameters(); param.Add("P_SFID", ESFRepo.New_Scheme_Fund_Id, DbType.String, ParameterDirection.Input); param.Add("VDATA", null, DbType.Decimal, ParameterDirection.Output); con.GetConnection().Execute("SEL_CH_COLL_ACC", param, commandType: CommandType.StoredProcedure); decimal ESBENEFIT = param.Get <decimal>("VDATA"); if (ESBENEFIT > 0) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } }
//check cash available public bool Get_GL_Balance(crm_EmployeeSchemeFundRepo ESFRepo) { try { //Get connection var con = new AppSettings(); var param = new DynamicParameters(); param.Add("P_SFID", ESFRepo.Scheme_Fund_Id, DbType.String, ParameterDirection.Input); param.Add("P_ESFID", ESFRepo.Cust_No + ESFRepo.Scheme_Fund_Id, DbType.String, ParameterDirection.Input); param.Add("VDATA", null, DbType.Decimal, ParameterDirection.Output); param.Add("GB", null, DbType.Decimal, ParameterDirection.Output); con.GetConnection().Execute("SEL_CH_CASH_FOR_SF", param, commandType: CommandType.StoredProcedure); decimal ESBENEFIT = param.Get <decimal>("VDATA"); decimal CASH_BALANCE = param.Get <decimal>("GB") * -1; ESFRepo.ESF_BAL = ESBENEFIT; if (ESBENEFIT < CASH_BALANCE) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } }
public void SaveRecord(crm_EmployeeSchemeFundRepo ESFRepo) { try { //Get Connection AppSettings app = new AppSettings(); con = app.GetConnection(); DynamicParameters param = new DynamicParameters(); param.Add(name: "P_ESF_ID", value: ESFRepo.Cust_No + ESFRepo.Scheme_Fund_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "P_SCHEME_FUND_ID", value: ESFRepo.Scheme_Fund_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "P_EMPLOYEE_UNIT_BALANCE", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "P_EMPLOYER_UNIT_BALANCE", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "P_CUST_NO", value: ESFRepo.Cust_No, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "P_MAKER_ID", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input); con.Execute("MIX_REMIT_EMPLOYEE_SCHEME_FUND", param, commandType: CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } finally { if (con.State == ConnectionState.Open) { con.Close(); if (con != null) { con = null; } } } }
// change employer public bool ChangeRecordemployer(crm_EmployeeSchemeFundRepo ESFRepo) { var app = new AppSettings(); TransactionOptions tsOp = new TransactionOptions(); tsOp.IsolationLevel = System.Transactions.IsolationLevel.Snapshot; TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew, tsOp); tsOp.Timeout = TimeSpan.FromMinutes(20); using (OracleConnection conn = new OracleConnection(app.conString())) // { try { DynamicParameters param = new DynamicParameters(); param.Add("p_esf_id", ESFRepo.Employer_Id, DbType.String, ParameterDirection.Input); param.Add("p_new_esf_id", ESFRepo.New_Employer_Id, DbType.String, ParameterDirection.Input); param.Add("p_cust_no", ESFRepo.Cust_No, DbType.String, ParameterDirection.Input); param.Add(name: "p_Maker_Id", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input); conn.Execute(sql: "CHG_CRM_EMPLOYER", param: param, commandType: CommandType.StoredProcedure); ts.Complete(); return(true); } catch (Exception ex) { throw ex; } finally { ts.Dispose(); if (conn.State == ConnectionState.Open) { conn.Close(); } } } }