public NCOAImport Copy() { NCOAImport _nCOAImport = new NCOAImport(); _nCOAImport.CASEID = _cASEID; _nCOAImport.INPUTFIRST = _iNPUTFIRST; _nCOAImport.INPUTMIDDLE = _iNPUTMIDDLE; _nCOAImport.INPUTLAST = _iNPUTLAST; _nCOAImport.INPUTSUFFIX = _iNPUTSUFFIX; _nCOAImport.ADDRESS1 = _aDDRESS1; _nCOAImport.ADDRESS2 = _aDDRESS2; _nCOAImport.CITY = _cITY; _nCOAImport.STATE = _sTATE; _nCOAImport.ZIP = _zIP; _nCOAImport.NEWADDRESS_FLAG = _nEWADDRESS_FLAG; _nCOAImport.MRT_FLAG = _mRT_FLAG; _nCOAImport.MAILTO1_ADDRESS = _mAILTO1_ADDRESS; _nCOAImport.MAILTO2_ADDRESS = _mAILTO2_ADDRESS; _nCOAImport.MAILTO_CITY = _mAILTO_CITY; _nCOAImport.MAILTO_STATE = _mAILTO_STATE; _nCOAImport.MAILTO_ZIP = _mAILTO_ZIP; _nCOAImport.MAIL_ZIP4 = _mAIL_ZIP4; _nCOAImport.MAILTO_DPBC = _mAILTO_DPBC; _nCOAImport.MAIL_CARRIER_ROUTE = _mAIL_CARRIER_ROUTE; _nCOAImport.DPVCONFIRMATION_INDICATOR = _dPVCONFIRMATION_INDICATOR; _nCOAImport.NCOA_MATCH_TYPE = _nCOA_MATCH_TYPE; _nCOAImport.NCOA_MOVE_DATE = _nCOA_MOVE_DATE; _nCOAImport.DELIVERY_CODE = _dELIVERY_CODE; _nCOAImport.ZIP4_UPDATES = _zIP4_UPDATES; _nCOAImport.MAILABILITY_SCORE = _mAILABILITY_SCORE; return(_nCOAImport); }
static public void Delete(NCOAImport objNCOAImport) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_NCOAImportDelete"); db.AddInParameter(dbCommand, "CASEID", DbType.Int32, objNCOAImport.CASEID); db.ExecuteNonQuery(dbCommand); }
static public void Save(NCOAImport objNCOAImport) { if (objNCOAImport.IsModified == true) { //if (objNCOAImport.CASEID == 0 ) //{ Insert(objNCOAImport); //} //else //{ // Update(objNCOAImport); //} } }
static private void Insert(NCOAImport objNCOAImport) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_NCOAImportInsert"); if (objNCOAImport.CASEID > 0) { db.AddInParameter(dbCommand, "CASEID", DbType.Int32, objNCOAImport.CASEID); } else { db.AddInParameter(dbCommand, "CASEID", DbType.Int32, Convert.DBNull); } db.AddInParameter(dbCommand, "INPUTFIRST", DbType.String, objNCOAImport.INPUTFIRST); db.AddInParameter(dbCommand, "INPUTMIDDLE", DbType.String, objNCOAImport.INPUTMIDDLE); //if (objNCOAImport.INPUTMIDDLE > 0) //{ // db.AddInParameter(dbCommand, "INPUTMIDDLE", DbType.Int32, objNCOAImport.INPUTMIDDLE); //} //else //{ // db.AddInParameter(dbCommand, "INPUTMIDDLE", DbType.Int32, Convert.DBNull); //} db.AddInParameter(dbCommand, "INPUTLAST", DbType.String, objNCOAImport.INPUTLAST); db.AddInParameter(dbCommand, "INPUTSUFFIX", DbType.String, objNCOAImport.INPUTSUFFIX); db.AddInParameter(dbCommand, "ADDRESS1", DbType.String, objNCOAImport.ADDRESS1); db.AddInParameter(dbCommand, "ADDRESS2", DbType.String, objNCOAImport.ADDRESS2); db.AddInParameter(dbCommand, "CITY", DbType.String, objNCOAImport.CITY); db.AddInParameter(dbCommand, "STATE", DbType.String, objNCOAImport.STATE); db.AddInParameter(dbCommand, "ZIP", DbType.String, objNCOAImport.ZIP); db.AddInParameter(dbCommand, "NEWADDRESS_FLAG", DbType.String, objNCOAImport.NEWADDRESS_FLAG); db.AddInParameter(dbCommand, "MRT_FLAG", DbType.String, objNCOAImport.MRT_FLAG); db.AddInParameter(dbCommand, "MAILTO1_ADDRESS", DbType.String, objNCOAImport.MAILTO1_ADDRESS); db.AddInParameter(dbCommand, "MAILTO2_ADDRESS", DbType.String, objNCOAImport.MAILTO2_ADDRESS); db.AddInParameter(dbCommand, "MAILTO_CITY", DbType.String, objNCOAImport.MAILTO_CITY); db.AddInParameter(dbCommand, "MAILTO_STATE", DbType.String, objNCOAImport.MAILTO_STATE); db.AddInParameter(dbCommand, "MAILTO_ZIP", DbType.String, objNCOAImport.MAILTO_ZIP); db.AddInParameter(dbCommand, "MAIL_ZIP4", DbType.String, objNCOAImport.MAIL_ZIP4); db.AddInParameter(dbCommand, "MAILTO_DPBC", DbType.String, objNCOAImport.MAILTO_DPBC); db.AddInParameter(dbCommand, "MAIL_CARRIER_ROUTE", DbType.String, objNCOAImport.MAIL_CARRIER_ROUTE); db.AddInParameter(dbCommand, "DPVCONFIRMATION_INDICATOR", DbType.String, objNCOAImport.DPVCONFIRMATION_INDICATOR); db.AddInParameter(dbCommand, "NCOA_MATCH_TYPE", DbType.String, objNCOAImport.NCOA_MATCH_TYPE); db.AddInParameter(dbCommand, "NCOA_MOVE_DATE", DbType.String, objNCOAImport.NCOA_MOVE_DATE); db.AddInParameter(dbCommand, "DELIVERY_CODE", DbType.String, objNCOAImport.DELIVERY_CODE); db.AddInParameter(dbCommand, "ZIP4_UPDATES", DbType.String, objNCOAImport.ZIP4_UPDATES); db.AddInParameter(dbCommand, "MAILABILITY_SCORE", DbType.String, objNCOAImport.MAILABILITY_SCORE); db.ExecuteNonQuery(dbCommand); objNCOAImport.CASEID = Int32.Parse(db.GetParameterValue(dbCommand, "CASEID").ToString()); }
static public List <NCOAImport> GetAll() { List <NCOAImport> objNCOAImports = new List <NCOAImport>(); Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL)) { while (reader.Read()) { NCOAImport objNCOAImport = new NCOAImport(); LoadNCOAImport(objNCOAImport, reader); objNCOAImport.IsModified = false; objNCOAImports.Add(objNCOAImport); } // always call Close when done reading. reader.Close(); return(objNCOAImports); } }
static public NCOAImport GetByID(int CASEID) { NCOAImport objNCOAImport = new NCOAImport(); string query = _selectViewSQL + " where CASEID = " + CASEID; Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, query)) { if (reader.Read()) { LoadNCOAImport(objNCOAImport, reader); // always call Close when done reading. reader.Close(); objNCOAImport.IsModified = false; return(objNCOAImport); } else { return(null); } } }
static private void LoadNCOAImport(NCOAImport objNCOAImport, IDataReader _reader) { if (_reader.IsDBNull(0) != true) { objNCOAImport.CASEID = _reader.GetInt32(0); } if (_reader.IsDBNull(1) != true) { objNCOAImport.INPUTFIRST = _reader.GetString(1); } if (_reader.IsDBNull(2) != true) { objNCOAImport.INPUTMIDDLE = _reader.GetString(2); } if (_reader.IsDBNull(3) != true) { objNCOAImport.INPUTLAST = _reader.GetString(3); } if (_reader.IsDBNull(4) != true) { objNCOAImport.INPUTSUFFIX = _reader.GetString(4); } if (_reader.IsDBNull(5) != true) { objNCOAImport.ADDRESS1 = _reader.GetString(5); } if (_reader.IsDBNull(6) != true) { objNCOAImport.ADDRESS2 = _reader.GetString(6); } if (_reader.IsDBNull(7) != true) { objNCOAImport.CITY = _reader.GetString(7); } if (_reader.IsDBNull(8) != true) { objNCOAImport.STATE = _reader.GetString(8); } if (_reader.IsDBNull(9) != true) { objNCOAImport.ZIP = _reader.GetString(9); } if (_reader.IsDBNull(10) != true) { objNCOAImport.NEWADDRESS_FLAG = _reader.GetString(10); } if (_reader.IsDBNull(11) != true) { objNCOAImport.MRT_FLAG = _reader.GetString(11); } if (_reader.IsDBNull(12) != true) { objNCOAImport.MAILTO1_ADDRESS = _reader.GetString(12); } if (_reader.IsDBNull(13) != true) { objNCOAImport.MAILTO2_ADDRESS = _reader.GetString(13); } if (_reader.IsDBNull(14) != true) { objNCOAImport.MAILTO_CITY = _reader.GetString(14); } if (_reader.IsDBNull(15) != true) { objNCOAImport.MAILTO_STATE = _reader.GetString(15); } if (_reader.IsDBNull(16) != true) { objNCOAImport.MAILTO_ZIP = _reader.GetString(16); } if (_reader.IsDBNull(17) != true) { objNCOAImport.MAIL_ZIP4 = _reader.GetString(17); } if (_reader.IsDBNull(18) != true) { objNCOAImport.MAILTO_DPBC = _reader.GetString(18); } if (_reader.IsDBNull(19) != true) { objNCOAImport.MAIL_CARRIER_ROUTE = _reader.GetString(19); } if (_reader.IsDBNull(20) != true) { objNCOAImport.DPVCONFIRMATION_INDICATOR = _reader.GetString(20); } if (_reader.IsDBNull(21) != true) { objNCOAImport.NCOA_MATCH_TYPE = _reader.GetString(21); } if (_reader.IsDBNull(22) != true) { objNCOAImport.NCOA_MOVE_DATE = _reader.GetString(22); } if (_reader.IsDBNull(23) != true) { objNCOAImport.DELIVERY_CODE = _reader.GetString(23); } if (_reader.IsDBNull(24) != true) { objNCOAImport.ZIP4_UPDATES = _reader.GetString(24); } if (_reader.IsDBNull(25) != true) { objNCOAImport.MAILABILITY_SCORE = _reader.GetString(25); } }