Exemplo n.º 1
0
        private void listadoDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0 && listadoDataGridView.CurrentCell.OwningColumn.Name == "editButton")
            {
                DatosGuardarActualizar
                (
                    listadoDataGridView.Rows[e.RowIndex].Cells["id"].Value.ToString(),
                    "Actualizar",
                    listadoDataGridView.Rows[e.RowIndex].Cells["id_number"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["business_name"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["tradename"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["address"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["landline"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["mobile_phone"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["email"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["client"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["provider"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["special_taxpayer"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["additional_information"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["typeIdentificationId"].Value.ToString()
                );
            }

            if (e.RowIndex >= 0 && listadoDataGridView.CurrentCell.OwningColumn.Name == "deleteButton")
            {
                if (MessageBox.Show($"¿Estas seguro que deseas eliminar a {listadoDataGridView.Rows[e.RowIndex].Cells["business_name"].Value}?", "Eliminar contacto", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    if (ConsultasSql.Eliminar(TableBdd, "id", $"'{listadoDataGridView.Rows[e.RowIndex].Cells["id"].Value}'"))
                    {
                        DatosIniciales();
                    }
                }
            }
        }
Exemplo n.º 2
0
        private void ListadoDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0 && listadoDataGridView.CurrentCell.OwningColumn.Name == "editButton")
            {
                DatosGuardarActualizar
                (
                    listadoDataGridView.Rows[e.RowIndex].Cells["id"].Value.ToString(),
                    "Actualizar",
                    listadoDataGridView.Rows[e.RowIndex].Cells["main_code"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["aux_code"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["name"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["detail"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["stock"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["minimum_stock_level"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["cost"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["percentage_price"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["price"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["pvp"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["percentage_price2"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["price2"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["pvp2"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["percentage_price3"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["price3"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["pvp3"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["categoryId"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["manufacturerId"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["iceRateId"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["ivaRateId"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["typeProductId"].Value.ToString(),
                    listadoDataGridView.Rows[e.RowIndex].Cells["unitMeasurementId"].Value.ToString()
                );
            }

            if (e.RowIndex >= 0 && listadoDataGridView.CurrentCell.OwningColumn.Name == "deleteButton")
            {
                if (MessageBox.Show($"¿Estas seguro que deseas eliminar {listadoDataGridView.Rows[e.RowIndex].Cells["name"].Value} del catálogo?", "Eliminar item", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    if (ConsultasSql.Eliminar(TableBdd, "id", $"'{listadoDataGridView.Rows[e.RowIndex].Cells["id"].Value}'"))
                    {
                        DatosIniciales();
                    }
                }
            }
        }
Exemplo n.º 3
0
        private void ListadoDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0 && listadoDataGridView.CurrentCell.OwningColumn.Name == "editButton")
            {
                DatosGuardarActualizar
                (
                    listadoDataGridView.Rows[e.RowIndex].Cells["id"].Value.ToString(),
                    "Actualizar",
                    listadoDataGridView.Rows[e.RowIndex].Cells["name"].Value.ToString()
                );
            }

            if (e.RowIndex >= 0 && listadoDataGridView.CurrentCell.OwningColumn.Name == "deleteButton")
            {
                if (MessageBox.Show("¿Estas seguro que deseas eliminar este item?", "Eliminar item", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    if (ConsultasSql.Eliminar(TableBdd, "id", $"'{listadoDataGridView.Rows[e.RowIndex].Cells["id"].Value}'"))
                    {
                        DatosIniciales();
                    }
                }
            }
        }