//public IEnumerable<Search_Train_By_DestST_Result> Search_Train_By_DestSTDAL(int id)
//{
// using (var orr = new Online_Railway_reservation_systemEntities())
// {
// orr.Configuration.ProxyCreationEnabled = false;
// foreach (var item in orr.Search_Train_By_DestST(id,DateTime.Now.Date))
// {
// yield return item;
// }
// }
//}
//public IEnumerable<Search_Train_By_DestST_Result> Search_Train_By_DestDAL(int id, string dt)
//{
// using (var orr = new Online_Railway_reservation_systemEntities())
// {
// orr.Configuration.ProxyCreationEnabled = false;
// foreach (var item in orr.Search_Train_By_DestST(id,DateTime.Parse(dt)))
// {
// yield return item;
// }
// }
//}
//public IEnumerable<Get_Train_Des_Result> Get_Train_DesDAL(int id, DateTime dt)
//{
// using (var orr = new Online_Railway_reservation_systemEntities())
// {
// //orr.Configuration.ProxyCreationEnabled = false;
// //orr.Configuration.LazyLoadingEnabled = false;
// //orr.Configuration.AutoDetectChangesEnabled = false;
// //orr.Configuration.UseDatabaseNullSemantics = false;
// //orr.Configuration.ValidateOnSaveEnabled = false;
// //orr.ChangeTracker.DetectChanges();
// foreach(var item in orr.Get_Train_Des(id,dt)){
// yield return item;
// }
// }
//}
//public IEnumerable<Get_Train_Des_Schedule_Result> Get_Train_Des_ScheduleDAL(int id, DateTime dt)
//{
// using (var orr = new Online_Railway_reservation_systemEntities())
// {
// orr.Configuration.ProxyCreationEnabled = false;
// //orr.Configuration.LazyLoadingEnabled = false;
// //orr.Configuration.AutoDetectChangesEnabled = false;
// //orr.Configuration.UseDatabaseNullSemantics = false;
// //orr.Configuration.ValidateOnSaveEnabled = false;
// //orr.ChangeTracker.DetectChanges();
// foreach (var item in orr.Get_Train_Des_Schedule(id, dt.Date))
// {
// yield return item;
// }
// }
//}
public IEnumerable<Get_Train_Des2_Result> Get_Train_Des2DAL(int id, DateTime dt)
{
using (var orr = new Online_Railway_reservation_systemEntities())
{
orr.Configuration.ProxyCreationEnabled = false;
foreach (var item in orr.Get_Train_Des2(id, dt))
{
yield return item;
}
}
}
