/// <summary>
/// Save current Deck to Database, used for the Deckbuilder
/// </summary>
/// <param name="deckcardId"></param>
/// <param name="deckId"></param>
public static void SaveDeckToDatabase(int deckcardId, int deckId)
{
tblcollection coll = new tblcollection();
tbldeck deck = new tbldeck();
using (var db = new ClonestoneFSEntities())
{
var cocaItem = (from c in db.tblcollection
where c.idcollectioncard == deckcardId
select c).FirstOrDefault();
var deckItem = (from d in db.tbldeck
where d.iddeck == deckId
select d).FirstOrDefault();
deckItem.tblcollection.Add(cocaItem);
db.SaveChanges();
}
}
/// <summary>
/// Used to execute and confirm orders (card- and goldorders)
/// Cardorder: checks if user has enough currency then generates the amount of cards based on cardquantity
/// Goldorder: creditcard payment, creditcardnumber get checkt via luhn algorithm and data will be send via HTTPS to the Credit Card company
/// </summary>
/// <param name="personID"></param>
/// <param name="packID"></param>
/// <param name="creditCardNumber"></param>
public static void ExecuteOrder(int personID, int packID, string creditCardNumber)
{
using (var db = new ClonestoneFSEntities())
{
tblorder order = new tblorder();
tblcollection col = new tblcollection();
Random r = new Random();
order.fkpack = packID;
order.fkperson = personID;
order.orderdate = DateTime.Now;
db.tblorder.Add(order);
db.SaveChanges();
int orderID = (from p in db.tblorder
orderby p.idorder descending
select p.idorder).FirstOrDefault();
int cardq = (from q in db.tblpack
where q.idpack == packID
select q.cardquantity).FirstOrDefault();
#region Kartenpacks
if (cardq != 0)
{
// Update Person !
try
{
var updatePerson = (from p in db.tblperson
where p.idperson == personID
select p);
var packValue = (from v in db.tblpack
where v.idpack == packID
select v.packprice).FirstOrDefault();
foreach (var value in updatePerson)
{
value.currencybalance -= (int)packValue;
}
db.SaveChanges();
}
catch (Exception e)
{
Log.Writer.LogError(e);
}
// Insert Cards !
for (int i = 0; i < cardq; i++)
{
int rng = r.Next(1, 698);
var card = (from c in db.tblcard
where c.idcard == rng
select c).FirstOrDefault();
if (card != null)
{
col.fkperson = personID;
col.fkorder = orderID;
col.fkcard = card.idcard;
db.tblcollection.Add(col);
db.SaveChanges();
}
else
{
i = i - 1;
}
}
}
#endregion
#region Goldpacks
else
{
//TODO - ausbessern
if (true)
{
tblperson person = new tblperson();
var updatePerson = (from p in db.tblperson
where p.idperson == personID
select p);
var goldValue = (from g in db.tblpack
where g.idpack == packID
select g.goldquantity).FirstOrDefault();
foreach (var value in updatePerson)
{
value.currencybalance += (int)goldValue;
}
db.SaveChanges();
}
else
{
//was auch immer
}
}
#endregion
}
}