public HttpResponseMessage Put([FromBody] Models.shop updatedShop)
{
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
var originalShop = db.shops.Find(updatedShop.ShopId);
if (originalShop != null)
{
db.Entry(originalShop).CurrentValues.SetValues(updatedShop);
db.SaveChanges();
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "shop id not recognized"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, JObject.FromObject(updatedShop)));
}
public HttpResponseMessage Delete(int id)
{
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
var originalShop = db.shops.Find(id);
if (originalShop != null)
{
db.shops.Remove(originalShop);
db.SaveChanges();
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "shop id not recognized"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Delete(int id)
{
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
var originalUser = db.users.Find(id);
if (originalUser != null)
{
db.users.Remove(originalUser);
db.SaveChanges();
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, "user id not recognized");
}
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}
public static List <Models.user> GetUsers()
{
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
return(db.users.ToList());
}
}
catch (Exception ex)
{
throw new Exception("Error retrieving user list", ex);
}
}
public static List<Models.user> GetUsers()
{
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
return db.users.ToList();
}
}
catch(Exception ex)
{
throw new Exception("Error retrieving user list", ex);
}
}
public static Models.user GetUser(int userId)
{
Models.user thisUser;
try {
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
thisUser = db.users.SingleOrDefault(s => s.UserId == userId);
}
}
catch (Exception ex)
{
throw new Exception("Error finding user", ex);
}
return(thisUser);
}
public static Models.user GetUser(int userId)
{
Models.user thisUser;
try {
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
thisUser = db.users.SingleOrDefault(s => s.UserId == userId);
}
}
catch (Exception ex)
{
throw new Exception("Error finding user", ex);
}
return thisUser;
}
public HttpResponseMessage Post([FromBody] Models.shop newShop)
{
try
{
newShop.ShopId = 0;
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
db.shops.Add(newShop);
db.SaveChanges();
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, JObject.FromObject(newShop)));
}
public HttpResponseMessage Get()
{
JArray shops = new JArray();
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
foreach (Models.shop s in db.shops)
{
shops.Add(JObject.FromObject(s));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, shops));
}
public HttpResponseMessage Get()
{
JArray shops = new JArray();
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
foreach (Models.shop s in db.shops)
{
shops.Add(JObject.FromObject(s));
}
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
}
return Request.CreateResponse(HttpStatusCode.OK, shops);
}
public HttpResponseMessage Get(int id)
{
Models.shop thisShop;
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
thisShop = db.shops.SingleOrDefault(s => s.ShopId == id);
if (thisShop == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "shop id " + id.ToString() + " not found"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, JObject.FromObject(thisShop)));
}
public HttpResponseMessage GetUser(int id)
{
Models.user thisUser;
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
thisUser = db.users.SingleOrDefault(s => s.UserId == id);
if(thisUser == null)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, "user id " + id.ToString() + " not found");
}
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
}
return Request.CreateResponse(HttpStatusCode.OK, JObject.FromObject(thisUser));
}
public HttpResponseMessage GetRuns(int id)
{
List <Models.run> runs = new List <Models.run>();
JArray runArray = new JArray();
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
runs = db.runs.Where(s => s.ShopId == id).ToList();
foreach (Models.run r in runs)
{
runArray.Add(JToken.FromObject(r));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, runArray));
}
public HttpResponseMessage GetOrders(int id)
{
List <Models.order> orders = new List <Models.order>();
JArray orderArray = new JArray();
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
orders = db.orders.SqlQuery("select * from orders o join runs r on o.runid = r.runid where r.shopid = shopIdParam", new SqlParameter("shopIdParam", id)).ToList();
foreach (Models.order o in orders)
{
orderArray.Add(JToken.FromObject(o));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, orderArray));
}
public HttpResponseMessage GetOrders(int id)
{
List<Models.order> orders = new List<Models.order>();
JArray orderArray = new JArray();
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
orders = db.orders.SqlQuery("select * from orders o join runs r on o.runid = r.runid where r.shopid = shopIdParam", new SqlParameter("shopIdParam",id)).ToList();
foreach (Models.order o in orders)
{
orderArray.Add(JToken.FromObject(o));
}
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
}
return Request.CreateResponse(HttpStatusCode.OK, orderArray);
}
public HttpResponseMessage GetRuns(int id)
{
List<Models.run> runs = new List<Models.run>();
JArray runArray = new JArray();
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
runs = db.runs.Where(s => s.ShopId == id).ToList();
foreach(Models.run r in runs)
{
runArray.Add(JToken.FromObject(r));
}
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
}
return Request.CreateResponse(HttpStatusCode.OK, runArray);
}
public HttpResponseMessage Put([FromBody]Models.user updatedUser)
{
try
{
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
var originalUser = db.users.Find(updatedUser.UserId);
if(originalUser != null)
{
db.Entry(originalUser).CurrentValues.SetValues(updatedUser);
db.SaveChanges();
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, "user id not recognized");
}
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
}
return Request.CreateResponse(HttpStatusCode.OK, JObject.FromObject(updatedUser));
}
public HttpResponseMessage Post([FromBody]Models.user newUser)
{
try
{
newUser.UserId = 0;
using (var db = new SONRCoffee.Data.SONRCoffeeDbContext())
{
db.users.Add(newUser);
db.SaveChanges();
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
}
return Request.CreateResponse(HttpStatusCode.OK, JObject.FromObject(newUser));
}
