public ActionResult getLots() { List <pLotModel> lots = new List <pLotModel>(); ParkinglotModel plm = new ParkinglotModel(); foreach (ParkinglotModel lot in plm.getAllLots()) { DateTime dt = DateTime.Now; LogModel lgm = new LogModel(); lgm.lot_id = lot.lot_id; lgm.day = dt.ToString("dd/MM/yyyy"); int engagedCount = lgm.getAllLogsbyLotDayOutTime().Count(); int freeCount = int.Parse(lot.max_vehicle) - engagedCount; if (freeCount > 1) { lots.Add(new pLotModel { lot_id = lot.lot_id, lot_name = lot.lot_name, lat = double.Parse(lot.latitude), lon = double.Parse(lot.longitude), desc = freeCount + "/" + lot.max_vehicle }); } } return(Json(lots, JsonRequestBehavior.AllowGet)); }
// // GET: /Billing/ public ActionResult Index() { if (Request.Cookies["user"] != null) { double totalPay = 0.00; string transactions = ""; LogModel lgm = new LogModel(); lgm.user_id = Request.Cookies["user"].Value; foreach (LogModel log in lgm.getAllLogsbyUserOutTime()) { transactions = transactions + "<tr>"; ParkinglotModel plm = new ParkinglotModel(); plm.lot_id = log.lot_id; plm = plm.getLot(); transactions = transactions + "<td>" + plm.lot_name + "</td>" + "<td>" + log.day + " " + log.out_time + "</td><td>18 Tk</td>"; string duration = getDuration(log.in_time, log.out_time); transactions = transactions + "<td>" + duration + "</td>"; double charge = getPrice(log.day, log.in_time, log.out_time, 18.00); transactions = transactions + "<td>" + String.Format("{0: 0.00}", charge) + " Tk</td>"; if (log.pay_status.Trim() == "0") { transactions = transactions + "<td>Pending</td></tr>"; totalPay = totalPay + charge; } else { transactions = transactions + "<td>Paid</td></tr>"; } } ViewBag.Transactions = transactions; ViewBag.TotalPayable = String.Format("{0: 0.00}", totalPay); if (totalPay < 1.00) { ViewBag.DueDate = "N/A"; } else { ViewBag.DueDate = DateTime.Now.ToString("MMM") + " " + DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month).ToString() + ", " + DateTime.Now.ToString("yyyy"); } return(View()); } else { return(RedirectToAction("Login", "Home")); } }
public ActionResult getLot(string lot_id) { pLotModel plot = new pLotModel(); ParkinglotModel plm = new ParkinglotModel(); plm.lot_id = lot_id; plm = plm.getLot(); plot.lot_id = lot_id; plot.lot_name = plm.lot_name; plot.lat = double.Parse(plm.latitude); plot.lon = double.Parse(plm.longitude); plot.desc = getFreeSpaces(lot_id, plm.max_vehicle) + "/" + plm.max_vehicle; return(Json(plot, JsonRequestBehavior.AllowGet)); }