public JsonResult GetListSalients(int Id) { var dao = new CarDAO(); var data = dao.GetListSalients(Id); return(Json(new { data = data }, JsonRequestBehavior.AllowGet)); }
private void dgvManufacturers_SelectionChanged(object sender, EventArgs e) { string sID = dgvManufacturers.CurrentRow.Cells[0].Value.ToString(); int ID = -1; try { ID = int.Parse(sID); } catch (Exception ex) { } CarDAO carDAO = new CarDAO(); bool check = carDAO.CheckUsingManufacturer(ID); if (check) { btnDelete.Enabled = false; } else { btnDelete.Enabled = true; } }
public JsonResult LoadCarCategory() { CarDAO dao = new CarDAO(); var category = dao.LoadCarCategory(); return(Json(new { category = category }, JsonRequestBehavior.AllowGet)); }
public void SetCarList(int category_parent, int category_child, int min_price, int max_price) { var carlist = new CarDAO().LoadCar().Where(x => x.Price > min_price && x.Price < max_price); if (category_parent != -1 && category_child == -1) { List <Car> list = new List <Car>(); var listchild = new CarCategoryDAO().GetListChildByCategoryID(category_parent); foreach (var item in listchild) { var listcar = new CarDAO().GetCarListByCategoryID((int)item.ID); foreach (var car in listcar) { list.Add(car); } } carlist = list.Where(x => x.Price > min_price && x.Price < max_price); } if (category_parent != -1 && category_child != -1) { carlist = new CarDAO().GetCarListByCategoryID(category_child).Where(x => x.Price > min_price && x.Price < max_price); } ViewBag.CarListSearch = carlist.Where(x => x.Status == true); }
public JsonResult DeleteCar(int Id) { var dao = new CarDAO(); bool mes = dao.DeleteCar(Id); return(Json(new { mes = mes })); }
public ActionResult Details(int id) { CarDAO carDAO = new CarDAO(); CarModel car = carDAO.GetCarById(id); return(View("Details", car)); }
async void GetDataAsync() { data = await CarDAO.GetAllCarInfoAsync(); List <CarIF> dataMain = new List <CarIF>(); foreach (var item in data) { dataMain.Add(item); } DataGridCar.DataSource = dataMain;// loi call by other thread //DataGridCar.DataSource = data; CarIF car = data[0]; carIdTextBox.Text = car.CarId.ToString(); carNameTextBox.Text = car.CarName; if (car.GetImage() != null) { avtBox.Image = car.GetImage(); } licensePlateTextBox.Text = car.licensePlate; UserIDDropD.Items.Add(car.UserId); UserIDDropD.SelectedIndex = 0; List <string> userid = CarDAO.GetAllUserId(); foreach (var item in userid) { if (!UserIDDropD.Items.Contains(item)) { UserIDDropD.Items.Add(item); } } dataBlinding(DataGridCar.DataSource); MessageBox.Show("loading data done!"); }
public ActionResult Edit(int id) { CarDAO carDAO = new CarDAO(); CarModel car = carDAO.GetCarById(id); return(View("CarForm", car)); }
private void btnDeleteCar_Click(object sender, EventArgs e) { CarDAO dao = new CarDAO(); dao.DeleteCar(carIdTextBox.Text); GetDataAsync(); }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { CarDAO dao = new CarDAO(); dao.UnDeleteCar(carIdTextBox.Text); GetDataAsync(); }
public ActionResult ProcessCreate(CarModel carModel) { CarDAO carDAO = new CarDAO(); carDAO.Insert(carModel); return(View("Details", carModel)); }
private void textBox1_TextChanged(object sender, EventArgs e) { List <CarIF> dataSearch = CarDAO.GetCarByLikeName(txtSearch.Text, data); DataGridCar.DataSource = dataSearch; if (dataSearch != null) { CarIF car = dataSearch.ElementAt(0); carIdTextBox.Text = car.CarId.ToString(); carNameTextBox.Text = car.CarName; if (car.GetImage() != null) { avtBox.Image = car.GetImage(); } licensePlateTextBox.Text = car.licensePlate; UserIDDropD.Items.Add(car.UserId); UserIDDropD.SelectedIndex = 0; List <string> userid = CarDAO.GetAllUserId(); foreach (var item in userid) { if (!UserIDDropD.Items.Contains(item)) { UserIDDropD.Items.Add(item); } } } dataBlinding(DataGridCar.DataSource); }
public JsonResult ChangeStatus(int Id) { var dao = new CarDAO(); bool?res = dao.ChangeStatus(Id); return(Json(new { res = res })); }
public JsonResult GetCarById(int Id) { var dao = new CarDAO(); var data = dao.GetCarByID(Id); return(Json(new { data = data }, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(string search) { CarDAO carDAO = new CarDAO(); List <CarModel> searchResults = carDAO.SearchCar(search); return(View("Index", searchResults)); }
public List <Account> FindAllDrivers() { List <Account> driversAccounts = new List <Account>(); driversAccounts = AccountDAO.Read().Where(acc => Role.DRIVER.Equals(acc.Role)).ToList(); driversAccounts.ForEach(acc => acc.Car = CarDAO.GetById((int)acc.CarId)); return(driversAccounts); }
// GET: Car public ActionResult Index() { List <CarModel> cars = new List <CarModel>(); CarDAO carDAO = new CarDAO(); cars = carDAO.GetAllCars(); return(View("Index", cars)); }
public IActionResult SearchResult(string search) { CarDAO cars = new CarDAO(); List <CarModel> carList = cars.SearchCars(search); return(View("index", carList)); }
private void search() { string manufacturer = cbManufacturer.Text.Trim(); string category = cbCategory.Text.Trim(); string type = cbType.Text.Trim(); string sPriceFrom = txtPriceFrom.Text.Trim(); string sPriceTo = txtPriceTo.Text.Trim(); double PriceFrom = -1; double PriceTo = -1; if (!string.IsNullOrEmpty(sPriceFrom)) { try { PriceFrom = double.Parse(sPriceFrom); } catch (Exception) { MessageBox.Show("Please input valid Price From!"); return; } if (PriceFrom < 0) { MessageBox.Show("Price must be greater or equal 0!"); return; } } if (!string.IsNullOrEmpty(sPriceTo)) { try { PriceTo = double.Parse(sPriceTo); } catch (Exception) { MessageBox.Show("Please input valid Price To!"); return; } if (PriceTo < 0) { MessageBox.Show("Price must be greater or equal 0!"); return; } } CarDAO carDAO = new CarDAO(); List <CarDTO> list = carDAO.Search(manufacturer, category, type, PriceFrom, PriceTo); dgvCars.DataSource = list; if (list != null) { dgvCars.Rows[0].Selected = true; } }
private void ParkingManager_Load(object sender, EventArgs e) { List <string> useridList = CarDAO.GetAllUserId(); cbUser.DataSource = useridList; cbUser.SelectedIndex = 0; GetData(cbUser.SelectedValue.ToString()); GetParkedPerMonth(); }
public JsonResult LoadCar(int page, int pageSize) { CarDAO dao = new CarDAO(); var data = dao.LoadCar().Skip((page - 1) * pageSize).Take(pageSize); var category = dao.LoadNameCategory(data); int totalRow = data.Count(); return(Json(new { data = data, category = category, totalRowCar = totalRow, }, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(SearchViewModel tempModel) { List <CarViewModel> carViewModels = new ListStack <CarViewModel>(); //put code of search DAO CarDAO.GetCar(tempModel); return(RedirectToAction("SearchResult", new{ carViewModels })); }
//Important public ActionResult Delete(int id) { CarDAO carDAO = new CarDAO(); // show a list after deleting carDAO.Delete(id); List <CarModel> cars = carDAO.GetAllCars(); return(View("Index", cars)); }
public IActionResult Index() { //create an instance of Mobility smaple data to access the method in order to have a link to the data & display // to the browser //MobilitySampleData mobilitySampleData = new MobilitySampleData(); CarDAO cars = new CarDAO(); return(View(cars.GetAllCars())); }
public ActionResult EnterNewCar(CarViewModel tempModel) { CarModel carModel = new CarModel(tempModel); int CarId = 1; CarDAO.InsertCar(carModel); CarPhotoViewModel carPhotoViewModel = new CarPhotoViewModel(); carPhotoViewModel.Id = CarId; return(RedirectToAction("UploadPhoto", new { carPhotoViewModel })); }
public JsonResult CreateEditCar(string strCar) { JavaScriptSerializer serializer = new JavaScriptSerializer(); Car entity = serializer.Deserialize <Car>(strCar); CarDAO dao = new CarDAO(); entity.MetaTitle = Common.convertToUnSign.convert(entity.Name); int res = dao.CreateEditCar(entity, (string)Session[Common.CommonConstants.USER_NAME]); return(Json(new { res = res })); }
public JsonResult Search(int category_parent = -1, int category_child = -1, int min_price = 0, int max_price = 1000000000, string btnsort = "") { if (min_price > max_price) { int a = min_price; min_price = max_price; max_price = a; } var carlist = new CarDAO().LoadCar(); if (category_parent != -1 && category_child == -1) { List <Car> list = new List <Car>(); var listchild = new CarCategoryDAO().GetListChildByCategoryID(category_parent); foreach (var item in listchild) { var listcar = new CarDAO().GetCarListByCategoryID((int)item.ID); foreach (var car in listcar) { list.Add(car); } } carlist = list; } if (category_parent != -1 && category_child != -1) { carlist = new CarDAO().GetCarListByCategoryID(category_child); } if (btnsort == "") { carlist = carlist.Where(x => x.Price > min_price && x.Price < max_price); } if (btnsort == "xedangban") { carlist = carlist.Where(x => x.Price > min_price && x.Price < max_price && x.Sold == true); } if (btnsort == "xesapve") { carlist = carlist.Where(x => x.Price > min_price && x.Price < max_price && x.Sold == false); } if (btnsort == "giatang") { carlist = carlist.Where(x => x.Price > min_price && x.Price < max_price).OrderBy(x => x.Price); } if (btnsort == "giagiam") { carlist = carlist.Where(x => x.Price > min_price && x.Price < max_price).OrderByDescending(x => x.Price); } carlist = carlist.Where(x => x.Status == true); ViewBag.CarListSearch = carlist; return(Json(new { data = carlist, }, JsonRequestBehavior.AllowGet)); }
private void CreateCars() { for (int i = 0; i < ROW_COUNT; i++) { Car car = new Car(); car.CarName = RandomUtil.GetInstance.GetRandomString; car.CarSpeed = 100 * RandomUtil.GetInstance.GetRandomDouble; car.CarCapacity = 100 * RandomUtil.GetInstance.GetRandomDouble; car.IsHealthy = RandomUtil.GetInstance.GetRandomBool; CarDAO.Create(car); } }
public JsonResult SaveSalients(string[] strSalients, int Id) { var dao = new CarDAO(); XElement xElement = new XElement("Salients"); foreach (var item in strSalients) { xElement.Add(new XElement("Salient", item)); } int res = dao.UploadSalients(xElement.ToString(), Id); return(Json(new { res = res })); }
public ActionResult ViewCar(int id) { CarDAO dao = new CarDAO(); Car car = dao.GetCarByID(id); ViewBag.CategoryCar = new CarCategoryDAO().GetParentNameByCategoryID((int)car.CategoryID); ViewBag.ListImages = new CarDAO().GetListImages((int)car.ID); ViewBag.ListSalients = new CarDAO().GetListSalients((int)car.ID); ViewBag.Title = car.SeoTitle; ViewBag.MetaKeywords = car.MetaKeywords; ViewBag.MetaDescription = car.MetaDescriptions; ViewBag.CarDetail = car; return(View(car)); }