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