public static void DeleteBarLogic(int?id)
{
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
var delbar = db.Bar.SingleOrDefault(x => x.BarId == id);
db.Bar.Remove(delbar);
db.SaveChanges();
}
}
public static Bar BarDetailsLogic(int?id)
{
Bar newbar = new Bar();
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
newbar = db.Bar.Include(x => x.Rating).Include(y => y.Review).SingleOrDefault(z => z.BarId == id);
}
return(newbar);
}
public static Bar SearchBarByItemLogic(string SearchBarByItem)
{
Bar SearchedBar = new Bar();
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
SearchedBar = db.Bar.Include(x => x.Rating).Include(y => y.Review).SingleOrDefault(x => x.BarName == SearchBarByItem);
}
return(SearchedBar);
}
public static List <Bar> SearchBarByCityLogic(string SearchCity)
{
List <Bar> listBarsCurrentCity = new List <Bar>();
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
listBarsCurrentCity = db.Bar.Include(x => x.Rating).Where(x => x.City.ToLower().Equals(SearchCity.ToLower())).ToList();
}
return(listBarsCurrentCity);
}
public static void RegistrationLogic(string LoginReg, string PasswordReg, string EmailReg)
{
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
db.User.Add(new User {
Username = LoginReg, Password = PasswordReg, Email = EmailReg
});
db.SaveChanges();
}
}
public static void AddBarLogic(Bar bar)
{
if (bar.BarName != "" && bar.Category != "" && bar.City != "")
{
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
db.Bar.Add(bar);
db.SaveChanges();
}
}
}
public static Bar AddReviewLogic(Review rev)
{
Bar barrev;
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
barrev = db.Bar.Include(x => x.Review).SingleOrDefault(x => x.BarId == rev.BarId);
var index = barrev.Review.Count + 1;
barrev.Review.SingleOrDefault().ReviewContent.Insert(index, rev.ReviewContent);
}
return(barrev);
}
public static Bar EditBarLogic(Bar bar)
{
Bar Fullbar = new Bar();
using (BarTrackerDBEntities db = new BarTrackerDBEntities())
{
Bar oldBar = db.Bar.SingleOrDefault(x => x.BarId == bar.BarId);
oldBar.BarName = bar.BarName;
oldBar.Category = bar.Category;
oldBar.City = bar.City;
db.SaveChanges();
Fullbar = db.Bar.Include(x => x.Rating).FirstOrDefault(x => x.BarId == bar.BarId);
}
return(Fullbar);
}
