using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Configuration.Provider;


using System.Configuration;

public partial class Pages_Default : System.Web.UI.Page
{



    SqlConnection conn;
    SqlCommand cmd;
    protected void Page_Load(object sender, EventArgs e)
    {

        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["eyesConnectionString"].ToString();
        conn.Open();
        cmd = new SqlCommand();
        cmd.CommandText = "MeasureGlasses";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Connection = conn;
        cmd.Parameters.Add("@PID", SqlDbType.Int).Value = txtIDpatient.Text;
        cmd.Parameters.Add("@SphereRE", SqlDbType.Int).Value = txtSphereRE.Text;
        cmd.Parameters.Add("@CylinderRE", SqlDbType.Int).Value = txtCylinderRE.Text;
        cmd.Parameters.Add("@AxisRE", SqlDbType.Int).Value = txtAxisRE.Text;
        cmd.Parameters.Add("@PrismRE", SqlDbType.Int).Value = txtPrismRE.Text;
        cmd.Parameters.Add("@ReadingaddRE", SqlDbType.Int).Value = txtReadingaddRE.Text;
        cmd.Parameters.Add("@SphereLE", SqlDbType.Int).Value = txtSphereLE.Text;
        cmd.Parameters.Add("@CylinderLE", SqlDbType.Int).Value = txtCylinderLE.Text;
        cmd.Parameters.Add("@AxisLE", SqlDbType.Int).Value = txtAxisLE.Text;
        cmd.Parameters.Add("@PrismLE", SqlDbType.Int).Value = txtPrismLE.Text;
        cmd.Parameters.Add("@ReadingaddLE", SqlDbType.Int).Value = txtReadingaddLE.Text;
        cmd.Parameters.Add("@DistanceUnaidedRE", SqlDbType.Int).Value = txtDistanceUnaidedRE.Text;
        cmd.Parameters.Add("@DistanceAidedRE", SqlDbType.Int).Value = txtDistanceAidedRE.Text;
        cmd.Parameters.Add("@NearUnaidedRE", SqlDbType.Int).Value = txtNearUnaidedRE.Text;
        cmd.Parameters.Add("@NearAidedRE", SqlDbType.Int).Value = txtNearAidedRE.Text;
        cmd.Parameters.Add("@DistanceUnaidedLE", SqlDbType.Int).Value = txtDistanceUnaidedLE.Text;
        cmd.Parameters.Add("@DistanceAidedLE", SqlDbType.Int).Value = txtDistanceAidedLE.Text;
        cmd.Parameters.Add("@NearUnaidedLE", SqlDbType.Int).Value = txtNearUnaidedLE.Text;
        cmd.Parameters.Add("@NearAidedLE", SqlDbType.Int).Value = txtNearAidedLE.Text;
        cmd.Parameters.Add("@IPD", SqlDbType.Int).Value = txtipd.Text;

        cmd.Connection = conn;
        txtIDpatient.Text="";
         txtSphereRE.Text="";
         txtCylinderRE.Text="";
         txtAxisRE.Text="";
         txtPrismRE.Text="";
         txtReadingaddRE.Text = "";
         txtSphereLE.Text = "";
         txtCylinderLE.Text = "";
         txtAxisLE.Text = "";
         txtPrismLE.Text = "";
         txtReadingaddLE.Text = "";
         txtDistanceUnaidedRE.Text = "";
         txtDistanceAidedRE.Text = "";
         txtNearUnaidedRE.Text = "";
         txtNearAidedRE.Text = "";
         txtDistanceUnaidedLE.Text = "";
         txtDistanceAidedLE.Text = "";
         txtNearUnaidedLE.Text = "";
         txtNearAidedLE.Text = "";
         txtipd.Text = "";




        SqlDataReader reader = cmd.ExecuteReader();
        GridView1.DataBind();
        conn.Close();
    }
}