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"));
}
