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