public IHttpActionResult Put(CustomerViewModel customer) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new CustomerConnection()) { var existingCustomer = ctx.Customers.Where(s => s.CustomerId == customer.CostumerId) .FirstOrDefault <Customer>(); if (existingCustomer != null) { existingCustomer.Name = customer.Name; existingCustomer.EmailId = customer.EmailId; existingCustomer.Address = customer.Address; existingCustomer.MobileNo = customer.MobileNo; ctx.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
// GET api/values public IHttpActionResult Get() { List <CustomerViewModel> oList = new List <CustomerViewModel>(); using (var ctx = new CustomerConnection()) { foreach (var item in ctx.Customers) { oList.Add( new CustomerViewModel() { Name = item.Name, Address = item.Address, Birthday = item.Birthday, CostumerId = item.CustomerId, EmailId = item.EmailId, MobileNo = item.MobileNo }); } } if (oList.Count == 0) { return(NotFound()); } return(Ok(oList)); }
//This is only public because I need the connectionString to get a List of all the stored procs on the table. public string GetConnectionString() { var connectionString = ""; CustomerConnection.GetCustomerConnection(_sessionService.GetCustomerId(), out connectionString); return(connectionString); }
public IHttpActionResult Post() { using (var ctx = new CustomerConnection()) { ctx.Customers.Add(new Customer() { Name = "Eduardo", Address = "Rua Das Margaridas", EmailId = "@google.com", MobileNo = "1199993333", Birthday = DateTime.Now }); ctx.SaveChanges(); } return(Ok()); }
public IHttpActionResult Delete(int id) { if (id <= 0) { return(BadRequest("Not a valid student id")); } using (var ctx = new CustomerConnection()) { var customer = ctx.Customers .Where(s => s.CustomerId == id) .FirstOrDefault(); ctx.Entry(customer).State = System.Data.Entity.EntityState.Deleted; ctx.SaveChanges(); } return(Ok()); }