protected void signup_Click(object sender, EventArgs e) { main_class m = new main_class(); //check string check = string.Format("select * from professor where username = '******' ",Profesor_usrname.Text); DataTable dt = m.filldt(check); if (dt.Rows.Count != 0) { exists.Visible = true; } else { int id = m.get_maxid("professor"); string professor_register = string.Format("insert into professor (professor_Id,FName,Email,Contactno,Username,Password,approved,institute) values ({0},'{1}','{2}',{3},'{4}','{5}' , 'No' , '{6}') ", id, Profesor_name.Text, Profesor_email.Text, Profesor_no.Text, Profesor_usrname.Text, Profesor_passwrd.Text, institute.Text); m.insertvalues(professor_register); //dispose m.cn.Close(); m = null; Response.Redirect("Professor_login.aspx"); } }
protected void fill_Click(object sender, EventArgs e) { string professor = Session["Professor_Username"].ToString(); main_class m = new main_class(); for (int i = 0; i < attendence.Rows.Count; i++) { string result = ""; RadioButtonList rb = attendence.Rows[i].Cells[4].FindControl("rblist") as RadioButtonList; if (rb.Items[0].Selected == true) { result = "Present"; } if (rb.Items[1].Selected == true) { result = "Absent"; } int max_id=m.get_maxid("attendence"); string ins_attn = string.Format("insert into attendence values ({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8}) ", max_id, attendence.Rows[i].Cells[0].Text, attendence.Rows[i].Cells[1].Text, attendence.Rows[i].Cells[2].Text, result, professor, date.Text.ToString(), subject.Text, attendence.Rows[i].Cells[3].Text); m.insertvalues(ins_attn); } }
protected void approve_Click(object sender, EventArgs e) { object ID = ((Button)sender).CommandArgument; Response.Write(ID.ToString()); main_class m = new main_class(); string update = string.Format("update professor set approved = 'Yes' where Professor_Id= {0} ",ID); m.insertvalues(update); bind_profesor(); }
protected void add_Click(object sender, EventArgs e) { string admin= Session["User"].ToString(); main_class m = new main_class(); int max_id = m.get_maxid("Department"); string ins = string.Format("insert into department values ({0},'{1}','{2}') ",max_id,department.Text,admin); m.insertvalues(ins); bind_files(); }
protected void save_Click(object sender, EventArgs e) { main_class m = new main_class(); string img_path = ""; //Image Upload Code if (FileUpload1.HasFile) { try { System.IO.File.Delete(MapPath(img.ImageUrl)); } catch { } img_path = "/images/ProfilePic_Student/" + FileUpload1.FileName; FileUpload1.SaveAs(MapPath(img_path)); } else { img_path = img.ImageUrl; } // string username = Session["Student_Username"].ToString(); int id = m.get_idfromusername("student",username); string update = string.Format("update student set fname='{0}',"+ "mname='{1}',"+ "lname='{2}',"+ "email='{3}',"+ "contactno={4},"+ "profilepic='{5}',"+ "school='{6}',"+ "college='{7}',"+ "bdate='{8}',"+ "gender='{9}',"+ "enrollno='{10}',"+ "department = '{11}' where student_id = {12}", first_name.Text, Middle_name.Text, last_name.Text, mail_id.Text, contactno.Text, img_path, high_school.Text, college.Text, bdate_date.Text, gender.Text, enrollmentno.Text, department.Text, id ); m.insertvalues(update); m = null; }
protected void save_Click(object sender, EventArgs e) { main_class m = new main_class(); string username = Session["Professor_Username"].ToString(); string img_path = ""; //Image Upload Code if (FileUpload1.HasFile) { try { System.IO.File.Delete(MapPath(img.ImageUrl)); } catch { } img_path = "/images/ProfilePic_Professor/" + FileUpload1.FileName; FileUpload1.SaveAs(MapPath(img_path)); } else { img_path = img.ImageUrl; } string update = string.Format("update Professor set fname='{0}',Mname='{1}',Lname='{2}',Profilepic='{3}',contactno={4},bdate='{5}',email='{6}',institute='{7}',gender='{8}',department='{9}' where username='******'", first_name.Text, Middle_name.Text, last_name.Text, img_path, contactno.Text, bdate_date.Text, mail_id.Text, college.Text, gender.Text, department.Text, username); m.insertvalues(update); Response.Redirect("Professor_Home.aspx"); }
protected void Upload_doc_Click(object sender, EventArgs e) { string professor = Session["Professor_Username"].ToString(); main_class m = new main_class(); if (FileUpload1.HasFile) { string ext = Path.GetExtension(FileUpload1.FileName); if (ext == ".PPTX" || ext == ".pptx" || ext == ".PPT" || ext == ".ppt" || ext == ".pdf" || ext == ".PDF" || ext == ".txt" || ext == ".TXT" || ext == ".DOC" || ext == ".doc" || ext == ".DOCX" || ext == ".docx") { string q = "/Docs/" + FileUpload1.FileName; FileUpload1.SaveAs(MapPath(q)); int max_id = m.get_maxid("docs"); //Inserting in db string q1 = string.Format("insert into docs values ({0},'{1}','{2}','{3}') ", max_id, professor, q, doc_title.Text); m.insertvalues(q1); Response.Write("File Uploaded"); bind_files(); } else { Response.Write("Only PDF Files allowed"); } } }