private void btnDelete_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (dataGridViewRoles.SelectedRows.Count != 0)
{
try
{
spRole role = (spRole)bindingSourceRoles.Current;
var _userolesquery = from us in db.spUsers
where us.RoleId == role.Id
select us;
List <spUser> _Users = _userolesquery.ToList();
var _AllowedRoleMenusquery = from us in db.spAllowedRoleMenus
where us.RoleId == role.Id
select us;
List <spAllowedRoleMenu> _AllowedRoleMenus = _AllowedRoleMenusquery.ToList();
var _AllowedReportsRolesMenusquery = from us in db.spAllowedReportsRolesMenus
where us.RoleId == role.Id
select us;
List <spAllowedReportsRolesMenu> _AllowedReportsRolesMenus = _AllowedReportsRolesMenusquery.ToList();
if (_Users.Count > 0)
{
MessageBox.Show("There is a User Associated with this Role.\n Delete the User First!", "Confirm Delete", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else if (_AllowedRoleMenus.Count > 0)
{
MessageBox.Show("There is a Menu Right Associated with this Role.\n Delete the Menu Right First!", "Confirm Delete", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else if (_AllowedReportsRolesMenus.Count > 0)
{
MessageBox.Show("There is a Report Menu Right Associated with this Role.\n Delete the Report Menu Right First!", "Confirm Delete", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
if (DialogResult.Yes == MessageBox.Show("Are you sure you want to delete Role\n" + role.Description.ToUpper().ToString().Trim(), "Confirm Delete", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question))
{
db.spRoles.DeleteObject(role);
db.SaveChanges();
RefreshGrid();
}
}
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
}
public EditRolesForm(spRole _role, string Conn)
{
InitializeComponent();
if (string.IsNullOrEmpty(Conn))
{
throw new ArgumentNullException("connection");
}
connection = Conn;
rep = new Repository(connection);
db = new SBPayrollDBEntities(connection);
role = _role;
}
public async Task <UserResponse> RegisterUserAsync(RegisterUserModel model)
{
var eu = await db.tbUsers.FirstOrDefaultAsync(x => x.Username == model.Username);
if (eu != null)
{
return new UserResponse()
{
Status = 0, StatusMessage = "User exits"
}
}
;
var role = db.spRoles.Find(1);
if (role == null)
{
var r = new spRole();
r.Name = "Admin";
r.UserAccess = ",999";
await db.spRoles.AddAsync(r);
await db.SaveChangesAsync();
}
var u = new tbUser();
u.FirstName = model.FirstName;
u.LastName = model.LastName;
u.Username = model.Username;
u.Password = HashSha256.Get(model.Password);
u.EMail = model.EMail;
u.RoleId = 1;
await db.tbUsers.AddAsync(u);
await db.SaveChangesAsync();
return(await AuthenticateAsync(new UserRequest()
{
Username = model.Username, Password = model.Password
}));
}
}
public static void Run(Apteka.SqlServer.AptekaSqlServerDbContext sqlDb, MyDbContext pgDb)
{
var sr = new spRole()
{
Name = "admin",
UserAccess = "999;1;2;3",
CreateDate = DateTime.Now,
CreateUser = 1,
Status = 1
};
var sl = new spAccessList()
{
Id = 999,
Name = "admin",
CreateDate = DateTime.Now,
CreateUser = 1,
Status = 1
};
pgDb.tbUser.Add
(
new tbUser()
{
FirstName = "admin",
LastName = "admin",
Role = sr,
Status = 1,
CreateDate = DateTime.Now,
CreateUser = 1,
Username = "******",
Password = "******"
}
);
pgDb.ChangeTracker.DetectChanges();
pgDb.SaveChanges();
}
private void btnAdd_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
if (IsRoleValid())
{
try
{
spRole role = new spRole();
if (!string.IsNullOrEmpty(txtShortCode.Text))
{
role.ShortCode = Utils.ConvertFirstLetterToUpper(txtShortCode.Text);
}
if (!string.IsNullOrEmpty(txtDescription.Text))
{
role.Description = Utils.ConvertFirstLetterToUpper(txtDescription.Text);
}
role.IsDeleted = false;
if (db.spRoles.Any(i => i.ShortCode == role.ShortCode))
{
MessageBox.Show("Role Code Exist!", "SB Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (!db.spRoles.Any(i => i.ShortCode == role.ShortCode))
{
db.spRoles.AddObject(role);
db.SaveChanges();
RolesListForm rlf = (RolesListForm)this.Owner;
rlf.RefreshGrid();
this.Close();
}
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
}
