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 string DeleteAllSubscriptions(int user)
{
string answer = "Ваш список подписок очищен";
try
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var result = concertDB.tblSubscriptions.Where(b => b.user_id == user);
if (result != null)
{
foreach (var item in result)
{
concertDB.tblSubscriptions.Remove(item);
}
concertDB.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(answer);
}
public IQueryable <tblSubscriptions> DeleteSubscription(int user, int group_id)
{
GroupActions groupActions = new GroupActions();
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var group = groupActions.FindGroupById(group_id);
if (group == null)
{
return(null);
}
var Result = concertDB.tblSubscriptions.Where(b => (b.user_id == user) && (b.group_id == group.group_id));
if (Result != null)
{
foreach (var item in Result)
{
concertDB.tblSubscriptions.Remove(item);
}
concertDB.SaveChanges();
}
return(Result);
}
public void UpdateGroup(int id, string name)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
tblGroups group = concertDB.tblGroups.Where(b => b.group_id == id).First();
group.group_name = name;
concertDB.SaveChanges();
}
public void InsertSubscription(int user, int group)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var sub = new tblSubscriptions();
var subs = SelectAllSubscriptions();
sub.group_id = group;
sub.user_id = user;
sub.subscription_id = subs.Count() + 1;
concertDB.tblSubscriptions.Add(sub);
concertDB.SaveChanges();
}
public bool ContainsGroup(string name)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var result = concertDB.tblGroups.Where(b => b.group_name == name);
if (result.Count() > 0)
{
return(true);
}
else
{
return(false);
}
}
public tblConcerts FindGroupIdByConcert(int id)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var result = concertDB.tblConcerts.Where(b => b.concert_id == id);
if (result.Count() > 0)
{
return(result.First());
}
else
{
return(null);
}
}
public tblGroups FindGroupByName(string name)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var result = concertDB.tblGroups.Where(b => b.group_name == name);
if (result.Count() > 0)
{
return(result.First());
}
else
{
return(null);
}
}
public tblUsers FindUser(int id)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var result = concertDB.tblUsers.Where(b => b.user_id == id);
if (result.Count() > 0)
{
return(result.First());
}
else
{
return(null);
}
}
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);
}
}
public void InsertConcerts(Concert concert, int group)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var conc = new tblConcerts();
conc.concert_id = group + 1;
conc.group_id = group;
conc.concert_city = "Test location";
conc.concert_date = System.DateTime.Now;
conc.concert_link = "no url";
conc.concert_place = "place location";
conc.concert_title = "Test ";
concertDB.tblConcerts.Add(conc);
concertDB.SaveChanges();
}
public void InsertConc(tblConcerts concert, int group)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var conc = new tblConcerts();
conc.concert_id = concert.concert_id;
conc.group_id = group;
conc.concert_city = concert.concert_city;
conc.concert_date = concert.concert_date;
conc.concert_link = concert.concert_link;
conc.concert_place = concert.concert_place;
conc.concert_title = concert.concert_title;
concertDB.tblConcerts.Add(conc);
concertDB.SaveChanges();
}
public void InsertConcert(Concert concert, int group)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
var conc = new tblConcerts();
conc.concert_id = concert.ID;
conc.group_id = group;
conc.concert_city = concert.Location;
conc.concert_date = concert.Date;
conc.concert_link = concert.Link;
conc.concert_place = concert.Place;
conc.concert_title = concert.Title;
concertDB.tblConcerts.Add(conc);
concertDB.SaveChanges();
}
public IList <tblSubscriptions> SelectSubscriptions(int user)
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
return(concertDB.tblSubscriptions.Where(b => b.user_id == user).ToList());
}
public DbSet <tblConcerts> SelectAllConcerts()
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
return(concertDB.tblConcerts);
}
public DbSet <tblSubscriptions> SelectAllSubscriptions()
{
ConcertNotifierEntities1 concertDB = new ConcertNotifierEntities1();
return(concertDB.tblSubscriptions);
}
public GroupActions(ConcertNotifierEntities1 context)
{
concertDB = context;
}