protected void PatientRegGetStartedBtn_Click(object sender, EventArgs e)
{
string Email = PatientRegEmailTxt.Text;
if (PatientRegEmailTxt.Text == "" || PatientRegNameTxt.Text == "" || PatientRegPhoneTxt.Text == "" ||
PatientRegGenderRdo.SelectedValue == "")
{
PatientRegMsgLbl.Text = "Fill all the field";
}
else
{
string query = "select Email from PatientDetails where Email='" + PatientRegEmailTxt.Text + "'";
object firstElement = all.ExeScalar(query);
try
{
if (firstElement.ToString() == Email)
{
PatientRegMsgLbl.Text = "Email is already registered";
}
}
catch (Exception ex)
{
if (PatientRegPwdTxt.Text != PatientRegCnfPwdTxt.Text)
{
PatientRegMsgLbl.Text = "Password does not match";
}
else
{
query = "insert into PatientDetails(Name,Email,Phone,Gender)values(@name,@email,@phone,@gender)";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@name", PatientRegNameTxt.Text),
new SqlParameter("@email", PatientRegEmailTxt.Text),
new SqlParameter("@phone", PatientRegPhoneTxt.Text),
new SqlParameter("@gender", PatientRegGenderRdo.SelectedItem.Value)
};
int x = all.ExeNonQuery(query, parameter);
string query1 = "select UserId from PatientDetails where Email='" + PatientRegEmailTxt.Text + "'";
object userid = all.ExeScalar(query1);
query = "insert into EmailPasswordDetails(UserId,Email,Password,Name,CustId)values(@useid,@email,@password,@name,@custid)";
SqlParameter[] parameter1 = new SqlParameter[]
{
new SqlParameter("@useid", Convert.ToInt32(userid)),
new SqlParameter("@email", PatientRegEmailTxt.Text),
new SqlParameter("@password", PatientRegPwdTxt.Text),
new SqlParameter("@name", PatientRegNameTxt.Text),
new SqlParameter("@custid", 1)
};
x = all.ExeNonQuery(query, parameter1);
Response.Redirect("PatientAfterLogin.aspx");
}
}
finally
{
PatientRegMsgLbl.Text = "Email is already registered";
}
}
}
protected void LabRegGetStatedBtn_Click(object sender, EventArgs e)
{
string Email = LabRegEmailTxt.Text;
if (LabRegEmailTxt.Text == "" || LabRegNameTxt.Text == "" || LabRegPhoneTxt.Text == "")
{
LabRegMsgLbl.Text = "Fill all the field";
}
else
{
string query = "select Email from LabDetails where Email='" + LabRegEmailTxt.Text + "'";
object firstElement = all.ExeScalar(query);
try
{
if (firstElement.ToString() == Email)
{
LabRegMsgLbl.Text = "Email is already registered";
}
}
catch (Exception ex)
{
if (LabRegPwdTxt.Text != LabRegCnfPwdTxt.Text)
{
LabRegMsgLbl.Text = "Password does not match";
}
else
{
query = "insert into LabDetails(Name,Email,Phone,PathologyName,City)values(@Name,@Email,@Phone,@pathology,@city)";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@Name", LabRegNameTxt.Text),
new SqlParameter("@Email", LabRegEmailTxt.Text),
new SqlParameter("@Phone", LabRegPhoneTxt.Text),
new SqlParameter("@pathology", LabRegPathologyNameTxt.Text),
new SqlParameter("@city", LabRegCityTxt.Text)
};
int x = all.ExeNonQuery(query, parameter);
string query1 = "select UserId from LabDetails where Email='" + LabRegEmailTxt.Text + "'";
object userid = all.ExeScalar(query1);
query = "insert into EmailPasswordDetails(UserId,Email,Password,Name,CustId)values(@useid,@email,@password,@name,@custid)";
SqlParameter[] parameter1 = new SqlParameter[]
{
new SqlParameter("@useid", Convert.ToInt32(userid)),
new SqlParameter("@email", LabRegEmailTxt.Text),
new SqlParameter("@password", LabRegPwdTxt.Text),
new SqlParameter("@name", LabRegNameTxt.Text),
new SqlParameter("@custid", 3)
};
x = all.ExeNonQuery(query, parameter1);
Response.Redirect("PathologyAfterLogin.aspx");
}
}
}
}
protected void DocRegGetStartedBtn_Click(object sender, EventArgs e)
{
string Email = DocRegEmailTxt.Text;
if (DocRegEmailTxt.Text == "" || DocRegNameTxt.Text == "" || DocRegPhoneTxt.Text == "" || DocRegGenderRdo.SelectedValue == "")
{
DocRegMsgLbl.Text = "Fill all the field";
}
else
{
string query = "select Email from DoctorDetails where Email='" + DocRegEmailTxt.Text + "'";
object firstElement = all.ExeScalar(query);
try
{
if (firstElement.ToString() == Email)
{
DocRegMsgLbl.Text = "Email is already registered";
}
}
catch (Exception ex)
{
if (DocRegPwdTxt.Text != DocRegCnfPwdTxt.Text)
{
DocRegMsgLbl.Text = "Password does not match";
}
else
{
query = "insert into DoctorDetails(Name,Email,Phone,Gender,Specialization,City)values(@Name,@Email,@Phone,@Gender,@specialization,@city)";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@Name", DocRegNameTxt.Text),
new SqlParameter("@Email", DocRegEmailTxt.Text),
new SqlParameter("@Phone", DocRegPhoneTxt.Text),
new SqlParameter("@Gender", DocRegGenderRdo.SelectedItem.Value),
new SqlParameter("@specialization", DocSpecializationTxt.Text),
new SqlParameter("@city", DocCityText.Text)
};
int x = all.ExeNonQuery(query, parameter);
string query1 = "select UserId from DoctorDetails where Email='" + DocRegEmailTxt.Text + "'";
object userid = all.ExeScalar(query1);
query = "insert into EmailPasswordDetails(UserId,Email,Password,Name,CustId)values(@useid,@email,@password,@name,@custid)";
SqlParameter[] parameter1 = new SqlParameter[]
{
new SqlParameter("@useid", Convert.ToInt32(userid)),
new SqlParameter("@email", DocRegEmailTxt.Text),
new SqlParameter("@password", DocRegPwdTxt.Text),
new SqlParameter("@name", DocRegNameTxt.Text),
new SqlParameter("@custid", 2)
};
x = all.ExeNonQuery(query, parameter1);
Response.Redirect("DoctorAfterLogin.aspx");
}
}
}
}
protected void CheckApp_Click(object sender, EventArgs e)
{
string query = "select DoctorId from BookingDetails where PatientId = 10001 and Date = '" + datepicker.Text + "'";
string Did = all.ExeScalar(query).ToString();
string query1 = "select Name from DoctorDetails where UserId = " + Did + " ";
DocNamelbl.Text = "DR " + all.ExeScalar(query1).ToString();
string query2 = "select Name from PatientDetails where UserId = 10001 ";
PatientNameLbl.Text = all.ExeScalar(query2).ToString();
string query3 = "select TestId, TestName from PathologyTestDetail where PatientId = 10001 and Date = '" + datepicker.Text + "'";
all.DrpDownData(LRTestNameDrpdwn, query3, "TestId", "TestName", "--select Test --");
}
protected void SubmitBtn_Click(object sender, EventArgs e)
{
string query1 = "select UserId from PatientDetails where Email='" + EmailLbl.Text + "'";
object ui = all.ExeScalar(query1);
string query = "insert into PharmacyPrescription(PatientId,DoctorId,PharmacyId,Prescription,Date)values(@patid,@docid,@pharid,@pres,@date)";
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@patid", Convert.ToInt32(ui)),
new SqlParameter("@docid", Session["userid"]),
new SqlParameter("@pharid", PharmacyNameDrpdwn.SelectedItem.Value),
new SqlParameter("@pres", PrescriptionTxt.Text),
new SqlParameter("@date", picker.Text)
};
int x = all.ExeNonQuery(query, parameter);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["user"].ToString() != "")
{
SignLbl.Text = Session["user"].ToString();
}
}
catch (Exception ex)
{
Response.Redirect("LoginReg.aspx");
}
DocNameLbl.Text = Session["user"].ToString();
temp = Convert.ToInt32(Session["userid"]);
query = "select Email from DoctorDetails where UserId=" + temp + "";
docemail = all.ExeScalar(query).ToString();
string query1 = "select Phone,City,Exprience,Degree1,Degree2,Degree3,Region,Landline1,Fees,Address from DoctorDetails where Email='" + docemail + "'";
ds = all.ExeAdapter(query1, "tempTable");
DocEditPhoneTxt.Text = ds.Tables["temptable"].Rows[0][0].ToString();
DocEditCityTxt.Text = ds.Tables["temptable"].Rows[0][1].ToString();
DocEditExprienceTxt.Text = ds.Tables["temptable"].Rows[0][2].ToString();
DocEditDegree1Txt.Text = ds.Tables["temptable"].Rows[0][3].ToString();
DocEditDegree2Txt.Text = ds.Tables["temptable"].Rows[0][4].ToString();
DocEditDegree3Txt.Text = ds.Tables["temptable"].Rows[0][5].ToString();
DocEditRegionTxt.Text = ds.Tables["temptable"].Rows[0][6].ToString();
DocEditLandlineTxt.Text = ds.Tables["temptable"].Rows[0][7].ToString();
DocEditFeeTxt.Text = ds.Tables["temptable"].Rows[0][8].ToString();
DocEditAddressTxt.Text = ds.Tables["temptable"].Rows[0][9].ToString();
}
protected void CheckApp_Click(object sender, EventArgs e)
{
string query = "select DoctorId from BookingDetails where PatientId = 10001 and Date = '" + datepicker.Text + "'";
string Did = all.ExeScalar(query).ToString();
string query1 = "select Name from DoctorDetails where UserId = " + Did + " ";
DocName.Text = "DR "+ all.ExeScalar(query1).ToString();
string query2 = "select Prescription, Status from PharmacyPrescription where PatientId = 10001 and Date = '" + datepicker.Text + "'";
ds = all.ExeAdapter(query2, "temp");
PrescriptionTxt.Text = ds.Tables["temp"].Rows[0][0].ToString();
string Sts = ds.Tables["temp"].Rows[0][1].ToString();
if (Sts.Equals("paid"))
{
PaymentChkBox.Checked = true;
SubmitBtn.Enabled = false;
}
}
protected void MedicalPrescriptionBtn_Click(object sender, EventArgs e)
{
MedicalPrescriptionBtn.Attributes.Add("style", "background-color:white;color:#28465A;");
LabReportBtn.Attributes.Add("style", "background-color:none;color:white;");
DocReviewBtn.Attributes.Add("style", "background-color:none;color:white;");
AppointmentBtn.Attributes.Add("style", "background-color:none;color:white;");
MedicalPrescription.Visible = true;
Review.Visible = false;
Appointment.Visible = false;
LabReport.Visible = false;
MRDocNameLbl.Text = AppDocNameLbl.Text;
string query = "select Prescription from PharmacyPrescription where PatientId = " + Session["userid"] + " and Date = '" + datepicker.Text + "'";
object s = all.ExeScalar(query);
MPPrescriptionTxt.Text = s.ToString();
}
protected void LogindBtn_Click(object sender, EventArgs e)
{
string email = LoginEmailTxt.Text;
string pwd = LoginPasswordTxt.Text;
if (LoginEmailTxt.Text == null || LoginEmailTxt.Text == "" || LoginPasswordTxt.Text == null || LoginPasswordTxt.Text == "")
{
LoginMsglbl.Text = "Please fill all the fields";
}
else
{
string query = "select Email from EmailPasswordDetails where Email='" + email + "'";
object firstelement = all.ExeScalar(query);
try
{
if (firstelement.ToString() == email)
{
string query1 = "select * from EmailPasswordDetails where Email='" + email + "'";
ds = all.ExeAdapter(query1, "EmailPwdTable");
if (pwd != ds.Tables["EmailPwdTable"].Rows[0][2].ToString())
{
LoginMsglbl.Text = "Password does not Matches";
}
else
{
if (Convert.ToInt32(Session["state"]) == 1)
{
Session["user"] = ds.Tables["EmailPwdTable"].Rows[0][3].ToString();
Session["userid"] = Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][0]);
string query2 = "insert into BookingDetails(PatientId,DoctorId,SlotId,Date)values(@patientid,@doctorid,@slotid,@date)";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@patientid", Convert.ToInt32(Session["userid"])),
new SqlParameter("@doctorid", Convert.ToInt32(Session["docid"])),
new SqlParameter("@slotid", Convert.ToInt32(Session["slotid"])),
new SqlParameter("@date", Session["date"].ToString())
};
int x = all.ExeNonQuery(query2, parameter);
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Booking is successfull')", true);
Response.Redirect("PatientAfterLogin.aspx");
}
else
{
Session["user"] = ds.Tables["EmailPwdTable"].Rows[0][3].ToString();
Session["userid"] = Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][0]);
Response.Redirect("Find.aspx");
}
}
}
}
catch (Exception ex)
{
LoginMsglbl.Text = "Email is not Registered";
}
}
}
protected void LogindBtn_Click(object sender, EventArgs e)
{
string email = LoginEmailTxt.Text;
string pwd = LoginPasswordTxt.Text;
if (LoginEmailTxt.Text == null || LoginEmailTxt.Text == "" || LoginPasswordTxt.Text == null || LoginPasswordTxt.Text == "")
{
LoginMsglbl.Text = "Please fill all the fields";
LoginEmailTxt.Text = string.Empty;
LoginPasswordTxt.Text = string.Empty;
}
else
{
string query = "select Email from EmailPasswordDetails where Email='" + email + "'";
object firstelement = all.ExeScalar(query);
try
{
if (firstelement.ToString() == email)
{
string query1 = "select * from EmailPasswordDetails where Email='" + email + "'";
ds = all.ExeAdapter(query1, "EmailPwdTable");
if (pwd != ds.Tables["EmailPwdTable"].Rows[0][2].ToString())
{
LoginMsglbl.Text = "Password does not Matches";
}
else
{
if (Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][4]) == 1)
{
Session["user"] = ds.Tables["EmailPwdTable"].Rows[0][3].ToString();
Session["userid"] = Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][0]);
Response.Redirect("PatientAfterLogin.aspx");
}
else if (Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][4]) == 2)
{
Session["user"] = ds.Tables["EmailPwdTable"].Rows[0][3].ToString();
Session["userid"] = Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][0]);
Response.Redirect("DoctorAfterLogin.aspx");
}
else if (Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][4]) == 3)
{
Session["user"] = ds.Tables["EmailPwdTable"].Rows[0][3].ToString();
Session["userid"] = Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][0]);
Response.Redirect("PathologyAfterLogin.aspx");
}
else
{
Session["user"] = ds.Tables["EmailPwdTable"].Rows[0][3].ToString();
Session["userid"] = Convert.ToInt32(ds.Tables["EmailPwdTable"].Rows[0][0]);
Response.Redirect("PharmacyAfterLogin.aspx");
}
}
}
}
catch (Exception ex)
{
LoginMsglbl.Text = "Email is not Registered";
}
}
}
