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