public static object ActivateRecordByLink(string TableName, string ColumnName, string Value) { // ACTIVATE RECORD FROM TABLE , USING TABLE NAME , COLUMN NAME (MOSTALLY LINK) AND VALUE OF THAT COLUMN MySqlParameter[] parameters = { new MySqlParameter("TableName", TableName), new MySqlParameter("FieldName", ColumnName), new MySqlParameter("FieldValue", Value) }; return(DatabaseConnectionSqlServer.ExecuteNonQuery("ActivateRecordByLink", parameters)); }
public static object DeleteRecordByLink(string TableName, string ColumnName, string Value) { // DELETE RECORD FROM TABLE , USING TABLE NAME , COLUMN NAME (MOSTALLY LINK) AND VALUE OF THAT COLUMN MySqlParameter[] parameters = { new MySqlParameter("TableName", TableName), new MySqlParameter("FieldName", ColumnName), new MySqlParameter("FieldValue", Value) }; // DeactivateRecordByLink is a stored procedure name and Above Parameter list for the stored procedure return(DatabaseConnectionSqlServer.ExecuteNonQuery("DeactivateRecordByLink", parameters)); }