public IActionResult Create(CoffeeItem item) { _context.CoffeeItems.Add(item); _context.SaveChanges(); return(CreatedAtRoute("GetCoffee", new { id = item.Id }, item)); }
public IActionResult AddEditBook(long?id, BookViewModel model) { try { if (ModelState.IsValid) { bool isNew = !id.HasValue; Book book = isNew ? new Book { AddedDate = DateTime.UtcNow } : context.Set <Book>().SingleOrDefault(s => s.Id == id.Value); book.Name = model.Name; book.ISBN = model.ISBN; book.Author = model.Author; book.Publisher = model.Publisher; if (isNew) { context.Add(book); } context.SaveChanges(); } } catch (Exception ex) { throw ex; } return(RedirectToAction("Index")); }
public IHttpActionResult PutProduct(long id, Product product) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product.Id) { return(BadRequest()); } db.Entry(product).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProductExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,EmploymentDate")] MasterRoaster masterRoaster) { if (ModelState.IsValid) { db.MasterRoasters.Add(masterRoaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(masterRoaster)); }
public OrderDetail Create(OrderDetail model) { var newOd = new OrderDetail() { OrderDetailId = model.OrderDetailId, OrderId = model.OrderId }; context.OrderDetails.Add(newOd); context.SaveChanges(); return(model); }
public ProductOrderDetail Create(ProductOrderDetail model) { var newPod = new ProductOrderDetail() { ProductId = model.ProductId, OrderDetailId = model.OrderDetailId, Count = model.Count, ProductOrderDetailId = model.ProductOrderDetailId }; context.ProductOrderDetails.Add(newPod); context.SaveChanges(); return(model); }
public Product Create(Product model) { var newPt = new Product() { ProductId = model.ProductId, Name = model.Name, AvatarPath = model.AvatarPath, Price = model.Price, ProductTypeId = model.ProductTypeId }; context.Products.Add(newPt); context.SaveChanges(); return(model); }
public override void Up() { //Add in no sugar option to list using (var db = new CoffeeContext()) { // Get all the users foreach (var user in db.Users) { // Transform JSON List <KeyValuePair <string, KeyValuePair <string, string> > > options = JsonConvert.DeserializeObject <List <KeyValuePair <string, KeyValuePair <string, string> > > >(user.CoffeeOptionsJson); // Add in No Sugar option if (!options.Any(o => o.Key == "No Sugar")) { options.Add(new KeyValuePair <string, KeyValuePair <string, string> >( key: "No Sugar", value: new KeyValuePair <string, string>( key: "bool", value: "false" ) )); } user.CoffeeOptionsJson = JsonConvert.SerializeObject(options); } db.SaveChanges(); } }
public ActionResult Get(int id) { UserItem user = _context.UserItems.Find(id); List <CoffeeItem> coffeeItems = new List <CoffeeItem>(); foreach (CoffeeItem item in _context.CoffeeItems) { if (item.UserId == user.UserId) { coffeeItems.Add(item); } } user.CoffeeItems = coffeeItems.ToList(); _context.SaveChanges(); return(new JsonResult(user)); }
public void addProduct(Product product) { using (var db = new CoffeeContext()){ db.Products.Add(product); db.SaveChanges(); } }
public override void Down() { // Change JSON for coffee options from KeyValuePair<string, KeyValuePair<string, string>> to KeyValuePair<string, int // THIS RESULTS IN DATA LOSS (of non-integer values) using (var db = new CoffeeContext()) { // Get all the users foreach (var user in db.Users) { // Transform JSON List <KeyValuePair <string, KeyValuePair <string, string> > > old = JsonConvert.DeserializeObject <List <KeyValuePair <string, KeyValuePair <string, string> > > >(user.CoffeeOptionsJson); List <KeyValuePair <string, int> > newOptions = new List <KeyValuePair <string, int> >(); foreach (KeyValuePair <string, KeyValuePair <string, string> > kvp in old) { if (kvp.Value.Key == "int") { newOptions.Add( new KeyValuePair <string, int>( kvp.Key, Int32.Parse(kvp.Value.Value) ) ); } } user.CoffeeOptionsJson = JsonConvert.SerializeObject(newOptions); } db.SaveChanges(); } }
public override void Up() { // Change JSON for coffee options from KeyValuePair<string, int> to KeyValuePair<string, KeyValuePair<string, string>> using (var db = new CoffeeContext()) { // Get all the users foreach (var user in db.Users) { // Transform JSON List <KeyValuePair <string, int> > old = JsonConvert.DeserializeObject <List <KeyValuePair <string, int> > >(user.CoffeeOptionsJson); List <KeyValuePair <string, KeyValuePair <string, string> > > newOptions = new List <KeyValuePair <string, KeyValuePair <string, string> > >(); foreach (KeyValuePair <string, int> kvp in old) { newOptions.Add( new KeyValuePair <string, KeyValuePair <string, string> >( kvp.Key, new KeyValuePair <string, string>( "int", kvp.Value.ToString()) ) ); } user.CoffeeOptionsJson = JsonConvert.SerializeObject(newOptions); } db.SaveChanges(); } }
protected void SetUpDatabase() { var options = new DbContextOptionsBuilder <CoffeeContext>() .UseInMemoryDatabase(databaseName: "CoffeeDb") .Options; Guid CoffeeEspressorId = Guid.NewGuid(); Guid EspressorEspressorId = Guid.NewGuid(); Context = new CoffeeContext(options); Context.EspressoMachines.Add(new EspressoMachineEntity { Id = CoffeeEspressorId, IsEspressor = false }); Context.EspressoMachines.Add(new EspressoMachineEntity { Id = EspressorEspressorId, IsEspressor = true }); Context.Coffees.Add(new CoffeeEntity { Name = "First Coffee", Price = 20, Sweetness = Sweetness.Bitter, EspressoMachineId = CoffeeEspressorId }); Context.Coffees.Add(new CoffeeEntity { Name = "Second Coffee", Price = 30, Sweetness = Sweetness.Sweet, EspressoMachineId = EspressorEspressorId }); Context.Coffees.Add(new CoffeeEntity { Name = "Third Coffee", Price = 45, Sweetness = Sweetness.LessSweet, EspressoMachineId = EspressorEspressorId }); Context.SaveChanges(); }
public void UpdateUser(User user) { using (var coffeeContext = new CoffeeContext()) { coffeeContext.Users.AddOrUpdate(user); coffeeContext.SaveChanges(); } }
public void ClearOldReminders(DateTime oldestAcceptableDate) { using (var coffeeContext = new CoffeeContext()) { var removethese = coffeeContext.Reminders.Where(r => r.CreatedOn < oldestAcceptableDate); coffeeContext.Reminders.RemoveRange(removethese); coffeeContext.SaveChanges(); } }
public void SetWillBeThere(User forUser, bool value = true) { using (var coffeeContext = new CoffeeContext()) { var user = coffeeContext.Users.SingleOrDefault(u => u.Id == forUser.Id); user.WillBeThere = value; coffeeContext.SaveChanges(); } }
public void SaveReport(CoffeeReport coffeereport) { using (var coffeeContext = new CoffeeContext()) { coffeeContext.CoffeeReports.Add(coffeereport); coffeeContext.SaveChanges(); } }
public Order Edit(Order employee) { var editOd = context.Orders.Attach(employee); editOd.State = EntityState.Modified; context.SaveChanges(); return(employee); }
public IActionResult Post(CoffeeItem item) { CoffeeItem exist = _context.CoffeeItems.Find(item.Id); if (exist == null) { _context.CoffeeItems.Add(item); _context.SaveChanges(); return(CreatedAtRoute("coffee", new { id = item.Id }, item)); } else { Debug.Print("SERVER INFO item name:" + item.Name); exist.Name = item.Name; _context.SaveChanges(); return(CreatedAtRoute("coffee", new { id = item.Id }, item)); } }
public JsonResult updateOrderStatus(long orderId, int currentStatus) { var currentOrder = _context.Orders.FirstOrDefault(x => x.Id == orderId); OrderStatus currStatus = (OrderStatus)Enum.Parse(typeof(OrderStatus), currentStatus.ToString()); currentOrder.Status = currStatus; _context.SaveChanges(); return(Json(currentOrder, JsonRequestBehavior.AllowGet)); }
public void SetWillBeThere(User forUser, Reminder reminder) { SetWillBeThere(forUser); using (var coffeeContext = new CoffeeContext()) { var dbReminder = coffeeContext.Reminders.Single(r => r.Id == reminder.Id); coffeeContext.Reminders.Remove(dbReminder); coffeeContext.SaveChanges(); } }
public void RemoveUserFromCompany(long userId) { var user = _context.Set <User>().Include(uc => uc.UserCompanies).FirstOrDefault(item => item.Id == userId); var userCompany = user.UserCompanies.FirstOrDefault(item => item.UserId == userId); user.UserCompanies.Remove(userCompany); _context.SaveChanges(); }
public void AddEspressoMachine(EspressoMachineEntity espressoMachine) { if (string.IsNullOrEmpty(espressoMachine.Name)) { throw new Exception("Name cannot be empty"); } coffeeContext.EspressoMachines.Add(espressoMachine); coffeeContext.SaveChanges(); }
public CoffeeDataController(CoffeeContext context) { _context = context; if (_context.coffeeShops.Count() == 0) { //_context.coffeeShops.Add(new CoffeeShop {Name = "Lupo"} ); _context.SaveChanges(); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { CoffeeContext db = new CoffeeContext(); db.Roles.Find("Admin"); if (!db.Roles.Any()) { try { db.Roles.AddRange(new List <UserRole>() { new UserRole() { Role = "User" }, new UserRole() { Role = "Employee" }, new UserRole() { Role = "Admin" } }); db.SaveChanges(); db.Users.Add(new User() { Login = "******", Password = "******".GetSha256Hash(), RoleFK = "Admin", Name = "John", Surname = "Doe" }); db.SaveChanges(); } catch (DbUpdateException ex) { MessageBox.Show(ex.Message); throw; } db.Dispose(); } e.Handled = true; }
public ActionResult Create(Product product) { product.ProductName = product.ProductName.Trim(); if (_context.Products.Any(x => x.ProductName.ToLower() == product.ProductName.ToLower())) { ModelState.AddModelError("ProductName", "Product Name already exists!"); ViewBag.Categories = LoadCategories(null); return(View()); } else { product.CreatedBy = ""; product.CreatedDate = System.DateTime.Now; product.UpdatedBy = ""; product.UpdatedDate = System.DateTime.Now; _context.Products.Add(product); _context.SaveChanges(); return(RedirectToAction("Index")); } }
public void SetMeeting(DateTime time) { using (var coffeeContext = new CoffeeContext()) { var settings = coffeeContext.GlobalInformation.FirstOrDefault(); settings = settings ?? new GlobalInformation(); settings.MeetingDate = time; coffeeContext.GlobalInformation.AddOrUpdate(settings); coffeeContext.SaveChanges(); } }
public void ClearWillBeThere() { using (var coffeeContext = new CoffeeContext()) { foreach (var user in coffeeContext.Users) { user.WillBeThere = false; } coffeeContext.SaveChanges(); } }
public IActionResult Create([FromBody] CoffeeShop item) { if (item == null) { return(BadRequest()); } _context.coffeeShops.Add(item); _context.SaveChanges(); //return CreatedAtRoute("GetCoffeeShop", new CoffeeShop{Id = item.Id}); return(NoContent()); }
public Reminder CreateReminder(User user) { using (var coffeeContext = new CoffeeContext()) { var dbUser = coffeeContext.Users.Include(u => u.Drink).SingleOrDefault(u => u.Id == user.Id); var reminder = new Reminder() { User = dbUser, CreatedOn = DateTime.UtcNow, Id = Guid.NewGuid() }; coffeeContext.Reminders.Add(reminder); coffeeContext.SaveChanges(); return(reminder); } }