static public void Save(DealerMailingList objDealerMailingList, Database db, DbTransaction trans, bool CommitTrans) { try { if (objDealerMailingList.IsModified == true) { if (objDealerMailingList.ID == 0) { Insert(objDealerMailingList, db, trans); } else { Update(objDealerMailingList, 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(DealerMailingList objDealerMailingList) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_DealerMailingListDelete"); db.AddInParameter(dbCommand, "ID", DbType.Int32, objDealerMailingList.ID); db.ExecuteNonQuery(dbCommand); }
static private void LoadDealerMailingList(DealerMailingList objDealerMailingList, IDataReader _reader) { if (_reader.IsDBNull(0) != true) { objDealerMailingList.ID = _reader.GetInt32(0); } if (_reader.IsDBNull(1) != true) { objDealerMailingList.DealerID = _reader.GetInt32(1); } if (_reader.IsDBNull(2) != true) { objDealerMailingList.CreationDate = _reader.GetDateTime(2); } if (_reader.IsDBNull(3) != true) { objDealerMailingList.StartFilterDate = _reader.GetDateTime(3); } if (_reader.IsDBNull(4) != true) { objDealerMailingList.EndFilterDate = _reader.GetDateTime(4); } if (_reader.IsDBNull(5) != true) { objDealerMailingList.FiledCasesOnly = _reader.GetBoolean(5); } if (_reader.IsDBNull(6) != true) { objDealerMailingList.NumberCases = _reader.GetInt32(6); } if (_reader.IsDBNull(7) != true) { objDealerMailingList.MarkedAsSold = _reader.GetBoolean(7); } if (_reader.IsDBNull(8) != true) { objDealerMailingList.Description = _reader.GetString(8); } if (_reader.IsDBNull(9) != true) { objDealerMailingList.TemplateFilePath = _reader.GetString(9); } if (_reader.IsDBNull(10) != true) { objDealerMailingList.CsvFilePath = _reader.GetString(10); } if (_reader.IsDBNull(11) != true) { objDealerMailingList.MailMergeFilePath = _reader.GetString(11); } if (_reader.IsDBNull(12) != true) { objDealerMailingList.TrackingLetterRecieved = _reader.GetBoolean(12); } }
static public void Save(DealerMailingList objDealerMailingList) { if (objDealerMailingList.IsModified == true) { if (objDealerMailingList.ID == 0) { Insert(objDealerMailingList); } else { Update(objDealerMailingList); } } }
static private void Insert(DealerMailingList objDealerMailingList) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_DealerMailingListInsert"); db.AddOutParameter(dbCommand, "ID", DbType.Int32, 4); if (objDealerMailingList.DealerID > 0) { db.AddInParameter(dbCommand, "DealerID", DbType.Int32, objDealerMailingList.DealerID); } else { db.AddInParameter(dbCommand, "DealerID", DbType.Int32, Convert.DBNull); } if (objDealerMailingList.CreationDate > DateTime.MinValue) { db.AddInParameter(dbCommand, "CreationDate", DbType.DateTime, objDealerMailingList.CreationDate); } else { db.AddInParameter(dbCommand, "CreationDate", DbType.DateTime, Convert.DBNull); } if (objDealerMailingList.StartFilterDate > DateTime.MinValue) { db.AddInParameter(dbCommand, "StartFilterDate", DbType.DateTime, objDealerMailingList.StartFilterDate); } else { db.AddInParameter(dbCommand, "StartFilterDate", DbType.DateTime, Convert.DBNull); } if (objDealerMailingList.EndFilterDate > DateTime.MinValue) { db.AddInParameter(dbCommand, "EndFilterDate", DbType.DateTime, objDealerMailingList.EndFilterDate); } else { db.AddInParameter(dbCommand, "EndFilterDate", DbType.DateTime, Convert.DBNull); } db.AddInParameter(dbCommand, "FiledCasesOnly", DbType.Boolean, objDealerMailingList.FiledCasesOnly); db.AddInParameter(dbCommand, "NumberCases", DbType.Int32, objDealerMailingList.NumberCases); db.AddInParameter(dbCommand, "MarkedAsSold", DbType.Boolean, objDealerMailingList.MarkedAsSold); db.AddInParameter(dbCommand, "Description", DbType.String, objDealerMailingList.Description); db.AddInParameter(dbCommand, "TemplateFilePath", DbType.String, objDealerMailingList.TemplateFilePath); db.AddInParameter(dbCommand, "CsvFilePath", DbType.String, objDealerMailingList.CsvFilePath); db.AddInParameter(dbCommand, "MailMergeFilePath", DbType.String, objDealerMailingList.MailMergeFilePath); db.AddInParameter(dbCommand, "TrackingLetterRecieved", DbType.Boolean, objDealerMailingList.TrackingLetterRecieved); db.ExecuteNonQuery(dbCommand); objDealerMailingList.ID = Int32.Parse(db.GetParameterValue(dbCommand, "ID").ToString()); }
public DealerMailingList Copy() { DealerMailingList _dealerMailingList = new DealerMailingList(); _dealerMailingList.ID = _iD; _dealerMailingList.DealerID = _dealerID; _dealerMailingList.CreationDate = _creationDate; _dealerMailingList.StartFilterDate = _startFilterDate; _dealerMailingList.EndFilterDate = _endFilterDate; _dealerMailingList.FiledCasesOnly = _filedCasesOnly; _dealerMailingList.NumberCases = _numberCases; _dealerMailingList.MarkedAsSold = _markedAsSold; _dealerMailingList.Description = _description; _dealerMailingList.TemplateFilePath = _templateFilePath; _dealerMailingList.CsvFilePath = _csvFilePath; _dealerMailingList.MailMergeFilePath = _mailMergeFilePath; return(_dealerMailingList); }
static public List <DealerMailingList> GetAll() { List <DealerMailingList> objDealerMailingLists = new List <DealerMailingList>(); Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL)) { while (reader.Read()) { DealerMailingList objDealerMailingList = new DealerMailingList(); LoadDealerMailingList(objDealerMailingList, reader); objDealerMailingList.IsModified = false; objDealerMailingLists.Add(objDealerMailingList); } // always call Close when done reading. reader.Close(); return(objDealerMailingLists); } }
static public DealerMailingList GetByID(int ID) { DealerMailingList objDealerMailingList = new DealerMailingList(); string query = _selectViewSQL + " where ID = " + ID; Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, query)) { if (reader.Read()) { LoadDealerMailingList(objDealerMailingList, reader); // always call Close when done reading. reader.Close(); objDealerMailingList.IsModified = false; return(objDealerMailingList); } else { return(null); } } }
public MailMergeHelper(Dealer dealer, DealerMailingList dealerMailingList) { _dealer = dealer; _dealerMailingList = dealerMailingList; }