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; }
protected void Page_Load(object sender, EventArgs e) { string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; TextBox1.Attributes.Add("OnBlur", "sumar()"); TextBox3.Attributes.Add("OnBlur", "sumar()"); ticket(); if (!IsPostBack) { //Tabla imprimir receta DataTable dt = new DataTable(); dt.Columns.Add("Nombre"); dt.Columns.Add("Fecha"); MostrarGridRecetaPrevia(); ddlConsulta.DataSource = ConseptoPagoDAO.GetAll(); ddlConsulta.DataBind(); SqlConnection cnn; cnn = new SqlConnection(conexion); cnn.Open(); string consulta = "select Id_ConsultaReceta from Tabla_Registro_ConsultaReceta where Id_Consulta=" + Id_Consulta + ""; SqlCommand comando = new SqlCommand(consulta, cnn); Id_ConsultaReceta = Convert.ToInt32(comando.ExecuteScalar()); Session["Id_ConsultasRecetas"] = Id_ConsultaReceta; if (Id_ConsultaReceta != 0) { SqlCommand comando2 = new SqlCommand("SP_Registro_ConsultasRecetas", cnn); comando2.CommandType = CommandType.StoredProcedure; comando2.Parameters.AddWithValue("@Opcion", "ENCONTRAR"); comando2.Parameters.AddWithValue("@Id_ConsultaReceta", Id_ConsultaReceta); SqlDataReader reader = comando2.ExecuteReader(); if (reader.Read()) { txtmedicamento.Text = reader.GetString(reader.GetOrdinal("Medicamento_ConsultaReceta")).ToString(); //txtdosis.Text = reader.GetString(reader.GetOrdinal("Dosis_ConsultaReceta")).ToString().Trim(); //txtnotas.Text = reader.GetString(reader.GetOrdinal("Notas_ConsultaReceta")).ToString().Trim(); } } else { DateTime hoy = DateTime.Now; //fecha_actual = hoy.ToString("dd-MM-yyyy HH:mm:ss"); //txtfechaconsulta.Text = fecha_actual; //txtnombre.Text = NombreCompleto; } cnn.Close(); sumar(); loadTemporal(); loadMedicamentos(); } if (!IsPostBack) { if (Id_FichaIdentificacion != 0) { loadUsuario(); //Label1.Text = NombreCompleto; SqlConnection cnn; cnn = new SqlConnection(conexion); cnn.Open(); string consulta = "select Id_Consulta from Tabla_Registro_Consulta where Id_Agenda=" + Id_Agenda + ""; SqlCommand comando = new SqlCommand(consulta, cnn); Id_Consulta = Convert.ToInt32(comando.ExecuteScalar()); Session["Id_Consultas"] = Id_Consulta; } } }