/// <summary>
/// Create Store
/// </summary>
public static void CreateStore(StoreDTO storeDTO)
{
try
{
using (SuperZapatosContext db = new SuperZapatosContext())
{
var storeDB = new Store();
storeDB.name = storeDTO.name;
storeDB.address = storeDTO.address;
db.Stores.Add(storeDB);
db.SaveChanges();
};
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Remove store
/// </summary>
public static StoreDTO DeleteStore(int id)
{
try
{
using (SuperZapatosContext db = new SuperZapatosContext())
{
var storeToDelete = GetStoreById(id);
var storemodel = db.Stores.Find(id);
db.Stores.Remove(storemodel);
db.SaveChanges();
return(storeToDelete);
};
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update store
/// </summary>
public static void UpdateStore(StoreDTO storeDTO)
{
try
{
using (SuperZapatosContext db = new SuperZapatosContext())
{
var storeDB = new Store();
storeDB.name = storeDTO.name;
storeDB.address = storeDTO.address;
storeDB.id = storeDTO.id;
db.Entry(storeDB).State = EntityState.Modified;
db.SaveChanges();
};
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Remove article
/// </summary>
public static ArticleDTO DeleteArticle(int id)
{
try
{
using (SuperZapatosContext db = new SuperZapatosContext())
{
var articleToDelete = GetArticleById(id);
var articlemodel = db.Articles.Find(id);
db.Articles.Remove(articlemodel);
db.SaveChanges();
return(articleToDelete);
};
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update Article
/// </summary>
public static void UpdateArticle(ArticleDTO articleDTO)
{
try
{
using (SuperZapatosContext db = new SuperZapatosContext())
{
var articleDB = new Article();
articleDB.name = articleDTO.name;
articleDB.description = articleDTO.description;
articleDB.price = articleDTO.price;
articleDB.total_in_shelf = articleDTO.total_in_shelf;
articleDB.total_in_vault = articleDTO.total_in_vault;
articleDB.store_id = articleDTO.store_id;
db.Entry(articleDB).State = EntityState.Modified;
db.SaveChanges();
};
}
catch (Exception ex)
{
throw ex;
}
}
