private ObservableCollection<Broker> GetBrokerMapping()
{
lstBrokers = new ObservableCollection<Broker>();
try
{
using (SybaseConnection con = new SybaseConnection(model.Constants.SybaseConnection))
{
using (SybaseCommand com = new SybaseCommand(model.Constants.SelectBrokerMapping, con) { CommandType = CommandType.Text })
{
con.Open();
try
{
using (SybaseDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
lstBrokers.Add(new Broker(Convert.ToInt32(reader["id"].ToString()), reader["portia_broker_name"].ToString(),
reader["dtc_broker_name"].ToString(), reader["executing_broker_id"].ToString(),
Convert.ToDateTime(reader["effective_date"].ToString()),
reader["updatedBy"].ToString()
));
}
}
}
catch (Exception ex)
{
Utility.PostMessage("Broker Mapping", ex.InnerException.ToString(), Mcm.Logger.Log.Level.Error);
return null;
}
}
}
}
catch (Exception ex)
{
Utility.PostMessage("Broker Mapping", ex.InnerException.ToString(), Mcm.Logger.Log.Level.Error);
return null;
}
return lstBrokers;
}
private ObservableCollection<Account> GetAccountMapping(string dtcAccount, string portiaAccount)
{
lstAccount = new ObservableCollection<Account>();
using (SybaseConnection con = new SybaseConnection(model.Constants.SybaseConnection))
{
using (SybaseCommand com = new SybaseCommand(model.Constants.SelectAccountMapping, con) { CommandType = CommandType.Text })
{
SybaseParameter oCom = new SybaseParameter("@portiaAccountNumber", SybaseDbType.VarChar);
oCom.Value = portiaAccount;
com.Parameters.Add(oCom);
oCom = new SybaseParameter("@dtcAccountNumber", SybaseDbType.VarChar);
oCom.Value = dtcAccount;
com.Parameters.Add(oCom);
con.Open();
try
{
using (SybaseDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
lstAccount.Add(new Account(Convert.ToInt32(reader["id"].ToString()), reader["portiaAccountNumber"].ToString(),
reader["dtcAccountNumber"].ToString(),
Convert.ToDateTime(reader["modifiedDate"].ToString()),
reader["modifiedBy"].ToString()
));
}
}
}
catch (Exception ex)
{
}
}
}
return lstAccount;
}
private ObservableCollection<PortiaAccount> GetPortiaAccounts()
{
lstPortiaAccount = new ObservableCollection<PortiaAccount>();
try
{
using (SybaseConnection con = new SybaseConnection(model.Constants.SybaseConnection))
{
using (SybaseCommand com = new SybaseCommand(model.Constants.SelectPortiaAccount, con) { CommandType = CommandType.Text })
{
con.Open();
try
{
using (SybaseDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
lstPortiaAccount.Add(new PortiaAccount(reader["portiaAccountNumber"].ToString()));
}
}
}
catch (Exception ex)
{
Utility.PostMessage("Account Mapping Portia", ex.InnerException.ToString(), Mcm.Logger.Log.Level.Error);
return null;
}
}
}
}
catch (Exception ex)
{
Utility.PostMessage("Account Mapping Portia", ex.InnerException.ToString(), Mcm.Logger.Log.Level.Error);
return null;
}
return lstPortiaAccount;
}
