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