public void GetSystemDate(EndOfDayRepo EODRepo) { var app = new AppSettings(); using (OracleConnection conp = new OracleConnection(app.conString())) { try { //Get connection var con = new AppSettings(); var param = new DynamicParameters(); param.Add("P_DATE_NOW", "", DbType.Date, ParameterDirection.Output); con.GetConnection().Execute("SEL_DATE_NOW", param, commandType: CommandType.StoredProcedure); EODRepo.System_Date = param.Get <DateTime>("P_DATE_NOW"); } catch (Exception ex) { throw ex; } finally { if (conp.State == ConnectionState.Open) { conp.Close(); conp.Dispose(); } } } }
//public bool RunEOD(EndOfDayRepo EODRepo) //{ // 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 // { // // check for pending transactions // //Remittance // //var paramR = new DynamicParameters(); // // paramR.Add("P_SCHEME_ID", Scheme_Id, DbType.String, ParameterDirection.Input); // // paramR.Add("VDATA", null, DbType.Int32, ParameterDirection.Output); // // conn.Execute("EOD_PENDING_REMITTANCE", paramR, commandType: CommandType.StoredProcedure); // // int paramoption = paramR.Get<int>("VDATA"); // // if (paramoption > 0) // // return false; // //Payment // var paramRe = new DynamicParameters(); // paramRe.Add("P_SCHEME_ID", Scheme_Id, DbType.String, ParameterDirection.Input); // paramRe.Add("P_VALUE_DATE", EODRepo.Scheme_Today_Date, DbType.Date, ParameterDirection.Input); // paramRe.Add("VDATA", null, DbType.Int32, ParameterDirection.Output); // conn.Execute("EOD_PENDING_PAYMENT", paramRe, commandType: CommandType.StoredProcedure); // int receipt = paramRe.Get<int>("VDATA"); // if (receipt > 0) // return false; // //Purchases // var paramPu = new DynamicParameters(); // paramPu.Add("P_SCHEME_ID", Scheme_Id, DbType.String, ParameterDirection.Input); // paramPu.Add("P_VALUE_DATE", EODRepo.Scheme_Today_Date, DbType.Date, ParameterDirection.Input); // paramPu.Add("VDATA", "", DbType.Int32, ParameterDirection.Output); // conn.Execute("EOD_PENDING_PURCHASE", paramPu, commandType: CommandType.StoredProcedure); // int purchase = paramPu.Get<int>("VDATA"); // if (purchase > 0) // return false; // // GL(Journal) // //check for pending investments // //Accrue investment interest // //check for securities maturity // //rollover investments // //GET AUM // //ACCRUE FEES BEFORE NAV // //ACCRUE FEES AFTER NAV // //ACCRUE FUND MANAGERS FEE // //calculate unit price // // Apply surchage on contribution due for surchage // DynamicParameters param = new DynamicParameters(); // param.Add(name: "P_SCHEME_ID", value: Scheme_Id, dbType: DbType.String, direction: ParameterDirection.Input); // conn.Execute("EOD_SURCHARGE_CON_LOG", param, commandType: CommandType.StoredProcedure); // // move today date to next date // DynamicParameters parama = new DynamicParameters(); // parama.Add(name: "P_SCHEME_ID", value: Scheme_Id, dbType: DbType.String, direction: ParameterDirection.Input); // conn.Execute("EOD_NEXT_DATE", parama, commandType: CommandType.StoredProcedure); // // log unit price // ts.Complete(); // return true; // } // catch (Exception ex) // { // throw ex; // } // finally // { // ts.Dispose(); // if (conn.State == ConnectionState.Open) // { // conn.Close(); // } // } // } //} public void GetSchemeList(EndOfDayRepo EODRepo) { var app = new AppSettings(); using (OracleConnection conp = new OracleConnection(app.conString())) { try { //Get connection var con = new AppSettings(); var param = new DynamicParameters(); param.Add("P_SCHEME_ID", EODRepo.Scheme_Id, DbType.String, ParameterDirection.Input); param.Add("VDATA", "", DbType.String, ParameterDirection.Output); con.GetConnection().Execute("SEL_SCHEME_NAME", param, commandType: CommandType.StoredProcedure); EODRepo.Scheme_Name = param.Get <string>("VDATA"); } catch (Exception ex) { throw ex; } finally { if (conp.State == ConnectionState.Open) { conp.Close(); conp.Dispose(); } } } }