/// <summary>
/// Delete user from list
/// </summary>
/// <returns></returns>
public static int DeleteUser(int userID)
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
SQLParamList sqlParams = new SQLParamList();
SqlParameter output;
SqlParameter rowsUpdated;
sqlParams.Add("@UserID", userID);
sqlParams.Add("@ClientID", Config.clientId);
sqlParams.AddOutputParam("@OutputCode", 4, out output);
sqlParams.AddOutputParam("@RowCount", 4, out rowsUpdated);
DataTable dt = sql.ExecStoredProcedureDataTable("spCOM_DeleteUser", sqlParams);
if (!sql.HasError)
{
return(Convert.ToInt32(dt.Rows[0]["AffectedRows"]));
}
return(0);
}