protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string GY = Request.QueryString["Year"];
Student_DBEntities S = new Student_DBEntities();
var GYL = S.Students.GroupBy(x => x.Graduation_Year);
foreach (var i in GYL)
{
Grad_Year_DDL.Items.Add(i.Key.ToString());
}
if (GY != null)
{
Grad_Year_DDL.ClearSelection();
Grad_Year_DDL.Items.FindByText(GY).Selected = true;
}
else
{
Grad_Year_DDL.ClearSelection();
Grad_Year_DDL.Items.FindByText(GYL.First().Key.ToString()).Selected = true;
}
int Grad_year = Convert.ToInt32(Grad_Year_DDL.SelectedItem.Text);
year_grads_count = S.Students.ToList().Where(x => x.Graduation_Year == Grad_year).Count();
total_grads_count = S.Students.ToList().Count();
ratio = ((float)year_grads_count / (float)total_grads_count) * 100;
}
}
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 ID_S = Request.QueryString["ID"];
if (ID_S != null)
{
edit = true;
int ID = Convert.ToInt32(ID_S);
Student_DBEntities S = new Student_DBEntities();
var Student = S.Students.FirstOrDefault(x => x.Id == ID);
TextBoxName.Text = Student.Name;
TextBoxPhone.Text = Student.Phone;
TextBoxEmail.Text = Student.Email;
TextBoxCourses.Text = Student.Courses;
TextBoxDivision.Text = Student.division;
TextBoxScore.Text = Student.Score;
TextBoxJob.Text = Student.Job;
TextBoxGradYear.Text = Student.Graduation_Year.ToString();
TextBoxDegree.Text = Student.Degree;
}
}
}
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;
}
}
}
}
