public virtual int Update(int SGID, int SWID, double STopLine, double SbaseLine, double SQuantity, int Original_SGID, int Original_SWID, double Original_STopLine, double Original_SbaseLine, double Original_SQuantity)
{
this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(SGID));
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(SWID));
this.Adapter.UpdateCommand.Parameters[2].Value = ((double)(STopLine));
this.Adapter.UpdateCommand.Parameters[3].Value = ((double)(SbaseLine));
this.Adapter.UpdateCommand.Parameters[4].Value = ((double)(SQuantity));
this.Adapter.UpdateCommand.Parameters[5].Value = ((int)(Original_SGID));
this.Adapter.UpdateCommand.Parameters[6].Value = ((int)(Original_SWID));
this.Adapter.UpdateCommand.Parameters[7].Value = ((double)(Original_STopLine));
this.Adapter.UpdateCommand.Parameters[8].Value = ((double)(Original_SbaseLine));
this.Adapter.UpdateCommand.Parameters[9].Value = ((double)(Original_SQuantity));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
public virtual int UpdateQuery(string explanation, long id)
{
System.Data.SqlClient.SqlCommand command = this.CommandCollection[3];
if ((explanation == null))
{
command.Parameters[0].Value = System.DBNull.Value;
}
else
{
command.Parameters[0].Value = ((string)(explanation));
}
command.Parameters[1].Value = ((long)(id));
System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public static SqlDataBaseOjectHandler GlobalPerformQuery(string query)
{
SqlDataBaseOjectHandler handler = new SqlDataBaseOjectHandler();
try
{
SqlCommand command = new SqlCommand(query, SqlConnectionClass.getConn());
SqlConnectionClass.getConn().Open();
System.Data.ConnectionState state = SqlConnectionClass.getConn().State;
if (!(state == System.Data.ConnectionState.Open))
{
Helper_Classes_namespace.ErrorMessages.setErrorMessage(" Sorry no Db Connection !!!!!!! ", true);
handler.hasErrors = true;
return(handler);
}
command.ExecuteNonQuery();
handler.reader = command.ExecuteReader();
}
catch (System.Exception em)
{
Helper_Classes_namespace.ErrorMessages.setErrorMessage(em.ToString(), true);
handler.hasErrors = true;
}
return(handler);
}
public virtual int InsertQuery(int questionId, string explanation)
{
System.Data.SqlClient.SqlCommand command = this.CommandCollection[2];
command.Parameters[0].Value = ((int)(questionId));
if ((explanation == null))
{
command.Parameters[1].Value = System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(explanation));
}
System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int Insert(string RoleDescription)
{
if ((RoleDescription == null))
{
throw new System.ArgumentNullException("RoleDescription");
}
else
{
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(RoleDescription));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.InsertCommand.Connection.Close();
}
}
}
public virtual int Update(System.Guid p1, byte[] p2, System.DateTime p3, System.Guid p4)
{
this.Adapter.UpdateCommand.Parameters[0].Value = ((System.Guid)(p1));
if ((p2 == null))
{
throw new System.ArgumentNullException("p2");
}
else
{
this.Adapter.UpdateCommand.Parameters[1].Value = ((byte[])(p2));
}
this.Adapter.UpdateCommand.Parameters[2].Value = ((System.DateTime)(p3));
this.Adapter.UpdateCommand.Parameters[3].Value = ((System.Guid)(p4));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
public virtual int Insert(string MaNgayCong, System.Nullable <int> SoNgay)
{
if ((MaNgayCong == null))
{
throw new System.ArgumentNullException("MaNgayCong");
}
else
{
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(MaNgayCong));
}
if ((SoNgay.HasValue == true))
{
this.Adapter.InsertCommand.Parameters[1].Value = ((int)(SoNgay.Value));
}
else
{
this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.InsertCommand.Connection.Close();
}
}
}
public virtual int Insert(int Number, System.Nullable <decimal> Balance, string Name)
{
this.Adapter.InsertCommand.Parameters[0].Value = ((int)(Number));
if ((Balance.HasValue == true))
{
this.Adapter.InsertCommand.Parameters[1].Value = ((decimal)(Balance.Value));
}
else
{
this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
}
if ((Name == null))
{
this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
}
else
{
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(Name));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
this.Adapter.InsertCommand.Connection.Open();
try {
return(this.Adapter.InsertCommand.ExecuteNonQuery());
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.InsertCommand.Connection.Close();
}
}
}
public virtual int UpdateQuery(int value, int id)
{
System.Data.SqlClient.SqlCommand command = this.CommandCollection[2];
command.Parameters[0].Value = ((int)(value));
command.Parameters[1].Value = ((int)(id));
System.Data.ConnectionState previousConnectionState = command.Connection.State;
Trace.WriteLine(string.Format("connection state: {0}", previousConnectionState));
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
command.Connection.Open();
Trace.WriteLine("Opening connection again");
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual object DeleteGroup(int Original_idx)
{
System.Data.SqlClient.SqlCommand command = this.CommandCollection[1];
command.Parameters[0].Value = ((int)(Original_idx));
System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
object returnValue;
try {
returnValue = command.ExecuteScalar();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
if (((returnValue == null) ||
(returnValue.GetType() == typeof(System.DBNull))))
{
return(null);
}
else
{
return((object)(returnValue));
}
}
public virtual int Update(int AnimalID, string AnimalName, int Original_AnimalID, string Original_AnimalName)
{
this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(AnimalID));
if ((AnimalName == null))
{
throw new System.ArgumentNullException("AnimalName");
}
else
{
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(AnimalName));
}
this.Adapter.UpdateCommand.Parameters[2].Value = ((int)(Original_AnimalID));
if ((Original_AnimalName == null))
{
throw new System.ArgumentNullException("Original_AnimalName");
}
else
{
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(Original_AnimalName));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
this.Adapter.UpdateCommand.Connection.Open();
try {
return(this.Adapter.UpdateCommand.ExecuteNonQuery());
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
public List <int> GetIdList()
{
List <int> list = new List <int>();
System.Data.SqlClient.SqlCommand command = this.CommandCollection(0);
command.CommandTimeout = command.Connection.ConnectionTimeout;
System.Data.ConnectionState previousConnectionState = command.Connection.State;
try {
if (((command.Connection.State & System.Data.ConnectionState.Open) != System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
using (System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
list.Add(reader.GetInt32(0));
}
}
} finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(list);
}
public virtual int Update(string DemoValue, int Original_DemoID, string Original_DemoValue, int DemoID)
{
if ((DemoValue == null))
{
this.Adapter.UpdateCommand.Parameters[0].Value = System.DBNull.Value;
}
else
{
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(DemoValue));
}
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(Original_DemoID));
if ((Original_DemoValue == null))
{
this.Adapter.UpdateCommand.Parameters[2].Value = ((int)(1));
this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
}
else
{
this.Adapter.UpdateCommand.Parameters[2].Value = ((int)(0));
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(Original_DemoValue));
}
this.Adapter.UpdateCommand.Parameters[4].Value = ((int)(DemoID));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
this.Adapter.UpdateCommand.Connection.Open();
try {
return(this.Adapter.UpdateCommand.ExecuteNonQuery());
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
public virtual int Insert(string name)
{
if ((name == null))
{
this.Adapter.InsertCommand.Parameters[0].Value = System.DBNull.Value;
}
else
{
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(name));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.InsertCommand.Connection.Close();
}
}
}
public List<int> GetIdList(int categoryID)
{
List<int> list = new List<int>();
System.Data.SqlClient.SqlCommand command = this.CommandCollection[0];
command.CommandTimeout = command.Connection.ConnectionTimeout;
System.Data.ConnectionState previousConnectionState = command.Connection.State;
try {
if (((command.Connection.State & System.Data.ConnectionState.Open) != System.Data.ConnectionState.Open)) {
command.Connection.Open();
}
command.Parameters[ "@id" ].Value = categoryID;
using (System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader()) {
while (reader.Read()) {
list.Add(reader.GetInt32(0));
}
}
} finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
command.Connection.Close();
}
}
return list;
}
public virtual int UpdateGroup(string name, int Original_idx)
{
System.Data.SqlClient.SqlCommand command = this.CommandCollection[2];
if ((name == null))
{
command.Parameters[0].Value = System.DBNull.Value;
}
else
{
command.Parameters[0].Value = ((string)(name));
}
command.Parameters[1].Value = ((int)(Original_idx));
System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int Delete(int Original_Id, string Original_Name)
{
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(Original_Id));
if ((Original_Name == null))
{
throw new System.ArgumentNullException("Original_Name");
}
else
{
this.Adapter.DeleteCommand.Parameters[1].Value = ((string)(Original_Name));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
public virtual int Delete(int Original_id, string Original_nome)
{
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(Original_id));
if ((Original_nome == null))
{
this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[2].Value = System.DBNull.Value;
}
else
{
this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_nome));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
public virtual int Insert(string FirstName, string LastName)
{
if ((FirstName == null))
{
throw new System.ArgumentNullException("FirstName");
}
else
{
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(FirstName));
}
if ((LastName == null))
{
this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
}
else
{
this.Adapter.InsertCommand.Parameters[1].Value = ((string)(LastName));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
this.Adapter.InsertCommand.Connection.Open();
try {
return(this.Adapter.InsertCommand.ExecuteNonQuery());
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.InsertCommand.Connection.Close();
}
}
}
public virtual int Delete(int Original_UserID, string Original_FirstName, string Original_LastName)
{
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(Original_UserID));
if ((Original_FirstName == null))
{
throw new System.ArgumentNullException("Original_FirstName");
}
else
{
this.Adapter.DeleteCommand.Parameters[1].Value = ((string)(Original_FirstName));
}
if ((Original_LastName == null))
{
this.Adapter.DeleteCommand.Parameters[2].Value = ((int)(1));
this.Adapter.DeleteCommand.Parameters[3].Value = System.DBNull.Value;
}
else
{
this.Adapter.DeleteCommand.Parameters[2].Value = ((int)(0));
this.Adapter.DeleteCommand.Parameters[3].Value = ((string)(Original_LastName));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
this.Adapter.DeleteCommand.Connection.Open();
try {
return(this.Adapter.DeleteCommand.ExecuteNonQuery());
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
public virtual int DeleteGroupByName(string name)
{
System.Data.SqlClient.SqlCommand command = this.CommandCollection[2];
if ((name == null))
{
throw new System.ArgumentNullException("name");
}
else
{
command.Parameters[0].Value = ((string)(name));
}
System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public void TestDbAccess_Connection() // Assertion is true if connection was opened
{
enetConnection.Open();
System.Data.ConnectionState state = enetConnection.State;
enetConnection.Close();
CheckIfItsPopulated();
Assert.IsTrue(state == System.Data.ConnectionState.Open);
}
public void CloseConnection()
{
if (_OracleConnection.State != System.Data.ConnectionState.Closed)
{
System.Data.ConnectionState prevstate = _OracleConnection.State;
_OracleConnection.Close();
FireConnectionChangedEvent(prevstate, _OracleConnection.State);
}
}
public virtual int Update(string NameOfApplicant, string Village_CityName, decimal Original_AdjudicationId, string Original_NameOfApplicant, string Original_Village_CityName, decimal AdjudicationId)
{
if ((NameOfApplicant == null))
{
this.Adapter.UpdateCommand.Parameters[0].Value = System.DBNull.Value;
}
else
{
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(NameOfApplicant));
}
if ((Village_CityName == null))
{
this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
}
else
{
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(Village_CityName));
}
this.Adapter.UpdateCommand.Parameters[2].Value = ((decimal)(Original_AdjudicationId));
if ((Original_NameOfApplicant == null))
{
this.Adapter.UpdateCommand.Parameters[3].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
}
else
{
this.Adapter.UpdateCommand.Parameters[3].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(Original_NameOfApplicant));
}
if ((Original_Village_CityName == null))
{
this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
}
else
{
this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(Original_Village_CityName));
}
this.Adapter.UpdateCommand.Parameters[7].Value = ((decimal)(AdjudicationId));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
public void CloseCurrentUIMF()
{
if (instance != null)
{
Reader.Dispose();
ConnectionState = System.Data.ConnectionState.Closed;
}
}
public override void Open()
{
if (state != System.Data.ConnectionState.Open)
{
this.query = new LogQuery();
this.connection = new IISLogInputFormat();
}
state = System.Data.ConnectionState.Open;
}
public virtual int Delete(string Original_OznDrzave, string Original_NazDrzave, string Original_ISO3Drzave, System.Nullable <int> Original_SifDrzave)
{
if ((Original_OznDrzave == null))
{
throw new System.ArgumentNullException("Original_OznDrzave");
}
else
{
this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(Original_OznDrzave));
}
if ((Original_NazDrzave == null))
{
throw new System.ArgumentNullException("Original_NazDrzave");
}
else
{
this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_NazDrzave));
}
if ((Original_ISO3Drzave == null))
{
this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[4].Value = System.DBNull.Value;
}
else
{
this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_ISO3Drzave));
}
if ((Original_SifDrzave.HasValue == true))
{
this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[6].Value = ((int)(Original_SifDrzave.Value));
}
else
{
this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[6].Value = System.DBNull.Value;
}
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open))
{
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return(returnValue);
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed))
{
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
public override void Close()
{
_Connected = false;
_State = System.Data.ConnectionState.Closed;
if (_TcpClient != null)
{
_TcpClient.Close();
}
}
private void FireConnectionChangedEvent(System.Data.ConnectionState prevState, System.Data.ConnectionState newState)
{
if (_eventMgr == null)
{
return;
}
DbConnectionChangedMessage message = new DbConnectionChangedMessage(prevState, newState);
_eventMgr.GetEvent <DbConnectionChangedEvent>().Publish(message);
}
protected void Open(TcpClient tcpClient)
{
int elapseConnectTime = 1;
Random rand = new Random();
_ServerBusy = false;
while (elapseConnectTime < this.ConnectionTimeout * 1000)
{
tcpClient.Connect(this.ConnectionTimeout * 1000);
try
{
tcpClient.SendSyncMessage((short)ConnectEvent.Connect, BuildConnectionMessage());
break;
}
catch (Exception e)
{
if (e.Message.Trim() == "Too many connects on server")
{
tcpClient.Close();
_Connected = false;
ConnectionString = ConnectionString;
if (!CommandReportNoCache && TryConnectTimeout > 0)
{
if (elapseConnectTime >= TryConnectTimeout)
{
_ServerBusy = true;
return;
}
}
int sleepMillisecond = rand.Next(200, 800);
elapseConnectTime += sleepMillisecond;
System.Threading.Thread.Sleep(sleepMillisecond);
continue;
}
tcpClient.Close();
throw e;
}
}
if (elapseConnectTime > this.ConnectionTimeout * 1000)
{
throw new System.Data.DataException("Connect timeout.The hubbledotnet server is too busy right now.");
}
_Connected = true;
_State = System.Data.ConnectionState.Open;
DataCacheMgr.OnConnect(this);
}
public override void Close()
{
state = System.Data.ConnectionState.Closed;
}
public void Close()
{
this.state = System.Data.ConnectionState.Closed;
}
public void Open()
{
System.Diagnostics.Trace.WriteLine("DataSetConnection Open");
// nothing to open, just set the state
this.state = System.Data.ConnectionState.Open;
}
/// <summary>
/// Opens the connection
/// </summary>
private void OpenConnection()
{
this.ConnectionState = Connection.State;
this.Connection.Close();
this.Connection.Open();
schemaData = null;
}
public override void Open()
{
if (state != System.Data.ConnectionState.Open)
{
this.query = new LogQuery();
this.connection = new IISLogInputFormat();
}
state = System.Data.ConnectionState.Open;
}
