protected void save1_Click(object sender, EventArgs e) { string a = "select max(cropid) from cropdetails"; string b = db.maxid(a).ToString(); if (save1.Text == "SAVE") { string s = "insert into cropdetails values('" + b + "','" + crty.Text + "','" + crc.Text + "','" + crn.Text + "','" + Session["path"] + "','" + dt.Text + "')"; db.nonreturn(s); Response.Write("<script>alert('Inserted successfully...');window.location='agricropferti.aspx'</script>"); crty.Text = " "; crc.Text = " "; crn.Text = " "; dt.Text = " "; grid1(); } else { string s = "update cropdetails set croptype='" + crty.Text + "',cropclass='" + crc.Text + "',cropname='" + crn.Text + "',details='" + dt.Text + "' where cropid='" + b + "'"; db.nonreturn(s); Response.Write("<script>alert('updated successfully...');window.location='agricropferti.aspx'</script>"); crty.Text = " "; crc.Text = " "; dt.Text = " "; grid1(); } }
protected void send_Click(object sender, EventArgs e) { string c = "select max(replyid) from reply"; string d = db.maxid(c).ToString(); string b = "insert into reply values ('" + Session["msgid"] + "','" + d + "','" + msgs + "')"; db.nonreturn(b); Response.Write("<script>alert('Reply send successfully...');window.location='agridoubtclearence.aspx'</script>"); }
public ActionResult patient_medical_details_insert(FormCollection fm) { pmed.chestpain = fm["ctl00$MainContent$DropDownPaintype"]; pmed.restsbp = fm["ctl00$MainContent$bpsText"]; pmed.restdbp = fm["ctl00$MainContent$bpdText"]; pmed.cholestrol = fm["ctl00$MainContent$cholText"]; pmed.fastbs = fm["ctl00$MainContent$fsugarText"]; pmed.restecg = fm["ctl00$MainContent$DropDownRestecg"]; pmed.maxheart = fm["ctl00$MainContent$heartrateText"]; pmed.exangina = fm["ctl00$MainContent$DropDownExercisAn"]; pmed.oldpeak = fm["ctl00$MainContent$peakText"]; pmed.slop = fm["ctl00$MainContent$DropDownSlope"]; pmed.numvessel = fm["ctl00$MainContent$DropDownVessels"]; pmed.thal = fm["ctl00$MainContent$DropDownThal"]; pmed.pid = Convert.ToInt32(Session["logid"]); SqlCommand cm = new SqlCommand(); cm.CommandText = "maxmid_in_patmed"; int id = d.maxid(cm); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "set_patient_med_details"; cmd.Parameters.AddWithValue("@mid", (id)); cmd.Parameters.AddWithValue("@pid", (pmed.pid)); cmd.Parameters.AddWithValue("@chestpain", dna.eNcrypt(pmed.chestpain)); cmd.Parameters.AddWithValue("@restsbp", dna.eNcrypt(pmed.restsbp)); cmd.Parameters.AddWithValue("@chol", dna.eNcrypt(pmed.cholestrol)); cmd.Parameters.AddWithValue("@fastbs", dna.eNcrypt(pmed.fastbs)); cmd.Parameters.AddWithValue("@restecg", dna.eNcrypt(pmed.restecg)); cmd.Parameters.AddWithValue("@maxh", dna.eNcrypt(pmed.maxheart)); cmd.Parameters.AddWithValue("@exang", dna.eNcrypt(pmed.exangina)); cmd.Parameters.AddWithValue("@oldp", dna.eNcrypt(pmed.oldpeak)); cmd.Parameters.AddWithValue("@slop", dna.eNcrypt(pmed.slop)); cmd.Parameters.AddWithValue("@numv", dna.eNcrypt(pmed.numvessel)); cmd.Parameters.AddWithValue("@thal", dna.eNcrypt(pmed.thal)); d.execute(cmd); Session["visible_predict"] = 1; return(RedirectToAction("patient_medical_details")); }
protected void save_Click(object sender, EventArgs e) { string b = "select max(artid) from article"; string c = db.maxid(b).ToString(); string s = "insert into article values ('" + c + "','" + System.DateTime.Now.ToShortDateString() + "','" + artit.Text + "','" + Session["path"] + "')"; db.nonreturn(s); Response.Write("<script>alert('Inserted successfully...');window.location='adminarticle.aspx'</script>"); artit.Text = " "; MultiView1.SetActiveView(View1); grid(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); string a = "select * from governmentpolicies"; DataTable dt = db.ret(a); DataGrid1.DataSource = dt; DataGrid1.DataBind(); string b = "select max(policyno) from governmentpolicies"; policy_no.Text = db.maxid(b).ToString(); } }
protected void save_Click(object sender, EventArgs e) { Random rnd = new Random(); int pwd = rnd.Next(4411, 55555); string a = "select max(userid) from login"; b = db.maxid(a).ToString(); z = "AO" + b; string dob = DropDownList2.Text + "/" + DropDownList3.Text + "/" + DropDownList4.Text; string doj = DropDownList5.Text + "/" + DropDownList6.Text + "/" + DropDownList7.Text; string dor = DropDownList8.Text + "/" + DropDownList9.Text + "/" + DropDownList10.Text; string g = " "; if (f.Checked == true) { g = f.Text; } else { g = m.Text; } if (save.Text == "save") { string s = "insert into AOS values('" + b + "'," + DropDownList1.SelectedValue + ",'" + name.Text + "','" + em_l.Text + "','" + Ph_ne.Text + "','" + doj + "','" + dob + "','" + dor + "','" + z + "','" + Session["path"] + "','" + g + "')"; db.nonreturn(s); string u = "insert into login values('" + b + "','" + z + "','" + pwd + "','AO')"; db.nonreturn(u); SmtpClient sc = new SmtpClient("smtp.gmail.com", 587); MailMessage msg = new MailMessage("*****@*****.**", em_l.Text); msg.Subject = "Your A/C password"; msg.Body = ("thankyou for registering. Your username is" + z + "Your password is" + pwd); sc.Credentials = new NetworkCredential("anjithad43", " muqmapassion"); sc.EnableSsl = true; sc.Send(msg); Response.Write("<script>alert('Inserted successfully...');window.location='adminaoreg.aspx'</script>"); name.Text = " "; em_l.Text = " "; Ph_ne.Text = " "; } else { string c = "update AOS set name=" + name.Text + ", emailid= " + em_l.Text + ",phoneid='" + Ph_ne.Text + "' where aid='" + b + "'"; db.nonreturn(c); Response.Write("<script>alert('updated successfully...');window.location='adminaoreg.aspx'</script>"); name.Text = " "; em_l.Text = " "; Ph_ne.Text = " "; } }
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// }
protected void save_Click(object sender, EventArgs e) { string a = "select max(fertid) from fertilizerdetails"; string b = db.maxid(a).ToString(); if (save.Text == "SAVE") { string s = "insert into fertilizerdetails values ('" + b + "','" + fertn.Text + "','" + usedfr.Text + "','" + Session["path"] + "')"; db.nonreturn(s); Response.Write("<script>alert('Inserted successfully...');window.location='adminferti.aspx'</script>"); fertn.Text = " "; usedfr.Text = " "; } else { string s = "update fertilizerdetails set fertname='" + fertn.Text + "',usedin='" + usedfr.Text + "' where fertid='" + b + "'"; db.nonreturn(s); Response.Write("<script>alert('Updated successfully...');window.location='adminferti.aspx'</script>"); fertn.Text = " "; usedfr.Text = " "; } }
protected void save_Click(object sender, EventArgs e) { string b = "select max(policyid) from notification"; string c = db.maxid(b).ToString(); if (save.Text == "SAVE") { string s = "insert into notification values ('" + c + "','" + tit.Text + "','" + notd.Text + "','" + notde.Text + "')"; db.nonreturn(s); Response.Write("<script>alert('Inserted successfully...');window.location='adminnotification.aspx'</script>"); tit.Text = " "; notd.Text = " "; notde.Text = " "; } else { string s = "update notification set title='" + tit.Text + "',notdate='" + notd.Text + "',notdet='" + notde.Text + "' where policyid='" + c + "'"; db.nonreturn(s); Response.Write("<script>alert('updated successfully...');window.location='adminnotification.aspx'</script>"); tit.Text = " "; notde.Text = " "; notd.Text = " "; } }
public ActionResult insert_doc(FormCollection f) { SqlCommand cm = new SqlCommand(); cm.CommandText = "maxid_in_login"; int id = db.maxid(cm); Random rd = new Random(); ulc.passd = rd.Next(000000, 999999).ToString() + Session["logid"].ToString(); dr.d_fname = f["ctl00$MainContent$DfnameText"]; dr.d_mname = f["ctl00$MainContent$DmnameText"]; dr.d_lname = f["ctl00$MainContent$DlnameText"]; dr.d_gender = f["ctl00$MainContent$RadioButtonListGen"]; dr.d_dob = f["ctl00$MainContent$DdobText"]; dr.d_mob = f["ctl00$MainContent$DmobText"]; dr.d_add = f["ctl00$MainContent$DaddrText"]; dr.d_pin = f["ctl00$MainContent$DpinText"]; dr.d_email = f["ctl00$MainContent$DmailText"]; dr.d_school1 = f["ctl00$MainContent$Dschool1Text"]; dr.d_school2 = f["ctl00$MainContent$Dschool2Text"]; dr.d_school3 = f["ctl00$MainContent$Dschool3Text"]; dr.d_cgpa1 = f["ctl00$MainContent$Dcgpa1Text"]; dr.d_cgpa2 = f["ctl00$MainContent$Dcgpa2Text"]; dr.d_cgpa3 = f["ctl00$MainContent$Dcgpa3Text"]; dr.d_year1 = Convert.ToInt32(f["ctl00$MainContent$Dyear1Text"]); dr.d_year2 = Convert.ToInt32(f["ctl00$MainContent$Dyear2Text"]); dr.d_year3 = Convert.ToInt32(f["ctl00$MainContent$Dyear3Text"]); dr.d_board1 = f["ctl00$MainContent$DBoard1Text"]; dr.d_board2 = f["ctl00$MainContent$Dboard2Text"]; dr.d_board3 = f["ctl00$MainContent$Dboard3Text"]; dr.d_hosp = f["ctl00$MainContent$DhospText"]; DateTime StartDate = Convert.ToDateTime(f["ctl00$MainContent$TextBox1"]); DateTime EndDate = Convert.ToDateTime(f["ctl00$MainContent$TextBox2"]); DateTime zeroTime = new DateTime(1, 1, 1); TimeSpan span = EndDate - StartDate; int years = (zeroTime + span).Year - 1; dr.d_exper = years.ToString(); dr.d_resume_path = f["ctl00$MainContent$FileUploadResume"]; dr.d_photo_path = f["ctl00$MainContent$FileUploadResume"]; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "insert_doctor"; cmd.Parameters.AddWithValue("@did", id); cmd.Parameters.AddWithValue("@fname", dr.d_fname); cmd.Parameters.AddWithValue("@mname", dr.d_mname); cmd.Parameters.AddWithValue("@lname", dr.d_lname); cmd.Parameters.AddWithValue("@gender", dr.d_gender); cmd.Parameters.AddWithValue("@dob", dr.d_dob); cmd.Parameters.AddWithValue("@mob", dr.d_mob); cmd.Parameters.AddWithValue("@add", dr.d_add); cmd.Parameters.AddWithValue("@pin", dr.d_pin); cmd.Parameters.AddWithValue("@email", dr.d_email); cmd.Parameters.AddWithValue("@school1", dr.d_school1); cmd.Parameters.AddWithValue("@school2", dr.d_school2); cmd.Parameters.AddWithValue("@school3", dr.d_school3); cmd.Parameters.AddWithValue("@cgpa1", dr.d_cgpa1); cmd.Parameters.AddWithValue("@cgpa2", dr.d_cgpa2); cmd.Parameters.AddWithValue("@cgpa3", dr.d_cgpa3); cmd.Parameters.AddWithValue("@year1", dr.d_year1); cmd.Parameters.AddWithValue("@year2", dr.d_year2); cmd.Parameters.AddWithValue("@year3", dr.d_year3); cmd.Parameters.AddWithValue("@board1", dr.d_board1); cmd.Parameters.AddWithValue("@board2", dr.d_board2); cmd.Parameters.AddWithValue("@board3", dr.d_board3); cmd.Parameters.AddWithValue("@hosp", dr.d_hosp); cmd.Parameters.AddWithValue("@exper", dr.d_exper); cmd.Parameters.AddWithValue("@resume", "1"); cmd.Parameters.AddWithValue("@photo", "1"); cmd.Parameters.AddWithValue("@uid", id); cmd.Parameters.AddWithValue("@uname", Session["newdoc_uname"].ToString()); cmd.Parameters.AddWithValue("@passw", ulc.passd); cmd.Parameters.AddWithValue("@utype", "Doctor"); db.execute(cmd); return(RedirectToAction("Doc_registration")); }