public ResponseData GetBuses([FromBody] T_RouteDetail v)
{
List <T_BusDetails> buslist = dalobj.T_BusDetails.ToList();
List <T_JourneyDetails> journeylist = dalobj.T_JourneyDetails.ToList();
List <T_RouteDetail> routelist = dalobj.T_RouteDetail.ToList();
List <T_AvlSeats> avllist = dalobj.T_AvlSeats.ToList();
//Int32 i = 1;
var innerJoinQuery =
from bus in buslist
join journy in journeylist on bus.BusId equals journy.BusId
join route in routelist on journy.RouteId equals route.RouteId
join avl in avllist on bus.BusId equals avl.BusId
where route.FromId == v.FromId && route.ToId == v.ToId && avl.Available > 0
select new { bus.BusCapacity, bus.BusType, journy.JourneyFare, route.RouteId, route.ToId, route.FromId,
bus.BusId, journy.JourneyId, journy.ArrivalTime, journy.DepartureTime, bus.BusRegNo, avl.Available };
// dalobj.Database.SqlQuery( )
//int query1 = from r1 in routelist
// where r1.ToId.Equals("Karad") & r1.FromId.Equals("Pune")
// select r1.RouteId;
//var query2 =
// from b in buslist
// join j in journeylist on b.BusId equals j.BusId
// join r in routelist on j.RouteId equals r.RouteId
// where r.RouteId =query1[0].RouteI
// select new { b.BusType, b.BusCapacity, j.JourneyFare, j.DepartureTime, j.ArrivalTime, r.RouteDistance, r.FromId, r.ToId };
res.Data = innerJoinQuery;
if (res.Data != null)
{
res.Status = "Success";
}
return(res);
}
public ResponseData AddRoute([FromBody] T_RouteDetail route)
{
var result = dalobj.T_RouteDetail.Add(route);
dalobj.SaveChanges();
if (result != null)
{
res.Status = "Success";
res.Data = null;
}
return(res);
}
// PUT: api/Admin/5
public ResponseData Put(int id, [FromBody] T_RouteDetail r)
{
var routetobeupdated = dalobj.T_RouteDetail.Find(id);
routetobeupdated.FromId = r.FromId;
routetobeupdated.ToId = r.ToId;
routetobeupdated.RouteDistance = r.RouteDistance;
dalobj.SaveChanges();
if (routetobeupdated != null)
{
res.Status = "Updated";
}
else
{
res.Status = "Some error";
}
return(res);
}
