public IHttpActionResult PutconfigCards(Guid id, configCards configCards)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != configCards.CardID)
{
return(BadRequest());
}
db.Entry(configCards).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!configCardsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PerformTransaction(string cardQR, int Total, int SupplierID, int password)
{
var cQR = Guid.Parse(cardQR);
//return class contains password or not found if there is no password
Messages msg = new Messages();
using (db = new HajjCoinsModel())
{
configCards configCards = new configCards();
var CoinsCount = db.configCards.Where(a => a.CardID == cQR).Select(a => a.NoOfCoins).FirstOrDefault();
if (CoinsCount >= Total)
{
//var coinsList = db.Coins.Where(a => a.CardID == cQR).ToList();
//var validCoins = (from coinsList in db.Coins
// join usedList in db.TransactionsCoinsSupplier
// on coinsList.CoinID equals usedList.CoinsID
// where db.TransactionsCoinsSupplier.Contains(usedList.CoinsID)
// select new { coinsList.CoinID }).ToList();
var trans_coinList = db.TransactionsCoinsSupplier.Select(x => x.CoinsID).ToArray();
var validCoins = db.Coins.Where(p => !trans_coinList.Contains(p.CoinID)).ToList();
if (validCoins.Count > 0)
{
var cardCoin = db.configCards.Where(a => a.CardID == cQR).FirstOrDefault();
db.Entry(cardCoin).State = EntityState.Modified;
cardCoin.NoOfCoins -= Total;
db.SaveChanges();
Transaction tr = new Transaction();
tr.TotalCoinsUsed = Total;
tr.TransactionDate = System.DateTime.Now;
tr.SupplyerID = SupplierID;
db.Transaction.Add(tr);
db.SaveChanges();
for (int i = 0; i < Total; i++)
{
TransactionsCoinsSupplier coin = new TransactionsCoinsSupplier();
coin.CoinsID = validCoins[i].CoinID;
coin.TransactionID = tr.TransactionID;
db.TransactionsCoinsSupplier.Add(coin);
}
msg.message = Total + " hajjCoins successfully received";
msg.status = true;
return(Ok(msg));
}
else
{
msg.message = "Your hajjCoins balance is not enough";
msg.status = false;
return(Ok(msg));
}
}
else
{
msg.message = "Your hajjCoins balance is not enough";
msg.status = false;
return(Ok(msg));
}
}
}