public string UpdateContact(ContactType pContact) { string _Err = String.Empty; TrackerDb _TDB = new TrackerDb(); _TDB.AddParams(pContact.CustomerTypeID, DbType.Int32); _TDB.AddParams(pContact.PredictionDisabled, DbType.Boolean); _TDB.AddWhereParams(pContact.CustomerID, DbType.Int64); // CONST_SQL_UPDATE _Err = _TDB.ExecuteNonQuerySQLWithParams(CONST_SQL_UPDATE, _TDB.Params, _TDB.WhereParams); _TDB.Close(); return(_Err); }
/// <summary> /// Update only Contact Type, usese pContact.CustType and pContact.CustID /// </summary> /// <param name="pContact">cus</param> /// <returns></returns> public string UpdateContactTypeIfInfoOnly(long pCustomerID, int pCustomerTypeID) { string _Err = String.Empty; TrackerDb _TDB = new TrackerDb(); _TDB.AddParams(pCustomerTypeID, DbType.Int32); _TDB.AddWhereParams(pCustomerID, DbType.Int64); _TDB.AddWhereParams(CustomerTypeTbl.CONST_INFO_ONLY, DbType.Int32); // CONST_SQL_UPDATE _Err = _TDB.ExecuteNonQuerySQLWithParams(CONST_SQL_UPDATETYPEONLY, _TDB.Params, _TDB.WhereParams); _TDB.Close(); return(_Err); }