/// <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; }