protected void saveToTickets(object sender, EventArgs e)
        {
            string queryInv = "";

            string query = "select * from Tabla_Catalogo_TicketTemp";
            Helpers h = new Helpers();
            var oneTemp = new Tabla_Catalogo_Ticket();
            var lTemporal = h.GetAllParametized(query, oneTemp);
            string queryInsert = "insert into Tabla_Catalogo_Ticket (No_Tiket, Id_Medicamento, NombreMedicamento, RazonSocial, Costo, Fecha) values (@No_Tiket, @Id_Medicamento, @NombreMedicamento, @RazonSocial, @Costo, @Fecha)";
            var oneT = new Tabla_Catalogo_TicketDTO();
            string queryLast = "SELECT TOP 1 No_Tiket FROM Tabla_Catalogo_Ticket ORDER BY No_Tiket DESC";
            var lIdTemplate = h.GetAllParametized(queryLast, oneT);
            if (lIdTemplate.Count == 0)
            {
                oneT.No_Tiket = 0;
            }
            else
            {
                oneT.No_Tiket = lIdTemplate[0].No_Tiket + 1;
            }
            foreach (var y in lTemporal)
            {
                var oneTemplate = new Tabla_Catalogo_TicketDTO();
                oneTemplate.Id_Medicamento = y.Id_Medicamento;
                oneTemplate.No_Tiket = oneT.No_Tiket;
                oneTemplate.NombreMedicamento = y.NombreMedicamento;
                oneTemplate.RazonSocial = "";
                oneTemplate.Costo = y.Costo;

                oneTemplate.Fecha = DateTime.Now;

                h.ExecuteNonQueryParam(queryInsert, oneTemplate);

                queryInv = "update Tabla_Catalogo_ProductosFarmacia set Existencias = Existencias - 1 where Id_Productos = "+y.Id_Medicamento+"";
                h.ExecuteNonQueryParam(queryInv, oneTemp);
            }

               // string script = "AlertaGuardar();";
               // ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
            borrar();
            loadTemporal();
            ticket();

            if (CheckboxFacturar.Checked == true)
            {
                Response.Redirect("Facturar.aspx?No_Tiket="+oneT.No_Tiket);
            }
            return;
        }
 public void ticket()
 {
     Helpers h = new Helpers();
     var oneT = new Tabla_Catalogo_TicketDTO();
     string queryLast = "SELECT TOP 1 No_Tiket FROM Tabla_Catalogo_Ticket ORDER BY No_Tiket DESC";
     var lIdTemplate = h.GetAllParametized(queryLast, oneT);
     lblTicket.Text = (lIdTemplate[0].No_Tiket + 1).ToString();
 }