public static bool Get(int userID, int clinicID) { user_preferences_clinics temp = new user_preferences_clinics(); DataTable matches = temp.Search(string.Format("SELECT * FROM user_preferences_clinics WHERE user_id = {0} and clinic_id = {1}", userID, clinicID)); if (matches.Rows.Count > 0) { return(Convert.ToBoolean(matches.Rows[0]["visible"])); } else { return(true); } }
public static void Set(int userID, int clinicID, bool value) { user_preferences_clinics temp = new user_preferences_clinics(); DataTable matches = temp.Search(string.Format("SELECT * FROM user_preferences_clinics WHERE user_id = {0} and clinic_id = {1}", userID, clinicID)); if (matches.Rows.Count > 0) { temp.ExecuteNonQuery(string.Format("UPDATE user_preferences_clinics SET visible = {0} WHERE user_id = {1} and clinic_id = {2}", Convert.ToInt32(value), userID, clinicID)); } else { temp.ExecuteNonQuery(string.Format("INSERT INTO user_preferences_clinics (user_id, clinic_id, visible) VALUES ({0}, {1}, {2})", userID, clinicID, Convert.ToInt32(value))); } }