protected override void OnRequest() { base.OnRequest(); string marketName = getParameter("market_name"); string cargoDescription = getParameter("cargo_description"); CargoListModel cargoList = null; try { cargoList = new Controller.Cargo().GetCargoList(marketName, cargoDescription); WriteSuccess <CargoListModel>(cargoList); } catch (UnfulfilException ex) { WriteUnfulfil(ex.DisplayMessage); } catch (Exception ex) { WriteException(ex); } WriteEnd(); }
// GET: Cargo public ActionResult Index() { if (Session["Key"] == null) { return(RedirectToAction("../Login/Index")); } CargoListModel lista = CargoListModel.Get(); return(View(lista)); }
protected override void OnRequest() { base.OnRequest(); try { string cargoPlate = getParameter("cargo_plate"); string cargoDriver = getParameter("cargo_driver"); string cargoLicence = getParameter("cargo_licence"); string cargoContact = getParameter("cargo_contact"); string cargoDescription = getParameter("cargo_description"); string marketName = getParameter("market_name"); CargoListModel cargoList = null; using (Controller.Cargo controllerCargo = new Controller.Cargo()) { cargoList = controllerCargo.GetCargoList(cargoPlate, cargoDriver, cargoLicence, cargoContact, cargoDescription, marketName); } DatagridModel <ViewCargoListModel> data = new DatagridModel <ViewCargoListModel>(); data.total = (uint)cargoList.Count; data.rows = cargoList; WriteJson(data); } catch (UnfulfilException ex) { WriteUnfulfil(ex.DisplayMessage); } catch (Database.Exception ex) { WriteException(ex); } catch (Exception ex) { WriteException(ex); } }
public CargoListModel GetCargoList(string cargoPlate, string cargoDriver, string cargoLicence, string cargoContact, string cargoDescription, string marketName) { string where = ""; if (!String.IsNullOrWhiteSpace(cargoPlate)) { where += string.Format("view_cargolist.cargo_plate LIKE '%{0}%'", cargoPlate); } if (!String.IsNullOrWhiteSpace(cargoDriver)) { if (!String.IsNullOrWhiteSpace(where)) { where += " AND "; } where += string.Format("view_cargolist.cargo_driver LIKE '%{0}%'", cargoDriver); } if (!String.IsNullOrWhiteSpace(cargoLicence)) { if (!String.IsNullOrWhiteSpace(where)) { where += " AND "; } where += string.Format("view_cargolist.driver_licence LIKE '%{0}%'", cargoLicence); } if (!String.IsNullOrWhiteSpace(cargoContact)) { if (!String.IsNullOrWhiteSpace(where)) { where += " AND "; } where += string.Format("view_cargolist.driver_contact LIKE '%{0}%'", cargoContact); } if (!String.IsNullOrWhiteSpace(cargoDescription)) { if (!String.IsNullOrWhiteSpace(where)) { where += " AND "; } where += string.Format("view_cargolist.cargo_description LIKE '%{0}%'", cargoDescription); } if (!String.IsNullOrWhiteSpace(marketName)) { if (!String.IsNullOrWhiteSpace(where)) { where += " AND "; } where += string.Format("view_cargolist.market_name = '{0}'", marketName); } List <ViewCargoListModel> list = db.SelectData <ViewCargoListModel>("view_cargolist", null, where, true, "view_cargolist.cargo_plate DESC"); if (list == null) { throw new UnfulfilException("/language/database/no_record"); } CargoListModel cargoList = new CargoListModel(); foreach (ViewCargoListModel cargo in list) { cargoList.Add(cargo); } return(cargoList); }