public string DeleteSubscription(int user, string name) { GroupActions groupActions = new GroupActions(); ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1(); var group = groupActions.FindGroupByName(name); string answer = null; var result = concertDB.tblSubscriptions.Where(b => (b.user_id == user) && (b.group_id == group.group_id)); try { if (result.ToList().Count() > 0) { foreach (var item in result) { concertDB.tblSubscriptions.Remove(item); } } concertDB.SaveChanges(); answer = "Исполнитель успешно удален"; } catch (Exception e) { answer = "У вас нет подписки с таким именем"; Console.WriteLine(e); return(answer); } return(answer); }
public bool ContainsSubscription(string name, int user) { ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1(); GroupActions groupActions = new GroupActions(); var group = groupActions.FindGroupByName(name); var result = concertDB.tblSubscriptions.Where(b => (b.group_id == group.group_id) && (b.user_id == user)); if (result.Count() > 0) { return(true); } else { return(false); } }