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(); } } }