protected void bt1_Click(object sender, EventArgs e) { Class1 x = new Class1(); x.connect(); string at = "select max(Id_institute) from Institutemaster "; int ff = x.autoincrement(at); string varidpol = ff.ToString(); string varname=txtname.Text; string varadd=txtaddress.Text; string varcity=txtcity.Text; string varstate=txtstate.Text; string varcountry=ddlcountry.SelectedItem.ToString(); string varabout=txtabout.Text; string varaff=txtaffiliated.Text; string varcat=ddlcategory.SelectedItem.ToString(); string varsub = ddlsub.SelectedItem.ToString(); string varwebsite=txtwebsite.Text; string varemail=txtemail.Text; string varpass= txtpassword.Text; string varhelp=txthelp.Text; string varapp = txtapp.Text; string q = "insert into Institutemaster(Id_institute,Name,Address,City,State,Country,About,Affiliated,Category,Subcategory,Website,Email,Password,Helplineno,Approved) values("+ varidpol +",'"+varname +"','"+varadd +"','"+varcity +"','"+varstate +"','"+varcountry +"','"+varabout +"','"+varaff +"','"+varcat +"','"+varsub +"','"+varwebsite +"','"+varemail +"','"+varpass +"',"+varhelp+",'"+varapp +"')"; x.allquery(q); }
protected void Page_Load(object sender, EventArgs e) { Class1 x = new Class1(); x.connect(); if(!IsPostBack) { string q = "select * from Polls"; DataTable dt = x.display(q); gv1.DataSource = dt; gv1.DataBind(); if (Request.QueryString["iid"] != null) { string id= Request.QueryString["iid"].ToString(); string s = "delete from polls where id_poll=" + id; x.allquery(s); Response.Redirect("deletepoll.aspx"); } } }
protected void b1_Click(object sender, EventArgs e) { Class1 X = new Class1(); X.connect(); string at = "select max(id_feedback) from feedback "; int ff = X.autoincrement(at); string msg = "name is "+ t1.Text + "E-mail is" +t2.Text + "Phone-no is"+t3.Text + "Message is"+t4.Text; string w = "insert into feedback values('"+ff+"','"+t1.Text+"','"+t2.Text+"','"+t3.Text+"','"+t4.Text+"')"; int n= X.allquery(w); if (Send(SQLFix("*****@*****.**"), SQLFix("FORGET PASSWORD "), SQLFix(msg))) { abcxyz.Text = "Your inquiry has been succesfully sent"; abcxyz.Visible = true; } else { abcxyz.Text = "Problem with Sending Email , Try after some time"; abcxyz.Visible = true; } }
protected void signup_Click(object sender, EventArgs e) { Class1 x = new Class1(); x.connect(); string at = "select max(Id_Student) from studentmaster"; int studentid = x.autoincrement(at); string m = "insert into Studentmaster values ('" + studentid + "','" + name.Text + "','" + dob.Text + "','" + address.Text + "','" + recentqualification.Text + "','" + email.Text + "','" + city.Text + "','" + state.Text + "','" + country.Text + "','" + username.Text + "','" + password.Text + "','" + newsletter.SelectedItem + "','" + phone.Text + "')"; x.allquery(m); }
protected void button1_Click(object sender, EventArgs e) { Class1 x = new Class1(); x.connect(); string at = "select max(Id_course) from Course_master "; int ff = x.autoincrement(at); string varidpol = ff.ToString(); string q = "insert into Course_master values(" + varidpol + ",'" + TextBox1.Text + "','" + textbox2.Text + "','" + textbox3.Text + "')"; x.allquery(q); TextBox1.Text = ""; textbox2.Text = ""; textbox3.Text = ""; Label1.Visible = true; }
protected void Button1_Click(object sender, EventArgs e) { Class1 x = new Class1(); x.connect(); string varinstitut = Session["Id_institute"].ToString(); ; int varphotoid = x.autoincrement("select max(id_photos) from institutephotogal"); string varphoto = "photos/" + FileUpload1.FileName; FileUpload1.SaveAs(MapPath(varphoto)); Image1.ImageUrl = varphoto; string q = "insert into institutephotogal values(" + varinstitut + "," + varphotoid + ",'" + varphoto + "')"; x.allquery(q); ltr.Text = "Photo Uploaded"; }
protected void add_Click(object sender, EventArgs e) { Class1 x = new Class1(); x.connect(); string at = "select max(id_poll) from Polls "; int ff = x.autoincrement(at); string varidpol = ff.ToString(); string varque = txtques1.Text; string varop1 = txtop1.Text; string varop2 = txtop2.Text; string varop3 = txtop3.Text; string varop4 = txtop4.Text; string q = "insert into polls values(" + varidpol + ",'" + varque + "','" + varop1 + "','" + varop2 + "','" + varop3 + "','" + varop4 + "')"; int n = x.allquery(q); }
protected void isignup_Click(object sender, EventArgs e) { Class1 x = new Class1(); x.connect(); string ai = "select max(Id_institute) from Institutemaster"; int instid = x.autoincrement(ai); string filename = "../logo/default.jpg"; if (FileUpload1.HasFile) { filename = "../logo/" + FileUpload1.FileName; FileUpload1.SaveAs(MapPath(filename)); } else { filename = "../logo/untitled.png"; // logo.SaveAs(MapPath(filename)); } string m = "insert into institutemaster values ('" + instid + "','" + name.Text + "','" + addr.Text + "','" + helpline.Text + "','" + category.Text + "','" + Subcategory.Text + "','" + City.Text + "','" + State.Text + "','" + cont.SelectedItem + "','" + about.Text + "','" + aff.Text + "','" + website.Text + "','" + Email.Text + "','" + password.Text + "','Yes','" + filename + "')"; x.allquery(m); }