示例#1
0
        public bool SetUserPermission(UserBE entity)
        {
            var dbContext = new DBContext();

            bool result = false;

            try
            {
                dbContext.BeginTran();

                PermissionDAL per = new PermissionDAL();

                if (per.DeleteUserPermission(entity, dbContext))
                {
                    result = per.SetUserPermission(entity, dbContext);
                }


                if (result)
                {
                    dbContext.CommitTran();
                    return(result);
                }

                dbContext.RollBackTran();
                return(result);
            }
            catch (Exception)
            {
                return(result);
            }
        }
示例#2
0
        public bool Update(UserBE entity)
        {
            var dbContext = new DBContext();

            try
            {
                var           dataSet       = new DataSet();
                var           parameters    = Array.Empty <SqlParameter>();
                PermissionDAL permissionDAL = new PermissionDAL();

                parameters = new SqlParameter[11];

                parameters[0] = dbContext.CreateParameters("@userid", entity.Id);
                parameters[1] = dbContext.CreateParameters("@userName", entity.UserName);
                parameters[2] = dbContext.CreateParameters("@lastName", entity.LastName);
                parameters[3] = dbContext.CreateParameters("@name", entity.Name);
                parameters[4] = dbContext.CreateParameters("@languageID", entity.Language.Id);
                parameters[5] = dbContext.CreateParameters("@email", !string.IsNullOrEmpty(entity.Email) ? entity.Email : null);
                parameters[6] = dbContext.CreateParameters("@password", entity.Password);

                parameters[9]  = dbContext.CreateParameters("@artistName", !string.IsNullOrEmpty(entity.ArtistName) ? entity.ArtistName : null);
                parameters[7]  = dbContext.CreateParameters("@contractID", entity.Contract == null ? Guid.Empty : Guid.NewGuid());
                parameters[8]  = dbContext.CreateParameters("@imgKey", !string.IsNullOrEmpty(entity.ImgKey) ? entity.ImgKey : null);
                parameters[10] = dbContext.CreateParameters("@serviceID", entity.Contract == null  ? Guid.Empty : entity.Contract.Service.Id);

                dbContext.BeginTran();
                if (dbContext.Write("UpdateUser", parameters) > 0)
                {
                    permissionDAL.DeleteUserPermission(entity, dbContext);

                    permissionDAL.SetUserPermission(entity, dbContext);


                    dbContext.CommitTran();
                    return(true);
                }
                dbContext.RollBackTran();
                return(false);
            }
            catch (Exception ex)
            {
                dbContext.RollBackTran();
                throw new Exception(Messages.Generic_Error);
            }
        }