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