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