private void DeleteSubCategoryButton_Click(object sender, EventArgs e)
{
try
{
if (SubCategoryDataGridView.Rows.Count != 0)
{
if (MetroMessageBox.Show(this, $"¿Seguro que desea eliminar la subcategoría: { SubCategoryDataGridView.CurrentRow.Cells[2].Value.ToString() }?", "Eliminar subcategoría", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
if (SubcategoryManagement.DeleteSubCategoryById(int.Parse(SubCategoryDataGridView.CurrentRow.Cells[0].Value.ToString())))
{
FrmMain.Instance.ToolStripLabel.Text = "Se eliminó la Subcategoría correctamente.";
SubCategoryNameTextBox.Text = "";
CategoryComboBox.SelectedIndex = 0;
ReloadSubCategoriesDataGridView();
}
else
{
MetroMessageBox.Show(this, $"Ha ocurrido un error al eliminar la subcategoría: { SubCategoryDataGridView.CurrentRow.Cells[2].Value.ToString()}.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MetroMessageBox.Show(this, "Debe seleccionar una subcategoría para poder eliminarla.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
}
}
//----------------METODOS CAMBIO DE VALOR DE EL COMBOBOX---------------
private void CategoryComboBox_SelectedValueChanged(object sender, EventArgs e)
{
CategoryModel category = (CategoryModel)CategoryComboBox.SelectedItem;
SubcategoryComboBox.DataSource = SubcategoryManagement.SelectSubCategoriesByCategoryId(category.Id_Category);
SubcategoryComboBox.DisplayMember = "Name";
SubcategoryComboBox.ValueMember = "Id_Category";
}
private void SearchSubCategoryTextBox_ButtonClick(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(SearchSubCategoryTextBox.Text))
{
SubCategoryDataGridView.DataSource = SubcategoryManagement.SearchSubcategory(SearchSubCategoryTextBox.Text);
}
else
{
ReloadSubCategoriesDataGridView();
}
}
private void ReloadSubCategoriesDataGridView()
{
showCatAndSubcats = SubcategoryManagement.SelectAllCatAndSucat();
SubCategoryDataGridView.DataSource = showCatAndSubcats;
SubCategoryDataGridView.MultiSelect = false;
SubCategoryDataGridView.Columns["Id_Subcategory"].HeaderText = "ID";
SubCategoryDataGridView.Columns["Category"].HeaderText = "Categoría";
SubCategoryDataGridView.Columns["Subcategory"].HeaderText = "SubCategoría";
SubCategoryDataGridView.Columns["Id_Subcategory"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
SubCategoryDataGridView.Columns["Category"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
SubCategoryDataGridView.Columns["Subcategory"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
SubCategoryDataGridView.Columns["Id_Subcategory"].Visible = false;
SubCategoryDataGridView.MultiSelect = false;
}
private void SubCategoryDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (SubCategoryDataGridView.Rows.Count != 0)
{
SubCategoryNameTextBox.Text = SubCategoryDataGridView.CurrentRow.Cells[2].Value.ToString();
SubcategoryModel subCategoryModel = SubcategoryManagement.SelectSubCategoryById(int.Parse(SubCategoryDataGridView.CurrentRow.Cells[0].Value.ToString()));
foreach (CategoryModel categoryModel in CategoryComboBox.Items)
{
if (categoryModel.Id_Category == subCategoryModel.Id_Category)
{
CategoryComboBox.SelectedItem = categoryModel;
break;
}
}
}
}
private void SaveSubCategoryButton_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(SubCategoryNameTextBox.Text))
{
CategoryModel categoryModel = (CategoryModel)CategoryComboBox.SelectedItem;
List <SubcategoryModel> subcategory = SubcategoryManagement.SelectSubCategoriesByName(SubCategoryNameTextBox.Text);
Boolean var = true;
foreach (SubcategoryModel item in subcategory)
{
if (item.Id_Category == categoryModel.Id_Category)
{
var = false;
}
}
if (subcategory == null || var == true)
{
if (SubcategoryManagement.InsertSubCategory(categoryModel.Id_Category, SubCategoryNameTextBox.Text))
{
FrmMain.Instance.ToolStripLabel.Text = "Se agregó la Subcategoría correctamente.";
SubCategoryNameTextBox.Text = "";
CategoryComboBox.SelectedIndex = 0;
ReloadSubCategoriesDataGridView();
}
}
else
{
MetroMessageBox.Show(this, "Ya existe una subcategoría con ese nombre.", "subcategoría repetida", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MetroMessageBox.Show(this, "El campo del nombre de la subcategoría no puede estar vacío.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
}
}
private void ShowSubcategories()
{
try
{
subCategoryModels = SubcategoryManagement.SelectAllSubCategories();
SubCategoryDataGridView.Rows.Clear();
foreach (SubcategoryModel item2 in subCategoryModels)
{
int Id = item2.Id_Subcategory;
CategoryModel category = CategoryManagement.SelectCategoryByID(item2.Id_Category.ToString());
string name = category.Name;
string Sub = item2.Name;
SubCategoryDataGridView.Rows.Add(Id, name, Sub);
}
}
catch (Exception)
{
throw;
}
}
private void UpdateSubCategoryButton_Click(object sender, EventArgs e)
{
try
{
if (SubCategoryDataGridView.Rows.Count != 0)
{
if (!string.IsNullOrEmpty(SubCategoryNameTextBox.Text))
{
if (MetroMessageBox.Show(this, $"¿Seguro que desea modificar la subcategoría: { SubCategoryDataGridView.CurrentRow.Cells[2].Value.ToString() }?", "Modificar subcategoría", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
int idCat = ((CategoryModel)CategoryComboBox.SelectedItem).Id_Category;
if (SubcategoryManagement.UpdateSubCategoryById(int.Parse(SubCategoryDataGridView.CurrentRow.Cells[0].Value.ToString()), idCat, SubCategoryNameTextBox.Text))
{
FrmMain.Instance.ToolStripLabel.Text = "Se actualizó la Subcategoría correctamente.";
SubCategoryNameTextBox.Text = "";
CategoryComboBox.SelectedIndex = 0;
ReloadSubCategoriesDataGridView();
}
else
{
MetroMessageBox.Show(this, $"Ha ocurrido un error al modificar la subcategoría: { SubCategoryDataGridView.CurrentRow.Cells[2].Value.ToString()}.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MetroMessageBox.Show(this, "No puede estar vacio el campo nombre subcategoría.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MetroMessageBox.Show(this, "Debe seleccionar una subcategoría para poder modificarla.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
}
}
//----------------METODOS DATA GRID VIEW DE EL PRODUCTO---------------
private void ProductDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
IdLabel.Text = ProductDataGridView.CurrentRow.Cells[0].Value.ToString();
try
{
if (ProductDataGridView.SelectedRows[0] != null)
{
ProductModel productModel = ProductManagement.SelectProductByID(ProductDataGridView.CurrentRow.Cells["Id_Product"].Value.ToString());
codeTextBox.Text = Convert.ToString(productModel.Code);;
descriptionTextBox.Text = productModel.Description;
stockTextBox.Text = Convert.ToString(productModel.Quantity_Stock);
unityPriceTextBox.Text = Convert.ToString(productModel.Price);
lowerPriceTextBox1.Text = Convert.ToString(productModel.Lower_Price);
foreach (BrandModel item in BrandComboBox.Items)
{
int idBrand = productModel.Id_Brand;
if (item.Id_Brand == idBrand)
{
BrandComboBox.SelectedItem = item;
}
}
foreach (CategoryModel item2 in CategoryComboBox.Items)
{
SubcategoryModel sub = SubcategoryManagement.SelectSubCategoryById(productModel.Id_Subcategory);
CategoryModel cat = CategoryManagement.SelectCategoryByID(sub.Id_Category.ToString());
if (item2.Id_Category == sub.Id_Category)
{
CategoryComboBox.SelectedItem = item2;
foreach (SubcategoryModel item in SubcategoryComboBox.Items)
{
if (item.Id_Subcategory == sub.Id_Subcategory)
{
SubcategoryComboBox.SelectedItem = item;
}
}
}
}
if (productModel.Image == null)
{
ImgpictureBox.Image = null;
}
else
{
ImgpictureBox.Image = ImageManagement.ByteToImage(productModel.Image);
}
if (productModel.Ivi)
{
gravadoRadioButton.Select();
}
else
{
exentoRadioButton.Select();
}
}
}
catch (Exception)
{
MetroMessageBox.Show(this, $"Ha ocurrido un error al seleccionar el producto.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
