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