Esempio n. 1
0
        public async Task <IHttpActionResult> PutBO_ROLE(long id, BO_ROLE bO_ROLE)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != bO_ROLE.BO_ROLE_ID)
            {
                return(BadRequest());
            }

            db.Entry(bO_ROLE).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!BO_ROLEExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Esempio n. 2
0
        public async Task <IHttpActionResult> GetBO_ROLE(long id)
        {
            BO_ROLE bO_ROLE = await db.BO_ROLE.FindAsync(id);

            if (bO_ROLE == null)
            {
                return(NotFound());
            }

            return(Ok(bO_ROLE));
        }
Esempio n. 3
0
        public async Task <IHttpActionResult> PostBO_ROLE(BO_ROLE bO_ROLE)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.BO_ROLE.Add(bO_ROLE);
            await db.SaveChangesAsync();

            return(CreatedAtRoute("DefaultApi", new { id = bO_ROLE.BO_ROLE_ID }, bO_ROLE));
        }
Esempio n. 4
0
        public async Task <IHttpActionResult> DeleteBO_ROLE(long id)
        {
            BO_ROLE bO_ROLE = await db.BO_ROLE.FindAsync(id);

            if (bO_ROLE == null)
            {
                return(NotFound());
            }

            db.BO_ROLE.Remove(bO_ROLE);
            await db.SaveChangesAsync();

            return(Ok(bO_ROLE));
        }
Esempio n. 5
0
        public async System.Threading.Tasks.Task <DataTable> SaveBoRolesAsync(string roleId, string userName, List <BoRoleLine> boRoleLines, FAISEntities db)
        {
            foreach (var line in boRoleLines)
            {
                var boRole = new BO_ROLE()
                {
                    ROLE_ID   = line.ROLE_ID,
                    CAN_READ  = line.CAN_READ,
                    CAN_WRITE = line.CAN_WRITE,
                    STATUS    = "ACTIVE",
                };

                if (line.OBJECT_TYPE == "BO")
                {
                    boRole.META_BO_ID = line.META_BO_ID;
                }
                else
                {
                    boRole.PAGE_ID = line.META_BO_ID;
                }

                if (line.lineStatus == "new")
                {
                    boRole.CREATED_BY   = userName;
                    boRole.CREATED_DATE = DateTime.Now;
                    boRole.ROLE_ID      = roleId;

                    db.Entry(boRole).State = System.Data.Entity.EntityState.Added;
                }
                else
                {
                    boRole = await db.BO_ROLE.FindAsync(line.BO_ROLE_ID);

                    boRole.CAN_READ     = line.CAN_READ;
                    boRole.CAN_WRITE    = line.CAN_WRITE;
                    boRole.UPDATED_BY   = userName;
                    boRole.UPDATED_DATE = DateTime.Now;

                    db.Entry(boRole).State = System.Data.Entity.EntityState.Modified;
                }
            }

            await db.SaveChangesAsync();

            return(GetBoRoles(roleId));
        }