public void PostToSql(TrainHelperModel trainObj) { Train NewData = new Train { TrainId = trainObj.TrainId, TrainName = trainObj.TrainName, FromStation = trainObj.FromStation, ToStation = trainObj.ToStation, Time = trainObj.Time }; db.Trains.Add(NewData); db.SaveChanges(); }
public ActionResult Create([Bind(Include = "TrainId,TrainName,FromStation,ToStation,Time")] TrainHelperModel newTrainData) { if (ModelState.IsValid) { ctx.PostDataToSql(newTrainData); BackgroundJob.Enqueue(() => PostData()); BackgroundJob.Enqueue(() => PostDataToElasticSearch()); return(RedirectToAction("Index")); } return(View(newTrainData)); }
public List <TrainHelperModel> GetDataFromMongo() { IQueryable <TrainMongo> List = db.TrainMongoCollection.AsQueryable(); List <TrainHelperModel> ReturnedObjects = new List <TrainHelperModel>(); foreach (var item in List) { TrainHelperModel temp = new TrainHelperModel { TrainId = item.TrainId, TrainName = item.TrainName, FromStation = item.FromStation, ToStation = item.ToStation, Time = item.Time }; ReturnedObjects.Add(temp); } return(ReturnedObjects); }
public List <TrainHelperModel> GetDataFromSql() { List <Train> temp = db.Trains.ToList(); List <TrainHelperModel> returneditems = new List <TrainHelperModel>(); foreach (var item in temp) { TrainHelperModel val = new TrainHelperModel { TrainId = item.TrainId, TrainName = item.TrainName, FromStation = item.FromStation, ToStation = item.ToStation, Time = item.Time }; returneditems.Add(val); } return(returneditems); }
public void PostDataToSql(TrainHelperModel trainsqlObj) { db.PostToSql(trainsqlObj); }