コード例 #1
0
ファイル: UserRepository.cs プロジェクト: nanson1998/Netccore
        public bool DeleteUser(string id)
        {
            var user = FindUserById(id);

            if (user == null)
            {
                return(false);
            }

            _context.Users.Remove(user);
            _context.SaveChanges();
            return(true);
        }
コード例 #2
0
        public Response Post(Product item)
        {
            Response resp = new Response();

            try
            {
                using (_context = new DemoAPIContext())
                {
                    item.CreatedOn     = DateTime.Now;
                    item.LastUpdatedOn = DateTime.Now;
                    item.IsDeleted     = false;
                    _context.Products.Add(item);
                    _context.SaveChanges();
                    resp.httpCode = HttpStatusCode.OK;
                    resp.message  = "Request Posted Successfully";
                }
            }
            catch (Exception ex)
            {
                resp.httpCode = HttpStatusCode.BadRequest;
                resp.message  = "Something went wrong";
                resp.json     = JsonConvert.SerializeObject(new { Error = ex.Message });
                return(resp);
            }
            return(resp);
        }
コード例 #3
0
        public Response Delete(int id)
        {
            Response resp = new Response();

            try
            {
                using (_context = new DemoAPIContext())
                {
                    Product record = _context.Products.Where(a => a.Id == id).FirstOrDefault();
                    if (!ReferenceEquals(record, null))
                    {
                        _context.Products.Remove(record);
                        _context.SaveChanges();
                        resp.httpCode = HttpStatusCode.OK;
                        resp.message  = "Record Deleted Successfully";
                    }
                    else
                    {
                        resp.httpCode = HttpStatusCode.BadRequest;
                        resp.message  = "No record found";
                    }
                }
            }
            catch (Exception ex)
            {
                resp.httpCode = HttpStatusCode.BadRequest;
                resp.message  = "Something went wrong";
                resp.json     = JsonConvert.SerializeObject(new { Error = ex.Message });
                return(resp);
            }
            return(resp);
        }
コード例 #4
0
        public Response Put(Product item)
        {
            Response resp = new Response();

            try
            {
                using (_context = new DemoAPIContext())
                {
                    Product record = _context.Products.Where(a => a.Id == item.Id).FirstOrDefault();
                    if (!ReferenceEquals(record, null))
                    {
                        record.Title           = item.Title;
                        record.ProductTypeId   = item.ProductTypeId;
                        record.ContactPersonId = item.ContactPersonId;
                        record.Description     = item.Description;
                        record.LastUpdatedOn   = DateTime.Now;
                        // _context.Entry(item).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
                        _context.SaveChanges();
                        resp.httpCode = HttpStatusCode.OK;
                        resp.message  = "Record Updated Successfully";
                    }
                    else
                    {
                        resp.httpCode = HttpStatusCode.BadRequest;
                        resp.message  = "No record found";
                    }
                }
            }
            catch (Exception ex)
            {
                resp.httpCode = HttpStatusCode.BadRequest;
                resp.message  = "Something went wrong";
                resp.json     = JsonConvert.SerializeObject(new { Error = ex.Message });
                return(resp);
            }
            return(resp);
        }