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