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