public IHttpActionResult Get(int id)
        {
            DTO_CUS_DOC_File_Actitity tbl_CUS_DOC_File_Actitity = BS_CUS_DOC_File_Actitity.get_CUS_DOC_File_Actitity(db, PartnerID, id);

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

            return(Ok(tbl_CUS_DOC_File_Actitity));
        }
        public IHttpActionResult Post(DTO_CUS_DOC_File_Actitity tbl_CUS_DOC_File_Actitity)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            DTO_CUS_DOC_File_Actitity result = BS_CUS_DOC_File_Actitity.post_CUS_DOC_File_Actitity(db, PartnerID, tbl_CUS_DOC_File_Actitity, Username);


            if (result != null)
            {
                return(CreatedAtRoute("get_CUS_DOC_File_Actitity", new { id = result.ID }, result));
            }
            return(Conflict());
        }
        public IHttpActionResult Delete(int id)
        {
            bool check = BS_CUS_DOC_File_Actitity.check_CUS_DOC_File_Actitity_Exists(db, id);

            if (!check)
            {
                return(NotFound());
            }

            bool result = BS_CUS_DOC_File_Actitity.delete_CUS_DOC_File_Actitity(db, id, Username);

            if (result)
            {
                return(StatusCode(HttpStatusCode.NoContent));
            }
            return(Conflict());
        }
        public IQueryable <DTO_CUS_DOC_File_Actitity> Get()
        {
            var result = BS_CUS_DOC_File_Actitity.get_CUS_DOC_File_Actitity(db, PartnerID, QueryStrings).ToList();

            if (result != null)
            {
                var context = new Models.ApplicationDbContext();
                var users   = context.Users.ToList();

                foreach (var item in result)
                {
                    var u = users.FirstOrDefault(d => d.Email == item.CreatedBy);
                    if (u != null)
                    {
                        item.ModifiedByName = u.FullName;
                        item.Avatar         = u.Avatar;
                    }
                }
            }

            return(result.AsQueryable());
        }
        public IHttpActionResult Put(int id, DTO_CUS_DOC_File_Actitity tbl_CUS_DOC_File_Actitity)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tbl_CUS_DOC_File_Actitity.ID || PartnerID != tbl_CUS_DOC_File_Actitity.IDPartner)
            {
                return(BadRequest());
            }


            bool resul = BS_CUS_DOC_File_Actitity.put_CUS_DOC_File_Actitity(db, PartnerID, id, tbl_CUS_DOC_File_Actitity, Username);

            if (resul)
            {
                return(StatusCode(HttpStatusCode.NoContent));
            }
            else
            {
                return(NotFound());
            }
        }