public static CarIF[] GetAllCarInfo() { DataClasses1DataContext db = new DataClasses1DataContext(); CarIF[] results = null; while (results == null) { try { var cars = (from table in db.tblCars select table).ToList(); results = new CarIF[cars.Count]; int i = 0; foreach (var car in cars) { CarIF result = new CarIF(); result.CarId = car.carID; result.CarName = car.carName; result.licensePlate = car.licensePlate; result.Status = car.status; result.UserId = car.userID; result.SetImage(car.nearestPhoto != null ? car.nearestPhoto.ToArray() : null); results[i] = result; ++i; } ; } catch (Exception) { MessageBox.Show("Datas are loading...."); } } return(results); }
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!"); }
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); }
//internal void GetData() //{ // data = CarDAO.GetAllCarInfo(); // 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); //} internal void Getdata(CarIF data) { List <CarIF> list = (List <CarIF>)DataGridCar.DataSource; list.Add(data); DataGridCar.DataSource = list; dataBlinding(DataGridCar.DataSource); }
public static CarIF GetCarfullInfor(string carID) { CarIF result = new CarIF(); DataClasses1DataContext db = new DataClasses1DataContext(); tblCar car = db.tblCars.Where(s => s.carID == int.Parse(carID)).Single(); result.CarId = car.carID; result.CarName = car.carName; result.licensePlate = car.licensePlate; result.Status = car.status; result.SetImage(car.nearestPhoto.ToArray()); db.Dispose(); return(result); }
private static void ISP() { var electricCar = new ElectricCarIF(); var car = new CarIF(); car.Name = "Tesla"; car.WheelsCount = 4; car.Type = "Muscle Car"; car.Combustion = 10.5f; electricCar.Name = "Tesla"; electricCar.WheelsCount = 4; electricCar.BatteriesCount = 10; electricCar.About(); car.About(); IVehicle ec = (IVehicle)electricCar; }
private void btnSave_Click(object sender, EventArgs e) { bool check = ValidationFeild(); if (check == true) { tblCar car = new tblCar(); CarIF data = new CarIF(); car.carName = txtCarName.Text; if (txtLicensePlate.Text == null || txtLicensePlate.Text == "") { if (readLicense(PicBoxCarLicence.Image) == null) { MessageBox.Show("Can't read license.Please give another picture"); } else { car.licensePlate = readLicense(PicBoxCarLicence.Image); } } else { car.licensePlate = txtLicensePlate.Text; } MemoryStream ms = new MemoryStream(); PicBoxCarLicence.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png); car.nearestPhoto = ms.ToArray(); car.status = "activated"; car.userID = cbUser.SelectedItem.ToString(); CarDAO dao = new CarDAO(); dao.AddNewCar(car); data = CarDAO.GetCarfullInforByName(car.carName); parent.Getdata(data); MessageBox.Show("Add car success!"); this.Close(); } }