public void Write(RestaurantInformation objectToList, string fileName)
{
SocialTapContext db = new SocialTapContext();
db.RestaurantInformationTable.Add(objectToList);
db.SaveChanges();
}
public void Write(Drink objectToList)
{
SocialTapContext db = new SocialTapContext();
db.DrinkInfo.Add(objectToList);
db.SaveChanges();
}
public List <New> Read(string time = "Today")
{
DateTime date = new DateTime();
switch (time)
{
case "Today":
date = DateTime.Today;
break;
case "Yesterday":
date = DateTime.Today.AddDays(-1);
break;
default:
date = DateTime.Today;
break;
}
SocialTapContext db = new SocialTapContext();
var allNews = from news in db.NewTable
where news.Date == date
select news;
List <New> newList = allNews.ToList();
return(newList);
}
public IHttpActionResult Post(Restaurant restaurant)
{
SocialTapContext context = new SocialTapContext();
context.Restaurants.Add(restaurant);
context.SaveChanges();
return(Ok());
}
public List <RestaurantInformation> Read(String fileName)
{
SocialTapContext db = new SocialTapContext();
var restaurants = from restaurant in db.RestaurantInformationTable
select restaurant;
List <RestaurantInformation> restaurantList = restaurants.ToList();
return(restaurantList);
}
public List <Drink> Read()
{
SocialTapContext db = new SocialTapContext();
var drinks = from drink in db.DrinkInfo
select drink;
List <Drink> drinkList = drinks.ToList();
return(drinkList);
}
public IHttpActionResult Get()
{
SocialTapContext context = new SocialTapContext();
Scan sc = new Scan();
sc.Date = DateTime.Today.AddDays(-15);
sc.Drink = "Alcohol";
sc.Percentage = 33;
sc.Millimeters = 870;
sc.Price = 5.80;
var d = context.Restaurants.ToList();
sc.Restaurant = d.ElementAt(0);
//REIKIA DABARTINIO USERIO
var list = context.Users.ToList();
sc.SocialTapUser = list.ElementAt(0);
//**************************************
context.Scans.Add(sc);
context.SaveChanges();
var result = _rep.GetAll();
return(Ok(result));
}
