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