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 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 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");
}
}
}
protected void Upload_Image_Click(object sender, EventArgs e)
{
string User = Session["admin"].ToString();
if (User == null || User == string.Empty)
{
Response.Redirect("Admin_Login.aspx");
}
else
{
string cat = "hello";
main_class m = new main_class();
//file upload code
if (FileUpload1.HasFile)
{
string q = "/images/PhotoGallery/" + FileUpload1.PostedFile.FileName;
FileUpload1.SaveAs(MapPath(q));
int max_id = m.get_maxid("PhotoGallery");
//Inserting in db
string q1 = string.Format("insert into PhotoGallery values ({0},'{1}','{2}','{3}') ", max_id, q, cat, User);
SqlCommand insertCommand = new SqlCommand(q1, m.cn);
insertCommand.ExecuteNonQuery();
Response.Write("Image Uploaded");
}
m.cn.Close();
m = null;
}
}
