public void AddFeature(enable_features mst)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string check = @"SELECT count(*) FROM enable_features where user_id = @user_id and features_id = @feature_id";
int cnt = con.Query <int>(check, new { user_id = mst.user_id, feature_id = mst.feature_id }).SingleOrDefault();
if (cnt == 0)
{
string query = @"INSERT INTO enable_features
(user_id,
features_id)
VALUES
(@user_id,
@feature_id);";
con.Execute(query, new
{
mst.user_id,
mst.feature_id
});
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteFeature(enable_features mst)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = @"DELETE FROM enable_features
WHERE
user_id = @user_id
AND features_id = @feature_id;";
con.Execute(query, new
{
mst.user_id,
mst.feature_id
});
}
}
catch (Exception ex)
{
throw ex;
}
}