//put-update database on id public IHttpActionResult PutCustomer(CustomerViewModel customer) { if (!ModelState.IsValid) { return(BadRequest("This is invalid model.please recheck")); } using (var x = new webapiEntities()) { var checkExsitingCustomer = x.Customers.Where(c => c.id == customer.Id) .FirstOrDefault <Customer>(); if (checkExsitingCustomer != null) { checkExsitingCustomer.name = customer.Name; checkExsitingCustomer.address = customer.Address; checkExsitingCustomer.phone = customer.Phone; x.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
//delete-delete a record base on id public IHttpActionResult Delete(int id) { if (id <= 0) { return(BadRequest("please enter valid customer id")); } using (var x = new webapiEntities()) { var customer = x.Customers .Where(c => c.id == id).FirstOrDefault(); x.Entry(customer).State = System.Data.Entity.EntityState.Deleted; x.SaveChanges(); } return(Ok()); }
//post-insert new record public IHttpActionResult PostNewCustomer(CustomerViewModel customer) { if (!ModelState.IsValid) { return(BadRequest("Invaliddata.please recheck")); } using (var x = new webapiEntities()) { x.Customers.Add(new Customer() { name = customer.Name, email = customer.Email, address = customer.Address, phone = customer.Phone }); x.SaveChanges(); } return(Ok()); }
//Get-retrive data public IHttpActionResult GetAllCustomer() { IList <CustomerViewModel> customer = null; using (var x = new webapiEntities()) { customer = x.Customers .Select(c => new CustomerViewModel() { Id = c.id, Name = c.name, Email = c.email, Address = c.address, Phone = c.phone }).ToList <CustomerViewModel>(); if (customer.Count == 0) { return(NotFound()); } return(Ok(customer)); } }
public AllRepository() { _context = new webapiEntities(); dbEntity = _context.Set <T>(); }