private void GenerateTasks() { using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { dvgsmark2.Rows.Clear(); List <Modelss.Student> students = db.Students.Where(s => s.GroupId == _groupID).ToList(); foreach (var item in students) { List <Modelss.StudentsMark> studentsMark = db.StudentsMarks.Where(sm => sm.StudentId == item.Id && sm.TaskId == _taskID).ToList(); Modelss.Task task = item.Group.Tasks.FirstOrDefault(t => t.Id == _taskID); string taskName = ""; int taskMark = 0; if (task != null) { taskName = task.Name; Modelss.StudentsMark smark = task.StudentsMarks.FirstOrDefault(sm => sm.StudentId == item.Id); if (smark != null) { taskMark = smark.Mark; } } dvgsmark2.Rows.Add(item.Id, task.Id, item.Name, item.Surname, taskName, taskMark); } } }
private bool UpdateTeacher() { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { int spId = (db.Educations.Where(a => a.Name == cbSpc.SelectedItem.ToString())).FirstOrDefault().Id; T.Id = Convert.ToInt32(dvgTeacherss.CurrentRow.Cells[0].Value); Modelss.Teacher Teachers = db.Teachers.Where(g => g.Id == T.Id).FirstOrDefault(); Teachers.Name = txtName.Text; Teachers.Surname = txtSurname.Text; Teachers.Email = txtEmail.Text; Teachers.Phone = txtPhone.Text; Teachers.SpecialityID = spId; affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
void FillStudents() { using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { dvgstudent.Rows.Clear(); List <Modelss.Student> students = db.Students.Where(s => s.Status == true).ToList(); List <Modelss.Group> grps = db.Groups.Where(g => g.Status == true).ToList(); foreach (var item in grps) { cbStudentGroups.Items.Add(item.Name); } foreach (var item in students) { List <Modelss.Group> groups = db.Groups.Where(g => g.Id == item.GroupId).ToList(); double studentGroup = 0; foreach (var item2 in groups) { studentGroup = Convert.ToDouble(item2.Education.Price); } double odm = studentGroup - Convert.ToDouble(item.Fee); if (odm < 0) { odm = 0; } dvgstudent.Rows.Add(item.Id, item.Name, item.Surname, item.Email, item.Phone, item.Group.Name, item.Fee, odm); } } }
private void BtnSsearch_Click(object sender, EventArgs e) { string srchTxt = txtSearchstudent.Text.Trim().ToLower(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Student> foundedStudents = db.Students.Where(f => f.Name.ToLower().Contains(srchTxt) || f.Surname.ToLower().Contains(srchTxt) || f.Group.Name.ToLower().Contains(srchTxt) || f.Phone.ToLower().Contains(srchTxt) || f.Email.ToLower().Contains(srchTxt) ).ToList(); dvgstudent.Rows.Clear(); foreach (var item in foundedStudents) { List <Modelss.Group> groups = db.Groups.Where(g => g.Id == item.GroupId).ToList(); double studentGroup = 0; foreach (var item2 in groups) { studentGroup = Convert.ToDouble(item2.Education.Price); } double odm = studentGroup - Convert.ToDouble(item.Fee); if (odm < 0) { odm = 0; } dvgstudent.Rows.Add(item.Id, item.Name, item.Surname, item.Email, item.Phone, item.Group.Name, item.Fee, odm); } } }
private void Tsearch_Click(object sender, EventArgs e) { string srctxt = txtSearchh.Text.Trim().ToLower(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Group> gr = db.Groups.ToList(); List <Modelss.Teacher> tch = db.Teachers.Where(t => t.Name.ToLower().Contains(srctxt) || t.Surname.ToLower().Contains(srctxt) || t.Salary.ToString().Contains(srctxt) ).ToList(); dvgT.Rows.Clear(); foreach (var item in tch) { var list = db.Groups.Where(g => g.TeacherId == item.Id).ToList(); string Tgroups = " "; foreach (var item2 in list) { Tgroups += item2.Name + " "; } dvgT.Rows.Add(item.Id, item.Name, item.Surname, Tgroups, item.Salary); } } }
private void FillTeachers() { using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Teacher> teachers = db.Teachers.Where(t => t.Status == true).ToList(); List <Modelss.Group> grps = db.Groups.Where(g => g.Status == true).ToList(); foreach (var item in teachers) { var list = db.Groups.Where(g => g.TeacherId == item.Id).ToList(); string Tgroups = " "; foreach (var item2 in list) { Tgroups += item2.Name + " "; } dvgTeacherss.Rows.Add(item.Id, item.Name, item.Surname, item.Education.Name, item.Email, item.Phone, item.Salary); } List <Modelss.Education> educations = db.Educations.ToList(); List <Modelss.Group> gr = db.Groups.ToList(); foreach (var item in educations) { cbSpc.Items.Add(item.Name); } } }
private bool UpdateStudent() { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { studentFounded.Id = Convert.ToInt32(dvgstudent.CurrentRow.Cells[0].Value); List <Modelss.Group> gr = db.Groups.Where(g => g.Status == true).ToList(); int selected = cbStudentGroups.SelectedIndex; int grId = gr[selected].Id; Modelss.Student student = db.Students.Where(s => s.Id == studentFounded.Id).FirstOrDefault(); student.Name = txtSName.Text; student.Surname = txtSSurname.Text; student.Email = txtSEmail.Text; student.GroupId = grId; student.Phone = txtSPhone.Text; student.Fee = Convert.ToDouble(TxtSFee.Text); student.Status = true; affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void BtnSTsave_Click(object sender, EventArgs e) { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { groupp.Id = db.Groups.Where(g => g.Name == cbgroups.Text).FirstOrDefault().Id; //db.Tasks.Where(t => t.GroupId == groupp.Id).FirstOrDefault(); Modelss.Task grpTask = new Modelss.Task(); grpTask.Name = txtTask.Text; grpTask.Deadline = Convert.ToDateTime(tdedline.Text); grpTask.GroupId = groupp.Id; grpTask.Status = true; db.Tasks.Add(grpTask); affectedRows = db.SaveChanges(); txtTask.Text = tdedline.Text = cbgroups.Text = ""; } if (affectedRows > 0) { MessageBox.Show("Submitted"); return; } else { MessageBox.Show("Not Submitted !!"); return; } }
void FillStudents() { dvgstudent2.Rows.Clear(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Student> students = db.Students.Where(s => s.Group.Name == cbgr.Text).ToList(); foreach (var item in students) { dvgstudent2.Rows.Add(item.Id, item.Name, item.Surname); } } }
void FilldvgMarks() { dvgMarks.Rows.Clear(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.StudentsMark> studentsmark = db.StudentsMarks.ToList(); foreach (var item in studentsmark) { var studentList = db.Students.Where(m => m.Id == item.StudentId).ToList(); foreach (var item2 in studentList) { dvgMarks.Rows.Add(item.Id, item2.Id, item2.Name, item2.Surname, item.Task.Name, item.Mark); } } } }
private void TaskForm_Activated(object sender, EventArgs e) { dvgtask.Rows.Clear(); cbgroups.Items.Clear(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Group> gr = db.Groups.ToList(); foreach (var item in gr) { cbgroups.Items.Add(item.Name); } List <Modelss.Task> tasks = db.Tasks.ToList(); foreach (var item in tasks) { dvgtask.Rows.Add(item.GroupId, item.Id, item.Name, item.Deadline, item.Group.Name); } } }
private void GroupForm_Activated(object sender, EventArgs e) { dvggroup.Rows.Clear(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Group> grps = db.Groups.ToList(); foreach (var item in grps) { string mname = db.Employees.Where(m => m.Id == item.MentorId).FirstOrDefault().Name; var list = db.Teachers.Where(t => t.Id == item.TeacherId).ToList(); string tname = ""; foreach (var item2 in list) { tname += item2.Name; } dvggroup.Rows.Add(item.Id, item.Name, tname, mname, item.Education.Name, item.Capacity, item.Classroom.Name); } List <Modelss.Employee> emp = db.Employees.Where(em => em.PositionId == 1).ToList(); cbmentor.Items.Clear(); foreach (var item in emp) { cbmentor.Items.Add(item.Name); } List <Modelss.Teacher> tch = db.Teachers.ToList(); cbteacher.Items.Clear(); foreach (var item in tch) { cbteacher.Items.Add(item.Name); } List <Modelss.Education> edc = db.Educations.ToList(); cbprogram.Items.Clear(); foreach (var item in edc) { cbprogram.Items.Add(item.Name); } List <Modelss.Classroom> rooms = db.Classrooms.ToList(); cbroom.Items.Clear(); foreach (var item in rooms) { cbroom.Items.Add(item.Name); } } }
private void EmployeeForm_Activated(object sender, EventArgs e) { dvgemp.Rows.Clear(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Position> p = db.Positions.ToList(); foreach (var item in p) { eposition.Items.Add(item.Name); } List <Modelss.Employee> employees = db.Employees.ToList(); foreach (var item in employees) { dvgemp.Rows.Add(item.Id, item.Name, item.Surname, item.Email, item.Phone, item.Position.Name, item.Start_Time, item.Salary); } } }
private void Teachers_with_groups_Activated(object sender, EventArgs e) { using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Group> gr = db.Groups.ToList(); List <Modelss.Teacher> teachers = db.Teachers.ToList(); foreach (var item in teachers) { var list = db.Groups.Where(g => g.TeacherId == item.Id).ToList(); string Tgroups = " "; foreach (var item2 in list) { Tgroups += item2.Name + " "; } dvgT.Rows.Add(item.Id, item.Name, item.Surname, Tgroups, item.Salary); } } }
private void BtnTsearch_Click(object sender, EventArgs e) { string searchText = txtSearchClient.Text.Trim().ToLower(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Teacher> Tlist = db.Teachers.Where(c => c.Name.ToLower().Contains(searchText) || c.Surname.ToLower().Contains(searchText) || c.Email.ToLower().Contains(searchText) || c.Phone.ToLower().Contains(searchText) ).ToList(); dvgTeacherss.Rows.Clear(); foreach (var item in Tlist) { dvgTeacherss.Rows.Add(item.Id, item.Name, item.Surname, item.Education.Name, item.Email, item.Phone); } } }
private void EmpSave_Click(object sender, EventArgs e) { MessageBox.Show(timee.Value.ToString()); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { //Modelss.Employee emp = new Modelss.Employee(); //int selected = eposition.SelectedIndex; //List<Modelss.Position> position = db.Positions.ToList(); //int posID = position[selected].Id; //emp.PositionId = posID; //emp.Name = Ename.Text; //emp.Surname = esurname.Text; //emp.Phone = ephone.Text; //emp.Salary = Convert.ToDouble(esalaryy.Text); //emp.Start_Time = Convert.ToDateTime(timee.Value); //db.Employees.Add(emp); //db.SaveChanges(); } }
private void Btnwrite_Click(object sender, EventArgs e) { if (btnwrite.Text == "Update") { if (!UpdateMark()) { MessageBox.Show("Not Submitted"); cbg.Text = txtMark.Text = ""; return; } MessageBox.Show("Submitted"); FilldvgMarks(); FilldvgAverage(); btnwrite.Text = "Submit"; cbg.Text = txtMark.Text = ""; return; } string sname = dvgstudent2.CurrentRow.Cells[1].Value.ToString(); string ssurname = dvgstudent2.CurrentRow.Cells[2].Value.ToString(); int id = Convert.ToInt32(dvgstudent2.CurrentRow.Cells[0].Value); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { Modelss.StudentsMark sm = new Modelss.StudentsMark(); int taskid = Convert.ToInt32(db.Tasks.Where(t => t.Name == cbg.Text).FirstOrDefault().Id); sm.Mark = Convert.ToInt32(txtMark.Text); sm.StudentId = id; sm.TaskId = taskid; db.StudentsMarks.Add(sm); db.SaveChanges(); } FilldvgMarks(); FilldvgAverage(); txtMark.Text = cbg.Text = " "; }
private void StudentMarks_Activated(object sender, EventArgs e) { using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Task> tasks = db.Tasks.ToList(); cbg.Items.Clear(); foreach (var item in tasks) { cbg.Items.Add(item.Name); } List <Modelss.Group> groups = db.Groups.ToList(); foreach (var item in groups) { cbgr.Items.Add(item.Name); } } FilldvgMarks(); FilldvgAverage(); }
private bool DeleteStudent() { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { studentFounded.Id = Convert.ToInt32(dvgstudent.CurrentRow.Cells[0].Value); Modelss.Student st = db.Students.Where(s => s.Id == studentFounded.Id).FirstOrDefault(); db.Students.Remove(st); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void Btnmark2_Click(object sender, EventArgs e) { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { smm.Id = (int)dvgsmark2.CurrentRow.Cells[0].Value; Modelss.StudentsMark SM = db.StudentsMarks.Where(s => s.StudentId == smm.Id).FirstOrDefault(); //validation only numbers String patternnum = "^[0-9]+(,[0-9]+)*$"; Regex mark = new Regex(patternnum); Match numMatch = mark.Match(txtmark.Text); if (!numMatch.Success) { MessageBox.Show("Yalniz ededler daxil edin"); txtmark.Text = ""; return; } SM.Mark = Convert.ToInt32(txtmark.Text); SM.StudentId = (int)dvgsmark2.CurrentRow.Cells[0].Value; SM.TaskId = (int)dvgsmark2.CurrentRow.Cells[1].Value; affectedRows = db.SaveChanges(); //dvgsmark2.CurrentRow.Cells[5].Value = txtmark.Text; btnmark2.Enabled = false; txtmark.Text = ""; GenerateTasks(); } if (affectedRows > 0) { MessageBox.Show("success"); return; } else { MessageBox.Show("error"); return; } }
private void BtnSTsave_Click(object sender, EventArgs e) { if (btnSdelete.Enabled) { if (!UpdateStudent()) { MessageBox.Show(" Not Submited"); return; } MessageBox.Show(" Submited"); Refresh(); return; } using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { Modelss.Student students = new Modelss.Student(); List <Modelss.Group> gr = db.Groups.ToList(); int selected = cbStudentGroups.SelectedIndex; int StudentGrId = gr[selected].Id; List <Modelss.Student> studentss = db.Students.ToList(); dvgstudent.Rows.Add(ID, txtSName.Text, txtSSurname.Text, txtSEmail.Text, txtSPhone.Text, cbStudentGroups.Text, TxtSFee.Text); students.Name = txtSName.Text; students.Surname = txtSSurname.Text; students.Email = txtSEmail.Text; students.GroupId = StudentGrId; students.Phone = txtSPhone.Text; students.Fee = Convert.ToDouble(TxtSFee.Text); students.Status = true; txtSName.Text = txtSSurname.Text = txtSEmail.Text = cbStudentGroups.Text = TxtSFee.Text = txtSPhone.Text = " "; db.Students.Add(students); db.SaveChanges(); } }
void FilldvgAverage() { dvgavrage.Rows.Clear(); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Student> student = db.Students.ToList(); foreach (var item in student) { var tasklist = db.StudentsMarks.Where(m => m.StudentId == item.Id).ToList(); int mark = 0; int average = 0; foreach (var item2 in tasklist) { mark += item2.Mark; average = mark / tasklist.Count; } dvgavrage.Rows.Add(item.Id, item.Name, item.Surname, average); } } }
private bool DeleteTeacher() { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { T.Id = Convert.ToInt32(dvgTeacherss.CurrentRow.Cells[0].Value); Modelss.Teacher Teachers = db.Teachers.Where(g => g.Id == T.Id).FirstOrDefault(); db.Teachers.Remove(Teachers); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool UpdateMark() { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { studentMark.StudentId = Convert.ToInt32(dvgMarks.CurrentRow.Cells[1].Value); Modelss.StudentsMark studenmarks = db.StudentsMarks.Where(m => m.StudentId == studentMark.StudentId).FirstOrDefault(); int taskid = Convert.ToInt32(db.Tasks.Where(t => t.Name == cbg.Text).FirstOrDefault().Id); studenmarks.Mark = Convert.ToInt32(txtMark.Text); studenmarks.TaskId = taskid; studenmarks.StudentId = Convert.ToInt32(dvgMarks.CurrentRow.Cells[1].Value); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void BtnTsave_Click(object sender, EventArgs e) { if (btnTdelete.Enabled) { if (!UpdateTeacher()) { MessageBox.Show("Not Submited"); return; } MessageBox.Show("Submited"); Refresh(); return; } int affectedRow = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { List <Modelss.Education> spcs = db.Educations.Where(a => a.Status == true).ToList(); List <Modelss.Teacher> teachers = db.Teachers.Where(t => t.Status == true).ToList(); Modelss.Teacher tt = new Modelss.Teacher(); //validation Name string onlyLetters = @"^[a-zA-Z]+$"; Regex tname = new Regex(onlyLetters); Match tnameMatch = tname.Match(txtName.Text); if (!tnameMatch.Success) { MessageBox.Show("Adi duzgun Daxil edin"); txtName.Text = ""; return; } //validation Surname Regex tsurname = new Regex(onlyLetters); Match tsurnameMatch = tsurname.Match(txtSurname.Text); if (!tsurnameMatch.Success) { MessageBox.Show("Soyadi duzgun Daxil edin"); txtSurname.Text = ""; return; } string emailPattern = @"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$"; //email validation Regex mail = new Regex(emailPattern); Match mailMatch = mail.Match(txtEmail.Text); if (!mailMatch.Success) { MessageBox.Show("Emaili duzgin daxil edin..."); txtEmail.Text = ""; return; } //validation only numbers String patternnum = "^[0-9]+(,[0-9]+)*$"; Regex salry = new Regex(patternnum); Match numMatch = salry.Match(slry.Text); if (!numMatch.Success) { MessageBox.Show("Yalniz ededler daxil edin"); slry.Text = ""; return; } dvgTeacherss.Rows.Add(ID, txtName.Text, txtSurname.Text, cbSpc.Text, txtEmail.Text, txtPhone.Text); tt.Name = txtName.Text; tt.Surname = txtSurname.Text; int selected = cbSpc.SelectedIndex; List <Modelss.Education> educations = db.Educations.ToList(); int catID = educations[selected].Id; tt.SpecialityID = catID; tt.Email = txtEmail.Text; tt.Phone = txtPhone.Text; tt.Salary = Convert.ToDouble(slry.Text); tt.Status = true; db.Teachers.Add(tt); txtName.Text = txtSurname.Text = cbSpc.Text = txtEmail.Text = txtPhone.Text = slry.Text = ""; affectedRow = db.SaveChanges(); if (affectedRow > 0) { MessageBox.Show("Melumat qeyde alindi"); } else { MessageBox.Show("xeta!!"); } } }