public bool IssueBusTickets(Int64 busPnrId, int appUserId) { try { _ent.Bus_IssueTickets(busPnrId, appUserId); //change status here-- var changestatusobj = _ent.Bus_PNRs.FirstOrDefault(x => x.BusPNRId == busPnrId); if (changestatusobj != null) { changestatusobj.TicketStatusId = 4; _ent.ApplyCurrentValues(changestatusobj.EntityKey.EntitySetName, changestatusobj); if (changestatusobj.Bus_Passengers != null && changestatusobj.Bus_Passengers.Any()) { foreach (var item in changestatusobj.Bus_Passengers) { item.TicketStatusId = 4; _ent.ApplyCurrentValues(item.EntityKey.EntitySetName, item); } } _ent.SaveChanges(); } //========================= } catch { return(false); } return(true); }