private void loadTemporal() { // string query = @"select a.*, b.Descripcion as Tem_Medicamento from Tabla_Catalogo_TicketTemp a // left join Tabla_Catalogo_ProductosFarmacia b on b.Id_Productos = a.Id_Medicamento where a.Id_Ticket = @Id_Ticket"; string query = @"select a.*, b.Descripcion as Tem_Medicamento from Tabla_Catalogo_TicketTemp a left join Tabla_Catalogo_ProductosFarmacia b on b.Id_Productos = a.Id_Medicamento"; var oneTemp = new Tabla_Catalogo_Ticket(); oneTemp.Id_Ticket = 1; //oneTemp.Id_FichaIdentificacion = Id_FichaIdentificacion; Helpers h = new Helpers(); var lTemporal = h.GetAllParametized(query, oneTemp); rptTemporal.DataSource = lTemporal; rptTemporal.DataBind(); sumar(); //////////// //string queryTemplate = "select Id_Template, Tem_Nombre from tabla_receta_template group by Id_Template , Tem_Nombre"; //var lTemplates = h.GetAllParametized(queryTemplate, new Tabla_Receta_TemplateDTO()); //ddlTemplate.DataSource = lTemplates; //ddlTemplate.DataBind(); loadTemplate(); }
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; }
protected void InsertarMedicamento() { var oneMedicamento = new ProductosFarmacia(); oneMedicamento.Descripcion = txtSearch.Text; oneMedicamento = MedicamentoFarmaciaDAO.GetOneByName(oneMedicamento); var oneTemp = new Tabla_Catalogo_Ticket(); oneTemp.Id_Medicamento = oneMedicamento.Id_Productos; oneTemp.RazonSocial = oneMedicamento.Nombre; oneTemp.Costo = oneMedicamento.PrecioVenta; oneTemp.NombreMedicamento = oneMedicamento.Nombre; string query = "insert into Tabla_Catalogo_TicketTemp (Id_Medicamento, RazonSocial, Costo, NombreMedicamento) values (@Id_Medicamento, @RazonSocial, @Costo, @NombreMedicamento)"; Helpers h = new Helpers(); h.ExecuteNonQueryParam(query, oneTemp); //txtDos.Value = ""; //txtNot.Value = ""; txtSearch.Text = ""; //string script = "AlertaGuardar();"; // ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); Page.Response.Redirect(Page.Request.Url.ToString(), true); //loadTemporal(); return; }
protected void saveToConsulta(object sender, EventArgs e) { var oneConsulta = new Tabla_Catalogo_ConceptoPagoDTO(); oneConsulta.Id_ConceptoPago = Convert.ToInt32(ddlConsulta.SelectedValue); oneConsulta = ConseptoPagoDAO.GetOne(oneConsulta); var oneTemp = new Tabla_Catalogo_Ticket(); oneTemp.Id_Medicamento = oneConsulta.Id_ConceptoPago; oneTemp.RazonSocial = ""; oneTemp.Costo = Convert.ToInt32(oneConsulta.PrecioUnitario); oneTemp.NombreMedicamento = oneConsulta.NombreCorto_ConceptoPago; string query = "insert into Tabla_Catalogo_TicketTemp (Id_Medicamento, RazonSocial, Costo, NombreMedicamento) values (@Id_Medicamento, @RazonSocial, @Costo, @NombreMedicamento)"; Helpers h = new Helpers(); h.ExecuteNonQueryParam(query, oneTemp); //txtDos.Value = ""; //txtNot.Value = ""; txtSearch.Text = ""; //string script = "AlertaGuardar();"; // ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); Page.Response.Redirect(Page.Request.Url.ToString(), true); //loadTemporal(); return; }
public void RemoveTemporal(object sender, EventArgs e) { var linkButton = (LinkButton)sender; var Id_Temporal = linkButton.CommandArgument; string query = @"delete Tabla_Catalogo_TicketTemp Where Id_Ticket = @Id_Ticket "; var oneTemp = new Tabla_Catalogo_Ticket(); oneTemp.Id_Ticket = Convert.ToInt32(Id_Temporal); Helpers h = new Helpers(); h.ExecuteNonQueryParam(query, oneTemp); Label1.Text = ""; loadTemporal(); }