public int AddStation(tblStationDetail station)
{
station.CreatedDate = DateTime.Now;
station.LastUpdated = DateTime.Now;
station.Status = "Y";
return(repositery.AddStation(station));
}
public int AddStation(tblStationDetail station)
{
var result = db.tblStationDetails.SingleOrDefault(b => b.StationCode == station.StationCode);
if (result != null)
{
result.StationName = station.StationName;
result.LastUpdated = DateTime.Now;
return(db.SaveChanges());
}
else
{
db.tblStationDetails.Add(station);
return(db.SaveChanges());
}
}
public ActionResult StaionDetails(StationlistModel tsdm)
{
tblStationDetail station = tsdm.tblstation;
int i = Btrain.AddStation(station);
if (i > 0)
{
ViewBag.status = "Station Details Added sussfully";
}
else
{
ViewBag.status = "Failed to Add station.";
}
tsdm.tblstationslist = repositery.getStations().ToList();
return(View(tsdm));
}
public ActionResult TrainSchedule(TrainStationDetailsmodel tstd)
{
ViewBag.stations = repositery.getStations();
ViewBag.TrainId = tstd.TemptblStationTrainDetail.TrainId;
TrainStationDetailsmodel tsdm = new TrainStationDetailsmodel();
if (ModelState.IsValid)
{
tblStationDetail tsd = new tblStationDetail();
tsd = repositery.GetStationName(tstd.TemptblStationTrainDetail.StationCode);
tstd.TemptblStationTrainDetail.StationName = tsd.StationName;
tstd.TemptblStationTrainDetail.Status = "Y";
TemptblStationTrainDetail temp = new TemptblStationTrainDetail();
temp = tstd.TemptblStationTrainDetail;
repositery.ADDstationtraindetails(temp);
tsdm.TemptblStationTrainDetaillist = repositery.GetTemptrainstation(tstd.TemptblStationTrainDetail.TrainId);
ViewBag.TrainId = tstd.TemptblStationTrainDetail.TrainId;
return(View(tsdm));
}
return(View(tstd));
}
