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));
}
