static public void Save(RemoveMail objRemoveMail, Database db, DbTransaction trans, bool CommitTrans) { try { if (objRemoveMail.IsModified == true) { if (objRemoveMail.ID == 0) { Insert(objRemoveMail, db, trans); } else { Update(objRemoveMail, 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(RemoveMail objRemoveMail) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_RemoveMailDelete"); db.AddInParameter(dbCommand, "ID", DbType.Int32, objRemoveMail.ID); db.ExecuteNonQuery(dbCommand); }
static public void Save(RemoveMail objRemoveMail) { if (objRemoveMail.IsModified == true) { if (objRemoveMail.ID == 0) { Insert(objRemoveMail); } else { Update(objRemoveMail); } } }
public RemoveMail Copy() { RemoveMail _removeMail = new RemoveMail(); _removeMail.ID = _iD; _removeMail.IndexOnMailServer = _indexOnMailServer; _removeMail.MsgDateTime = _msgDateTime; _removeMail.ToAddress = _toAddress; _removeMail.FromAddress = _fromAddress; _removeMail.Subject = _subject; _removeMail.Body = _body; _removeMail.Processed = _processed; _removeMail.FoundAndRemoved = _foundAndRemoved; return(_removeMail); }
static public List <RemoveMail> GetSince(DateTime _date) { List <RemoveMail> objRemoveMails = new List <RemoveMail>(); Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL + " Where MsgDateTime > '" + _date.ToShortDateString() + "' order by MsgDateTime desc ")) { while (reader.Read()) { RemoveMail objRemoveMail = new RemoveMail(); LoadRemoveMail(objRemoveMail, reader); objRemoveMail.IsModified = false; objRemoveMails.Add(objRemoveMail); } // always call Close when done reading. reader.Close(); return(objRemoveMails); } }
static private void LoadRemoveMail(RemoveMail objRemoveMail, IDataReader _reader) { if (_reader.IsDBNull(0) != true) { objRemoveMail.ID = _reader.GetInt32(0); } if (_reader.IsDBNull(1) != true) { objRemoveMail.IndexOnMailServer = _reader.GetInt32(1); } if (_reader.IsDBNull(2) != true) { objRemoveMail.MsgDateTime = _reader.GetDateTime(2); } if (_reader.IsDBNull(3) != true) { objRemoveMail.ToAddress = _reader.GetString(3); } if (_reader.IsDBNull(4) != true) { objRemoveMail.FromAddress = _reader.GetString(4); } if (_reader.IsDBNull(5) != true) { objRemoveMail.Subject = _reader.GetString(5); } if (_reader.IsDBNull(6) != true) { objRemoveMail.Body = _reader.GetString(6); } if (_reader.IsDBNull(7) != true) { objRemoveMail.Processed = _reader.GetBoolean(7); } if (_reader.IsDBNull(8) != true) { objRemoveMail.FoundAndRemoved = _reader.GetBoolean(8); } }
static public RemoveMail GetByID(int ID) { RemoveMail objRemoveMail = new RemoveMail(); string query = _selectViewSQL + " where ID = " + ID; Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, query)) { if (reader.Read()) { LoadRemoveMail(objRemoveMail, reader); // always call Close when done reading. reader.Close(); objRemoveMail.IsModified = false; return(objRemoveMail); } else { return(null); } } }
static private void Update(RemoveMail objRemoveMail, Database db, DbTransaction trans) { //Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_RemoveMailUpdate"); db.AddInParameter(dbCommand, "ID", DbType.Int32, objRemoveMail.ID); db.AddInParameter(dbCommand, "IndexOnMailServer", DbType.Int32, objRemoveMail.IndexOnMailServer); if (objRemoveMail.MsgDateTime > DateTime.MinValue) { db.AddInParameter(dbCommand, "MsgDateTime", DbType.DateTime, objRemoveMail.MsgDateTime); } else { db.AddInParameter(dbCommand, "MsgDateTime", DbType.DateTime, Convert.DBNull); } db.AddInParameter(dbCommand, "ToAddress", DbType.String, objRemoveMail.ToAddress); db.AddInParameter(dbCommand, "FromAddress", DbType.String, objRemoveMail.FromAddress); db.AddInParameter(dbCommand, "Subject", DbType.String, objRemoveMail.Subject); db.AddInParameter(dbCommand, "Body", DbType.String, objRemoveMail.Body); db.AddInParameter(dbCommand, "Processed", DbType.Boolean, objRemoveMail.Processed); db.AddInParameter(dbCommand, "FoundAndRemoved", DbType.Boolean, objRemoveMail.FoundAndRemoved); db.ExecuteNonQuery(dbCommand, trans); }