private string GetPriorDate()
{
strUserIdentity = "fountainhead\bgoff";
GenericIdentity objGenericIdentity = new GenericIdentity(strUserIdentity);
CredentialPrincipal credPrincipal = new BAM.Repository.CredentialPrincipal(objGenericIdentity, null, strPerms); ;
config = new ConfigHelper();
_dataRepository = config.GetRepository("Persistence");
Hashtable ht = new Hashtable();
ht["date"] = DateTime.Now.Date;
ht["CountryArr"] = "US";
DataSet ds = GetDataSet("Persistence", "Persistence.StaarsConversion_GetPriorDate", ht);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
return ((DateTime)ds.Tables[0].Rows[0][0]).ToShortDateString();
else
return String.Empty;
}
private static DataSet GetDataSet(string repository, string alias, Hashtable ht)
{
DataSet ds = new DataSet();
config = new ConfigHelper();
_dataRepository = config.GetRepository(repository);
if (ht != null)
ds = _dataRepository.LoadDataSet(alias, ht);
else
ds = _dataRepository.LoadDataSet(alias);
return ds;
}
public override int Execute(Object o, Hashtable inputData)
{
int activityIdStarting = UpdateProcessStatus(Enums.ProcessStatus.Starting, "", (State)o );
if (IfResetOnEachRun)
ResetOutput();
PassAlongOutputs(inputData);
strUserIdentity = "fountainhead\bgoff";
GenericIdentity objGenericIdentity = new GenericIdentity(strUserIdentity);
CredentialPrincipal credPrincipal = new BAM.Repository.CredentialPrincipal(objGenericIdentity, null, strPerms); ;
config = new ConfigHelper();
_dataRepository = config.GetRepository(repositoryName);
DataSet ds = GetDataSet(repositoryName, sqlAlias, null);
AddToOutputs(this.Name, ds);
//Hashtable ht = new Hashtable();
//foreach (Object oIn in inputData)
//{
// DataTable dt = oIn as DataTable;
// foreach (DataRow dr in dt.Rows)
// {
// GetDataSet(repositoryName, sqlAlias, null);
// }
//}
int activityIdEnding = UpdateProcessStatus(Enums.ProcessStatus.Success, "", (State)o );
log.InfoFormat(job.KeyCode, "PersistenceAdapter executed.");
return 0;
}
public override int Execute(Object o, Hashtable inputData)
{
int activityIdStarting = UpdateProcessStatus(Enums.ProcessStatus.Starting, "", (State)o );
if (IfResetOnEachRun)
ResetOutput();
PassAlongOutputs(inputData);
strUserIdentity = "fountainhead\bgoff";
GenericIdentity objGenericIdentity = new GenericIdentity(strUserIdentity);
CredentialPrincipal credPrincipal = new BAM.Repository.CredentialPrincipal(objGenericIdentity, null, strPerms); ;
config = new ConfigHelper();
_dataRepository = config.GetRepository("GenevaPersistence");
Hashtable ht = new Hashtable();
foreach (Object oIn in inputData)
{
DataTable dt = oIn as DataTable;
foreach (DataRow dr in dt.Rows)
{
ht.Clear();
switch (columnMapMode)
{
case 0:
for (int i = 0; i < columnCount; i++)
ht[dt.Columns[i].ColumnName] = dr[i];
break;
}
//string pquery = String.Format("GenevaPersistence.{0}", query);
GetDataSet("GenevaPersistence", query, ht);
}
}
int activityIdEnding = UpdateProcessStatus(Enums.ProcessStatus.Success, "", (State)o );
log.InfoFormat(job.KeyCode, "GenevaPersistenceAdapter executed.");
return 0;
}
public override int Execute(Object o, Hashtable inputData)
{
int activityIdStarting = UpdateProcessStatus(Enums.ProcessStatus.Starting, "", (State)o );
if (IfResetOnEachRun)
ResetOutput();
PassAlongOutputs(inputData);
strUserIdentity = "fountainhead\bgoff";
GenericIdentity objGenericIdentity = new GenericIdentity(strUserIdentity);
CredentialPrincipal credPrincipal = new BAM.Repository.CredentialPrincipal(objGenericIdentity, null, strPerms); ;
config = new ConfigHelper();
_dataRepository = config.GetRepository("PersistenceAdapter");
Hashtable ht = new Hashtable();
foreach (Object oIn in inputData)
{
DataTable dt = oIn as DataTable;
foreach (DataRow dr in dt.Rows)
{
ht.Clear();
ht["entryDate"] = dr[0];
ht["datasource"] = dr[1];
ht["tradeDate"] = dr[2];
ht["symbol"] = dr[3];
ht["side"] = dr[4];
ht["quantity"] = dr[5];
ht["price"] = dr[6];
GetDataSet("Persistence", "Persistence.13fReport_SaTradeDelete", ht);
GetDataSet("Persistence", "Persistence.13fReport_SaTradeInsert", ht);
}
}
int activityIdEnding = UpdateProcessStatus(Enums.ProcessStatus.DoneSuccess, "", (State)o );
log.InfoFormat("PersistenceAdapter executed.");
return 0;
}
private string GetCat1CodeFromAccount(string account)
{
string strUserIdentity = "fountainhead\bgoff";
string LE = String.Empty;
GenericIdentity objGenericIdentity = new GenericIdentity(strUserIdentity);
CredentialPrincipal credPrincipal = new BAM.Repository.CredentialPrincipal(objGenericIdentity, null, strPerms); ;
config = new ConfigHelper();
repository = config.GetRepository("SqlPersistence");
Hashtable ht = new Hashtable();
ht["Account"] = account;
DataSet ds = repository.LoadDataSet("Sql.GetCat1CodeFromAccount", ht);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
LE = ds.Tables[0].Rows[0][0].ToString();
return LE;
}
private double GetCommAndFees(string chargeType, string assetClass, string broker, string underlyingAssetClass, string product, string cat1Code,
string country, string exchange, string buySell, double price, double quantity, double mktValue)
{
string strUserIdentity = "fountainhead\bgoff";
GenericIdentity objGenericIdentity = new GenericIdentity(strUserIdentity);
CredentialPrincipal credPrincipal = new BAM.Repository.CredentialPrincipal(objGenericIdentity, null, strPerms); ;
config = new ConfigHelper();
repository = config.GetRepository("SqlPersistence");
Hashtable ht = new Hashtable();
ht["ChargeType"] = chargeType;
ht["AssetClass"] = assetClass;
ht["Broker"] = broker;
ht["UnderlyingAssetClass"] = underlyingAssetClass;
ht["Product"] = product;
ht["Cat1Code"] = cat1Code;
ht["Country"] = country;
ht["Exchange"] = exchange;
ht["BuySell"] = buySell;
ht["Price"] = price;
ht["Quantity"] = quantity;
ht["Price"] = price;
ht["MarketValue"] = mktValue;
ht["Price"] = price;
ht["commission"] = null;
ht["currency"] = null;
//DataSet ds = Bam.Framework.Service.Persistence.Repository.GetRepository(repository.Name,
// repository.Type, repository.ConnectionString, repository.AliasDirectory).LoadDataSet("Sql.GetCommission", ht);
DataSet ds = repository.LoadDataSet("Sql.GetCommission", ht);
double expense = 0;
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
if (!ds.Tables[0].Rows[0]["Commission"].Equals(DBNull.Value))
expense = Convert.ToDouble(ds.Tables[0].Rows[0]["Commission"]);
return expense;
}
