protected void ADD_BTN_Click(object sender, EventArgs e) { Student_DBEntities S = new Student_DBEntities(); Student student = new Student(); student.Name = TextBoxName.Text; student.Phone = TextBoxPhone.Text; student.Email = TextBoxEmail.Text; student.Courses = TextBoxCourses.Text; student.division = TextBoxDivision.Text; student.Score = TextBoxScore.Text; student.Job = TextBoxJob.Text; if (TextBoxGradYear.Text != "") { student.Graduation_Year = Convert.ToInt32(TextBoxGradYear.Text); } else { student.Graduation_Year = 0; } student.Degree = TextBoxDegree.Text; S.Students.Add(student); S.SaveChanges(); Response.Redirect("Display"); }
protected void EDIT_BTN_Click(object sender, EventArgs e) { Student_DBEntities S = new Student_DBEntities(); int ID = Convert.ToInt32(Request.QueryString["ID"]); Student student = S.Students.FirstOrDefault(x => x.Id == ID); student.Name = TextBoxName.Text; student.Phone = TextBoxPhone.Text; student.Email = TextBoxEmail.Text; student.Courses = TextBoxCourses.Text; student.division = TextBoxDivision.Text; student.Score = TextBoxScore.Text; student.Job = TextBoxJob.Text; student.Graduation_Year = Convert.ToInt32(TextBoxGradYear.Text); student.Degree = TextBoxDegree.Text; S.SaveChanges(); Response.Redirect("Display"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string S_Type = Request.QueryString["S_Type"]; string Search = Request.QueryString["S"]; string RemoveID = Request.QueryString["RemoveID"]; Student_DBEntities S = new Student_DBEntities(); if (S_Type != null) { SearchTypeDDL.ClearSelection(); SearchTypeDDL.Items.FindByText(S_Type).Selected = true; } if (RemoveID != null) { int R_ID = Convert.ToInt32(RemoveID); Student student = S.Students.FirstOrDefault(x => x.Id == R_ID); S.Students.Remove(student); S.SaveChanges(); } if (Search == null || Search == "") { Students_list = S.Students.ToList(); } else { switch (S_Type) { case "الاسم": Students_list = S.Students.ToList().Where(x => x.Name.Contains(Search)); break; case "التلفون": Students_list = S.Students.ToList().Where(x => x.Phone == Search); break; case "البريد": Students_list = S.Students.ToList().Where(x => x.Email.Contains(Search)); break; case "الدورات التدريبيه": Students_list = S.Students.ToList().Where(x => x.Courses.Contains(Search)); break; case "الشعبه": Students_list = S.Students.ToList().Where(x => x.division.Contains(Search)); break; case "التقدير": Students_list = S.Students.ToList().Where(x => x.Score.Contains(Search)); break; case "الوظيفه": Students_list = S.Students.ToList().Where(x => x.Job.Contains(Search)); break; case "سنة التخرج": Students_list = S.Students.ToList().Where(x => x.Graduation_Year == Convert.ToInt32(Search)); break; case "الدرجة العلمية": Students_list = S.Students.ToList().Where(x => x.Degree.Contains(Search)); break; } } } }