private void InicioSesion()
{
Acceso = Conexion.InicializarInstanciaMySQL(Conexion.User, Conexion.Password, Settings.Default.servidor, Conexion.Database);
if (Acceso == "True")
{
DataTableUser = ConsultasSql.ConsultaIndividual("user", "*", "username", "=", $"{ textBoxUsuario.Text }", "password", "=", $"{ textBoxClave.Text }");
if (DataTableUser.Rows.Count >= 1)
{
Settings.Default.username = textBoxUsuario.Text;
Settings.Default.Save();
Settings.Default.Reload();
MainForm.Show();
Hide();
}
else
{
MessageBox.Show("Usuario y/o contraseña erroneos", "CompudavSystem", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Intentos += 1;
if (Intentos >= 3)
{
textBoxClave.Text = "";
textBoxUsuario.Text = "";
textBoxUsuario.Focus();
}
else
{
textBoxClave.Text = "";
textBoxClave.Focus();
}
}
}
}
private void GetIdContact(string idNumber)
{
DataTable data = ConsultasSql.ConsultaIndividual("contact", "id", "id_number", "=", idNumber);
if (data.Rows.Count > 0)
{
IdContact = data.Rows[0][0].ToString();
}
else
{
IdContact = "nuevo";
}
}
private void ListadoDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && listadoDataGridView.CurrentCell.OwningColumn.Name == "anularButton")
{
if ($"{listadoDataGridView.Rows[e.RowIndex].Cells["status_document"].Value}" == "Anulado")
{
MessageBox.Show("Factura anulada", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (MessageBox.Show($"¿Estas seguro que deseas anular la factura \n#{listadoDataGridView.Rows[e.RowIndex].Cells["number"].Value} del contacto \n{listadoDataGridView.Rows[e.RowIndex].Cells["name"].Value}?", "Anular factura", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
DataTable dataStatus = ConsultasSql.ConsultaIndividual("status_document", "id", "name", "=", "Anulado");
string statusDocumentId = dataStatus.Rows[0][0].ToString();
if (ConsultasSql.Actualizar("document", $"statusDocumentId = '{statusDocumentId}'", "id", $"'{listadoDataGridView.Rows[e.RowIndex].Cells["idDocument"].Value}'"))
{
DataTable dataInvoiceDetailment = ConsultasSql.ConsultaIndividual("invoice_detailment", "quantity, productId", "documentId", "=", $"{listadoDataGridView.Rows[e.RowIndex].Cells["idDocument"].Value}");
for (int i = 0; i < dataInvoiceDetailment.Rows.Count; i++)
{
DataTable dataMinimumStock = ConsultasSql.ConsultaIndividual("product", "stock, minimum_stock_level", "id", "=", $"{dataInvoiceDetailment.Rows[i]["productId"]}");
int minimumStockInt = int.Parse(dataMinimumStock.Rows[0][1].ToString());
int stockInt = int.Parse(dataMinimumStock.Rows[0][0].ToString());
decimal quantityDecimal = decimal.Parse(dataInvoiceDetailment.Rows[i][0].ToString());
int quantityInt = Convert.ToInt32(quantityDecimal);
if ($"{listadoDataGridView.Rows[e.RowIndex].Cells["type_document"].Value}" == "COMPRA")
{
stockInt -= quantityInt;
ConsultasSql.Actualizar("product", $"stock = {stockInt}, stock_indicator = { stockInt - minimumStockInt}", "id", $"'{dataInvoiceDetailment.Rows[i]["productId"]}'");
}
if ($"{listadoDataGridView.Rows[e.RowIndex].Cells["type_document"].Value}" == "VENTA")
{
stockInt += quantityInt;
ConsultasSql.Actualizar("product", $"stock = {stockInt}, stock_indicator = { stockInt + minimumStockInt}", "id", $"'{dataInvoiceDetailment.Rows[i]["productId"]}'");
}
}
DatosIniciales();
}
}
}
}
}
private void PresetComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
dataFilter = ConsultasSql.ConsultaIndividual(TableBdd, "*", "preset", "=", presetComboBox.Text);
if (dataFilter.Rows.Count > 0)
{
DataRow dataRow = dataFilter.Rows[0];
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);
}
}
private string GetStockItem(string tabla, string campo, string valor, int posicion)
{
DataTable data = ConsultasSql.ConsultaIndividual(tabla, "stock, minimum_stock_level", campo, "=", valor);
return(data.Rows[0][posicion].ToString());
}
private string GetIdItemTable(string tabla, string campo1, string valor1, string campo2, string valor2)
{
DataTable data = ConsultasSql.ConsultaIndividual(tabla, "id", campo1, "=", valor1, campo2, "=", valor2);
return(data.Rows[0][0].ToString());
}
