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