private void BTN_Limpar(object sender, RoutedEventArgs e)
{
TxtModelo.Clear();
RB_Sim.IsChecked = false;
RB_Nao.IsChecked = false;
TxtPreco.Text = "";
TxtMaterial.Clear();
TxtCor.Clear();
TextBox38.Clear();
TextBox38.IsEnabled = false;
CheckBox38.IsChecked = false;
TextBox39.Clear();
TextBox39.IsEnabled = false;
CheckBox39.IsChecked = false;
TextBox40.Clear();
TextBox40.IsEnabled = false;
CheckBox40.IsChecked = false;
TextBox41.Clear();
TextBox41.IsEnabled = false;
CheckBox41.IsChecked = false;
TextBox42.Clear();
TextBox42.IsEnabled = false;
CheckBox42.IsChecked = false;
TextBox43.Clear();
TextBox43.IsEnabled = false;
CheckBox43.IsChecked = false;
TextBox44.Clear();
TextBox44.IsEnabled = false;
CheckBox44.IsChecked = false;
}
protected void Page_Load(object sender, EventArgs e)
{
//Session
string name = " اهلا";
Label40.Text = "! " + Session["username"].ToString() + name;
TextBox44.Focus();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('حصلت على الموافقة')", true);
//idLab
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select idLab from Prescription p,Users u where p.idUser=u.idUser and idPresc=@idPresc";
cmd.Parameters.AddWithValue("idPresc", Session["idPresc"]);
conn.Open();
cmd.ExecuteNonQuery();
SqlDataReader dr = cmd.ExecuteReader();
try
{
if (dr.Read())
{
string id = dr["idLab"].ToString();
TextBox2.Text = id;
}
conn.Close();
}
catch (SqlException sqlexception)
{
Response.Write("ERROR ::" + sqlexception.Message);
}
catch (Exception ex)
{
Response.Write("ERROR ::" + ex.Message);
}
finally
{
conn.Close();
}
//Doctor: name, speciality, tel
SqlCommand cmd4 = conn.CreateCommand();
cmd4.CommandText = "select * from Prescription p,Doctors d where p.idDoc=d.idDoc and idPresc=@idPresc";
cmd4.Parameters.AddWithValue("idPresc", Session["idPresc"]);
conn.Open();
cmd4.ExecuteNonQuery();
SqlDataReader dr4 = cmd4.ExecuteReader();
try
{
if (dr4.Read())
{
TextBox8.Text = dr4["name"].ToString();
TextBox9.Text = dr4["speciality"].ToString();
string tel = dr4["tel"].ToString();
TextBox10.Text = tel;
}
conn.Close();
}
catch (SqlException sqlexception)
{
Response.Write("ERROR ::" + sqlexception.Message);
}
catch (Exception ex)
{
Response.Write("ERROR ::" + ex.Message);
}
finally
{
conn.Close();
}
//PrNB, ssn, PrIssuedDate, PrFilledDate
//Profs: name,tel,DateOfBirth
SqlCommand command3 = conn.CreateCommand();
command3.CommandText = "select * from Prescription where idPresc=@idPresc";
command3.Parameters.AddWithValue("idPresc", Session["idPresc"]);
conn.Open();
command3.ExecuteNonQuery();
SqlDataReader dr3 = command3.ExecuteReader();
try
{
if (dr3.Read())
{
TextBox44.Text = dr3["receiptNB"].ToString();
TextBox1.Text = dr3["prNB"].ToString();
String ssn1 = dr3["ssn"].ToString();
TextBox3.Text = ssn1;
String PrIssuedDate = dr3["PrIssuedDate"].ToString();
datepicker.Text = PrIssuedDate;
String PrFilledDate = dr3["PrFilledDate"].ToString();
TextBox7.Text = PrFilledDate;
//name
SqlCommand cmd2 = conn.CreateCommand();
cmd2.CommandText = "select * from Profs where ssn=@ssn";
cmd2.Parameters.AddWithValue("ssn", ssn1);
cmd2.ExecuteNonQuery();
SqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.Read())
{
TextBox4.Text = dr2["name"].ToString();
TextBox5.Text = dr2["DateOfBirth"].ToString();
TextBox6.Text = dr2["tel"].ToString();
}
}
conn.Close();
}
catch (SqlException sqlexception)
{
Response.Write("ERROR ::" + sqlexception.Message);
}
catch (Exception ex)
{
Response.Write("ERROR ::" + ex.Message);
}
finally
{
conn.Close();
}
}