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