private void ConfigureDataGridView(IList <EmployeesViewModel> employeesFound) { var configurator = DataGridViewConfigurator.Configure(EmployeeGrid); EmployeeGrid.DataSource = employeesFound; configurator.HideColumn("UserId"); }
private void ConfigureSalesGrid(DataTable data) { if (data.Rows.Count.Equals(0)) { SalesDataGridView.Height = 50; SalesDataGridView.DataSource = null; SalesTitleLabel.Text = string.Empty; return; } SalesTitleLabel.Location = new Point(0, ResumeSalesDataGridView.Height + ResumeSalesDataGridView.Location.Y + 25); SalesDataGridView.Location = new Point(0, SalesTitleLabel.Location.Y + 25); SalesTitleLabel.Text = "Detalle de ventas."; SalesDataGridView.DataSource = data; DataGridViewConfigurator configurator = DataGridViewConfigurator.CreateConfigurator(SalesDataGridView); IList <string> columns = new List <string> { "id_rol", "estado_orden" }; configurator.HideColumns(columns); configurator.ChangeHeader("fecha_orden", "Fecha de compra"); configurator.ChangeHeader("fecha_pago", "Fecha de pago"); configurator.ChangeHeader("condicion_pago", "Condición de pago"); configurator.ChangeHeader("metodo_pago", "Metodo pago"); configurator.CurrencyColumn("monto_pagado", "Monto"); configurator.AdjustHeight(); }
private void ConfigureProductGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ProductsDataGridView); configurator.ChangeHeader("Product", "Producto"); configurator.CurrencyColumn("UnitValue", "Valor"); configurator.NumericIntegerColumn("Quantity", "Cantidad"); configurator.CurrencyColumn("TotalValue", "Total"); }
private void ConfigureOrderDetailsGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ProductDataGridView); IList <string> columns = new List <string> { "id_detalle", "id_oferta", "id_producto", "Descuento aplicado" }; configurator.HideColumns(columns); configurator.CurrencyColumn("valor_original", "Precio inicial"); configurator.CurrencyColumn("Valor oferta", "Precio Oferta"); }
private void ConfigureGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(RecipientDataGridView); IList <string> columns = new List <string> { "Filename", "Subject", "Message" }; configurator.HideColumns(columns); configurator.ChangeHeader("Name", "Destinatario"); }
private void ConfigureResultGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ResultDataGridView); IList <string> columns = new List <string> { "id_resultado", "id_subasta", "id_cliente" }; configurator.HideColumns(columns); configurator.CurrencyColumn("Puja", "Valor propuesto"); RemoveButton.Visible = ResultDataGridView.Rows.Count.Equals(0); AuctionCloseButton.Visible = !ResultDataGridView.Rows.Count.Equals(0); }
private void ConfigureGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ListDataGridView); IList <string> columns = new List <string> { "id_producto", "id_cliente", "id_categoria", "Observacion", "categoria" }; configurator.HideColumns(columns); configurator.CurrencyColumn("Valor", "Precio por KG"); configurator.NumericIntegerColumn("Cantidad", "Stock disponible (en KG)"); }
private void ConfigureProductGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ProductDataGridView); IList <string> columns = new List <string> { "id_pago", "id_pedido", "id_cliente", "email" }; configurator.HideColumns(columns); configurator.NumericIntegerColumn("Cantidad", "Cantidad"); configurator.CurrencyColumn("Valor unitario", "Precio unitario"); configurator.CurrencyColumn("Valor productos", "Precio total"); }
private void ConfigureProductGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ProductsDataGridView); IList <string> columns = new List <string> { "DetailId" }; configurator.HideColumns(columns); configurator.ChangeHeader("Product", "Producto"); configurator.CurrencyColumn("UnitValue", "Valor"); configurator.NumericIntegerColumn("Quantity", "Cantidad"); configurator.CurrencyColumn("TotalValue", "Total"); }
private void ConfigureProductGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(Data); IList <string> columns = new List <string> { "id_respuesta", "id_pedido" }; configurator.HideColumns(columns); configurator.NumericIntegerColumn("Stock disponible", "Stock disponible"); configurator.NumericIntegerColumn("Cantidad solicitada", "Cantidad solicitada"); configurator.CurrencyColumn("Valor KG", "Valor KG"); configurator.CurrencyColumn("Total", "Valor KG"); }
private void ConfigureGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ProductDataGridView); IList <string> columns = new List <string> { "OfferDetailId", "ProductId" }; configurator.HideColumns(columns); configurator.ChangeHeader("ProductName", "Producto"); configurator.ChangeHeader("Percent", "Porcentaje descuento"); configurator.CurrencyColumn("ActualValue", "Precio actual"); configurator.CurrencyColumn("OfferValue", "Precio oferta"); }
private void ConfigurePaymentGrid() { var configurator = DataGridViewConfigurator.CreateConfigurator(ListDataGridView); IList <string> columns = new List <string> { "id_pago", "id_pedido", "id_cliente", "id_rol", "id_condicion", "id_metpago", "pago_notificado", "Notificacion", "tipo usuario", "Condicion pago", "desc_metpago", "Neto", "IVA", "Porcentaje descuento", "Descuento", "email" }; configurator.HideColumns(columns); configurator.ChangeHeader("Observacion", "Observación"); configurator.CurrencyColumn("Total a pagar", "Pago"); DisplayCounts(); }
private void ConfigureResumeSalesGrid(DataTable data) { if (data.Rows.Count.Equals(0)) { ResumeSalesLabel.Text = "No hay ventas registradas en el periodo."; ResumeSalesDataGridView.Height = 50; ResumeSalesDataGridView.DataSource = null; return; } ResumeSalesLabel.Text = "Resumen de ventas"; ResumeSalesDataGridView.DataSource = data; DataGridViewConfigurator configurator = DataGridViewConfigurator.CreateConfigurator(ResumeSalesDataGridView); configurator.ChangeHeader("fecha_compra", "Fecha"); configurator.CurrencyColumn("monto", "Venta diaria"); configurator.AdjustHeight(); }
private void LoadOrderDetail(string orderId) { try{ var usecase = OrderUseCase.CreateUseCase(); ProductDataGridView.DataSource = null; ProductDataGridView.DataSource = usecase.GetOrderDetailById(orderId); var configurator = DataGridViewConfigurator.CreateConfigurator(ProductDataGridView); IList <string> columns = new List <string> { "id", "id_pedido" }; configurator.HideColumns(columns); configurator.NumericIntegerColumn("Cantidad", "Cantidad solicitada"); } catch (Exception ex) { ProductDataGridView.DataSource = null; MessageBox.Show(ex.Message, "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void LoadOrders(int filterType) { try{ var usecase = OrderUseCase.CreateUseCase(); ListDataGridView.DataSource = null; ListDataGridView.DataSource = usecase.GetOrderByStatus(filterType + 1, profile.ProfileId); var configurator = DataGridViewConfigurator.CreateConfigurator(ListDataGridView); IList <string> columns = new List <string> { "id_pedido", "id_cliente", "id_estado", "id_condicion", "Condicion pago", "id_rol", "estado_subasta", "empresa", "dir", "fono", "observacion" }; configurator.HideColumns(columns); configurator.ChangeHeader("Observacion", "Observación"); configurator.NumericColumn("Descuento", "Descuento"); DisplayCounts(); } catch (Exception ex) { ListDataGridView.DataSource = null; MessageBox.Show(ex.Message, "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void LoadOffers(int filterType) { try{ var usecase = OfferUseCase.CreateUsecase(); ListDataGridView.DataSource = null; ListDataGridView.DataSource = usecase.FindOffersByStatus(nodeIndex + 1); var configurator = DataGridViewConfigurator.CreateConfigurator(ListDataGridView); IList <string> columns = new List <string> { "id_oferta", "estado_oferta", "tipo_oferta" }; configurator.HideColumns(columns); configurator.ChangeHeader("Descripcion", "Descripción"); configurator.ChangeHeader("Fecha publicacion", "Fecha publicación"); configurator.NumericColumn("Descuento", "Descuento"); DisplayCounts(); } catch (Exception ex) { ListDataGridView.DataSource = null; MessageBox.Show(ex.Message, "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void ConfigureResumeLossesGrid(DataTable data) { if (data.Rows.Count.Equals(0)) { ResumeLossesDataGridView.Height = 50; ResumeLossesDataGridView.DataSource = null; ResumeLossesLabel.Text = "No se registran mermas en el periodo seleccionado."; return; } ResumeLossesLabel.Text = "Resumen de mermas"; ResumeLossesDataGridView.DataSource = data; DataGridViewConfigurator configurator = DataGridViewConfigurator.CreateConfigurator(ResumeLossesDataGridView); IList <string> columns = new List <string> { "id_rol" }; configurator.HideColumns(columns); configurator.ChangeHeader("fecha_orden", "Fecha"); configurator.ChangeHeader("productor", "Productor"); configurator.CurrencyColumn("total_mermas", "Total mermas"); configurator.AdjustHeight(); }
private void ConfigureLossesSalesGrid(DataTable data) { if (data.Rows.Count.Equals(0)) { LossesDataGridView.Height = 50; LossesChart.Visible = false; LossesDataGridView.DataSource = null; LossesLabel.Text = string.Empty; return; } LossesLabel.Location = new Point(675, ResumeLossesDataGridView.Height + ResumeLossesDataGridView.Location.Y + 25); LossesDataGridView.Location = new Point(675, LossesLabel.Location.Y + 25); LossesLabel.Text = "Detalle de mermas registradas."; LossesDataGridView.DataSource = data; DataGridViewConfigurator configurator = DataGridViewConfigurator.CreateConfigurator(LossesDataGridView); IList <string> columns = new List <string> { "id_rol" }; configurator.HideColumns(columns); configurator.ChangeHeader("fecha_orden", "Fecha"); configurator.ChangeHeader("producto", "Producto"); configurator.NumericIntegerColumn("cantidad_merma", "Cantidad"); configurator.CurrencyColumn("precio_kg", "Precio (KG)"); configurator.CurrencyColumn("precio_productos", "Total"); configurator.ChangeHeader("productor", "Productor"); configurator.AdjustHeight(); LossesChart.Location = new Point(675, LossesDataGridView.Height + LossesDataGridView.Location.Y + 25); LossesChart.DataSource = data; LossesChart.Series[0].XValueMember = "producto"; LossesChart.Series[0].YValueMembers = "cantidad_merma"; LossesChart.Series[0]["PieLabelStyle"] = "Disabled"; LossesChart.Titles.Clear(); LossesChart.Titles.Add("Distribución de mermas por producto vs cantidad"); LossesChart.Visible = true; }
private void LoadUsers(int filterType) { try{ var useCase = ClientUseCase.CreateUseCase(Profile.ProfileId, Profile.SingleProfileName); var data = new DataTable(); ListDataGridView.DataSource = null; switch (filterType) { case 0: data = useCase.FindAll(); break; case 1: data = useCase.FindClientByName(ListFilterTextBox.Text); break; case 2: data = useCase.FindActiveClients(); break; case 3: data = useCase.FindInactiveClients(); break; } ListDataGridView.DataSource = data; var configurator = DataGridViewConfigurator.CreateConfigurator(ListDataGridView); IList <string> columns = new List <string> { "id_cliente", "id_usuario", "id_rol", "nombre_cliente", "apellido_cliente", "password", "is_active" }; configurator.HideColumns(columns); DisplayCounts(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }