public bool AddTrainStaSchedule(int delay, int Trainid) { List <TemptblStationTrainDetail> tempdetails = new List <TemptblStationTrainDetail>(); List <StationTrainDetail> stdetails = new List <StationTrainDetail>(); try { tempdetails = repositery.GetTemptrainstation(Trainid); StationTrainDetail std = new StationTrainDetail(); for (int i = 0; i < tempdetails.Count; i++) { if (i == 0) { std.Delay = delay; } else { std.Delay = null; } std.TrainId = tempdetails[i].TrainId; std.Status = tempdetails[i].Status; std.StationCode = tempdetails[i].StationCode; std.StationName = tempdetails[i].StationName; std.SchduleDate = tempdetails[i].SchduleDate; std.DepatureTime = tempdetails[i].DepatureTime; std.ArrivalTime = tempdetails[i].ArrivalTime; repositery.AddTrainStation(std); } return(true); } catch (Exception ex) { return(false); } }
public ActionResult Trainupdate(StationTrainDetail std) { int i = trepositery.Updatestationtraindetails(std); if (i > 0) { ViewBag.Status = "Train No" + std.TrainId + "has been updated successfully"; } return(View(std)); }
public int Updatestationtraindetails(StationTrainDetail std) { int i = 0; var result = db.StationTrainDetails.SingleOrDefault(b => b.Id == std.Id); var delayset = db.StationTrainDetails.SingleOrDefault(b => b.Delay != null && b.TrainId == std.TrainId && b.SchduleDate == result.SchduleDate); if (delayset != null && result != null) { delayset.Delay = null; db.SaveChanges(); } if (result != null) { result.ArrivalTime = std.ArrivalTime; result.DepatureTime = std.DepatureTime; result.Delay = std.Delay; i = db.SaveChanges(); } return(i); }
public int AddTrainStation(StationTrainDetail std) { db.StationTrainDetails.Add(std); return(db.SaveChanges()); }