public ActionResult PrintTickets(int id)
{
//BusdbEntities busdb = new BusdbEntities();
//List<reserve> R = busdb.reserves.ToList();
//ReserveM ReserveNew = new ReserveM();
//List<ReserveM> ReserveListNew = R.Select(x => new ReserveM
//{
// email = x.email,
// gender = x.gender,
// name = x.name,
// phone_no = x.phone_no,
// routeId = x.rid,
// scheduleId = x.sid,
// seat_no = x.seat_no,
// ticket_no = x.ticket_no,
//}).ToList();
//ReserveM reserveSingle = ReserveListNew.Single(y => y.ticket_no == id);
BusdbEntities db = new BusdbEntities();
ReserveM find = new ReserveM();
var xx = db.reserves.Where(x => x.ticket_no == id).FirstOrDefault();
find.email = xx.email;
find.gender = xx.gender;
find.name = xx.name;
find.phone_no = xx.phone_no;
find.routeId = xx.rid;
find.scheduleId = xx.sid;
find.seat_no = xx.seat_no;
find.ticket_no = xx.ticket_no;
List <ReserveM> nn = new List <ReserveM>();
nn.Add(find);
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/report"), "PrintTicket.rpt"));
rd.SetDataSource(nn);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "ticket.pdf"));
}
catch
{
throw;
}
}
public ActionResult Delete(int id)
{
BusdbEntities db = new BusdbEntities();
RbScheduleM find = new RbScheduleM();
var xx = db.rbschedules.Where(x => x.sid == id).FirstOrDefault();
db.rbschedules.Remove(xx);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
BusdbEntities db = new BusdbEntities();
Buses find = new Buses();
var xx = db.buses.Where(x => x.bid == id).FirstOrDefault();
db.buses.Remove(xx);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
BusdbEntities db = new BusdbEntities();
ReserveM find = new ReserveM();
var xx = db.reserves.Where(x => x.ticket_no == id).FirstOrDefault();
db.reserves.Remove(xx);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
BusdbEntities db = new BusdbEntities();
RouteM find = new RouteM();
var xx = db.routes.Where(x => x.rid == id).FirstOrDefault();
find.Routeid = xx.rid;
find.FromLocation = xx.from_location;
find.ToLocation = xx.to_location;
return(View(find));
}
public ActionResult Details(int id)
{
BusdbEntities db = new BusdbEntities();
Buses find = new Buses();
var xx = db.buses.Where(x => x.bid == id).FirstOrDefault();
find.Busid = xx.bid;
find.BusName = xx.bname;
find.BusType = xx.btype;
find.MaxSeat = xx.max_seats;
return(View(find));
}
public ActionResult Create(RouteM xx)
{
BusdbEntities db = new BusdbEntities();
route r = new route();
r.rid = xx.Routeid;
r.from_location = xx.FromLocation;
r.to_location = xx.ToLocation;
db.routes.Add(r);
db.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult Edit(int id)
{
BusdbEntities db = new BusdbEntities();
RbScheduleM find = new RbScheduleM();
var xx = db.rbschedules.Where(x => x.sid == id).FirstOrDefault();
find.sid = xx.sid;
find.rid = xx.rid;
find.bid = xx.bid;
find.fare = xx.fare;
find.departure_date = xx.departure_date;
find.departure_time = xx.departure_time;
return(View(find));
}
public ActionResult Edit(RouteM xx)
{
BusdbEntities db = new BusdbEntities();
var find = db.routes.Where(x => x.rid == xx.Routeid).FirstOrDefault();
find.rid = xx.Routeid;
find.from_location = xx.FromLocation;
find.to_location = xx.ToLocation;
db.Entry(find).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult Create(Buses xx)
{
BusdbEntities db = new BusdbEntities();
bus r = new bus();
r.bid = xx.Busid;
r.bname = xx.BusName;
r.btype = xx.BusType;
r.max_seats = xx.MaxSeat;
db.buses.Add(r);
db.SaveChanges();
return(RedirectToAction("index"));
}
// GET: Buses
public ActionResult Index()
{
BusdbEntities busdb = new BusdbEntities();
List <bus> B = busdb.buses.ToList();
Buses busnew = new Buses();
List <Buses> BusListNew = B.Select(x => new Buses
{
Busid = x.bid,
BusName = x.bname,
BusType = x.btype,
MaxSeat = x.max_seats,
}).ToList();
return(View(BusListNew));
}
// GET: Route
public ActionResult Index()
{
BusdbEntities busdb = new BusdbEntities();
List <route> routeList = busdb.routes.ToList();
RouteM rbs = new RouteM();
List <RouteM> RListNew = routeList.Select(x => new RouteM
{
Routeid = x.rid,
FromLocation = x.from_location,
ToLocation = x.to_location,
}).ToList();
return(View(RListNew));
}
public ActionResult Edit(Buses xx)
{
BusdbEntities db = new BusdbEntities();
var find = db.buses.Where(x => x.bid == xx.Busid).FirstOrDefault();
find.bid = xx.Busid;
find.bname = xx.BusName;
find.btype = xx.BusType;
find.max_seats = xx.MaxSeat;
db.Entry(find).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult Details(int id)
{
BusdbEntities db = new BusdbEntities();
ReserveM find = new ReserveM();
var xx = db.reserves.Where(x => x.ticket_no == id).FirstOrDefault();
find.email = xx.email;
find.gender = xx.gender;
find.name = xx.name;
find.phone_no = xx.phone_no;
find.routeId = xx.rid;
find.scheduleId = xx.sid;
find.seat_no = xx.seat_no;
find.ticket_no = xx.ticket_no;
return(View(find));
}
public ActionResult Create(RbScheduleM xx)
{
BusdbEntities db = new BusdbEntities();
rbschedule r = new rbschedule();
r.sid = xx.sid;
r.rid = xx.rid;
r.bid = xx.bid;
r.fare = xx.fare;
r.departure_date = xx.departure_date;
r.departure_time = xx.departure_time;
db.rbschedules.Add(r);
db.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult Edit(RbScheduleM xx)
{
BusdbEntities db = new BusdbEntities();
var find = db.rbschedules.Where(x => x.sid == xx.sid).FirstOrDefault();
find.sid = xx.sid;
find.rid = xx.rid;
find.bid = xx.bid;
find.fare = xx.fare;
find.departure_date = xx.departure_date;
find.departure_time = xx.departure_time;
db.Entry(find).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
// GET: Reserve
public ActionResult Index()
{
BusdbEntities busdb = new BusdbEntities();
List <reserve> R = busdb.reserves.ToList();
ReserveM ReserveNew = new ReserveM();
List <ReserveM> ReserveListNew = R.Select(x => new ReserveM
{
email = x.email,
gender = x.gender,
name = x.name,
phone_no = x.phone_no,
routeId = x.rid,
scheduleId = x.sid,
seat_no = x.seat_no,
ticket_no = x.ticket_no,
}).ToList();
return(View(ReserveListNew));
}
// GET: Schedule
public ActionResult Index()
{
BusdbEntities busdb = new BusdbEntities();
List <rbschedule> lrbs = busdb.rbschedules.ToList();
RbScheduleM rbs = new RbScheduleM();
List <RbScheduleM> SListNew = lrbs.Select(x => new RbScheduleM
{
sid = x.sid,
rid = x.rid,
fare = x.fare,
departure_date = x.departure_date,
departure_time = x.departure_time,
bid = x.bid
}).ToList();
return(View(SListNew));
}
public ActionResult Edit(ReserveM xx)
{
BusdbEntities db = new BusdbEntities();
var find = db.reserves.Where(x => x.ticket_no == xx.ticket_no).FirstOrDefault();
find.email = xx.email;
find.gender = xx.gender;
find.name = xx.name;
find.phone_no = xx.phone_no;
find.rid = xx.routeId;
find.sid = xx.scheduleId;
find.seat_no = xx.seat_no;
find.ticket_no = xx.ticket_no;
db.Entry(find).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
