private void SaveCoure() { if (dataGridView_Course.SelectedRows.Count > 0) { using (RRSContext ctx = new RRSContext()) { foreach (var item in courseBindingSource.List) { var course = (Course)item; if (course.CourseId <= 0) { ctx.Courses.Add(course); } else { ctx.Courses.Attach(course); ctx.Entry(course).State = System.Data.Entity.EntityState.Modified; } } ctx.SaveChanges(); MessageBox.Show(this, "Update Successfull"); CourseManagerForm_Load(null, null); } } else { using (var ctx = new RRSContext()) { var course = new Course { CourseName = tb_Course.Text, IsActive = true, }; ctx.Courses.Add(course); ctx.SaveChanges(); ClearText(); MessageBox.Show(this, "Save Successfull"); CourseManagerForm_Load(null, null); } } }
private void EditUser() { using (RRSContext ctx = new RRSContext()) { foreach (var item in userAccountBindingSource.List) { var account = (UserAccount)item; if (account.UserId <= 0) { ctx.UserAccounts.Add(account); } else { ctx.UserAccounts.Attach(account); ctx.Entry(account).State = System.Data.Entity.EntityState.Modified; } } ctx.SaveChanges(); MessageBox.Show(this, "Save Successfull"); } }
private void SaveUser() { if (dataGridView_User.SelectedRows.Count > 0) { using (RRSContext ctx = new RRSContext()) { foreach (var item in userAccountBindingSource.List) { var account = (UserAccount)item; if (account.UserId <= 0) { ctx.UserAccounts.Add(account); } else { ctx.UserAccounts.Attach(account); ctx.Entry(account).State = System.Data.Entity.EntityState.Modified; } } ctx.SaveChanges(); MessageBox.Show(this, "Update Successfull"); LoadData(); } } else { if (!(string.IsNullOrEmpty(tb_FirstName.Text) || string.IsNullOrEmpty(tb_LastName.Text) || (String.IsNullOrEmpty(tb_UserName.Text) || string.IsNullOrEmpty(tb_UserPassword.Text)))) { try { using (var ctx = new RRSContext()) { if (ctx.UserAccounts.Any(o => o.Username == tb_UserName.Text)) { MessageBox.Show("Use different username"); } else { var user = new UserAccount() { FirstName = tb_FirstName.Text, MiddleName = tb_MiddleName.Text, LastName = tb_LastName.Text, Username = tb_UserName.Text, UserPassword = tb_UserPassword.Text, UserRole = cb_Role.SelectedItem.ToString(), IsActive = true, }; ctx.UserAccounts.Add(user); ctx.SaveChanges(); LoadData(); MessageBox.Show(this, "Save Successfull"); } } } catch (Exception) { MessageBox.Show("Select Role"); } } else { MessageBox.Show("Please filled up all field)"); } } ClearText(); AccountManagerForm_Load(null, null); }