public ActionResult Create([Bind(Include = "Id,Email,Password")] Login login) { if (ModelState.IsValid) { db.Logins.Add(login); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(login)); }
public ActionResult Create([Bind(Include = "Id,Header,Text")] News news) { if (ModelState.IsValid) { db.News.Add(news); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(news)); }
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 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 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 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 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 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 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 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 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(); }