// Método que carga campos
private void Products_Load(object sender, EventArgs e)
{
RefreshDataGridView();
IEnumerable <DataAccess.Entities.Subcategory> subcategories = BusinessSubcategory.GetAllSubcategories().ToList();
comboInsertSubcategory.DataSource = subcategories;
comboInsertSubcategory.DisplayMember = "SubcategoryName";
comboInsertSubcategory.ValueMember = "SubcategoryId";
}
//Método para Refrescar la información de la tabla
private void RefreshDataGridView()
{
List <Subcategory> subcategories = BusinessSubcategory.GetAllSubcategories().ToList();
this.dtgridSubcatgory.DataSource = subcategories;
for (int i = 0; i < dtgridSubcatgory.Rows.Count; i++)
{
dtgridSubcatgory.Rows[i].Cells["Category"].Value = subcategories[i].Category.CategoryName;
}
DisabledFields();
}
// Método para buscar subcategoría
private void SearchSucategory(object sender, EventArgs e)
{
this.dtgridSubcatgory.DataSource = BusinessSubcategory.SearchSubcategory(this.txtSubcatgorySearch.Text);
List <Subcategory> subcategories = BusinessSubcategory.GetAllSubcategories().ToList();
foreach (DataGridViewRow item in dtgridSubcatgory.Rows)
{
foreach (var subitem in subcategories)
{
item.Cells["Category"].Value = subitem.Category.CategoryName;
}
}
}
// Método que hace los campos editables
private void ClickProduct(object sender, DataGridViewCellEventArgs e)
{
EnabledFields();
IEnumerable <DataAccess.Entities.Subcategory> subcategories = BusinessSubcategory.GetAllSubcategories().ToList();
comboProduct.DataSource = subcategories;
comboProduct.DisplayMember = "SubcategoryName";
comboProduct.ValueMember = "SubcategoryId";
var rows = this.dtgridProduct.CurrentRow;
if (rows != null)
{
this.txtProductName.Text = rows.Cells["ProductName"].Value.ToString();;
this.txtProductDescripcion.Text = rows.Cells["ProductDescription"].Value.ToString();;
this.lbId.Text = rows.Cells["ProductId"].Value.ToString();
this.txtEarns.Text = rows.Cells["Earns"].Value.ToString();
this.txtPrecioProducto.Text = rows.Cells["Price"].Value.ToString();
this.comboProduct.Text = rows.Cells["SubcategoryName"].Value.ToString();
}
else
{
MessageBox.Show("Selecciona una fila");
}
}