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