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);
}
