///AddProduct public ProductClass() { Add_Product r = new Add_Product(); JoinComBoxItems(r); DialogResult result = r.ShowDialog(); if (result == DialogResult.OK) { Product pro = new Product(); pro.Product_Name = r.txtProductname.Text; pro.Unit_Price = decimal.Parse(r.txtProductPrice.Text); pro.UnitsInStock = int.Parse(r.txtProductStock.Text); pro.UnitsOnOrder = 0; pro.Olib_KeluvchiID = (int)r.cobSupplier.SelectedValue; pro.CategoryID = (int)r.cobCategory.SelectedValue; pro.EnterDate = r.dateEnterDate.Value; pro.LastDate = r.dateLastDate.Value; db.Product.Add(pro); db.SaveChanges(); AddData.add(); } else { AddData.notadd(); } }
/// UpDate --Product<> public ProductClass(int UPDateItem, string a) { var query = (from i in db.Product join j in db.Deliver on i.Olib_KeluvchiID equals j.ID join c in db.Categories on i.CategoryID equals c.ID where i.ID == UPDateItem select new { Product_name = i.Product_Name, Product_stock = i.UnitsInStock, Product_Price = i.Unit_Price, Enter_Time = i.EnterDate, Last_Time = i.LastDate, CategoryID = c.ID, Olib_KeluvchiID = j.ID }).ToList(); Add_Product add = new Add_Product(); JoinComBoxItems(add); foreach (var item in query) { add.txtProductname.Text = item.Product_name; add.txtProductPrice.Text = item.Product_Price.ToString(); add.txtProductStock.Text = item.Product_stock.ToString(); add.dateEnterDate.Value = (DateTime)item.Enter_Time; add.dateLastDate.Value = (DateTime)item.Last_Time; add.cobCategory.SelectedValue = item.CategoryID; add.cobSupplier.SelectedValue = item.Olib_KeluvchiID; } DialogResult result = add.ShowDialog(); if (result == DialogResult.OK) { Product pro = db.Product.Find(UPDateItem); pro.Product_Name = add.txtProductname.Text; pro.Unit_Price = decimal.Parse(add.txtProductPrice.Text); pro.UnitsInStock = int.Parse(add.txtProductStock.Text); pro.Olib_KeluvchiID = (int)add.cobSupplier.SelectedValue; pro.CategoryID = (int)add.cobCategory.SelectedValue; pro.EnterDate = add.dateEnterDate.Value; pro.LastDate = add.dateLastDate.Value; db.Entry(pro).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); AddData.DataChange(); } else { AddData.notDataChange(); } }