public ActionResult AddExamPaper(FormCollection f)
{
Account acc = (Account)Session["acc"];
Candidate can = db.Candidates.SingleOrDefault(r => r.AccountID == acc.AccountID);
ExaminationsPaper ep = new ExaminationsPaper();
ep.CandidateID = can.CandidateID;
ep.UniExamID = int.Parse(f["uniName"]);
ep.VenueID = int.Parse(f["venueID"]);
ep.StatitonID = int.Parse(f["stationid"]);
ep.PickUpTime = int.Parse(f["pickupTime"]);
db.ExaminationsPapers.Add(ep);
db.SaveChanges();
return RedirectToAction("ManageExamPaper");
}
public ActionResult ViewCar(int id) // carId
{
Car car = db.Cars.SingleOrDefault(r => r.CarID == id);
if (car.ExaminationsPapers.Count > 0)
{
Lodge lodge = new Lodge();
ExaminationsPaper examinationsPaper = new ExaminationsPaper();
examinationsPaper = car.ExaminationsPapers.FirstOrDefault();
lodge = db.Lodges.FirstOrDefault(l => l.LodgeID == examinationsPaper.LodgeRegisteredID);
List<string> address = new List<string>();
address.Add(lodge.Address);
var venues = new List<Venue>();
List<int> venueIDs = new List<int>();
venueIDs = car.ExaminationsPapers.Select(r => r.VenueID).Distinct().ToList();
foreach (int venueID in venueIDs) address.Add(db.Venues.SingleOrDefault(r => r.VenueID == venueID).Address);
ViewData["Place"] = address;
}
return View(car);
}
public ActionResult DisplayRoute(int id) // carId
{
Car car = db.Cars.SingleOrDefault(r => r.CarID == id);
Lodge lodge = new Lodge();
ExaminationsPaper examinationsPaper = new ExaminationsPaper();
examinationsPaper = car.ExaminationsPapers.FirstOrDefault();
lodge = db.Lodges.FirstOrDefault(l => l.LodgeID == examinationsPaper.LodgeRegisteredID);
List<string> address = new List<string>();
address.Add(lodge.Address);
var venues = new List<Venue>();
List<int> venueIDs = new List<int>();
// ds dia diem thi cua cac thi sinh thuoc xe nay.
venueIDs = car.ExaminationsPapers.Select(r => r.VenueID).Distinct().ToList();
foreach (int venueID in venueIDs)
{
address.Add(db.Venues.SingleOrDefault(r => r.VenueID == venueID).Address);
}
//var listExamPaper = new List<Owner>();
//listExamPaper = db.ExaminationsPapers.Where(e => e.CarID == carId).ToList();
//var listVenue = new List<Venue>();
//foreach (var ex in listExamPaper)
//{
// listVenue.Add(ex.Venue);
//}
//listVenue = listVenue.Distinct().ToList();
//var ep = new Owner();
//var lodge = new Lodge();
//var examPaper = listExamPaper.FirstOrDefault();
//if (examPaper != null) joinIn = examPaper.JoinsIns.FirstOrDefault();
//if (joinIn != null) lodge = joinIn.Room.Lodge;
//var address = new List<string>();
//address.Add(lodge.Address);
//foreach (var venue in listVenue)
//{
// address.Add(venue.Address);
//}
//address = new List<string>();
//address.Add("03 hoa binh, quan 11");
//address.Add("100 quang trung, quan 12");
//address.Add("12 nguyen van bao, quan go vap");
//address.Add("cong truong me linh");
ViewData["Place"] = address;
//ViewData["Place"] =
// "[{\"index\": 0, \"address\": \"01 le duan, quan 1\"}, {\"index\": 1, \"address\": \"01 lac long quan, quan tan binh\"}, {\"index\": 2, \"address\": \"01 tran quang khai, quan 1\"}, {\"index\": 3, \"address\": \"59 nguyen hong dao, quan tan binh\"}]";
return View();
}
protected void AssignTheCar(List<ExaminationsPaper> eps, Car car)
{
ExaminationsPaper ep = new ExaminationsPaper();
int quantity = eps.Count < car.AvailableSlots ? eps.Count : car.AvailableSlots;
for (int i = 0; i < quantity; ++i)
{
ep = eps.FirstOrDefault(r => r.CarID == null);
ep.CarID = car.CarID;
--car.AvailableSlots;
}
db.SaveChanges();
}
