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