///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();
}
}
///--join table install items on ComBox
void JoinComBoxItems(Add_Product r)
{
r.cobCategory.DataSource = db.Categories.ToList();
r.cobCategory.DisplayMember = "Categories_name";
r.cobCategory.ValueMember = "ID";
r.cobSupplier.DataSource = db.Deliver.ToList();
r.cobSupplier.DisplayMember = "Contract_name";
r.cobSupplier.ValueMember = "ID";
}
/// 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();
}
}
