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