private void Guardar()
{
string name = descripcionTextBox.Text.Replace("'", "\\'").Trim();
if (name.Length > 0)
{
if (aceptarButton.Text == "Actualizar")
{
if (ConsultasSql.Actualizar(TableBdd, $"name = '{name}'", "id", $"'{IdField}'"))
{
CerrarYRefrescarFormulario();
}
}
if (aceptarButton.Text == "Guardar")
{
if (ConsultasSql.Insertar(TableBdd, "name", $"'{ name }'"))
{
CerrarYRefrescarFormulario();
}
}
}
else
{
MessageBox.Show("Campo descripcion en blanco");
}
}
private void Guardar()
{
string idNumber = (idNumberTextBox.Text.Trim() == "") ? "null" : $"'{idNumberTextBox.Text.Trim()}'";
string businessName = businessNameTextBox.Text.Replace("'", "\\'").Trim();
businessName = (businessName == "") ? "null" : $"'{businessName}'";
string tradename = tradenameTextBox.Text.Replace("'", "\\'").Trim();
tradename = (tradename == "") ? "null" : $"'{tradename}'";
string address = addressTextBox.Text.Replace("'", "\\'").Trim();
address = (address == "") ? "null" : $"'{address}'";
string landline = (landlineTextBox.Text.Trim() == "") ? "null" : $"'{landlineTextBox.Text.Trim()}'";
string mobilePhone = (mobilePhoneTextBox.Text.Trim() == "") ? "null" : $"'{mobilePhoneTextBox.Text.Trim()}'";
string email = emailTextBox.Text.Replace("'", "\\'").Trim();
email = (email == "") ? "null" : $"'{email}'";
bool client = clientCheckBox.Checked;
bool provider = providerCheckBox.Checked;
bool specialTaxpayer = specialTaxpayerCheckBox.Checked;
string additionalInformation = additionalInformationTextBox.Text.Replace("'", "\\'").Trim();
additionalInformation = (additionalInformation == "") ? "null" : $"'{additionalInformation}'";
string typeIdentification = (typeIdentificationComboBox.SelectedValue.ToString() == "nulo") ? "null" : $"'{typeIdentificationComboBox.SelectedValue}'";
if (aceptarButton.Text == "Actualizar")
{
if (ConsultasSql.Actualizar(TableBdd,
$"id_number = {idNumber}, business_name = {businessName}, tradename = {tradename}, address = {address}, " +
$"landline = {landline}, mobile_phone = {mobilePhone}, email = {email}, client = {client}, provider = {provider}, " +
$"special_taxpayer = {specialTaxpayer}, additional_information = {additionalInformation}, typeIdentificationId = {typeIdentification}",
"id", $"'{IdField}'"))
{
CerrarYRefrescarFormulario();
}
}
if (aceptarButton.Text == "Guardar")
{
if (ConsultasSql.Insertar(
TableBdd,
"id_number, business_name, tradename, address, landline, mobile_phone, " +
"email, client, provider, special_taxpayer, additional_information, typeIdentificationId",
$"{idNumber}, {businessName}, {tradename}, {address}, {landline}, {mobilePhone}, {email}, " +
$"{client}, {provider}, {specialTaxpayer}, {additionalInformation}, {typeIdentification}"
))
{
CerrarYRefrescarFormulario();
}
}
}
private void AceptarButton_Click(object sender, EventArgs e)
{
string preset = $"'{presetComboBox.Text}'";
string printerName = $"'{printerNameComboBox.Text}'";
string printerFontFamily = $"'{fontFamilyComboBox.Text}'";
string printerFontSize = $"{fontSizeTextBox.Text}";
string printerHeaderPositionX = $"{headerXTextBox.Text}";
string printerHeaderPositionY = $"{headerYTextBox.Text}";
string printerMainPositionX = $"{mainXTextBox.Text}";
string printerMainPositionY = $"{mainYTextBox.Text}";
string printerFooterPositionX = $"{footerXTextBox.Text}";
string printerFooterPositionY = $"{footerYTextBox.Text}";
string printerPageWidth = $"{printerPageWidthTextBox.Text}";
string printerPageHeight = $"{printerPageHeightTextBox.Text}";
string numberInvoice = $"'{numberDocument1TextBox.Text}{numberDocument2TextBox.Text}{numberDocument3TextBox.Text}'";
if (aceptarButton.Text == "Guardar")
{
if (ConsultasSql.Insertar(TableBdd,
"preset, printerName, printerFontFamily, printerFontSize, printerHeaderPositionX, " +
"printerHeaderPositionY, printerMainPositionX, printerMainPositionY, " +
"printerFooterPositionX, printerFooterPositionY, printerPageWidth, printerPageHeight, numberInvoice",
$"{preset}, {printerName}, {printerFontFamily}, {printerFontSize}, {printerHeaderPositionX}, " +
$"{printerHeaderPositionY}, {printerMainPositionX}, {printerMainPositionY}, " +
$"{printerFooterPositionX}, {printerFooterPositionY}, {printerPageWidth}, {printerPageHeight}, {numberInvoice}"
))
{
CargarDatos();
}
}
if (aceptarButton.Text == "Actualizar")
{
if (ConsultasSql.Actualizar(TableBdd,
$"preset = {preset}, printerName = {printerName}, printerFontFamily = {printerFontFamily}, printerFontSize = {printerFontSize}, " +
$"printerHeaderPositionX = {printerHeaderPositionX}, printerHeaderPositionY = {printerHeaderPositionY}, printerMainPositionX = {printerMainPositionX}, " +
$"printerMainPositionY = {printerMainPositionY}, printerFooterPositionX = {printerFooterPositionX}, printerFooterPositionY = {printerFooterPositionY}, " +
$"printerPageWidth = {printerPageWidth}, printerPageHeight = {printerPageHeight}, numberInvoice = {numberInvoice}",
"id", $"'{presetComboBox.SelectedValue}'"))
{
MessageBox.Show("Preset actualizado correctamente");
}
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
PrinterFont = new Font(Settings.Default.printerFontFamily, Settings.Default.printerFontSize, FontStyle.Regular);
PrinterName = Settings.Default.printerName;
printerLabel.Text = PrinterName;
ValidaCampo.Requerido(idNumberTextBox, "Por favor ingrese el numero de Identificación");
ValidaCampo.Requerido(nameTextBox, "Por favor ingrese el Nombre");
ValidaCampo.Requerido(addressTextBox, "Por favor ingrese la Dirección");
ValidaCampo.Requerido(listadoDataGridView, mainPanel, "Por favor selecciona al menos un item");
ValidaCampo.Requerido(numberDocument1TextBox, numberDocument3TextBox, 3, "Por favor escribe correctamente el numero de factura");
ValidaCampo.Requerido(numberDocument2TextBox, numberDocument3TextBox, 3, "Por favor escribe correctamente el numero de factura");
ValidaCampo.Requerido(numberDocument3TextBox, numberDocument3TextBox, 9, "Por favor escribe correctamente el numero de factura");
string idNumber = (idNumberTextBox.Text.Trim() == "") ? "null" : idNumberTextBox.Text.Trim();
string businessName = nameTextBox.Text.Replace("'", "\\'").Trim();
businessName = (businessName == "") ? "null" : $"'{businessName}'";
string address = addressTextBox.Text.Replace("'", "\\'").Trim();
address = (address == "") ? "null" : $"'{address}'";
string additional_information = additionalInformationTextBox.Text.Replace("'", "\\'").Trim();
additional_information = (additional_information == "") ? "null" : $"'{additional_information}'";
string landline = (landlineTextBox.Text.Trim() == "") ? "null" : landlineTextBox.Text.Trim();
string numberInvoice = $"{numberDocument1TextBox.Text}{numberDocument2TextBox.Text}{numberDocument3TextBox.Text}";
string typeIssuanceId = $"'{GetIdItemTable("type_issuance", "name", "Emisión Normal")}'";
string typeDocumentId = $"'{GetIdItemTable("type_document", "name", "FACTURA COMPRA")}'";
string statusDocumentId = $"'{GetIdItemTable("status_document", "name", "Autorizado")}'";
string paymentMethodId = $"'{GetIdItemTable("payment_method", "name", "Otros con utilización del Sistema Financiero")}'";
DateTime dateTime = dateIssueDateTimePicker.Value;
string date_of_issue = $"'{dateTime: yyyy-MM-dd} 18:59:59'";
if (ValidaCampo.ErrorStatus)
{
if (SavedTimes == 0)
{
GetIdContact(idNumber);
if (IdContact == "nuevo")
{
if (ConsultasSql.Insertar("contact",
"id_number, business_name, address, landline, provider",
$"'{idNumber}', {businessName}, {address}, '{landline}', true"))
{
GetIdContact(idNumber);
}
}
string idDocument = $"'{Guid.NewGuid()}'";
string contactId = $"{IdContact}";
if (ConsultasSql.Insertar("document", idDocument, "number, date_of_issue, subtotal, additional_discount, total_discount, subtotal_iva0, " +
"subtotal_iva12, iva_value, total_value, additional_information, typeIssuanceId, typeDocumentId, statusDocumentId, contactId, paymentMethodId",
$"'{numberInvoice}', {date_of_issue}, {subtotalTextBox.Text}, {valorDescuentoTextBox.Text}, {Math.Round(SubtotalDescuentoDecimal, 2)}, {subtotal0TextBox.Text}, " +
$"{subtotal12TextBox.Text}, {ivaTextBox.Text}, {totalTextBox.Text}, {additional_information}, {typeIssuanceId}, {typeDocumentId}, {statusDocumentId}, '{contactId}', {paymentMethodId}"))
{
for (int i = 0; i < listadoDataGridView.Rows.Count - 1; i++)
{
string quantity = $"{listadoDataGridView.Rows[i].Cells["cantidadColumn"].Value}";
string unitary_discount = $"{listadoDataGridView.Rows[i].Cells["cantidadColumn"].Value}";
string subtotal = $"{listadoDataGridView.Rows[i].Cells["subtotalColumn"].Value}";
string productId = $"{listadoDataGridView.Rows[i].Cells["idColumn"].Value}";
if (ConsultasSql.Insertar("invoice_detailment", "quantity, unitary_discount, subtotal, documentId, productId",
$"{quantity}, {unitary_discount}, {subtotal}, {idDocument}, '{productId}'"))
{
string stock = GetStockItem("product", "id", productId, 0);
string minimumStock = GetStockItem("product", "id", productId, 1);
int quantityInt = int.Parse(quantity);
int stockInt = int.Parse(stock);
int minimumStockInt = int.Parse(minimumStock);
stockInt += quantityInt;
ConsultasSql.Actualizar("product", $"stock = {stockInt}, stock_indicator = {stockInt + minimumStockInt}", "id", $"'{productId}'");
}
}
MessageBox.Show("Factura de compra registrada correctamente.");
SavedTimes += 1;
saveButton.BackColor = ColorTranslator.FromHtml("#56BA54");
saveButton.Text = "Registrado";
listadoDataGridView.Enabled = false;
idNumberTextBox.Enabled = false;
nameTextBox.Enabled = false;
addressTextBox.Enabled = false;
landlineTextBox.Enabled = false;
additionalInformationTextBox.Enabled = false;
descuentoTextBox.Enabled = false;
descuentoButton.Enabled = false;
}
}
}
}
private void Guardar()
{
string mainCode = mainCodeTextBox.Text.Replace("'", "\\'").Trim();
mainCode = (mainCode == "") ? "null" : $"'{mainCode}'";
string auxCode = auxCodeTextBox.Text.Replace("'", "\\'").Trim();
auxCode = (auxCode == "") ? "null" : $"'{auxCode}'";
string name = nameTextBox.Text.Replace("'", "\\'").Trim();
name = (name == "") ? "null" : $"'{name}'";
string descripcion = descripcionTextBox.Text.Replace("'", "\\'").Trim();
descripcion = (descripcion == "") ? "null" : $"'{descripcion}'";
string stock = (stockTextBox.Text.Trim() == "") ? "0" : stockTextBox.Text.Trim();
string minimumStockLevel = (minimumStockLevelTextBox.Text.Trim() == "") ? "0" : minimumStockLevelTextBox.Text.Trim();
string stockIndicator = (int.Parse(stock) - int.Parse(minimumStockLevel)).ToString();
string cost = (costTextBox.Text.Trim() == "") ? "null" : costTextBox.Text.Trim();
string percentagePrice1 = (percentagePrice1TextBox.Text.Trim() == "") ? "null" : percentagePrice1TextBox.Text.Trim();
string price1 = (price1TextBox.Text.Trim() == "") ? "null" : price1TextBox.Text.Trim();
string pvp = (pvp1TextBox.Text.Trim() == "") ? "null" : pvp1TextBox.Text.Trim();
string percentagePrice2 = (percentagePrice2TextBox.Text.Trim() == "") ? "null" : percentagePrice2TextBox.Text.Trim();
string price2 = (price2TextBox.Text.Trim() == "") ? "null" : price2TextBox.Text.Trim();
string pvp2 = (pvp2TextBox.Text.Trim() == "") ? "null" : pvp2TextBox.Text.Trim();
string percentagePrice3 = (percentagePrice3TextBox.Text.Trim() == "") ? "null" : percentagePrice3TextBox.Text.Trim();
string price3 = (price3TextBox.Text.Trim() == "") ? "null" : price3TextBox.Text.Trim();
string pvp3 = (pvp3TextBox.Text.Trim() == "") ? "null" : pvp3TextBox.Text.Trim();
string category = (categoryComboBox.SelectedValue.ToString() == "nulo") ? "null" : $"'{categoryComboBox.SelectedValue}'";
string manufacturer = (manufacturerComboBox.SelectedValue.ToString() == "nulo") ? "null" : $"'{manufacturerComboBox.SelectedValue}'";
string iceRate = (iceRateComboBox.SelectedValue.ToString() == "nulo") ? "null" : $"'{iceRateComboBox.SelectedValue}'";
string ivaRate = (ivaRateComboBox.SelectedValue.ToString() == "nulo") ? "null" : $"'{ivaRateComboBox.SelectedValue}'";
string typeProduct = (typeProductComboBox.SelectedValue.ToString() == "nulo") ? "null" : $"'{typeProductComboBox.SelectedValue}'";
string unitMeasurement = (unitMeasurementComboBox.SelectedValue.ToString() == "nulo") ? "null" : $"'{unitMeasurementComboBox.SelectedValue}'";
if (aceptarButton.Text == "Actualizar")
{
if (ConsultasSql.Actualizar(TableBdd,
$"main_code = {mainCode}, aux_code = {auxCode}, name = {name}, detail = {descripcion}, " +
$"stock = {stock}, minimum_stock_level = {minimumStockLevel}, stock_indicator = {stockIndicator}, cost = {cost}, " +
$"percentage_price = {percentagePrice1}, price = {price1}, pvp = {pvp}, " +
$"percentage_price2 = {percentagePrice2}, price2 = {price2}, pvp2 = {pvp2}, " +
$"percentage_price3 = {percentagePrice3}, price3 = {price3}, pvp3 = {pvp3}, " +
$"categoryId = {category}, manufacturerId = {manufacturer}, iceRateId = {iceRate}, " +
$"ivaRateId = {ivaRate}, typeProductId = {typeProduct}, unitMeasurementId = {unitMeasurement}",
"id", $"'{IdField}'"))
{
CerrarYRefrescarFormulario();
}
}
if (aceptarButton.Text == "Guardar")
{
if (ConsultasSql.Insertar(
TableBdd,
"main_code, aux_code, name, detail, stock, minimum_stock_level, stock_indicator, " +
"cost, percentage_price, price, pvp, percentage_price2, price2, pvp2, percentage_price3, price3, pvp3, " +
"categoryId, manufacturerId, iceRateId, ivaRateId, typeProductId, unitMeasurementId",
$"{mainCode}, {auxCode}, {name}, {descripcion}, {stock}, {minimumStockLevel}, {stockIndicator}," +
$"{cost}, {percentagePrice1}, {price1}, {pvp}, {percentagePrice2}, {price2}, {pvp2}, {percentagePrice3}, {price3}, {pvp3}, " +
$"{category}, {manufacturer}, {iceRate}, {ivaRate}, {typeProduct}, {unitMeasurement}"
))
{
CerrarYRefrescarFormulario();
}
}
}
