public void DatosIniciales()
{
listadoDataGridView.DataSource = ConsultasSql.ConsultaGeneral(TableBdd, campoOrden: "business_name");
listadoDataGridView.Sort(listadoDataGridView.Columns["business_name"], ListSortDirection.Ascending);
listadoDataGridView.Columns["business_name"].HeaderText = "Nombre";
listadoDataGridView.Columns["business_name"].Width = 320;
listadoDataGridView.Columns["id_number"].HeaderText = "Identificación";
listadoDataGridView.Columns["landline"].HeaderText = "Telefono";
listadoDataGridView.Columns["landline"].Width = 90;
listadoDataGridView.Columns["email"].HeaderText = "Correo";
listadoDataGridView.Columns["email"].Width = 120;
listadoDataGridView.Columns["id"].Visible = false;
listadoDataGridView.Columns["tradename"].Visible = false;
listadoDataGridView.Columns["address"].Visible = false;
listadoDataGridView.Columns["mobile_phone"].Visible = false;
listadoDataGridView.Columns["client"].Visible = false;
listadoDataGridView.Columns["provider"].Visible = false;
listadoDataGridView.Columns["special_taxpayer"].Visible = false;
listadoDataGridView.Columns["additional_information"].Visible = false;
listadoDataGridView.Columns["status"].Visible = false;
listadoDataGridView.Columns["created_at"].Visible = false;
listadoDataGridView.Columns["modified_at"].Visible = false;
listadoDataGridView.Columns["revision"].Visible = false;
listadoDataGridView.Columns["typeIdentificationId"].Visible = false;
}
private void AddPresetButton_Click(object sender, EventArgs e)
{
parameterDataTable = ConsultasSql.ConsultaGeneral(TableBdd, campoOrden: "preset");
presetComboBox.DataSource = parameterDataTable;
presetComboBox.DisplayMember = "preset";
presetComboBox.ValueMember = "id";
DataRow dataRow = parameterDataTable.NewRow();
dataRow["id"] = "nulo";
dataRow["preset"] = presetComboBox.Items.Count + 1;
parameterDataTable.Rows.Add(dataRow);
parameterDataTable.DefaultView.Sort = "preset desc";
presetComboBox.DataSource = parameterDataTable;
printerNameComboBox.SelectedIndex = 0;
fontFamilyComboBox.SelectedIndex = 0;
fontSizeTextBox.Text = "8";
headerXTextBox.Text = "0";
headerYTextBox.Text = "0";
mainXTextBox.Text = "0";
mainYTextBox.Text = "0";
footerXTextBox.Text = "0";
footerYTextBox.Text = "0";
numberDocument1TextBox.Text = "000";
numberDocument2TextBox.Text = "000";
numberDocument3TextBox.Text = "000000000";
aceptarButton.Text = "Guardar";
}
public void CargarDatos(int presetIndex = 0)
{
parameterDataTable = ConsultasSql.ConsultaGeneral(TableBdd, campoOrden: "preset");
presetComboBox.DataSource = parameterDataTable;
presetComboBox.DisplayMember = "preset";
presetComboBox.ValueMember = "id";
DataRow dataRow = parameterDataTable.Rows[presetIndex];
printerNameComboBox.Text = dataRow["printerName"].ToString();
fontFamilyComboBox.Text = dataRow["printerFontFamily"].ToString();
fontSizeTextBox.Text = dataRow["printerFontSize"].ToString();
headerXTextBox.Text = dataRow["printerHeaderPositionX"].ToString();
headerYTextBox.Text = dataRow["printerHeaderPositionY"].ToString();
mainXTextBox.Text = dataRow["printerMainPositionX"].ToString();
mainYTextBox.Text = dataRow["printerMainPositionY"].ToString();
footerXTextBox.Text = dataRow["printerFooterPositionX"].ToString();
footerYTextBox.Text = dataRow["printerFooterPositionY"].ToString();
printerPageHeightTextBox.Text = dataRow["printerPageHeight"].ToString();
printerPageWidthTextBox.Text = dataRow["printerPageWidth"].ToString();
string numberInvoice = dataRow["numberInvoice"].ToString();
numberDocument1TextBox.Text = numberInvoice.Substring(0, 3);
numberDocument2TextBox.Text = numberInvoice.Substring(3, 3);
numberDocument3TextBox.Text = numberInvoice.Substring(6, 9);
aceptarButton.Text = "Actualizar";
}
public void DatosIniciales()
{
listadoDataGridView.DataSource = ConsultasSql.ConsultaGeneral(TableBdd);
listadoDataGridView.Columns["number"].HeaderText = "NÚMERO";
listadoDataGridView.Columns["number"].Width = 110;
listadoDataGridView.Columns["number"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
listadoDataGridView.Columns["name"].Width = 180;
listadoDataGridView.Columns["name"].HeaderText = "CONTACTO";
listadoDataGridView.Columns["date_of_issue"].HeaderText = "FECHA";
listadoDataGridView.Columns["date_of_issue"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
listadoDataGridView.Columns["date_of_issue"].DefaultCellStyle.Format = "MMMM dd, yyyy";
listadoDataGridView.Columns["product"].HeaderText = "PRODUCTO";
listadoDataGridView.Columns["product"].Width = 120;
listadoDataGridView.Columns["quantity"].HeaderText = "CANT.";
listadoDataGridView.Columns["quantity"].Width = 50;
listadoDataGridView.Columns["quantity"].DefaultCellStyle.Format = "N0";
listadoDataGridView.Columns["quantity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
listadoDataGridView.Columns["total_value"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
listadoDataGridView.Columns["type_document"].HeaderText = "TIPO";
listadoDataGridView.Columns["type_document"].Width = 65;
listadoDataGridView.Columns["type_document"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
listadoDataGridView.Columns["status_document"].HeaderText = "ESTADO";
listadoDataGridView.Columns["status_document"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
listadoDataGridView.Columns["status_document"].Width = 70;
listadoDataGridView.Columns["total_value"].Visible = false;
listadoDataGridView.Columns["idDocument"].Visible = false;
listadoDataGridView.Columns["invoice_detailment"].Visible = false;
listadoDataGridView.Columns["payment_method"].Visible = false;
listadoDataGridView.Columns["subtotal"].Visible = false;
}
private void CargaDeDatosCombobox(ComboBox comboBox, string table, string displayMember = "name", string valueMember = "id", string campoOrden = "name")
{
comboBox.DataSource = ConsultasSql.ConsultaGeneral(table, campoOrden: campoOrden);
comboBox.DisplayMember = displayMember;
comboBox.ValueMember = valueMember;
comboBox.AutoCompleteSource = AutoCompleteSource.ListItems;
comboBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
}
public void DatosIniciales()
{
listadoDataGridView.DataSource = ConsultasSql.ConsultaGeneral(TableBdd);
listadoDataGridView.Sort(listadoDataGridView.Columns["name"], ListSortDirection.Ascending);
listadoDataGridView.Columns["name"].HeaderText = "Descripción";
listadoDataGridView.Columns["name"].Width = 242;
listadoDataGridView.Columns["id"].Visible = false;
listadoDataGridView.Columns["revision"].Visible = false;
listadoDataGridView.Columns["status"].Visible = false;
listadoDataGridView.Columns["created_at"].Visible = false;
listadoDataGridView.Columns["modified_at"].Visible = false;
}
public void DatosIniciales()
{
listadoDataGridView.DataSource = ConsultasSql.ConsultaGeneral(TableBdd);
listadoDataGridView.Sort(listadoDataGridView.Columns["name"], ListSortDirection.Ascending);
listadoDataGridView.Columns["name"].HeaderText = "Descripción";
listadoDataGridView.Columns["name"].Width = 364;
listadoDataGridView.Columns["cost"].HeaderText = "Costo";
listadoDataGridView.Columns["cost"].Width = 65;
listadoDataGridView.Columns["pvp"].HeaderText = "Oferta";
listadoDataGridView.Columns["pvp"].Width = 65;
listadoDataGridView.Columns["pvp2"].HeaderText = "Normal";
listadoDataGridView.Columns["pvp2"].Width = 65;
listadoDataGridView.Columns["stock"].HeaderText = "Stock";
listadoDataGridView.Columns["stock"].Width = 55;
listadoDataGridView.Columns["id"].Visible = false;
listadoDataGridView.Columns["main_code"].Visible = false;
listadoDataGridView.Columns["aux_code"].Visible = false;
listadoDataGridView.Columns["detail"].Visible = false;
listadoDataGridView.Columns["minimum_stock_level"].Visible = false;
listadoDataGridView.Columns["stock_indicator"].Visible = false;
listadoDataGridView.Columns["percentage_price"].Visible = false;
listadoDataGridView.Columns["price"].Visible = false;
listadoDataGridView.Columns["percentage_price2"].Visible = false;
listadoDataGridView.Columns["price2"].Visible = false;
listadoDataGridView.Columns["percentage_price3"].Visible = false;
listadoDataGridView.Columns["price3"].Visible = false;
listadoDataGridView.Columns["pvp3"].Visible = false;
listadoDataGridView.Columns["status"].Visible = false;
listadoDataGridView.Columns["created_at"].Visible = false;
listadoDataGridView.Columns["modified_at"].Visible = false;
listadoDataGridView.Columns["revision"].Visible = false;
listadoDataGridView.Columns["categoryId"].Visible = false;
listadoDataGridView.Columns["manufacturerId"].Visible = false;
listadoDataGridView.Columns["iceRateId"].Visible = false;
listadoDataGridView.Columns["ivaRateId"].Visible = false;
listadoDataGridView.Columns["typeProductId"].Visible = false;
listadoDataGridView.Columns["unitMeasurementId"].Visible = false;
}
public void DatosIniciales()
{
StockIndicator = 0;
DateTime dateTimeStart = toDateTimePicker.Value;
string fechaInicio = $"'{dateTimeStart: yyyy-MM-dd} 00:00:00'";
DateTime dateTimeEnd = fromDateTimePicker.Value;
string fechaFin = $"'{dateTimeEnd: yyyy-MM-dd} 23:59:59'";
listadoDataGridView.DataSource = ConsultasSql.TopItems("document_history", "product", "quantity", "subtotal", "type_document", "VENTA", "status_document", "Autorizado", "date_of_issue", fechaInicio, fechaFin, "5");
listadoDataGridView.Columns["product"].Width = 318;
listadoDataGridView.Columns["product"].DefaultCellStyle.Padding = new Padding(15, 0, 0, 0);
listadoDataGridView.Columns["quantity"].Width = 60;
listadoDataGridView.Columns["quantity"].DefaultCellStyle.Format = "N0";
listadoDataGridView.Columns["quantity"].DefaultCellStyle.Padding = new Padding(0, 0, 15, 0);
listadoDataGridView.Columns["quantity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
listadoDataGridView.Columns["subtotal"].Width = 120;
listadoDataGridView.Columns["subtotal"].DefaultCellStyle.Format = "C2";
listadoDataGridView.Columns["subtotal"].DefaultCellStyle.Padding = new Padding(0, 0, 15, 0);
listadoDataGridView.Columns["subtotal"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
listadoDataGridView.Columns["date_of_issue"].Visible = false;
listadoDataGridView.DefaultCellStyle.SelectionBackColor = ColorTranslator.FromHtml("#E5E5E5");
listadoDataGridView.DefaultCellStyle.SelectionForeColor = ColorTranslator.FromHtml("#000000");
DataTable dataValorTotal = ConsultasSql.SumaTotalItem("facturas_autorizadas", "total_value", "date_of_issue", fechaInicio, fechaFin);
decimal.TryParse(dataValorTotal.Rows[0][0].ToString(), out decimal totalVentasDecimal);
totalVentasTextBox.Text = Math.Round(totalVentasDecimal, 2).ToString("C2");
DataTable dataTotalFacturasImpresas = ConsultasSql.TotalFacturas("facturas_autorizadas", "!=", "date_of_issue", fechaInicio, fechaFin);
int.TryParse(dataTotalFacturasImpresas.Rows[0][0].ToString(), out int totalFacturasImpresas);
DataTable dataTotalFacturasGuardadas = ConsultasSql.TotalFacturas("facturas_autorizadas", "=", "date_of_issue", fechaInicio, fechaFin);
int.TryParse(dataTotalFacturasGuardadas.Rows[0][0].ToString(), out int totalFacturasGuardadas);
int totalFacturas = totalFacturasImpresas + totalFacturasGuardadas;
if (totalFacturas == 0)
{
totalFacturasTextBox.Text = "No hay facturas registradas";
facturasImpresasTextBox.Text = "";
facturasGuardadasTextBox.Text = "";
}
else if (totalFacturas >= 1)
{
totalFacturasTextBox.Text = $"Facturas totales : {totalFacturas}";
facturasImpresasTextBox.Text = $"Facturas impresas : {totalFacturasImpresas}";
facturasGuardadasTextBox.Text = $"Facturas guardadas : {totalFacturasGuardadas}";
}
stockDataGridView.DataSource = ConsultasSql.ConsultaGeneral("product", "stock", "ASC", "stock_indicator", "ASC", "name, stock, minimum_stock_level, stock_indicator");
stockDataGridView.Columns["name"].Width = 408;
stockDataGridView.Columns["name"].DefaultCellStyle.Padding = new Padding(15, 0, 0, 0);
stockDataGridView.Columns["stock"].Width = 90;
stockDataGridView.Columns["stock"].DefaultCellStyle.Format = "N0";
stockDataGridView.Columns["minimum_stock_level"].Visible = false;
stockDataGridView.Columns["stock_indicator"].Visible = false;
stockDataGridView.DefaultCellStyle.SelectionBackColor = ColorTranslator.FromHtml("#E5E5E5");
stockDataGridView.DefaultCellStyle.SelectionForeColor = ColorTranslator.FromHtml("#000000");
stockDataGridView.DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#ACFAC1");
listadoDataGridView.ClearSelection();
stockDataGridView.ClearSelection();
}
