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