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(); }
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; }