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