예제 #1
0
        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);
                }
            }
        }
예제 #2
0
        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;
        }
예제 #3
0
        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
            }));
        }
    }
예제 #4
0
        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();
        }
예제 #5
0
        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);
                }
            }
        }