/// <summary>
/// Exclui o card do banco de dados
/// </summary>
/// <param name="card"></param>
/// <returns>bool</returns>
public bool Destroy(Cards card)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
var excluir = db.cards.Where(t => t.id == card.id).First();
db.cards.DeleteOnSubmit(excluir);
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// Decrease the card amount
/// </summary>
/// <param name="card"></param>
/// <returns>bool</returns>
public bool Decrease(Cards card)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
Cards update = (from tar in db.cards
where tar.id == card.id
select tar).First();
update.Amount -= 1;
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// Salva um card para o banco de dados
/// </summary>
/// <param name="card"></param>
/// <returns>bool</returns>
public bool Save(Cards card)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
db.cards.InsertOnSubmit(card);
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
