public List <SuperZEnt.Articles> ListArticles()
{
List <SuperZEnt.Articles> lista = new List <SuperZEnt.Articles>();
using (var superArticles = new SuperZapatosEntities2())
{
lista = superArticles.Articles.ToList();
}
return(lista);
}
public int Delete(int id)
{
int ret = 0;
using (var superArticles = new SuperZapatosEntities2())
{
SuperZEnt.Articles art = superArticles.Articles.First(x => x.id == id);
superArticles.Articles.Remove(art);
ret = superArticles.SaveChanges();
}
return(ret);
}
public int Edit(SuperZEnt.Stores store)
{
int ret = 0;
using (var superStores = new SuperZapatosEntities2())
{
SuperZEnt.Stores art = superStores.Stores.First(x => x.id == store.id);
art.id = store.id;
art.name = store.name;
art.address = store.address;
ret = superStores.SaveChanges();
}
return(ret);
}
public int Edit(SuperZEnt.Articles article)
{
int ret = 0;
using (var superArticles = new SuperZapatosEntities2())
{
SuperZEnt.Articles art = superArticles.Articles.First(x => x.id == article.id);
art.id = article.id;
art.name = article.name;
art.description = article.description;
art.price = article.price;
art.store_id = article.store_id;
art.total_in_vault = article.total_in_shelf;
art.total_in_shelf = article.total_in_shelf;
ret = superArticles.SaveChanges();
}
return(ret);
}
public int Save(SuperZEnt.Articles article)
{
int ret = 0;
using (var superArticles = new SuperZapatosEntities2())
{
var art = superArticles.Articles
.Where(b => b.id == article.id)
.FirstOrDefault();
if (art == null)
{
superArticles.Articles.Add(article);
ret = superArticles.SaveChanges();
}
else
{
ret = -1;
}
}
return(ret);
}
public int Save(SuperZEnt.Stores store)
{
int ret = 0;
using (var superStores = new SuperZapatosEntities2())
{
var stor = superStores.Stores
.Where(b => b.id == store.id)
.FirstOrDefault();
if (stor == null)
{
superStores.Stores.Add(store);
ret = superStores.SaveChanges();
}
else
{
ret = -1;
}
}
return(ret);
}