public List <string> GetAllVehicleNumbers() { DataTable dt = new DataTable(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(VehicleStringsInner.GetAllVehicleNumbers()); } List <VehicleModel> arrVehicle = new List <VehicleModel>(); foreach (DataRow ms in dt.Rows) { arrVehicle.Add(VehicleModel.ToObject(ms)); } List <string> vehicleNumbers = new List <string>(); foreach (var vehicle in arrVehicle) { vehicleNumbers.Add(vehicle.vehicleNumber); } return(vehicleNumbers); }
public VehicleModel AddVehicle(VehicleModel vehicleModel) { DataTable dt = new DataTable(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(VehicleStringsSql.AddVehicle(vehicleModel)); } foreach (DataRow ms in dt.Rows) { vehicleModel = VehicleModel.ToObject(ms); } return(vehicleModel); }
public List <VehicleModel> GetAllVehicles() { DataTable dt = new DataTable(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(VehicleStringsInner.GetAllVehicles()); } List <VehicleModel> arrVehicle = new List <VehicleModel>(); foreach (DataRow ms in dt.Rows) { arrVehicle.Add(VehicleModel.ToObject(ms)); } return(arrVehicle); }
public VehicleModel GetOneVehicleByOwnerId(string personId) { DataTable dt = new DataTable(); if (personId.Equals(string.Empty) || personId.Equals("")) { throw new ArgumentOutOfRangeException(); } VehicleModel vehicleModel = new VehicleModel(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(VehicleStringsInner.GetOneVehicleByOwnerId(personId)); } foreach (DataRow ms in dt.Rows) { vehicleModel = VehicleModel.ToObject(ms); } return(vehicleModel); }
public VehicleModel GetOneVehicleByNumber(string vehicleNumber) { DataTable dt = new DataTable(); if (vehicleNumber.Equals(string.Empty) || vehicleNumber.Equals("")) { throw new ArgumentOutOfRangeException(); } VehicleModel vehicleModel = new VehicleModel(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(VehicleStringsSql.GetOneVehicleByNumber(vehicleNumber)); } foreach (DataRow ms in dt.Rows) { vehicleModel = VehicleModel.ToObject(ms); } return(vehicleModel); }