protected void Page_Load(object sender, EventArgs e) { try { Label6.Visible = false; // string session = Session["Docname"].ToString().Trim(); session1 = Session["docid"].ToString().Trim(); //string nu = GridView1.Rows.Count.ToString(); Label6.Text = session1; dw.SetCommand("SELECT COUNT(Appointmentdate_ID) from Appointment_date WHERE Doctor_ID=@docid"); dw.SetSqlCommandParameters("docid", Label6.Text.Trim()); lblNoSessions.Text = dw.GetSingleData(); dw.SetDataAdapter("SELECT Working_hospital,First_name,Specialized_area FROM Doctor WHERE Doctor_ID = @docid"); //dw.SetSqlCommandParameters("fname",session); dw.SetDataAdapterParameters("docid", session1); DataTable dt = dw.GetDataTable(); string hospital = (dt.Rows[0][0].ToString().Trim()) + " Hospital"; string fname = dt.Rows[0][1].ToString().Trim(); string specarea = dt.Rows[0][2].ToString().Trim(); // string hospital = dw.GetSingleData().ToString().Trim()+" Hospital"; lblName.Text = fname; lblSpecArea.Text = specarea; lblOther.Text = hospital; } catch { Response.Redirect("~/Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { uid = Session["User_ID"].ToString(); uname = Session["User_name"].ToString(); pid = Session["Patient_ID"].ToString(); } catch { Response.Redirect("~/Account/Login.aspx"); } string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); DataWorksClass dw = new DataWorksClass(constring); try { // Doctor Table ==================================================================================== dw.SetDataAdapter(@"select * from Doctor where User_ID='" + uid + "' "); DataTable dt = dw.GetDataTable(); string name = (dt.Rows[0][8].ToString()).Trim() + " " + (dt.Rows[0][9].ToString()).Trim(); lblName.Text = name; //Name lblPhn.Text = "User " + (dt.Rows[0][1].ToString()).Trim(); //UID } catch { } }
protected void Button6_Click(object sender, EventArgs e) { dw.SetDataAdapter("SELECT First_name, Last_name, Height, weight, bloodgroup,Smoking,Alchol,Waterintake,Alchol_intake, Diet FROM Patient WHERE Patient_ID = @pid"); dw.SetDataAdapterParameters("pid", ApptP_ID); DataTable dt5 = dw.GetDataTable(); txtfname.Text = dt5.Rows[0][0].ToString().Trim(); txtlname.Text = dt5.Rows[0][1].ToString().Trim(); txtgeight.Text = dt5.Rows[0][2].ToString().Trim(); txtweight.Text = dt5.Rows[0][3].ToString().Trim(); ddlbloodgroup.SelectedIndex = Convert.ToInt32(dt5.Rows[0][4].ToString().Trim()); ddlsmoking.SelectedValue = dt5.Rows[0][5].ToString().Trim(); ddlalchol.SelectedValue = dt5.Rows[0][6].ToString(); txtwaterintake.Text = dt5.Rows[0][7].ToString().Trim(); txtalcholintake.Text = dt5.Rows[0][8].ToString().Trim(); ddldiet.SelectedValue = dt5.Rows[0][9].ToString().Trim(); dw.SetDataAdapter("SELECT Title, Address, Home_telephone_number, Mobile_number, PassportN, DOBy,DOBd,DOBm,NIC, Country, Province, ZIPcode, office_number from namal WHERE User_ID = @uid"); dw.SetDataAdapterParameters("uid", ApptU_ID); DataTable dt6 = dw.GetDataTable(); DropDownList1.SelectedValue = dt6.Rows[0][0].ToString().Trim(); txtaddress.Text = dt6.Rows[0][1].ToString().Trim(); txthome.Text = dt6.Rows[0][2].ToString().Trim(); txtmobile.Text = dt6.Rows[0][3].ToString().Trim(); txtpassno.Text = dt6.Rows[0][4].ToString().Trim(); ddlyear.SelectedValue = dt6.Rows[0][5].ToString().Trim(); ddldate.SelectedValue = dt6.Rows[0][6].ToString().Trim(); ddlmonth.SelectedValue = dt6.Rows[0][7].ToString().Trim(); txtnic.Text = dt6.Rows[0][8].ToString().Trim(); ddlcountry.SelectedIndex = Convert.ToInt32(dt6.Rows[0][9].ToString().Trim()); ddlprovince.SelectedIndex = Convert.ToInt32(dt6.Rows[0][10].ToString().Trim()); txtzip.Text = dt6.Rows[0][11].ToString().Trim(); txtoffice.Text = dt6.Rows[0][12].ToString().Trim(); dw.SetDataAdapter("select Name, Contact_number FROM Family WHERE Patient_ID = @pid"); dw.SetDataAdapterParameters("pid", ApptP_ID); DataTable dt7 = dw.GetDataTable(); txtemergencyname.Text = dt7.Rows[0][0].ToString().Trim(); txtemergencycontact.Text = dt7.Rows[0][1].ToString().Trim(); }
protected void btnPP_Click(object sender, EventArgs e) { string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); DataWorksClass dw = new DataWorksClass(constring); dw.SetDataAdapter(@"SELECT * FROM Admin WHERE User_ID='" + uid + "' "); DataTable dt = dw.GetDataTable(); if (dw != null) { try { //dw.SetCommand(@"UPDATE Admin SET Working_hospital=@Working_hospital,Trained_area=@Trained_area,Salary=@Salary,First_name=@First_name,Last_name=@Last_name where User_ID='" + uid + "' "); dw.SetCommand(@"UPDATE Admin SET Working_hospital=@Working_hospital,Salary=@Salary,First_name=@First_name,Last_name=@Last_name where User_ID='" + uid + "' "); dw.SetSqlCommandParameters("@Working_hospital", DropDownList13.SelectedValue.Trim()); //dw.SetSqlCommandParameters("@Trained_area", DropDownList12.SelectedValue.Trim()); dw.SetSqlCommandParameters("@Salary", TextBox14.Text.Trim()); dw.SetSqlCommandParameters("@First_name", TextBox1.Text.Trim()); dw.SetSqlCommandParameters("@Last_name", TextBox2.Text.Trim()); dw.Update(); dw.SetCommand(@"UPDATE namal SET Title=@Title,Gender=@Gender,DOBy=@DOBy,DOBd=@DOBd,DOBm=@DOBm,NIC=@NIC,PassportN=@PassportN where User_ID='" + uid + "' "); dw.SetSqlCommandParameters("@Title", DropDownList1.SelectedIndex); dw.SetSqlCommandParameters("@Gender", DropDownList11.SelectedValue.Trim()); dw.SetSqlCommandParameters("@DOBy", DropDownList5.SelectedValue.Trim()); dw.SetSqlCommandParameters("@DOBd", DropDownList3.SelectedValue.Trim()); dw.SetSqlCommandParameters("@DOBm", DropDownList4.SelectedValue.Trim()); dw.SetSqlCommandParameters("@NIC", TextBox3.Text.Trim()); dw.SetSqlCommandParameters("@PassportN", TextBox4.Text.Trim()); dw.Update(); Response.Write("<script language=javascript>alert('Update Success!')</script>"); } catch (Exception) { Response.Write("<script language=javascript>alert('Updation Failed!')</script>"); } } else { Response.Write("<script language=javascript>alert('No Records Found!')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { try { uid = Session["User_ID"].ToString(); uname = Session["User_name"].ToString(); pid = Session["Patient_ID"].ToString(); ApptP_ID = Session["ApptPat_ID"].ToString(); TextBox1.Text = ApptP_ID.Trim(); TextBox4.Text = ApptP_ID.Trim(); TextBox14.Text = ApptP_ID.Trim(); TextBox15.Text = ApptP_ID.Trim(); } catch { Response.Redirect("~/User/Doctor/Appointments.aspx"); } // Start ================================================== string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); DataWorksClass dw = new DataWorksClass(constring); int message = 0; try { // Patient Table ==================================================================================== dw.SetDataAdapter(@"select * from patient where Patient_ID='" + ApptP_ID + "' "); DataTable dt = dw.GetDataTable(); string name = (dt.Rows[0][3].ToString()).Trim() + " " + (dt.Rows[0][4].ToString()).Trim(); lblName.Text = name; //Name lblPhn.Text = "User " + (dt.Rows[0][1].ToString()).Trim(); //UID Session["ApptU_ID"] = (dt.Rows[0][1].ToString()).Trim(); //UID ApptU_ID = Session["ApptU_ID"].ToString(); lblPatHelNo.Text = (dt.Rows[0][0].ToString()).Trim(); //PID lblPatWeight.Text = (dt.Rows[0][6].ToString()).Trim(); //weight lblPatHeight.Text = (dt.Rows[0][5].ToString()).Trim(); //height float HeightinM = float.Parse(lblPatHeight.Text) / 100; float bmi = float.Parse(lblPatWeight.Text) / (HeightinM * HeightinM); lblPatBmi.Text = bmi.ToString("0.00"); //Change BMI color according to value if (float.Parse(lblPatBmi.Text) >= 25) { lblPatBmi.ForeColor = System.Drawing.Color.Red; } else if (float.Parse(lblPatBmi.Text) < 18.5) { lblPatBmi.ForeColor = System.Drawing.Color.Orange; } else { lblPatBmi.ForeColor = System.Drawing.Color.Green; } H1.Value = (dt.Rows[0][7].ToString()).Trim(); //bGroup int g = Int32.Parse(H1.Value); DropDownList2.SelectedIndex = g; lblPatBloodGrp.Text = DropDownList2.Text; H1.Value = (dt.Rows[0][9].ToString()).Trim(); //smoke int j = Int32.Parse(H1.Value); DropDownList8.SelectedIndex = j; lblSmoke.Text = DropDownList8.SelectedValue; H1.Value = (dt.Rows[0][10].ToString()).Trim(); //AlPeriod int k = Int32.Parse(H1.Value); DropDownList9.SelectedIndex = k; lblAlcohol.Text = DropDownList9.SelectedValue; lblWatInt.Text = (dt.Rows[0][11].ToString()).Trim(); //WaterIntake }catch {} try{ // Namal Table ==================================================================================== DataTable dt = dw.GetDataTable(); dw.SetDataAdapter(@"select * from namal where User_ID='" + ApptU_ID + "' "); dt = dw.GetDataTable(); H1.Value = (dt.Rows[0][9].ToString()).Trim(); //year int f = Int32.Parse(H1.Value); DropDownList5.SelectedIndex = f; int age = 2018 - Int32.Parse(DropDownList5.SelectedValue); lblPatAge.Text = age.ToString(); lblPatNic.Text = (dt.Rows[0][12].ToString()).Trim(); //nic lblPatConMob.Text = (dt.Rows[0][5].ToString()).Trim(); //mobile lblPatConHom.Text = (dt.Rows[0][4].ToString()).Trim(); //home } catch { } // end ========================================== }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { string a = GridView1.SelectedRow.Cells[5].Text.Trim(); string repid = GridView1.SelectedRow.Cells[0].Text.Trim(); Session["lab_id"] = repid; //Session["ApptPat_ID"] = a; string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); DataWorksClass dw = new DataWorksClass(constring); switch (a) { case "Blood": btnBloodInsert.Visible = false; Button6.Visible = true; TextBox1.Text = ApptP_ID; TextBox24.Text = lblPatBloodGrp.Text; //Clear previous records DropDownList1.SelectedIndex = 0; DropDownList3.SelectedIndex = 0; DropDownList4.SelectedIndex = 0; DropDownList6.SelectedIndex = 88; TextBox2.Text = ""; TextBox3.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox8.Text = ""; TextBox7.Text = ""; //string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); //DataWorksClass dw = new DataWorksClass(constring); try { dw.SetDataAdapter(@"select * from Labreport where Lab_report_ID='" + repid + "' "); DataTable dt = dw.GetDataTable(); DropDownList1.SelectedValue = (dt.Rows[0][1].ToString()).Trim(); DropDownList3.SelectedValue = (dt.Rows[0][3].ToString()).Trim(); DropDownList4.SelectedValue = (dt.Rows[0][4].ToString()).Trim(); DropDownList6.SelectedValue = (dt.Rows[0][5].ToString()).Trim(); } catch { } try { dw.SetDataAdapter(@"select * from Bloodreport where Lab_report_ID='" + repid + "' "); DataTable dt = dw.GetDataTable(); TextBox2.Text = (dt.Rows[0][2].ToString()).Trim(); TextBox3.Text = (dt.Rows[0][3].ToString()).Trim(); TextBox5.Text = (dt.Rows[0][4].ToString()).Trim(); TextBox6.Text = (dt.Rows[0][6].ToString()).Trim(); TextBox8.Text = (dt.Rows[0][7].ToString()).Trim(); TextBox7.Text = (dt.Rows[0][8].ToString()).Trim(); } catch { } this.ModalPopupExtender1.Show(); break; case "Cholestrol": Button10.Visible = false; Button11.Visible = true; TextBox4.Text = ApptP_ID; //Clear previous records DropDownList7.SelectedIndex = 0; DropDownList10.SelectedIndex = 0; DropDownList11.SelectedIndex = 0; DropDownList12.SelectedIndex = 88; TextBox9.Text = ""; TextBox10.Text = ""; TextBox11.Text = ""; TextBox12.Text = ""; TextBox13.Text = ""; TextBox19.Text = ""; //string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); //DataWorksClass dw = new DataWorksClass(constring); try { dw.SetDataAdapter(@"select * from Labreport where Lab_report_ID='" + repid + "' "); DataTable dt = dw.GetDataTable(); DropDownList7.SelectedValue = (dt.Rows[0][1].ToString()).Trim(); DropDownList10.SelectedValue = (dt.Rows[0][3].ToString()).Trim(); DropDownList11.SelectedValue = (dt.Rows[0][4].ToString()).Trim(); DropDownList12.SelectedValue = (dt.Rows[0][5].ToString()).Trim(); } catch { } try { dw.SetDataAdapter(@"select * from Colestoroll where Lab_report_ID='" + repid + "' "); DataTable dt = dw.GetDataTable(); TextBox9.Text = (dt.Rows[0][2].ToString()).Trim(); TextBox10.Text = (dt.Rows[0][3].ToString()).Trim(); TextBox11.Text = (dt.Rows[0][4].ToString()).Trim(); TextBox12.Text = (dt.Rows[0][5].ToString()).Trim(); TextBox13.Text = (dt.Rows[0][6].ToString()).Trim(); TextBox19.Text = (dt.Rows[0][8].ToString()).Trim(); } catch { } this.ModalPopupExtender2.Show(); break; case "Urine": Button12.Visible = false; Button13.Visible = true; TextBox15.Text = ApptP_ID; //Clear previous records DropDownList13.SelectedIndex = 0; DropDownList14.SelectedIndex = 0; DropDownList15.SelectedIndex = 0; DropDownList16.SelectedIndex = 88; TextBox16.Text = ""; TextBox17.Text = ""; TextBox18.Text = ""; TextBox20.Text = ""; TextBox23.Text = ""; //string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); //DataWorksClass dw = new DataWorksClass(constring); try { dw.SetDataAdapter(@"select * from Labreport where Lab_report_ID='" + repid + "' "); DataTable dt = dw.GetDataTable(); DropDownList13.SelectedValue = (dt.Rows[0][1].ToString()).Trim(); DropDownList14.SelectedValue = (dt.Rows[0][3].ToString()).Trim(); DropDownList15.SelectedValue = (dt.Rows[0][4].ToString()).Trim(); DropDownList16.SelectedValue = (dt.Rows[0][5].ToString()).Trim(); } catch { } try { dw.SetDataAdapter(@"select * from Urinereport where Lab_report_ID='" + repid + "' "); DataTable dt = dw.GetDataTable(); TextBox16.Text = (dt.Rows[0][2].ToString()).Trim(); TextBox17.Text = (dt.Rows[0][3].ToString()).Trim(); TextBox18.Text = (dt.Rows[0][4].ToString()).Trim(); TextBox20.Text = (dt.Rows[0][5].ToString()).Trim(); TextBox23.Text = (dt.Rows[0][7].ToString()).Trim(); } catch { } this.ModalPopupExtender3.Show(); break; } }
protected void Page_Load(object sender, EventArgs e) { try { //string uid = Session["User_ID"].ToString(); //string uname = Session["User_name"].ToString(); //string pid = Session["Patient_ID"].ToString(); string ApptU_ID = Session["ApptU_ID"].ToString(); string ApptP_ID = Session["ApptPat_ID"].ToString(); dw.SetDataAdapter("SELECT First_name,Last_name,bloodgroup FROM Patient WHERE Patient_ID = @pid"); dw.SetDataAdapterParameters("pid", ApptP_ID); DataTable dt = dw.GetDataTable(); lblfname.Text = dt.Rows[0][0].ToString().Trim(); lbllname.Text = dt.Rows[0][1].ToString().Trim(); string bgroup = dt.Rows[0][2].ToString().Trim(); if (bgroup == "0") { bGroup.Text = "A+"; } else if (bgroup == "1") { bGroup.Text = "A-"; } else if (bgroup == "2") { bGroup.Text = "B+"; } else if (bgroup == "3") { bGroup.Text = "B-"; } else if (bgroup == "4") { bGroup.Text = "AB+"; } else if (bgroup == "5") { bGroup.Text = "AB-"; } else if (bgroup == "6") { bGroup.Text = "O+"; } else if (bgroup == "7") { bGroup.Text = "O-"; } lblPHN.Text = ApptP_ID; dw.SetDataAdapter("SELECT Home_telephone_number, Mobile_number, Address, NIC FROM namal WHERE User_ID = @uid"); dw.SetDataAdapterParameters("uid", ApptU_ID); DataTable dt1 = dw.GetDataTable(); lblhome.Text = dt1.Rows[0][0].ToString().Trim(); lblmobile.Text = dt1.Rows[0][1].ToString().Trim(); lblAddress.Text = dt1.Rows[0][2].ToString().Trim(); lblNIC.Text = dt1.Rows[0][3].ToString().Trim(); } catch { Response.Redirect("~/User/Admin/AdminDefault.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { uid = Session["User_ID"].ToString(); uname = Session["User_name"].ToString(); pid = Session["Patient_ID"].ToString(); // uid = "124"; // uname = "namal1"; // pid = "2"; } catch { Response.Redirect("~/Account/Login.aspx"); } // Patient Table ==================================================================================== try { // Patient Table ==================================================================================== dw.SetDataAdapter(@"select * from patient where Patient_ID='" + pid + "' "); DataTable dt = dw.GetDataTable(); string name = (dt.Rows[0][3].ToString()).Trim() + " " + (dt.Rows[0][4].ToString()).Trim(); lblName.Text = name; //Name lblPhn.Text = "User " + (dt.Rows[0][1].ToString()).Trim(); //UID Session["ApptU_ID"] = (dt.Rows[0][1].ToString()).Trim(); //UID //ApptU_ID = Session["ApptU_ID"].ToString(); lblPatHelNo.Text = (dt.Rows[0][0].ToString()).Trim(); //PID lblPatWeight.Text = (dt.Rows[0][6].ToString()).Trim(); //weight lblPatHeight.Text = (dt.Rows[0][5].ToString()).Trim(); //height float HeightinM = float.Parse(lblPatHeight.Text) / 100; float bmi = float.Parse(lblPatWeight.Text) / (HeightinM * HeightinM); lblPatBmi.Text = bmi.ToString("0.00"); //Change BMI color according to value if (float.Parse(lblPatBmi.Text) >= 25) { lblPatBmi.ForeColor = System.Drawing.Color.Red; } else if (float.Parse(lblPatBmi.Text) < 18.5) { lblPatBmi.ForeColor = System.Drawing.Color.Orange; } else { lblPatBmi.ForeColor = System.Drawing.Color.Green; } H1.Value = (dt.Rows[0][7].ToString()).Trim(); //bGroup int g = Int32.Parse(H1.Value); DropDownList2.SelectedIndex = g; lblPatBloodGrp.Text = DropDownList2.Text; H1.Value = (dt.Rows[0][9].ToString()).Trim(); //smoke int j = Int32.Parse(H1.Value); DropDownList8.SelectedIndex = j; lblSmoke.Text = DropDownList8.SelectedValue; H1.Value = (dt.Rows[0][10].ToString()).Trim(); //AlPeriod int k = Int32.Parse(H1.Value); DropDownList9.SelectedIndex = k; lblAlcohol.Text = DropDownList9.SelectedValue; lblWatInt.Text = (dt.Rows[0][11].ToString()).Trim(); //WaterIntake } catch { } try { // Namal Table ==================================================================================== DataTable dt = dw.GetDataTable(); dw.SetDataAdapter(@"select * from namal where User_ID='" + uid + "' "); dt = dw.GetDataTable(); H1.Value = (dt.Rows[0][9].ToString()).Trim(); //year int f = Int32.Parse(H1.Value); DropDownList5.SelectedIndex = f; int age = 2018 - Int32.Parse(DropDownList5.SelectedValue); lblPatAge.Text = age.ToString(); lblPatNic.Text = (dt.Rows[0][12].ToString()).Trim(); //nic lblPatConMob.Text = (dt.Rows[0][5].ToString()).Trim(); //mobile lblPatConHom.Text = (dt.Rows[0][4].ToString()).Trim(); //home } catch { } }
protected void Button1_Click(object sender, EventArgs e) { // Start ================================================== string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); DataWorksClass dw = new DataWorksClass(constring); int message = 0; try { // Doctor Table ==================================================================================== dw.SetDataAdapter(@"select * from Doctor where User_ID='" + uid + "' "); DataTable dt = dw.GetDataTable(); string name = (dt.Rows[0][8].ToString()).Trim() + " " + (dt.Rows[0][9].ToString()).Trim(); lblName.Text = name; //Name lblPhn.Text = "User " + (dt.Rows[0][1].ToString()).Trim(); //UID TextBox1.Text = (dt.Rows[0][8].ToString()).Trim(); //Fname TextBox2.Text = (dt.Rows[0][9].ToString()).Trim(); //Lname DropDownList12.SelectedValue = (dt.Rows[0][4].ToString()).Trim(); //Specialization DropDownList13.SelectedValue = (dt.Rows[0][3].ToString()).Trim(); //Hospital TextBox14.Text = (dt.Rows[0][5].ToString()).Trim(); //Salary }catch {} try{ // Namal Table ==================================================================================== dw.SetDataAdapter(@"select * from namal where User_ID='" + uid + "' "); DataTable dt = dw.GetDataTable(); H1.Value = (dt.Rows[0][7].ToString()).Trim(); //Title int a = Int32.Parse(H1.Value); DropDownList1.SelectedIndex = a; H1.Value = (dt.Rows[0][6].ToString()).Trim(); //gender int b = Int32.Parse(H1.Value); DropDownList11.SelectedIndex = b; DropDownList3.SelectedValue = (dt.Rows[0][10].ToString()).Trim(); //date DropDownList4.SelectedValue = (dt.Rows[0][11].ToString()).Trim(); //month DropDownList5.SelectedValue = (dt.Rows[0][9].ToString()).Trim(); //year TextBox3.Text = (dt.Rows[0][12].ToString()).Trim(); //nic TextBox4.Text = (dt.Rows[0][8].ToString()).Trim(); //passport message = 1; }catch {} try{ dw.SetDataAdapter(@"select * from namal where User_ID='" + uid + "' "); DataTable dt = dw.GetDataTable(); TextBox7.Text = (dt.Rows[0][5].ToString()).Trim(); //mobile TextBox8.Text = (dt.Rows[0][4].ToString()).Trim(); //home TextBox9.Text = (dt.Rows[0][13].ToString()).Trim(); //office TextBox10.Text = (dt.Rows[0][3].ToString()).Trim(); //address H1.Value = (dt.Rows[0][14].ToString()).Trim(); //country int h = Int32.Parse(H1.Value); DropDownList7.SelectedIndex = h; H1.Value = (dt.Rows[0][15].ToString()).Trim(); //province int i = Int32.Parse(H1.Value); DropDownList6.SelectedIndex = i; TextBox11.Text = (dt.Rows[0][16].ToString()).Trim(); //zip TextBox12.Text = (dt.Rows[0][21].ToString()).Trim(); //EmName TextBox13.Text = (dt.Rows[0][22].ToString()).Trim(); //EmConMob message = 1; }catch {} try{ if (lblName.Text != "") { //Response.Write("<script language=javascript>alert('Search Success!')</script>"); message = 0; } else { Response.Write("<script language=javascript>alert('No Records Found!')</script>"); message = 0; lblName.Text = "N/A"; lblPhn.Text = "N/A"; DropDownList1.SelectedIndex = 0; TextBox1.Text = ""; TextBox2.Text = ""; DropDownList11.SelectedIndex = 0; DropDownList3.SelectedIndex = 0; DropDownList4.SelectedIndex = 0; DropDownList5.SelectedIndex = 0; TextBox3.Text = ""; TextBox4.Text = ""; DropDownList12.SelectedIndex = 0; DropDownList13.SelectedIndex = 0; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; TextBox10.Text = ""; DropDownList7.SelectedIndex = 0; DropDownList6.SelectedIndex = 0; TextBox11.Text = ""; TextBox12.Text = ""; TextBox13.Text = ""; TextBox14.Text = ""; } } catch (Exception ex) { if (message == 1) { Response.Write("<script language=javascript>alert('Modification Needed!')</script>"); } else { Response.Write("<script language=javascript>alert('Invalid Entry!')</script>"); lblName.Text = "N/A"; lblPhn.Text = "N/A"; DropDownList1.SelectedIndex = 0; TextBox1.Text = ""; TextBox2.Text = ""; DropDownList11.SelectedIndex = 0; DropDownList3.SelectedIndex = 0; DropDownList4.SelectedIndex = 0; DropDownList5.SelectedIndex = 0; TextBox3.Text = ""; TextBox4.Text = ""; DropDownList12.SelectedIndex = 0; DropDownList13.SelectedIndex = 0; TextBox7.Text = ""; TextBox8.Text = ""; TextBox9.Text = ""; TextBox10.Text = ""; DropDownList7.SelectedIndex = 0; DropDownList6.SelectedIndex = 0; TextBox11.Text = ""; TextBox12.Text = ""; TextBox13.Text = ""; TextBox14.Text = ""; } } // end ========================================== }
protected void Button3_Click2(object sender, EventArgs e) { try { string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); DataWorksClass dw = new DataWorksClass(constring); dw.SetDataAdapter(@"select * from namal where User_ID='" + uid + "' "); DataTable dt = dw.GetDataTable(); cPass = (dt.Rows[0][2].ToString()).Trim(); //current pass string newPass = TextBox17.Text.Trim(); string newPassConf = TextBox18.Text.Trim(); if (TextBox16.Text.Trim() == cPass) { if (newPass == newPassConf) { dw.SetCommand(@"UPDATE namal SET Password=@Password where User_ID='" + uid + "' "); dw.SetSqlCommandParameters("@Password", TextBox17.Text.Trim()); dw.Update(); Label32.Text = ""; Label33.Text = ""; //Email Start...................................................... dw.SetCommand("SELECT E_mail FROM namal WHERE User_ID = @uid"); dw.SetSqlCommandParameters("uid", uid); string email = dw.GetSingleData().Trim(); string npass = TextBox17.Text.Trim(); dw.SetCommand("SELECT First_name FROM Doctor WHERE User_ID = @uid"); dw.SetSqlCommandParameters("uid", uid); string fname = dw.GetSingleData().Trim(); MailMessage mm = new MailMessage("*****@*****.**", email); //(your gmail,receiver gmail) mm.Subject = "KDU CMS | Password Reset!"; //Subject mm.Body = "<b>" + "Dear " + fname + "," + "</b> <br>" + "Your password has been changed on KDU Online Channelling and Management System." + "<br> <br>" + "<table>" + "<tr>" + "<td>" + "Your changed Password " + "</td>" + "<td>" + "<b>" + npass + "</b>" + "</td>" + "</tr>" + "</table>" + "<br> <br>" + "<i>" + "Important! Keep your password in a secure place. After remembering your password, permanantly delete this email for your account's safty." + "</i>" + "<br> <br>" + "<table>" + "<tr>" + "<td>" + "<img src=\"https://preview.ibb.co/kaGrEf/logo.png\" width=\"50px\">" + " " + "</td>" + "<td>" + "<b>" + "KDU Channeling Center," + "<br>" + "General Sir John Kotelawala Defence University," + "<br>" + "Southern Campus," + "<br>" + "Sooriyawewa." + "<br>" + "+94718810575" + "</b>" + "</td>" + "</tr>" + "</table>"; //Message //+"<table>"+ // "<tr>"+ // "<td>" + "Your Channel Number " + "</td>" + // "<td>" + "<b>" + channelno + "</b>" + "</td>" + // "</tr>"+ // "<tr>" + // "<td>" + "Your Reserved Date " + "</td>" + // "<td>" + "<b>" + TextBox3.Text.Trim() + "</b>" + "</td>" + // "</tr>" + // "<tr>" + // "<td>" + "Doctor " + "</td>" + // "<td>" + "<b>" + TextBox2.Text.Trim() + "</b>" + "</td>" + // "</tr>" + // "<tr>" + // "<td>" + "Specialization " +"</td>" + // "<td>" + "<b>" + TextBox4.Text.Trim() + "</b>" + "</td>" + // "</tr>" + //"</table>"+ //+"<table>" + // "<tr>" + // "<td>" + "<img src=\"https://preview.ibb.co/kaGrEf/logo.png\" width=\"50px\">" + " " + "</td>" + // "<td>" + "<b>" + "KDU Channeling Center,"+"<br>"+"General Sir John Kotelawala Defence University,"+"<br>"+"Southern Campus,"+"<br>"+"Sooriyawewa."+"<br>"+"+94718810575"+"</b>" + "</td>" + // "</tr>" + //"</table>" + mm.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.EnableSsl = true; NetworkCredential networkcred = new NetworkCredential("*****@*****.**", "KDU123cms");//(your gmail & gmail password) smtp.UseDefaultCredentials = true; smtp.Credentials = networkcred; smtp.Port = 587; smtp.Send(mm); //Response.Write("<script language=javascript>alert('BOOKING SUCCESSFULL! CHECK YOUR EMAILS!')</script>"); Response.Redirect("~/User/Doctor/Account.aspx"); //---------------------------------End Email } else { Label33.Text = ""; Label32.Text = "Password does not match!"; } } else { Label33.Text = "Incorrect Password!"; Label32.Text = ""; } } catch { } }
protected void btnlogin_Click(object sender, EventArgs e) { string constring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString(); DataWorksClass dw = new DataWorksClass(constring); dw.SetCommand(@"select count(User_ID) from namal where User_name=@username and Password = @password"); dw.SetSqlCommandParameters("username", txtuname.Text.Trim()); dw.SetSqlCommandParameters("password", txtpassword.Text.Trim()); int count = Convert.ToInt32(dw.GetSingleData()); dw.SetCommand("SELECT MAX(id) FROM loginlog"); int i = Convert.ToInt32(dw.GetSingleData()) + 1; DateTime d = DateTime.Now; string date = d.ToString("yyyy-MM-dd"); string time = d.ToString("hh:mm:ss"); //validating the user if (count == 1) { dw.SetDataAdapter(@"select Type,User_name,User_ID from namal where User_name=@username and Password = @password"); dw.SetDataAdapterParameters("username", txtuname.Text.Trim()); dw.SetDataAdapterParameters("password", txtpassword.Text.Trim()); DataTable dt = dw.GetDataTable(); string uname = (dt.Rows[0][1].ToString()).Trim(); string type = (dt.Rows[0][0].ToString()).Trim(); string uid = (dt.Rows[0][2].ToString()).Trim(); Session["User_ID"] = uid; Session["type"] = type; dw.SetCommand("SELECT Patient_ID FROM Patient WHERE User_ID = @uid"); dw.SetSqlCommandParameters("uid", uid); string pid = dw.GetSingleData().Trim(); Session["Patient_ID"] = pid; //filling login log table dw.SetCommand("INSERT INTO loginlog (id,username,attempt,date,time,type) VALUES (@id,@uname,@attempt,@date,@time,@type)");//,, dw.SetSqlCommandParameters("id", i); dw.SetSqlCommandParameters("uname", txtuname.Text.Trim()); dw.SetSqlCommandParameters("attempt", "success"); dw.SetSqlCommandParameters("date", date); dw.SetSqlCommandParameters("time", time); dw.SetSqlCommandParameters("type", type); dw.Insert(); Session["User_name"] = uname; //checking the type of users switch (type) { case "doctor": dw.SetCommand("SELECT Doctor_ID FROM Doctor WHERE User_ID = @uid"); dw.SetSqlCommandParameters("uid", uid); string did = dw.GetSingleData().Trim(); Session["Doctor_ID"] = did; if (CheckBox1.Checked) { Session["ok"] = "go"; } else { Session["ok"] = null; } Session["User_name"] = uname; Response.Redirect("~/User/Doctor/Appointments.aspx"); break; case "patient": if (CheckBox1.Checked) { Session["ok"] = "go"; } else { Session["ok"] = null; } Session["User_name"] = uname; Response.Redirect("~/Default.aspx"); break; case "admin": dw.SetCommand("SELECT Admin_ID FROM Admin WHERE User_ID = @uid"); dw.SetSqlCommandParameters("uid", uid); string aid = dw.GetSingleData().Trim(); Session["Admin_ID"] = aid; if (CheckBox1.Checked) { Session["ok"] = "go"; } else { Session["ok"] = null; } Session["User_name"] = uname; Response.Redirect("~/User/Admin/AdminDefault.aspx"); break; case "nurse": dw.SetCommand("SELECT Nurse_ID FROM Nurse WHERE User_ID = @uid"); dw.SetSqlCommandParameters("uid", uid); string nid = dw.GetSingleData().Trim(); Session["Nurse_ID"] = nid; if (CheckBox1.Checked) { Session["ok"] = "go"; } else { Session["ok"] = null; } Session["User_name"] = uname; Response.Redirect("~/User/Nurse/NurseDefault.aspx"); break; } } else { //print a error msg when user try to login without providing user credentials and in here userlogs table not filling if (txtuname.Text == "" || txtpassword.Text == "") { Response.Write("<script language=javascript>alert('PLZ FILL THE USERNAME AND PASSWORD FIELDS!!!!')</script>"); } else if (txtuname.Text != "" || txtpassword.Text != "") { //filing loginlog table dw.SetCommand("INSERT INTO loginlog (id,username,attempt,date,time,type) VALUES (@id,@uname,@attempt,@date,@time,@type)");//,, dw.SetSqlCommandParameters("id", i); dw.SetSqlCommandParameters("uname", txtuname.Text.Trim()); dw.SetSqlCommandParameters("attempt", "not success"); dw.SetSqlCommandParameters("date", date); dw.SetSqlCommandParameters("time", time); dw.SetSqlCommandParameters("type", "unbound"); dw.Insert(); Response.Write("<script language=javascript>alert('WRONG CREDENTIALS!!!!')</script>"); } } }