public ActionResult forgot_password(FormCollection fm) { dr.d_dob = fm["ctl00$ContentPlaceHolder1$dob_text"]; dr.d_mob = fm["ctl00$ContentPlaceHolder1$mobile_text"]; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "recover_password"; cmd.Parameters.AddWithValue("@mob", dr.d_mob); cmd.Parameters.AddWithValue("@dob", dr.d_dob); DataTable dt = db.getdata(cmd); TempData["Result"] = "Recovery Failed! Check your Date of birth and Mobile number"; if (dt.Rows.Count > 0) { SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "get_user_mailid"; cmd1.Parameters.AddWithValue("@id", dt.Rows[0][0].ToString()); DataTable dt1 = db.getdata(cmd1); TempData["Result"] = m.sentmail(dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt1.Rows[0][0].ToString()); } return(RedirectToAction("login_user")); }
public ActionResult newpatient_reg(FormCollection fm) { //RANDOM PASSWORD// Random rd = new Random(); string ps = rd.Next(000000, 999999).ToString() + Session["logid"].ToString(); uc.usern = fm["ctl00$ContentPlaceHolder1$UnameText"]; string mail = fm["ctl00$ContentPlaceHolder1$mailText"]; uc.passd = ps; uc.usertype = "Patient"; SqlCommand cmd2 = new SqlCommand(); cmd2.CommandText = "maxid_in_login"; db.maxid(cmd2); pa.did = Convert.ToInt32(Session["logid"]); SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "add_patient"; cmd1.Parameters.AddWithValue("@uid", db.maxid(cmd2)); cmd1.Parameters.AddWithValue("@uname", uc.usern); cmd1.Parameters.AddWithValue("@passw", uc.passd); cmd1.Parameters.AddWithValue("@utype", uc.usertype); cmd1.Parameters.AddWithValue("@did", pa.did); cmd1.Parameters.AddWithValue("@date", System.DateTime.Now); db.execute(cmd1); //FORWARD PASSWORD TO PATIENT// string s = mg.sentmail(uc.usern, uc.passd, mail); return(RedirectToAction("doc_add_patient"));//show succes or failure along// }