static public List <DealerMailingListCase> GetForMailingList(int DealerMailingListID, bool IncludeMarkedAsSoldAndRemoves) { List <DealerMailingListCase> objDealerMailingListCases = new List <DealerMailingListCase>(); Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); string _query = _selectViewSQL + " where DealerMailingListID = " + DealerMailingListID; if (IncludeMarkedAsSoldAndRemoves == false) { _query += " and DoNotSend = 0 and Sold=0 "; } _query += " order by LastName asc "; using (IDataReader reader = db.ExecuteReader(CommandType.Text, _query)) { while (reader.Read()) { DealerMailingListCase objDealerMailingListCase = new DealerMailingListCase(); LoadDealerMailingListCase(objDealerMailingListCase, reader); objDealerMailingListCase.IsModified = false; objDealerMailingListCases.Add(objDealerMailingListCase); } // always call Close when done reading. reader.Close(); return(objDealerMailingListCases); } }
static public void Delete(DealerMailingListCase objDealerMailingListCase) { Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_DealerMailingListCaseDelete"); db.AddInParameter(dbCommand, "DealerMailingListID", DbType.Int32, objDealerMailingListCase.DealerMailingListID); db.AddInParameter(dbCommand, "BankruptcyCaseID", DbType.Int32, objDealerMailingListCase.BankruptcyCaseID); db.ExecuteNonQuery(dbCommand); }
static public void Insert(DealerMailingListCase objDealerMailingListCase) { Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_DealerMailingListCaseInsert"); if (objDealerMailingListCase.DealerMailingListID > 0) { db.AddInParameter(dbCommand, "DealerMailingListID", DbType.Int32, objDealerMailingListCase.DealerMailingListID); } else { db.AddInParameter(dbCommand, "DealerMailingListID", DbType.Int32, Convert.DBNull); } if (objDealerMailingListCase.BankruptcyCaseID > 0) { db.AddInParameter(dbCommand, "BankruptcyCaseID", DbType.Int32, objDealerMailingListCase.BankruptcyCaseID); } else { db.AddInParameter(dbCommand, "BankruptcyCaseID", DbType.Int32, Convert.DBNull); } if (objDealerMailingListCase.DealerID > 0) { db.AddInParameter(dbCommand, "DealerID", DbType.Int32, objDealerMailingListCase.DealerID); } else { db.AddInParameter(dbCommand, "DealerID", DbType.Int32, Convert.DBNull); } db.AddInParameter(dbCommand, "Sold", DbType.Boolean, objDealerMailingListCase.Sold); if (objDealerMailingListCase.SoldDate > DateTime.MinValue) { db.AddInParameter(dbCommand, "SoldDate", DbType.DateTime, objDealerMailingListCase.SoldDate); } else { db.AddInParameter(dbCommand, "SoldDate", DbType.DateTime, Convert.DBNull); } db.AddInParameter(dbCommand, "GrossProfit", DbType.Decimal, objDealerMailingListCase.GrossProfit); db.AddInParameter(dbCommand, "DoNotSend", DbType.Boolean, objDealerMailingListCase.DoNotSend); db.ExecuteNonQuery(dbCommand); }
static public List <DealerMailingListCase> GetAll() { List <DealerMailingListCase> objDealerMailingListCases = new List <DealerMailingListCase>(); Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL)) { while (reader.Read()) { DealerMailingListCase objDealerMailingListCase = new DealerMailingListCase(); LoadDealerMailingListCase(objDealerMailingListCase, reader); objDealerMailingListCase.IsModified = false; objDealerMailingListCases.Add(objDealerMailingListCase); } // always call Close when done reading. reader.Close(); return(objDealerMailingListCases); } }
public DealerMailingListCase Copy() { DealerMailingListCase _dealerMailingListCase = new DealerMailingListCase(); _dealerMailingListCase.DealerMailingListID = _dealerMailingListID; _dealerMailingListCase.BankruptcyCaseID = _bankruptcyCaseID; _dealerMailingListCase.DealerID = _dealerID; _dealerMailingListCase.Sold = _sold; _dealerMailingListCase.SoldDate = _soldDate; _dealerMailingListCase.GrossProfit = _grossProfit; _dealerMailingListCase.DoNotSend = _doNotSend; _dealerMailingListCase.FirstName = _firstName; _dealerMailingListCase.LastName = _lastName; _dealerMailingListCase.AddrLine1 = _addrLine1; _dealerMailingListCase.AddrLine2 = _addrLine2; _dealerMailingListCase.City = _city; _dealerMailingListCase.StateCode = _stateCode; _dealerMailingListCase.PostalCode = _postalCode; _dealerMailingListCase.DischargeDate = _dischargeDate; return(_dealerMailingListCase); }
static public List <DealerMailingListCase> GetByDealerSalesReport(int DealerID, DateTime StartDate, DateTime EndDate) { List <DealerMailingListCase> objDealerMailingListCases = new List <DealerMailingListCase>(); string query = _selectViewSQL + " where DealerID = " + DealerID + " and SoldDate between '" + StartDate.ToShortDateString() + "' and '" + EndDate.ToShortDateString() + "' order by SoldDate asc "; Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, query)) { while (reader.Read()) { DealerMailingListCase objDealerMailingListCase = new DealerMailingListCase(); LoadDealerMailingListCase(objDealerMailingListCase, reader); objDealerMailingListCase.IsModified = false; objDealerMailingListCases.Add(objDealerMailingListCase); } // always call Close when done reading. reader.Close(); return(objDealerMailingListCases); } }
static public DealerMailingListCase GetByDealerAndCaseID(int BankruptcyCaseID, int DealerID) { DealerMailingListCase objDealerMailingListCase = new DealerMailingListCase(); string query = _selectViewSQL + " where BankruptcyCaseID = " + BankruptcyCaseID + " and DealerID = " + DealerID; Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, query)) { if (reader.Read()) { LoadDealerMailingListCase(objDealerMailingListCase, reader); // always call Close when done reading. reader.Close(); objDealerMailingListCase.IsModified = false; return(objDealerMailingListCase); } else { return(null); } } }
static private void LoadDealerMailingListCase(DealerMailingListCase objDealerMailingListCase, IDataReader _reader) { if (_reader.IsDBNull(0) != true) { objDealerMailingListCase.DealerMailingListID = _reader.GetInt32(0); } if (_reader.IsDBNull(1) != true) { objDealerMailingListCase.BankruptcyCaseID = _reader.GetInt32(1); } if (_reader.IsDBNull(2) != true) { objDealerMailingListCase.DealerID = _reader.GetInt32(2); } if (_reader.IsDBNull(3) != true) { objDealerMailingListCase.Sold = _reader.GetBoolean(3); } if (_reader.IsDBNull(4) != true) { objDealerMailingListCase.SoldDate = _reader.GetDateTime(4); } if (_reader.IsDBNull(5) != true) { objDealerMailingListCase.GrossProfit = _reader.GetDecimal(5); } if (_reader.IsDBNull(6) != true) { objDealerMailingListCase.DoNotSend = _reader.GetBoolean(6); } if (_reader.IsDBNull(7) != true) { objDealerMailingListCase.FirstName = _reader.GetString(7); } if (_reader.IsDBNull(8) != true) { objDealerMailingListCase.LastName = _reader.GetString(8); } if (_reader.IsDBNull(9) != true) { objDealerMailingListCase.AddrLine1 = _reader.GetString(9); } if (_reader.IsDBNull(10) != true) { objDealerMailingListCase.AddrLine2 = _reader.GetString(10); } if (_reader.IsDBNull(11) != true) { objDealerMailingListCase.City = _reader.GetString(11); } if (_reader.IsDBNull(12) != true) { objDealerMailingListCase.StateCode = _reader.GetString(12); } if (_reader.IsDBNull(13) != true) { objDealerMailingListCase.PostalCode = _reader.GetInt32(13); } if (_reader.IsDBNull(14) != true) { objDealerMailingListCase.DischargeDate = _reader.GetDateTime(14); } }
static public List <DealerMailingListCase> GetFiltered(int DealerID, string FirstName, string LastName, string ZipCode, int DealerMailingListID, bool DoNotSend, bool Sold, DateTime?StartDischargeDate, DateTime?EndDischargeDate) { List <DealerMailingListCase> objDealerMailingListCases = new List <DealerMailingListCase>(); Database db = DatabaseFactory.CreateDatabase("BKLeadsOnline"); string _query = _selectViewSQL + " where "; if (FirstName.Length > 0) { _query += " FirstName like '" + FirstName + "%' and "; } if (LastName.Length > 0) { _query += " LastName like '" + LastName + "%' and "; } if (DealerID > 0) { _query += " DealerID = " + DealerID + " and "; } if (DealerMailingListID > 0) { _query += " DealerMailingListID = " + DealerMailingListID + " and "; } if (DoNotSend == true) { _query += " DoNotSend = 1 and "; } if (Sold == true) { _query += " Sold = 1 and "; } if (ZipCode.Length > 0) { _query += " PostalCode = " + ZipCode + " and "; } if (StartDischargeDate != null) { _query += " DischargeDate > '" + DateTime.Parse(StartDischargeDate.ToString()).ToShortDateString() + "' and "; } if (EndDischargeDate != null) { _query += " DischargeDate < '" + DateTime.Parse(EndDischargeDate.ToString()).ToShortDateString() + "' and "; } _query = _query + " 1 = 1 ORDER BY LastName ASC"; using (IDataReader reader = db.ExecuteReader(CommandType.Text, _query)) { while (reader.Read()) { DealerMailingListCase objDealerMailingListCase = new DealerMailingListCase(); LoadDealerMailingListCase(objDealerMailingListCase, reader); objDealerMailingListCase.IsModified = false; objDealerMailingListCases.Add(objDealerMailingListCase); } // always call Close when done reading. reader.Close(); return(objDealerMailingListCases); } }