/// <summary>
/// Please refer to the documentation of <see cref="GentleProvider"/> and the
/// <see cref="IPersistenceEngine"/> interface it implements for details.
/// </summary>
public override IDbCommand GetCommand()
{
IDbCommand cmd = new SybaseCommand();
cmd.CommandTimeout = GentleSettings.DefaultCommandTimeout;
return(cmd);
}
public SybaseDataAdapter(SybaseCommand selectCommand)
{
SelectCommand = selectCommand;
#if NET_2_0
UpdateBatchSize = 1;
#endif
}
public new SybaseCommand CreateCommand()
{
SybaseCommand command = new SybaseCommand();
command.Connection = this;
return(command);
}
internal SybaseDataReader(SybaseCommand command)
{
readResult = false;
haveRead = false;
readResultUsed = false;
this.command = command;
resultsRead = 0;
isClosed = false;
command.Tds.RecordsAffected = -1;
#if NET_2_0
visibleFieldCount = 0;
#endif
NextResult();
}
/// <summary>
/// Please refer to the documentation of <see cref="GentleSqlFactory"/> for details.
/// </summary>
public override void AddParameter(IDbCommand cmd, string name, long dbType)
{
try
{
SybaseCommand sc = (SybaseCommand)cmd;
//AsaCommand sc = (AsaCommand) cmd;
//place suffix and prefix around parameter
sc.Parameters.Add(GetParameterPrefix() + name + GetParameterSuffix(),
(SybaseType)dbType);
//(AsaDbType) dbType );
}
catch (Exception e)
{
Check.Fail(Error.Unspecified, e.Message);
throw new GentleException(Error.Unspecified, "Unreachable code");
}
}
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;
}
internal SybaseParameterCollection(SybaseCommand command)
{
this.command = command;
metaParameters = new TdsMetaParameterCollection();
}
public static void DeriveParameters(SybaseCommand command)
{
throw new NotImplementedException();
}
private object AddBroker(object param)
{
string portiaName = ((Tuple<string, string,string>)param).Item1;
string dtcName = ((Tuple<string, string, string>)param).Item2;
string execBrokerId = ((Tuple<string, string, string>)param).Item3;
if (!string.IsNullOrEmpty(dtcName) && !string.IsNullOrEmpty(portiaName))
{
using (SybaseConnection con = new SybaseConnection(model.Constants.SybaseConnection))
{
using (SybaseCommand com = new SybaseCommand(model.Constants.InsertBroker, con) { CommandType = CommandType.Text })
{
SybaseParameter oParam = new SybaseParameter("@portiaBrokerName", SybaseDbType.VarChar);
oParam.Value = portiaName;
com.Parameters.Add(oParam);
SybaseParameter oParam1 = new SybaseParameter("@dtcBrokerName", SybaseDbType.VarChar);
oParam1.Value = dtcName;
com.Parameters.Add(oParam1);
SybaseParameter oParam2 = new SybaseParameter("@executingBrokerId", SybaseDbType.VarChar);
oParam2.Value = execBrokerId;
com.Parameters.Add(oParam2);
con.Open();
try
{
com.ExecuteNonQuery();
}
catch (Exception ex)
{
}
}
}
}
//DtcBrokerName = string.Empty;
//PortiaBrokerName = string.Empty;
//ExecBrokerId = string.Empty;
return null;
}
private object RemoveAccount(object param)
{
DialogResult result = (DialogResult)System.Windows.MessageBox.Show("Are you sure you want to remove this account ?", "Message", MessageBoxButton.YesNoCancel, MessageBoxImage.Question);
if (result==DialogResult.Yes)
{
Account account = FocusedRow as Account;
string dtcAccount = account.DtcAccountNum;
string portiaAccount = account.PortiaAccountNum;
if (!string.IsNullOrEmpty(dtcAccount) && !string.IsNullOrEmpty(portiaAccount))
{
using (SybaseConnection con = new SybaseConnection(model.Constants.SybaseConnection))
{
using (SybaseCommand com = new SybaseCommand(model.Constants.DeleteAccount, con) { CommandType = CommandType.Text })
{
SybaseParameter oParam = new SybaseParameter("@dtcAccountNumber", SybaseDbType.VarChar);
oParam.Value = dtcAccount;
com.Parameters.Add(oParam);
SybaseParameter oParam1 = new SybaseParameter("@portiaAccountNumber", SybaseDbType.VarChar);
oParam1.Value = portiaAccount;
com.Parameters.Add(oParam1);
con.Open();
try
{
com.ExecuteNonQuery();
}
catch (Exception ex)
{
}
}
}
}
PopulateDtcAccount();
PopulatePortiaAccount();
LstAccounts = GetAccountMapping(dtcAccount, portiaAccount);
NotifyPropertyChanged("LstAccounts");
}
//DtcAccountNum = string.Empty;
//PortiaAccountNum = string.Empty;
return null;
}
private object AddAccount(object param)
{
string dtcAccount = ((Tuple<string, string>)param).Item1;
string portiaAccount = ((Tuple<string, string>)param).Item2;
if (!string.IsNullOrEmpty(dtcAccount) && !string.IsNullOrEmpty(portiaAccount))
{
using (SybaseConnection con = new SybaseConnection(model.Constants.SybaseConnection))
{
using (SybaseCommand com = new SybaseCommand(model.Constants.InsertAccount, con) { CommandType = CommandType.Text })
{
SybaseParameter oParam = new SybaseParameter("@dtcAccountNumber", SybaseDbType.VarChar);
oParam.Value = dtcAccount;
com.Parameters.Add(oParam);
SybaseParameter oParam1 = new SybaseParameter("@portiaAccountNumber", SybaseDbType.VarChar);
oParam1.Value = portiaAccount;
com.Parameters.Add(oParam1);
con.Open();
try
{
com.ExecuteNonQuery();
}
catch (Exception ex)
{
}
}
}
}
PopulateDtcAccount();
PopulatePortiaAccount();
//DtcAccountNum = string.Empty;
//PortiaAccountNum = string.Empty;
return null;
}
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;
}
