private void MoveSelectedItemBetweenListBox(ListBox listBox_From, ListBox listBox_To)
{
CategoryProductArr categoryProductArr = null;
//מוצאים את הפריט הנבחר
object selectedItem = listBox_From.SelectedItem;
//מוסיפים את הפריט הנבחר לרשימת הפריטים הפוטנציאליים
//אם כבר יש פריטים ברשימת הפוטנציאליים
if (listBox_To.DataSource != null)
{
categoryProductArr = listBox_To.DataSource as CategoryProductArr;
}
else
{
categoryProductArr = new CategoryProductArr();
}
categoryProductArr.Add(selectedItem);
CategoryProductArrToForm(categoryProductArr, listBox_To);
///הסרת הפריט הנבחרים מרשימת הפריטים הנבחרים
categoryProductArr = listBox_From.DataSource as CategoryProductArr;
categoryProductArr.Remove(selectedItem);
CategoryProductArrToForm(categoryProductArr, listBox_From);
}
public void CategoryArrToForm(CategoryProduct curCategoryProduct, ComboBox comboBox, bool isMustChoose)
{
//ממירה את הטנ"מ אוסף ישובים לטופס
CategoryProductArr catrgoryProductArr = new CategoryProductArr();
CategoryProduct categoryProductDefault = new CategoryProduct();
categoryProductDefault.ID = -1;
if (isMustChoose)
{
categoryProductDefault.CategoryProductName = "Choose category";
}
else
{
categoryProductDefault.CategoryProductName = "Every category";
}
catrgoryProductArr.Add(categoryProductDefault);
catrgoryProductArr.Fill();
comboBox.DataSource = catrgoryProductArr;
comboBox.ValueMember = "ID";
comboBox.DisplayMember = "CategoryProductName";
if (curCategoryProduct != null)
{
comboBox.SelectedValue = curCategoryProduct.ID;
}
}
private void CategoryProductArrToForm()
{
//ממירה את הטנ"מ אוסף למוצרים לטופס
CategoryProductArr categoryProductArr = new CategoryProductArr();
categoryProductArr.Fill();
listBox_category_potential.DataSource = categoryProductArr;
}
private void CategoryProductArrToForm(CategoryProductArr categoryProductArr, ListBox listBox)
{
listBox.DataSource = null;
if (categoryProductArr == null)
{
categoryProductArr = new CategoryProductArr();
categoryProductArr.Fill();
}
listBox.DataSource = categoryProductArr;
}
private void Save(object sender, EventArgs e)
{
if (!CheckGood())
{
MessageBox.Show("You didn't write right", "TRY AGAIN", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
All_White();
}
else
{
CategoryProduct categoryProduct = FormToCategoryProduct();
if (categoryProduct.ID == 0)
{
CategoryProductArr oldCategoryProductArr = new CategoryProductArr();
oldCategoryProductArr.Fill();
if (!oldCategoryProductArr.IsContains(categoryProduct))
{
if (categoryProduct.Insert())
{
MessageBox.Show("CategoryProduct Details Saved");
Clean_Form();
CategoryProductArr categoryProductArr = new CategoryProductArr();
categoryProductArr.Fill();
categoryProduct = categoryProductArr.GetCategoryRoonWithMaxId();
CategoryProductArrToForm(categoryProduct);
Close();
}
else
{
MessageBox.Show("Cannot Save CategoryProduct Details");
}
}
else
{
MessageBox.Show("CategoryProduct already existing");
}
}
else
{
if (categoryProduct.Update())
{
MessageBox.Show("CategoryProduct Details UPDATED");
Clean_Form();
CategoryProductArrToForm(null);
}
else
{
MessageBox.Show("Cannot UPDATE CategoryProduct Details");
}
}
}
}
private void CategoryProductArrToForm(CategoryProduct curCategoryProduct)
{
//ממירה את הטנ"מ אוסף לקוחות לטופס
CategoryProductArr CategoryProductArr = new CategoryProductArr();
CategoryProductArr.Fill();
listBox_Category.DataSource = CategoryProductArr;
listBox_Category.ValueMember = "ID";
listBox_Category.DisplayMember = "CategoryProductName";
//אם נשלח לפעולה ישוב ,הצבתו בתיבת הבחירה של ישובים בטופס
if (curCategoryProduct != null)
{
listBox_Category.SelectedValue = curCategoryProduct.ID;
}
}
private void listBox_Clients_DoubleClick(object sender, EventArgs e)
{
ProductToForm(listBox_product.SelectedItem as Product);
CategoryProductArr categoryProductArrChoosed = new CategoryProductArr();
ProductDetailsArr productDetailsArr = new ProductDetailsArr();
productDetailsArr.Fill();
productDetailsArr = productDetailsArr.Filter((listBox_product.SelectedItem as Product));
categoryProductArrChoosed = productDetailsArr.GetCategoryProductArr();
CategoryProductArrToForm(categoryProductArrChoosed, listBox_category_choosed);
CategoryProductArr categoryProductArrNotChoosed = new CategoryProductArr();
categoryProductArrNotChoosed.Fill();
categoryProductArrNotChoosed.Remove(categoryProductArrChoosed);
CategoryProductArrToForm(categoryProductArrNotChoosed, listBox_category_potential);
}
private void Save(object sender, EventArgs e)
{
if (!CheckGood())
{
MessageBox.Show("You didn't write right", "TRY AGAIN", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
All_White();
}
else
{
Product product = FormToProduct();
ProductDetailsArr productDetailsArr_new;
ProductDetailsArr productDetailsArr_old = new ProductDetailsArr();
ProductArr productArr_new = new ProductArr();
productArr_new.Fill();
if (product.ID == 0)
{
if (product.Insert())
{
ProductArr productArr = new ProductArr();
productArr.Fill();
product = productArr.GetProductWithMaxId();
productDetailsArr_new = FormToProductDetailsArr(product);
productDetailsArr_new.Insert();
CategoryProductArr categoryProductArr = productDetailsArr_new.GetCategoryProductArr();
categoryProductArr.Update();
MessageBox.Show("Products Details Saved");
CleanForm();
ProductArrToForm();
CategoryProductArrToForm();
}
else
{
MessageBox.Show("Cannot Save Products Details");
}
}
else
{
if (product.Update())
{
productDetailsArr_new = FormToProductDetailsArr(product);
productDetailsArr_old.Fill();
productDetailsArr_old = productDetailsArr_old.Filter(product);
productDetailsArr_old.Delete();
productDetailsArr_new.Insert();
//(listBox_category_choosed.DataSource as CategoryProductArr).Update();
//(listBox_category_potential.DataSource as CategoryProductArr).Update();
MessageBox.Show("Products Details UPDATED");
CleanForm();
ProductArrToForm();
}
else
{
MessageBox.Show("Cannot UPDATE Products Details");
}
}
}
}
