private void UpdateBtn_Click(object sender, EventArgs e) { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { if (ValidateChildren()) { if (itemid != 0) { var Curritem = db.Education_Programs.Where(p => itemid == p.Id).First(); Curritem.Name = EPNameTxt.Text; Curritem.Price = Convert.ToInt32(EPPriceTxt.Text); MessageBox.Show("Program Updated"); SaveBtn.Enabled = true; DeleteBtn.Enabled = true; ResetInputs(); db.SaveChanges(); } else { MessageBox.Show("Program could not be updated"); return; } } else { return; } if (SaveBtn.Enabled == true) { UpdateBtn.Enabled = false; } } dgvPrograms.Rows.Clear(); ShowPrograms(); }
private void DeleteProgram() { if (dgvPrograms.CurrentRow.Index > -1) { int affectedRows = 0; int itemid = (int)dgvPrograms.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var program = db.Education_Programs.Where(ep => ep.Id == itemid).FirstOrDefault(); program.Status = false; affectedRows = db.SaveChanges(); } if (!(affectedRows > 0)) { MessageBox.Show("program deleted"); dgvPrograms.Rows.Clear(); } return; } else { MessageBox.Show("Choose program firstly"); } return; }
private void UpdateBtn_Click(object sender, EventArgs e) { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { if (ValidateChildren()) { if (itemId != 0) { var classroom = db.Classrooms.Where(t => itemId == t.Id).First(); classroom.Name = ClassroomTxt.Text; classroom.Capacity = Convert.ToInt32(ClassCapTxt.Text); MessageBox.Show("Classroom Updated"); SaveBtn.Enabled = true; DeleteBtn.Enabled = true; ClearInputs(); db.SaveChanges(); } else { MessageBox.Show("Classroom could not be updated"); return; } } else { MessageBox.Show("Please fill the form"); return; } if (SaveBtn.Enabled == true) { UpdateBtn.Enabled = false; } } ShowClassrooms(); }
private void CreatePosition() { int affectedrows = 0; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { Position NewPos = new Position { Name = PositionTxt.Text, Status = true }; db.Positions.Add(NewPos); affectedrows = db.SaveChanges(); } if (affectedrows > 0) { MessageBox.Show("Position created"); ResetInputs(); dgvPosition.Rows.Clear(); } else { MessageBox.Show("Position could not be created"); return; } }
private void DeleteBtn_Click(object sender, EventArgs e) { if (dgvClassroom.CurrentRow.Index > -1) { int affectedRows = 0; int classId = (int)dgvClassroom.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var user = db.Classrooms.Where(c => c.Id == classId).FirstOrDefault(); user.Status = false; affectedRows = db.SaveChanges(); } if (!(affectedRows > 0)) { MessageBox.Show("Classroom could not be deleted"); } else { MessageBox.Show("Classroom deleted"); ShowClassrooms(); } } else { MessageBox.Show("Choose classroom firstly"); } }
private void UpdateBtn_Click(object sender, EventArgs e) { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { if (ValidateChildren()) { if (PosId != 0) { var CurrPosition = db.Positions.Where(p => PosId == p.Id).First(); CurrPosition.Name = PositionTxt.Text; MessageBox.Show("Position Updated"); SaveBtn.Enabled = true; DeleteBtn.Enabled = true; ResetInputs(); db.SaveChanges(); } else { MessageBox.Show("Position could not be updated"); return; } } else { return; } if (SaveBtn.Enabled == true) { UpdateBtn.Enabled = false; } } dgvPosition.Rows.Clear(); FillPositions(); }
private void CreateEducationProgram() { int affectedrows = 0; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { Education_Program EP = new Education_Program { Name = EPNameTxt.Text, Price = Convert.ToInt32(EPPriceTxt.Text), Status = true }; db.Education_Programs.Add(EP); affectedrows = db.SaveChanges(); } if (affectedrows > 0) { MessageBox.Show("Program created"); ResetInputs(); dgvPrograms.Rows.Clear(); } else { MessageBox.Show("Program could not be created"); return; } }
private void DeletePosition() { if (dgvPosition.CurrentRow.Index > -1) { int affectedRows = 0; int userid = (int)dgvPosition.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var user = db.Positions.Where(t => t.Id == userid).FirstOrDefault(); user.Status = false; affectedRows = db.SaveChanges(); } if (!(affectedRows > 0)) { MessageBox.Show("Position deleted"); dgvPosition.Rows.Clear(); } return; } else { MessageBox.Show("Choose position firstly"); return; } }
private bool CreateTeacher() { int affectedRows = 0; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { Teacher newTea = new Teacher { Name = TNameTxt.Text, Surname = TSurnameTxt.Text, Speciality = (int)TSpecialityCmb.SelectedValue, Email = TEmailTxt.Text, Phone = TPhoneTxt.Text, Status = true }; db.Teachers.Add(newTea); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { MessageBox.Show("Teacher created"); ResetInputs(); return(true); } else { MessageBox.Show("Teacher could not be created"); return(false); } }
private void SignInBtn_Click(object sender, EventArgs e) { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { //Session sess = new Session(); if (ValidateChildren()) { List <User> allUsers = db.Users.ToList(); if (allUsers.Any(u => u.Email == emailTxt.Text.Trim().ToLower() && u.Password == passwordTxt.Text.Trim())) { var user = allUsers.Find(u => u.Email == emailTxt.Text.Trim().ToLower() && u.Password == passwordTxt.Text.Trim()); Session.UserRole = user.RoleId; MainForm mf = new MainForm(); mf.Show(); Hide(); } else { MessageBox.Show("This user does not exist.Please register"); } } else { MessageBox.Show("Fill the form"); } } }
private void ShowGroups() { dgvGroups.Rows.Clear(); using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var allgroups = db.Groups.Where(g => g.Status == true).ToList(); var Classrooms = db.Classrooms.Where(c => c.Status == true).ToList();; var Teachers = db.Teachers.Where(c => c.Status == true).ToList(); var Employees = db.Employees.Where(c => c.Status == true).ToList(); var Programs = db.Education_Programs.Where(c => c.Status == true).ToList(); foreach (var item in allgroups) { var list = Classrooms.Where(a => a.Id == item.ClasroomId); string classroomname = ""; foreach (var classroom in list) { classroom.Name = classroomname; } dgvGroups.Rows.Add( item.Id, item.Name, classroomname, item.TeacherId, item.MentorId, item.Capacity, item.EducationId ); } } }
private void FillPrograms() { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var data = db.Education_Programs.Select(x => new { x.Name, x.Id }).ToList(); GrEducCmb.DisplayMember = "Name"; GrEducCmb.ValueMember = "Id"; GrEducCmb.DataSource = data.ToList(); } }
private void FillClassrooms() { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var data = db.Classrooms.Select(x => new { x.Name, x.Id }).ToList(); GrClassCmb.DisplayMember = "Name"; GrClassCmb.ValueMember = "Id"; GrClassCmb.DataSource = data.ToList(); } }
private void FillMentors() { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var data = db.Employees.Where(e => e.PositionId == 7).Select(x => new { x.Name, x.Id }).ToList(); GrMentorCmb.DisplayMember = "Name"; GrMentorCmb.ValueMember = "Id"; GrMentorCmb.DataSource = data.ToList(); } }
private void RegBtn_Click(object sender, EventArgs e) { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { List <User> allusers = db.Users.ToList(); if (Pass2Reg.Text == PassReg.Text) { if (ValidateChildren()) { foreach (var item in allusers) { if (item.Email == EmailTxtReg.Text.ToLower()) { MessageBox.Show("This user is already created"); return; } } if (ChooseRole() != 0) { User newuser = new User { Email = EmailTxtReg.Text, Password = PassReg.Text, RoleId = ChooseRole() }; db.Users.Add(newuser); db.SaveChanges(); MessageBox.Show("User created"); MainForm mf = new MainForm(); mf.Show(); Hide(); } else { MessageBox.Show("Choose one them below"); return; } } else { MessageBox.Show("Could not create user"); } } else { MessageBox.Show("Passwords are not matching"); return; } } }
private void ShowTeachers() { dgvTeachers.Rows.Clear(); using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { List <Teacher> teachers = db.Teachers.Where(t => t.Status == true).ToList(); List <Models.Group> groups = db.Groups.Where(g => g.Status == true).ToList(); List <Education_Program> specs = db.Education_Programs.Where(s => s.Status == true).ToList(); foreach (var teacher in teachers) { var TeacherGroups = teacher.Groups.Where(g => g.TeacherId == teacher.Id).ToList(); var TeacherSpecs = specs.Where( e => e.Id == teacher.Speciality ); string speciality = ""; string GroupsNames = ""; foreach (var group in TeacherGroups) { //Comma seperator if (group != TeacherGroups[TeacherGroups.Count - 1]) { GroupsNames += group.Name + ", "; } else { GroupsNames += group.Name; } } foreach (var spec in TeacherSpecs) { speciality += spec.Name; } dgvTeachers.Rows.Add(teacher.Id, teacher.Name, teacher.Surname, speciality, teacher.Email, teacher.Phone, GroupsNames ); } } }
private void FillPositions() { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var positionslist = db.Positions.Where(p => p.Status == true).ToList(); foreach (var item in positionslist) { dgvPosition.Rows.Add( item.Id, item.Name ); } } }
private void dgvPosition_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { UpdateBtn.Enabled = true; SaveBtn.Enabled = false; DeleteBtn.Enabled = false; if (dgvPosition.CurrentRow.Index > 0) { PosId = (int)dgvPosition.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var Currposition = db.Positions.Where(p => p.Id == PosId).FirstOrDefault(); PositionTxt.Text = Currposition.Name; } } }
private void ShowClassrooms() { dgvClassroom.Rows.Clear(); using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { List <Classroom> classrooms = db.Classrooms.Where(c => c.Status == true).ToList(); foreach (var item in classrooms) { dgvClassroom.Rows.Add( item.Id, item.Name, item.Capacity); } } }
private void dgvClassroom_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { UpdateBtn.Enabled = true; SaveBtn.Enabled = false; DeleteBtn.Enabled = false; if (dgvClassroom.CurrentRow.Index > 0) { itemId = (int)dgvClassroom.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var Curritem = db.Classrooms.Where(p => p.Id == itemId).FirstOrDefault(); ClassroomTxt.Text = Curritem.Name; ClassCapTxt.Text = Curritem.Capacity.ToString(); } } }
private void dgvPrograms_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { UpdateBtn.Enabled = true; SaveBtn.Enabled = false; DeleteBtn.Enabled = false; if (dgvPrograms.CurrentRow.Index > 0) { itemid = (int)dgvPrograms.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var Curritem = db.Education_Programs.Where(p => p.Id == itemid).FirstOrDefault(); EPNameTxt.Text = Curritem.Name; EPPriceTxt.Text = Curritem.Price.ToString(); } } }
private void ShowPrograms() { dgvPrograms.Rows.Clear(); using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var positionslist = db.Education_Programs.Where(p => p.Status == true).ToList(); foreach (var item in positionslist) { dgvPrograms.Rows.Add( item.Id, item.Name, item.Price ); } } }
private void dgvTeachers_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { DeleteBtn.Enabled = false; UpdateBtn.Enabled = true; SaveBtn.Enabled = false; if (dgvTeachers.CurrentRow.Index > 0) { teacherid = (int)dgvTeachers.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var teacher = db.Teachers.Where(t => t.Id == teacherid).FirstOrDefault(); TNameTxt.Text = teacher.Name; TSurnameTxt.Text = teacher.Surname; TSpecialityCmb.Text = dgvTeachers.CurrentRow.Cells[3].Value.ToString(); TEmailTxt.Text = teacher.Email; TPhoneTxt.Text = teacher.Phone; } } }
private void MainForm_Load(object sender, EventArgs e) { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { List <Info> infolist = db.Infoes.ToList(); foreach (var item in infolist) { AcaName.Text = item.Name; AcaAdress.Text = item.Adress; AcaEmail.Text = item.Contemail; } } if (Session.UserRole == 1) { teachersToolStripMenuItem.Enabled = false; employeeToolStripMenuItem.Enabled = false; positionToolStripMenuItem.Enabled = false; } }
private void NewClassroom() { int affectedrows = 0; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { Classroom classroom = new Classroom { Name = ClassroomTxt.Text, Capacity = Convert.ToInt32(ClassCapTxt.Text), Status = true }; db.Classrooms.Add(classroom); affectedrows = db.SaveChanges(); if (!(affectedrows > 0)) { return; } } }
private bool DeleteTeacher() { if (dgvTeachers.CurrentRow.Index > -1) { int affectedRows = 0; int userid = (int)dgvTeachers.SelectedRows[0].Cells[0].Value; using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { var user = db.Teachers.Where(t => t.Id == userid).FirstOrDefault(); user.Status = false; affectedRows = db.SaveChanges(); } if (!(affectedRows > 0)) { MessageBox.Show("User deleted"); return(false); } return(true); } MessageBox.Show("Choose user firstly"); return(false); }
private void UpdateBtn_Click(object sender, EventArgs e) { using (CodeAcademyEntities1 db = new CodeAcademyEntities1()) { if (ValidateChildren()) { if (teacherid != 0) { var teacher = db.Teachers.Where(t => teacherid == t.Id).First(); teacher.Name = TNameTxt.Text; teacher.Surname = TSurnameTxt.Text; teacher.Speciality = (int)TSpecialityCmb.SelectedValue; teacher.Email = TEmailTxt.Text; teacher.Phone = TPhoneTxt.Text; MessageBox.Show("Teacher Updated"); SaveBtn.Enabled = true; DeleteBtn.Enabled = true; ResetInputs(); db.SaveChanges(); } else { MessageBox.Show("Teacher could not be updated"); return; } } else { MessageBox.Show("Please fill the form"); return; } if (SaveBtn.Enabled == true) { UpdateBtn.Enabled = false; } } ShowTeachers(); }