public HttpResponseMessage AddArticles([FromBody] ArticleRequest article)
{
try
{
using (BackNetEntity db = new BackNetEntity())
{
var oArticle = new Models.articles();
oArticle.name = article.name;
oArticle.description = article.description;
oArticle.price = article.price;
oArticle.total_in_shelf = article.total_in_shelf;
oArticle.total_in_vault = article.total_in_vault;
oArticle.store_id = article.store_id;
db.articles.Add(oArticle);
db.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, article);
message.Headers.Location = new Uri(Request.RequestUri +
article.id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage PutArticles(ArticleRequest oModel)
{
try
{
using (BackNetEntity db = new BackNetEntity())
{
articles oArticles = db.articles.Find(oModel.id);
if (oArticles == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"La Store con el Id " + oModel.id.ToString() + " no pudo actualizarse"));
}
else
{
oArticles.name = oModel.name;
oArticles.description = oModel.description;
oArticles.price = oModel.price;
oArticles.total_in_shelf = oModel.total_in_shelf;
oArticles.total_in_vault = oModel.total_in_vault;
oArticles.store_id = oModel.store_id;
db.Entry(oArticles).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage DelArticles(int id)
{
try
{
using (BackNetEntity db = new BackNetEntity())
{
articles oArticles = db.articles.Find(id);
if (oArticles == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"La Store con el Id " + id.ToString() + " no pudo Eliminarse"));
}
else
{
db.articles.Remove(oArticles);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage PutStores(StoresRequest oModel)
{
try
{
using (BackNetEntity db = new BackNetEntity())
{
stores oStore = db.stores.Find(oModel.id);
if (oStore == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"La Store con el Id " + oModel.id.ToString() + " no pudo actualizarse"));
}
else
{
oStore.name = oModel.name;
oStore.address = oModel.address;
db.Entry(oStore).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IHttpActionResult GetArticlesById(int id)
{
getArticles article = null;
using (var db = new BackNetEntity())
{
article = db.articles.Include("ArticleAdd")
.Where(s => s.id == id)
.Select(s => new getArticles()
{
id = s.id,
name = s.name,
description = s.description,
price = s.price,
total_in_shelf = s.total_in_shelf,
total_in_vault = s.total_in_vault,
store_id = s.store_id
}).FirstOrDefault <getArticles>();
}
if (article == null)
{
return(NotFound());
}
return(Ok(article));
}
public IHttpActionResult GetArticles()
{
IList <getArticles> lista = null;
using (var db = new BackNetEntity())
{
lista = db.articles.Include("ArticleAdd")
.Select(s => new getArticles()
{
id = s.id,
name = s.name,
description = s.description,
price = s.price,
total_in_shelf = s.total_in_shelf,
total_in_vault = s.total_in_vault,
store_id = s.store_id
}).ToList <getArticles>();
}
if (lista.Count == 0)
{
return(NotFound());
}
return(Ok(lista));
}
public IHttpActionResult GetStoresById(int id)
{
getStores store = null;
using (BackNetEntity db = new BackNetEntity())
{
//IQueryable<stores> list =
// from s in db.stores
// select new stores
// {
// id = s.id,
// name = s.name,
// address = s.address
// };
store = db.stores.Include("StoreAdd")
.Where(s => s.id == id)
.Select(s => new getStores()
{
id = s.id,
name = s.name,
address = s.address
}).FirstOrDefault <getStores>();
}
if (store == null)
{
return(NotFound());
}
return(Ok(store));
}
public IHttpActionResult GetAllStores()
{
IList <getStores> lista = null;
using (var db = new BackNetEntity())
{
lista = db.stores.Include("StoreAdd")
.Select(s => new getStores()
{
id = s.id,
name = s.name,
address = s.address
}).ToList <getStores>();
}
if (lista.Count == 0)
{
return(NotFound());
}
return(Ok(lista));
}
public HttpResponseMessage AddStores([FromBody] StoresRequest store)
{
try
{
using (BackNetEntity db = new BackNetEntity())
{
var oStores = new Models.stores();
oStores.name = store.name;
oStores.address = store.address;
db.stores.Add(oStores);
db.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, store);
message.Headers.Location = new Uri(Request.RequestUri +
store.id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
