/// <summary> /// [To be supplied.] /// </summary> /// <param name="CustomerID">[To be supplied.]</param> public void Remove(System.Data.SqlTypes.SqlInt32 CustomerID) { bool alreadyOpened = false; Params.spD_Customers Param = new Params.spD_Customers(true); Param.CommandTimeOut = this.deleteCommandTimeOut; switch (this.lastKnownConnectionType) { case Bob.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case Bob.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case Bob.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } Param.Param_CustomerID = CustomerID; SPs.spD_Customers Sp = new SPs.spD_Customers(true); Sp.Execute(ref Param); CloseConnection(Sp.Connection, alreadyOpened); }
/// <summary> /// [To be supplied.] /// </summary> /// <param name="record">[To be supplied.]</param> public void Remove(IBusinessComponentRecord record) { Customer recordToDelete = record as Customer; if (recordToDelete == null) { throw new ArgumentException("Invalid record type. Must be 'Bob.BusinessComponents.Customer'.", "record"); } bool alreadyOpened = false; Params.spD_Customers Param = new Params.spD_Customers(true); Param.CommandTimeOut = this.deleteCommandTimeOut; switch (this.lastKnownConnectionType) { case Bob.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case Bob.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case Bob.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } Param.Param_CustomerID = recordToDelete.CustomerID; SPs.spD_Customers Sp = new SPs.spD_Customers(true); Sp.Execute(ref Param); CloseConnection(Sp.Connection, alreadyOpened); if (internalRecords != null) { internalRecords.Remove(recordToDelete); } }