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();
}
