public ActionResult Edit(Providers provider) { Providers res = (from q in ctx.Providers where q.Id == provider.Id select q).FirstOrDefault(); res.Name = provider.Name; res.City = provider.City; ctx.SaveChanges(); return(RedirectToAction("ProvidersTable")); }
public ActionResult Edit(Clients clients) { Clients res = (from q in ctx.Clients where q.Id == clients.Id select q).FirstOrDefault(); res.Name = clients.Name; res.Card = clients.Card; res.Tel = clients.Tel; ctx.SaveChanges(); return(RedirectToAction("ClientsTable")); }
public ActionResult Edit(Orders order) { Orders res = (from q in ctx.Orders where q.id == order.id select q).FirstOrDefault(); res.Id_client = order.Id_client; res.Id_prod = order.Id_prod; res.Status = order.Status; ctx.SaveChanges(); return(RedirectToAction("OrdersTable")); }
public ActionResult Edit(Products product) { Products res = (from q in ctx.Products where q.Id == product.Id select q).FirstOrDefault(); res.Name = product.Name; res.Quantity = product.Quantity; res.Price = product.Price; res.Inf = product.Inf; res.Product_kind = product.Product_kind; res.Anim_kind = product.Anim_kind; ctx.SaveChanges(); return(RedirectToAction("ProductsTable")); }
private void OK_Click(object sender, EventArgs e) { try { int id = (int)this.ProviderCB.SelectedValue; int prodid = (int)this.ProductCB.SelectedValue; Providers provider = (from q in ctx.Providers where q.Id == id select q).FirstOrDefault(); Products product = (from q in ctx.Products where q.Id == prodid select q).FirstOrDefault(); if (provider.Products.Contains(product)) { throw new Exception("Already exists"); } else { ctx.Database.ExecuteSqlCommand("INSERT INTO [dbo].[Prov_Product]([Id_prod],[Id_prov])" + " VALUES ({0},{1})", prodid, id); ctx.SaveChanges(); this.DialogResult = DialogResult.OK; } } catch (Exception w) { MessageBox.Show(w.Message); } }
private void OK_Click(object sender, EventArgs e) { int id = (int)this.ProviderCB.SelectedValue; int prodid = (int)this.ProductCB.SelectedValue; ctx.Database.ExecuteSqlCommand("DELETE FROM [dbo].[Prov_Product] WHERE Id_prod = {0} AND Id_prov = {1}", prodid, id); ctx.SaveChanges(); this.DialogResult = DialogResult.OK; }
private void ProductSaveButton_Click(object sender, EventArgs e) { ctx.SaveChanges(); }