示例#1
0
        public IHttpActionResult EFUpdateEducationalContent(FarmworkersWebAPI.Entities.EducationalContent _educationalContentInformation)
        {
            _context.Configuration.ProxyCreationEnabled = false;

            try
            {
                FarmworkersWebAPI.Entities.EducationalContent original = _context.EducationalContents.
                                                                         Where(ucp => ucp.IDEducationalContent.Equals(_educationalContentInformation.IDEducationalContent)).FirstOrDefault();

                FarmworkersWebAPI.Entities.EducationalContent _updated = new FarmworkersWebAPI.Entities.EducationalContent();

                if (original != null)
                {
                    _context.Entry(original).CurrentValues.SetValues(_educationalContentInformation);
                    _context.SaveChanges();

                    _updated = _context.EducationalContents.Find(_educationalContentInformation.IDEducationalContent);

                    return(Ok(_updated));
                }
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }

            return(Ok("Educational Content Not Found"));
        }
示例#2
0
        public IHttpActionResult EFDeleteEducationalContent(FarmworkersWebAPI.Entities.EducationalContent _educationalContentInformation)
        {
            _context.Configuration.ProxyCreationEnabled = false;

            try
            {
                _context.EducationalContents.Attach(_educationalContentInformation);
                _context.EducationalContents.Remove(_educationalContentInformation);
                _context.SaveChanges();

                return(Ok("EducationalContent Deleted Successfully"));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
示例#3
0
        public IHttpActionResult EFInsertEducationalContent(FarmworkersWebAPI.Entities.EducationalContent _educationalContentInformation)
        {
            _context.Configuration.ProxyCreationEnabled = false;

            FarmworkersWebAPI.Entities.EducationalContent _educationalContentData = new FarmworkersWebAPI.Entities.EducationalContent();

            try
            {
                _educationalContentData = _context.EducationalContents.Add(_educationalContentInformation);
                _context.SaveChanges();

                return(Ok(_educationalContentData));
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }