protected void btnlog_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(txtstudent.Text))
{
//Response.Write("<script>alert('Sonunda amk')</script>");
Console.WriteLine("Fill the Blanks");
lblEror.Text = "Fill the Blanks!!";
lblEror.Visible = true;
System.Threading.Thread.Sleep(6000);
Response.Redirect("Login.aspx");
//Response.Redirect("Login.aspx");
}
int id = Convert.ToInt32(txtstudent.Text);
using (var db = new Ceng396_TermEntities())
{
var query = (from b in db.Student1 where b.StudentID == id &&
b.Password == txtpassw.Text select b).SingleOrDefault();
if (query != null)
{
Session["myuser"] = query.StudentID;
Session["guest"] = 0;
Response.Redirect("HomePage.aspx");
lblEror.Visible = false;
}
else
{
lblEror.Text = "Error! Check your email or password!!";
lblEror.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblID.Text = Request.QueryString["namesurname"];
var id = Convert.ToInt32(lblID.Text);
using (var db = new Ceng396_TermEntities())
{
var student = (from b in db.Student1
where b.StudentID == id
select b).SingleOrDefault();
lblisim.Text = student.SName;
lblstudentsoyisim.Text = student.SSurname;
lblfaculty.Text = student.Faculty;
lbldept.Text = student.Department;
lblyearstarted.Text = Convert.ToString((student.YearStarted));
if (student.Picture != null)
{
string PROFILE_PIC = Convert.ToBase64String(student.Picture);
Image1.ImageUrl = String.Format("data:image/jpg;base64,{0}", PROFILE_PIC);
}
}
}
protected void btncomment_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data source = DESKTOP-6PG46M2\SQLEXPRESS;Database=Ceng396_Term;User ID=sa;Password=123;Integrated Security=False");
con.Open();
SqlCommand cmd = new SqlCommand("insert into[CommentSection](Username,Subject,Comment,AcademicMemID)values(@Username,@Subject,@Comment,@AcademicMemID)", con);
//if (Convert.ToInt32(Session["guest"].ToString())==1)
//{
// lblguest.Visible = true;
// System.Threading.Thread.Sleep(3000);
// Response.Redirect("AcademicProfile.aspx");
//}
if (Session["myuser"] != null)
{
int id = Convert.ToInt32(Session["myuser"].ToString());
using (var db = new Ceng396_TermEntities())
{
var us = (from b in db.Student1
where b.StudentID == id select b).SingleOrDefault();
Label5.Text = us.SName;
}
}
using (var db = new Ceng396_TermEntities())
{
var acam = (from b in db.AcademicMems
where b.Name_Surname == Label2.Text
select b).SingleOrDefault();
lblAlper.Text = Convert.ToString(acam.ID);
}
cmd.Parameters.AddWithValue("@AcademicMemID", Convert.ToInt32(lblAlper.Text));
cmd.Parameters.AddWithValue("@Username", Label5.Text);
cmd.Parameters.AddWithValue("@Subject", txtSub.Text);
cmd.Parameters.AddWithValue("@Comment", txtcomment.Text);
cmd.ExecuteNonQuery();
con.Close();
txtSub.Text = string.Empty;
txtcomment.Text = string.Empty;
BindRepeaterData();
Response.Redirect("AcademicProfile.aspx?namesurname=" + Label2.Text);
}
protected void btnconfirm_Click(object sender, EventArgs e)
{
var id = Convert.ToUInt32(lblid.Text);
using (var db = new Ceng396_TermEntities())
{
var thestudent = (from b in db.Student1
where b.StudentID == id
select b).SingleOrDefault();
thestudent.Password = txtchngpass.Text;
thestudent.Email = txtchngemail.Text;
db.SaveChanges();
Response.Redirect("Login.aspx");
}
}
protected void btndisapprove_Click(object sender, EventArgs e)
{
using (var db = new Ceng396_TermEntities())
{
var acam = (from b in db.AcademicMems
where b.Name_Surname == Label2.Text
select b).SingleOrDefault();
acam.Rateb++;
acam.Rateg--;
btndisapprove.Enabled = false;
btnapprove.Enabled = true;
db.SaveChanges();
}
}
protected void btnreg_Click(object sender, EventArgs e)
{
using (var db = new Ceng396_TermEntities())
{
int idc = Convert.ToInt32(txtstudentid.Text);
var query = (from b in db.Student1 where b.StudentID == idc select b).SingleOrDefault();
if (query == null)
{
Student1 newUser = new Student1();
newUser.SName = txtname.Text;
newUser.SSurname = txtsurname.Text;
newUser.StudentID = idc;
newUser.IncasePassword = txtincase.Text;
newUser.Department = txtdept.Text;
newUser.Faculty = txtfac.Text;
newUser.YearStarted = txtyear.Text;
newUser.Email = txtemail.Text;
// newUser.email = txtMail.Text;
newUser.Password = txtpass.Text;
if (txtcpass.Text == txtpass.Text)
{
db.Student1.Add(newUser);
db.SaveChanges();
lblEror.Text = "Register Successful!";
lblEror.Visible = true;
Response.Redirect("Login.aspx");
}
else
{
lblEror.Text = "You entered wrong password!";
lblEror.Visible = true;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
System.Threading.Thread.Sleep(3000);
Response.Redirect("Register.aspx");
}
}
else
{
lblEror.Text = "Existing User!";
lblEror.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToInt32(Session["guest"].ToString()) == 1)
{
btnapprove.Enabled = false;
btndisapprove.Enabled = false;
txtcomment.Enabled = false;
txtSub.Enabled = false;
btncomment.Enabled = false;
}
Label2.Text = Request.QueryString["namesurname"];
using (var db = new Ceng396_TermEntities())
{
var acam = (from b in db.AcademicMems
where b.Name_Surname == Label2.Text
select b).SingleOrDefault();
lblfac.Text = acam.Faculty;
lbldep.Text = acam.Department;
string PROFILE_PIC = Convert.ToBase64String(acam.Picture);
Image1.ImageUrl = String.Format("data:image/jpg;base64,{0}", PROFILE_PIC);
cmd2 = new SqlCommand("SELECT Username,Subject,Comment FROM CommentSection WHERE AcademicMemID like'" + acam.ID + "%'", con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
}
else
{
grdAlperComment.DataSource = dt;
grdAlperComment.DataBind();
}
con.Close();
}
if (IsPostBack)
{
BindRepeaterData();
}
}
protected void btnconfirm_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txtstudentid.Text);
using (var db = new Ceng396_TermEntities())
{
var query = (from b in db.Student1
where b.StudentID == id
select b).SingleOrDefault();
if (query.IncasePassword == txtspass.Text)
{
lblyp.Visible = true;
lblspassdisplay.Text = query.Password;
lblspassdisplay.Visible = true;
}
else
{
lblspassdisplay.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblid.Text = Session["myuser"].ToString();
var id = Convert.ToUInt32(lblid.Text);
using (var db = new Ceng396_TermEntities())
{
var thestudent = (from b in db.Student1
where b.StudentID == id
select b).SingleOrDefault();
lblname.Text = thestudent.SName;
lblsurname.Text = thestudent.SSurname;
lbldept.Text = thestudent.Department;
lblemail.Text = thestudent.Email;
lblfaculty.Text = thestudent.Faculty;
lblyear.Text = thestudent.YearStarted;
if (thestudent.Picture != null)
{
string PROFILE_PIC = Convert.ToBase64String(thestudent.Picture);
Image1.ImageUrl = String.Format("data:image/jpg;base64,{0}", PROFILE_PIC);
}
}
}
