///UpDate Category Items public CategoryClass(int UpDateItem, string a) { var query = (from i in db.Categories where i.ID == UpDateItem select i).ToList(); foreach (var item in query) { r.txtCategoryname.Text = item.Categories_name; r.txtDiscription.Text = item.Description; r.txtPhotoPath.Text = item.PhotoPath; } DialogResult result = r.ShowDialog(); if (result == DialogResult.OK) { cat = db.Categories.Find(UpDateItem); cat.Categories_name = r.txtCategoryname.Text; cat.Description = r.txtDiscription.Text; cat.PhotoPath = r.txtPhotoPath.Text; db.Entry(cat).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); AddData.DataChange(); } else { AddData.notDataChange(); } }
//Update public PositionClass(int UpdateID, string a) { var query = (from i in db.Position where UpdateID == i.ID select i).ToList(); foreach (var item in query) { crpos.txtPosition_name.Text = item.Position_name; crpos.txtPayment.Text = item.Payment.ToString(); } DialogResult result = crpos.ShowDialog(); if (DialogResult.OK == result) { pos = db.Position.Find(UpdateID); pos.Position_name = crpos.txtPosition_name.Text; pos.Payment = decimal.Parse(crpos.txtPayment.Text); db.Entry(pos).State = EntityState.Modified; db.SaveChanges(); AddData.DataChange(); } else { AddData.notDataChange(); } }
/// 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(); } }
public EmployeeClass(int SelectItemUpDate, string UpDate) { emp = (from i in db.Employees where i.ID == SelectItemUpDate select i).First(); r.Text = "Do you want to change Employee's information"; r.txtAboutEmployees.Text = emp.Notes; r.txtAddress.Text = emp.Address; r.txtFirstname.Text = emp.First_name; r.txtlastname.Text = emp.Last_name; r.txtPasportNumber.Text = emp.Pasport_number; r.txtPhoneNumber.Text = emp.Phone; r.txtPhotoPath.Text = emp.PhotoPath; r.txtEmail.Text = emp.Email; r.birthDayEmployees.Value = emp.BirthDay.Value; r.HireDayEmployees.Value = emp.HireDay.Value; r.comCity.Text = emp.City; r.txtPayment.Text = emp.Payment_Bonus.ToString(); r.comCountry.Text = emp.Country; r.comPosition.SelectedItem = emp.Position.Position_name; DialogResult result = r.ShowDialog(); if (DialogResult.OK == result) { emp = db.Employees.Find(SelectItemUpDate); emp.First_name = r.txtFirstname.Text; emp.Last_name = r.txtlastname.Text; emp.BirthDay = r.birthDayEmployees.Value; emp.HireDay = r.HireDayEmployees.Value; emp.Notes = r.txtAboutEmployees.Text; emp.Pasport_number = r.txtPasportNumber.Text; emp.Phone = r.txtPhoneNumber.Text; emp.Address = r.txtAddress.Text; emp.PhotoPath = r.txtPhotoPath.Text; emp.City = r.comCity.Text; emp.Country = r.comCountry.Text; emp.PositionID = (int)r.comPosition.SelectedValue; db.Entry(emp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); AddData.DataChange(); } else { AddData.notDataChange(); } }
///UpDate Olib keluvchi Items public SuppliersClass(int UpDateItem, string a) { var query = (from i in db.Deliver where i.ID == UpDateItem select i).ToList(); foreach (var item in query) { add.txtFullname.Text = item.Full_name; add.txtPhoneNumber.Text = item.Company_Phone; add.txtCompanyname.Text = item.Company_name; add.txtContractname.Text = item.Contract_name; add.txtContractTitle.Text = item.Contract_Title; add.txtAddress.Text = item.Address; add.combCountry.Text = item.Country; add.combCity.Text = item.City; } DialogResult result = add.ShowDialog(); if (result == DialogResult.OK) { sup = db.Deliver.Find(UpDateItem); sup.Company_name = add.txtCompanyname.Text; sup.Contract_name = add.txtContractname.Text; sup.Contract_Title = add.txtContractTitle.Text; sup.City = add.combCity.Text; sup.Country = add.combCountry.Text; sup.Address = add.txtAddress.Text; sup.Full_name = add.txtFullname.Text; sup.Company_Phone = add.txtPhoneNumber.Text; db.Entry(sup).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); AddData.DataChange(); } else { AddData.notDataChange(); } }