private static void UpdateTicketAvailbality(int ticketID)
{
using (TRAINDBEntities db = new TRAINDBEntities())
{
var availble = db.Tickets.SingleOrDefault(t => t.ID == ticketID);
if (availble != null)
{
availble.Available = false;
db.SaveChanges();
}
}
}
private static void UpdateTicketIDinUser(int userID, int ticketID)
{
using (TRAINDBEntities db = new TRAINDBEntities())
{
var update = db.Tickets.SingleOrDefault(t => t.ID == ticketID);
if (update != null)
{
update.UserID = userID;
db.SaveChanges();
}
}
}
private static void UpdateMoneyInUserCreditcard(int userID, int ticketID)
{
using (TRAINDBEntities db = new TRAINDBEntities())
{
double ticketPrice = GetTicketPrice(ticketID);
double discount = Discout(userID);
int userCreditcardID = 0;
var credicardID = (from u in db.Users
where u.ID == userID
select u.CreditCardID);
foreach (var item in credicardID)
{
userCreditcardID = item;
}
var update = db.CraditCards.SingleOrDefault(c => c.ID == userCreditcardID);
if (update != null)
{
update.Amount -= (ticketPrice - (ticketPrice * discount));
db.SaveChanges();
}
}
}