public bool DeleteUser(string id) { var user = FindUserById(id); if (user == null) { return(false); } _context.Users.Remove(user); _context.SaveChanges(); return(true); }
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); }
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); }
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); }