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!!");
}
}
}
