static public void Save(CellCarrier objCellCarrier, Database db, DbTransaction trans, bool CommitTrans) { try { if (objCellCarrier.IsModified == true) { if (objCellCarrier.ID == 0) { Insert(objCellCarrier, db, trans); } else { Update(objCellCarrier, db, trans); } } if (CommitTrans == true) { trans.Commit(); } } catch (Exception e) { if (CommitTrans == true) { //we were hoping to commit the transaction which means we're at the end so //Roll back the transaction. Otherwise just rethrow the error and let the next //higher level catch it and rollback trans.Rollback(); } //and then rethrow the error throw (e); } }
static public void Delete(CellCarrier objCellCarrier) { Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_CellCarrierDelete"); db.AddInParameter(dbCommand, "ID", DbType.Int32, objCellCarrier.ID); db.ExecuteNonQuery(dbCommand); }
static private void Update(CellCarrier objCellCarrier, Database db, DbTransaction trans) { //Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_CellCarrierUpdate"); db.AddInParameter(dbCommand, "ID", DbType.Int32, objCellCarrier.ID); db.AddInParameter(dbCommand, "Name", DbType.String, objCellCarrier.Name); db.AddInParameter(dbCommand, "TxtEmailSuffix", DbType.String, objCellCarrier.TxtEmailSuffix); db.AddInParameter(dbCommand, "Active", DbType.Boolean, objCellCarrier.Active); db.ExecuteNonQuery(dbCommand, trans); }
public CellCarrier Copy() { CellCarrier _cellCarrier = new CellCarrier(); _cellCarrier.ID = _iD; _cellCarrier.Name = _name; _cellCarrier.TxtEmailSuffix = _txtEmailSuffix; _cellCarrier.Active = _active; return(_cellCarrier); }
static private void Insert(CellCarrier objCellCarrier) { Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_CellCarrierInsert"); db.AddOutParameter(dbCommand, "ID", DbType.Int32, 4); db.AddInParameter(dbCommand, "Name", DbType.String, objCellCarrier.Name); db.AddInParameter(dbCommand, "TxtEmailSuffix", DbType.String, objCellCarrier.TxtEmailSuffix); db.AddInParameter(dbCommand, "Active", DbType.Boolean, objCellCarrier.Active); db.ExecuteNonQuery(dbCommand); objCellCarrier.ID = Int32.Parse(db.GetParameterValue(dbCommand, "ID").ToString()); }
static public void Save(CellCarrier objCellCarrier) { if (objCellCarrier.IsModified == true) { if (objCellCarrier.ID == 0) { Insert(objCellCarrier); } else { Update(objCellCarrier); } } }
static private void LoadCellCarrier(CellCarrier objCellCarrier, IDataReader _reader) { if (_reader.IsDBNull(0) != true) { objCellCarrier.ID = _reader.GetInt32(0); } if (_reader.IsDBNull(1) != true) { objCellCarrier.Name = _reader.GetString(1); } if (_reader.IsDBNull(2) != true) { objCellCarrier.TxtEmailSuffix = _reader.GetString(2); } if (_reader.IsDBNull(3) != true) { objCellCarrier.Active = _reader.GetBoolean(3); } }
static public List <CellCarrier> GetAll() { List <CellCarrier> objCellCarriers = new List <CellCarrier>(); Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL)) { while (reader.Read()) { CellCarrier objCellCarrier = new CellCarrier(); LoadCellCarrier(objCellCarrier, reader); objCellCarrier.IsModified = false; objCellCarriers.Add(objCellCarrier); } // always call Close when done reading. reader.Close(); return(objCellCarriers); } }
static public CellCarrier GetByID(int ID) { CellCarrier objCellCarrier = new CellCarrier(); string query = _selectViewSQL + " where ID = " + ID; Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, query)) { if (reader.Read()) { LoadCellCarrier(objCellCarrier, reader); // always call Close when done reading. reader.Close(); objCellCarrier.IsModified = false; return(objCellCarrier); } else { return(null); } } }