public bool CancelTickets(string tktId) { if (string.IsNullOrEmpty(tktId)) { return(false); } var dbCtx = new AirlineReservationEntities(); Ticketing_Info cnclTkt = dbCtx.Ticketing_Info.Find(tktId); if (cnclTkt == null) { return(false); } cnclTkt.status = "X"; dbCtx.SaveChanges(); return(true); }
public bool BookTickets(int schId, int fareId, int custId) { string tktId = DateTime.Now.ToString("ddMMMyyhhmmss"); try { var dbCtx = new AirlineReservationEntities(); Ticketing_Info tktInfo = new Ticketing_Info() { ticket_id = tktId, Fare_Id = fareId, cust_id = custId, schedule_id = schId, status = "C" }; dbCtx.Ticketing_Info.Add(tktInfo); int saved = dbCtx.SaveChanges(); return(saved > 0); } catch (Exception exc) { throw exc; } }