private bool UpdateStudent() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { Student nwstu = db.Students.Where(s => s.Id == studentGlobal.Id).FirstOrDefault(); nwstu.Name = txtNameStudent.Text; nwstu.Surname = txtSurnameStudent.Text; nwstu.Email = txtEmailStudent.Text; nwstu.Phone = txtPhoneStudent.Text; nwstu.Fee = txtFeeStudent.Text; affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void GenerateTasks() { dgvTasks.Rows.Clear(); using (MyAcademyEntities2 db = new MyAcademyEntities2()) { List <Models.Task> tasks = db.Tasks.Where(g => g.Status == true).ToList(); foreach (var task in tasks) { dgvTasks.Rows.Add(task.Id, task.Name, task.Deadline, task.Group.Name ); //if (!task.Status) //{ // dgvTasks.Rows[dgvTasks.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Red; //} //if (task.Deadline > DateTime.Now.Date) //{ // dgvTasks.Rows[dgvTasks.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Red; //} //if ((dgvTasks.Rows[2].Cells[2].Value) > DateTime.Today.Day) //{ // dgvTasks.Rows[2].DefaultCellStyle.BackColor = Color.Red; //} } } }
private bool CreateEducation() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { Education education = new Education { Name = txtNameEducation.Text, Price = Convert.ToDouble(txtPriceEducation.Text), Status = true }; db.Educations.Add(education); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool CreateEmployee() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int positionId = (db.Positions.Where(g => g.Name == cmbPosition.SelectedItem.ToString()).FirstOrDefault()).Id; Employee employee = new Employee { Name = txtNameEmploye.Text, Surname = txtSurnameEmploye.Text, Email = txtEmailEmployee.Text, Phone = txtPhoneEmployee.Text, PositionId = positionId, StartTime = Convert.ToDateTime(txtStartTimeEmp.Text), Salary = Convert.ToDouble(txtSaalaryEmp.Text), Status = true }; db.Employees.Add(employee); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void FillEmployee() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { cmbPosition.DataSource = db.Positions.Select(g => g.Name).ToList(); } }
private bool UpdateEmployee() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int positionId = (db.Positions.Where(g => g.Name == cmbPosition.SelectedItem.ToString()).FirstOrDefault()).Id; Employee newemp = db.Employees.Where(s => s.Id == empGlobal.Id).FirstOrDefault(); newemp.Name = txtNameEmploye.Text; newemp.Surname = txtSurnameEmploye.Text; newemp.Email = txtEmailEmployee.Text; newemp.PositionId = positionId; newemp.StartTime = Convert.ToDateTime(txtStartTimeEmp.Text); newemp.Salary = Convert.ToDouble(txtSaalaryEmp.Text); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void GenerateEmployee() { dgvEmployee.Rows.Clear(); using (MyAcademyEntities2 db = new MyAcademyEntities2()) { List <Employee> employees = db.Employees.Where(g => g.Status == true).ToList(); foreach (var employee in employees) { dgvEmployee.Rows.Add(employee.Id, employee.Name, employee.Surname, employee.Email, employee.Phone, employee.Mentor, employee.Position.Name, employee.StartTime, employee.Salary); if (!employee.Status) { dgvEmployee.Rows[dgvEmployee.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Red; } } } }
private void FillTasks() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { cmbGroupTask.DataSource = db.Groups.Select(g => g.Name).ToList(); } }
private void GenerateStudent() { dgvStudents.Rows.Clear(); using (MyAcademyEntities2 db = new MyAcademyEntities2()) { db.Groups.ToList(); List <Student> students = db.Students.Where(g => g.Status == true).ToList(); foreach (var student in students) { dgvStudents.Rows.Add(student.Id, student.Name, student.Surname, student.Email, student.Phone, student.Fee, student.Group.Name ); if (!student.Status) { dgvStudents.Rows[dgvStudents.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Red; } } } }
private bool CreateTeacher() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { Teacher teacher = new Teacher { Name = txtNameTeacher.Text, Surname = txtSurnameTeacher.Text, Speciality = txtSpecStudent.Text, Email = txtEmailTeacher.Text, Phone = txtPhoneTeacher.Text, Status = true }; db.Teachers.Add(teacher); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool UpdateStudentMarks() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int studentId = (db.Students.Where(g => g.Name == cmbStudent.SelectedItem.ToString()).FirstOrDefault()).Id; int taskId = (db.Tasks.Where(g => g.Name == cmbTask.SelectedItem.ToString()).FirstOrDefault()).Id; Models.Task newtask = db.Tasks.Where(s => s.Id == studentsMarkGlobal.Id).FirstOrDefault(); studentsMarkGlobal.StudentId = studentId; studentsMarkGlobal.TaskId = taskId; studentsMarkGlobal.Mark = Convert.ToInt32(txtMark.Text); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool CreateTaskMarks() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int studentId = (db.Students.Where(g => g.Name == cmbStudent.SelectedItem.ToString()).FirstOrDefault()).Id; int taskId = (db.Tasks.Where(g => g.Name == cmbTask.SelectedItem.ToString()).FirstOrDefault()).Id; Models.StudentsMark studentsMark = new Models.StudentsMark { StudentId = studentId, TaskId = taskId, Mark = Convert.ToInt32(txtMark.Text), }; db.StudentsMarks.Add(studentsMark); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void GenerateTasksMarks() { dgvStudentMarks.Rows.Clear(); using (MyAcademyEntities2 db = new MyAcademyEntities2()) { List <Models.StudentsMark> studentsMarks = db.StudentsMarks.ToList(); List <Models.Student> students = db.Students.ToList(); List <Models.Task> tasks = db.Tasks.ToList(); foreach (var studentmark in studentsMarks) { string sName = ""; db.StudentsMarks.FirstOrDefault(); Student stu = studentmark.Task.Group.Students.FirstOrDefault(s => s.Id == studentmark.StudentId); if (stu != null) { sName = stu.Name; } dgvStudentMarks.Rows.Add(studentmark.Id, sName, studentmark.Task.Name, studentmark.Mark ); } } }
private void GenerateGroups() { dgvGroup.Rows.Clear(); using (MyAcademyEntities2 db = new MyAcademyEntities2()) { List <Group> groups = db.Groups.Where(g => g.Status == true).ToList(); foreach (var group in groups) { dgvGroup.Rows.Add(group.Id, group.Name, group.Classroom.Name, group.Teacher.Name + " " + group.Teacher.Surname, group.Employee.Mentor, group.Capacity, group.Education.Name); if (!group.Status) { dgvGroup.Rows[dgvGroup.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Red; } } } }
private bool CreateClassroom() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { Classroom classroom = new Classroom { Name = txtNameClassroom.Text, Status = true }; db.Classrooms.Add(classroom); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool CreateTask() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int groupId = (db.Groups.Where(g => g.Name == cmbGroupTask.SelectedItem.ToString()).FirstOrDefault()).Id; Models.Task task = new Models.Task { Name = txtNameTask.Text, Deadline = Convert.ToDateTime(dtpDeadline.Text), GroupId = groupId, Status = true }; db.Tasks.Add(task); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool CreatePosition() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { Position position = new Position { Name = txtNamePosition.Text, Status = true }; db.Positions.Add(position); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool CreateStudent() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { Student student = new Student { Name = txtNameStudent.Text, Surname = txtSurnameStudent.Text, Email = txtEmailStudent.Text, Phone = txtPhoneStudent.Text, Fee = txtFeeStudent.Text, Status = true }; db.Students.Add(student); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool UpdateTask() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int groupId = (db.Groups.Where(g => g.Name == cmbGroupTask.SelectedItem.ToString()).FirstOrDefault()).Id; Models.Task newtask = db.Tasks.Where(s => s.Id == taskGlobal.Id).FirstOrDefault(); newtask.Name = txtNameTask.Text; newtask.Deadline = Convert.ToDateTime(dtpDeadline.Text); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool UpdateGroup() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int classroomId = (db.Classrooms.Where(g => g.Name == cmbClassroom.SelectedItem.ToString()).FirstOrDefault()).Id; int educationID = (db.Educations.Where(g => g.Name == cmbEducation.SelectedItem.ToString()).FirstOrDefault()).Id; int teacherID = (db.Teachers.Where(g => g.Name + " " + g.Surname == cmbTeacher.SelectedItem.ToString()).FirstOrDefault()).Id; int mentorID = (db.Employees.Where(g => g.Mentor == cmbMentor.SelectedItem.ToString()).FirstOrDefault()).Id; Group newgru = db.Groups.Where(s => s.Id == groupGlobal.Id).FirstOrDefault(); newgru.Name = txtNameGroup.Text; newgru.ClassroomId = classroomId; newgru.TeacherId = teacherID; newgru.MentorId = mentorID; newgru.Capacity = Convert.ToInt32(txtCapacityGroup.Text); newgru.ClassroomId = classroomId; affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool CreateGroup() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { int classroomId = (db.Classrooms.Where(g => g.Name == cmbClassroom.SelectedItem.ToString()).FirstOrDefault()).Id; int educationID = (db.Educations.Where(g => g.Name == cmbEducation.SelectedItem.ToString()).FirstOrDefault()).Id; int teacherID = (db.Teachers.Where(g => g.Name + " " + g.Surname == cmbTeacher.SelectedItem.ToString()).FirstOrDefault()).Id; int mentorID = (db.Employees.Where(g => g.Mentor == cmbMentor.SelectedItem.ToString()).FirstOrDefault()).Id; Group group = new Group { Name = txtNameGroup.Text, ClassroomId = classroomId, TeacherId = teacherID, MentorId = mentorID, Capacity = Convert.ToInt32(txtCapacityGroup.Text), EducationProgramId = educationID, Status = true }; db.Groups.Add(group); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private bool UpdateTeacher() { int affectedRows = 0; using (MyAcademyEntities2 db = new MyAcademyEntities2()) { Teacher newteac = db.Teachers.Where(s => s.Id == teacherGlobal.Id).FirstOrDefault(); newteac.Name = txtNameTeacher.Text; newteac.Surname = txtSurnameTeacher.Text; newteac.Speciality = txtSpecStudent.Text; newteac.Email = txtEmailTeacher.Text; newteac.Phone = txtPhoneTeacher.Text; affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }
private void FillTasks() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { cmbStudent.DataSource = db.Students.Select(g => g.Name).ToList(); cmbTask.DataSource = db.Tasks.Select(g => g.Name).ToList(); } }
private void BtnGroupFill_Click(object sender, EventArgs e) { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { cmbGroupStudent.DataSource = db.Groups.Select(g => g.Name).ToList(); cmbGroupStudent.SelectedItem = dgvStudentMarks.SelectedRows; } }
private void FillGroups() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { cmbClassroom.DataSource = db.Classrooms.Select(g => g.Name).ToList(); cmbEducation.DataSource = db.Educations.Select(g => g.Name).ToList(); cmbMentor.DataSource = db.Employees.Select(e => e.Mentor).ToList(); cmbTeacher.DataSource = db.Teachers.Select(g => g.Name + " " + g.Surname).ToList(); } }
private void GenerateAcademy() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { List <Academy> academies = db.Academies.ToList(); foreach (var a in academies) { lblName.Text = a.Name; lblStreetsss.Text = a.Street; lblPhoneee.Text = a.Phone; } } }
private void DeleteStudentsMarks() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { for (int i = 0; i < dgvStudentMarks.SelectedRows.Count; i++) { int stdmarkId = (int)dgvStudentMarks.SelectedRows[i].Cells[0].Value; StudentsMark studentsMark = db.StudentsMarks.FirstOrDefault(u => u.Id == stdmarkId); } db.SaveChanges(); } GenerateTasksMarks(); }
private void DeleteTask() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { for (int i = 0; i < dgvTasks.SelectedRows.Count; i++) { int taskId = (int)dgvTasks.SelectedRows[i].Cells[0].Value; Models.Task task = db.Tasks.FirstOrDefault(u => u.Id == taskId); task.Status = false; } db.SaveChanges(); } GenerateTasks(); }
private void DeleteEducation() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { for (int i = 0; i < dgvEducation.SelectedRows.Count; i++) { int eduId = (int)dgvEducation.SelectedRows[i].Cells[0].Value; Education education = db.Educations.FirstOrDefault(u => u.Id == eduId); education.Status = false; } db.SaveChanges(); } GenerateEducation(); }
private void DeleteTeacher() { using (MyAcademyEntities2 db = new MyAcademyEntities2()) { for (int i = 0; i < dgvTeacher.SelectedRows.Count; i++) { int teacherId = (int)dgvTeacher.SelectedRows[i].Cells[0].Value; Teacher teacher = db.Teachers.FirstOrDefault(u => u.Id == teacherId); teacher.Status = false; } db.SaveChanges(); } GenerateTeacher(); }