public List<VehicleInformation> GetAllVehicle() { List<VehicleInformation> allVehicles = new List<VehicleInformation>(); try { SqlConnectionObj.Open(); string query = string.Format("select * from VehicleInformation"); SqlCommandObj.CommandText = query; SqlDataReader reader = SqlCommandObj.ExecuteReader(); while (reader.Read()) { VehicleInformation aVehicleInformation = new VehicleInformation(); aVehicleInformation.RegNo = reader[0].ToString(); aVehicleInformation.EngineNo = reader[1].ToString(); allVehicles.Add(aVehicleInformation); } } catch (Exception exceptionObj) { throw new Exception("Vehicle inforamtion number can not be loaded.", exceptionObj); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return allVehicles; }
public List<SchedulesOfAVehicle> GetSchedulesOfASingleVehicle(VehicleInformation vehicle) { List<SchedulesOfAVehicle> schedulesOfAVehicle = new List<SchedulesOfAVehicle>(); try { SqlConnectionObj.Open(); string query = string.Format("SELECT Date,Shift FROM ScheduleVehicle WHERE VehicleRegNo='{0}'", vehicle.RegNo); SqlCommandObj.CommandText = query; SqlDataReader reader = SqlCommandObj.ExecuteReader(); if(reader.HasRows) { while (reader.Read()) { SchedulesOfAVehicle singleScheduleOfAVehicle = new SchedulesOfAVehicle(); singleScheduleOfAVehicle.DateTime = (DateTime)reader[0]; singleScheduleOfAVehicle.Shift = reader[1].ToString(); schedulesOfAVehicle.Add(singleScheduleOfAVehicle); } return schedulesOfAVehicle; } } catch (Exception exceptionObj) { throw new Exception("Exception Occured in GetScheduleOfASingleVehicle method!!!",exceptionObj); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return null; }
public ScheduleVehicle IsScheduleBooked(VehicleInformation vehicle, DateTime selectedDate, string shift) { try { SqlConnectionObj.Open(); string query = string.Format("SELECT * FROM ScheduleVehicle WHERE VehicleRegNo='{0}' AND Date='{1}' AND Shift='{2}'", vehicle.RegNo, selectedDate, shift); SqlCommandObj.CommandText = query; SqlDataReader reader = SqlCommandObj.ExecuteReader(); while (reader.Read()) { ScheduleVehicle vehicleSchedule = new ScheduleVehicle(); vehicleSchedule.Vehicle.RegNo = reader[0].ToString(); vehicleSchedule.SelectedDate = (DateTime)reader[1]; vehicleSchedule.SelectShift = reader[2].ToString(); vehicleSchedule.BookedBy = reader[3].ToString(); vehicleSchedule.Address = reader[4].ToString(); return vehicleSchedule; } } catch (Exception exceptionObj) { throw new Exception("Exception occured! In Schedule Booking.",exceptionObj); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return null; }
public bool IsScheduleBooked(VehicleInformation vehicle, DateTime selectedDate, string shift) { ScheduleVehicle vehicleSchedule = new ScheduleVehicle(); vehicleSchedule = scheduleVehicleGateway.IsScheduleBooked(vehicle, selectedDate, shift); if(vehicleSchedule!=null) { string msg = string.Format("This schedule is already booked by : {0}", vehicleSchedule.BookedBy); return true; } return false; }
public List<SchedulesOfAVehicle>GetSchedulesOfASingleVehicle(VehicleInformation vehicle) { try { if(_vehicleScheduleGateway.GetSchedulesOfASingleVehicle(vehicle)!=null) { return _vehicleScheduleGateway.GetSchedulesOfASingleVehicle(vehicle); } } catch (Exception exceptionObj) { throw new Exception("Exception Occured!!",exceptionObj); } return null; }
public bool GetVehicleSchedule(VehicleInformation vehicle, DateTime selectedDate,string shift, string bookedBy, string address) { try { if(!IsScheduleBooked(vehicle,selectedDate,shift)) { scheduleVehicleGateway.SaveSchedule(vehicle, selectedDate, shift, bookedBy, address); return true; } } catch (Exception exceptionObj) { throw new Exception("Exception occured! Schedule can not be saved.",exceptionObj); } return false; }
private void singleVehicleScheduleShowButton_Click(object sender, EventArgs e) { VehicleScheduleManager vehicleScheduleManager = new VehicleScheduleManager(); VehicleInformation selectedVehicle = new VehicleInformation(); selectedVehicle = (VehicleInformation) scheduleOfAVehicleComboBox.SelectedItem; try { if(vehicleScheduleManager.GetSchedulesOfASingleVehicle(selectedVehicle)!=null) { schedulesOfAVehicleGridView.DataSource = vehicleScheduleManager.GetSchedulesOfASingleVehicle(selectedVehicle); schedulesOfAVehicleGridView.Show(); } else { MessageBox.Show("No Schedule is Booked :)"); } } catch (Exception exceptionObj) { MessageBox.Show("Exception occured in UI! "+exceptionObj.Message); } }
public bool SaveSchedule(VehicleInformation vehicle, DateTime selectedDate, string shift, string bookedBy, string address) { try { SqlConnectionObj.Open(); string query = string.Format("INSERT INTO ScheduleVehicle VALUES('{0}',{1},'{2}','{3}','{4}')", vehicle.RegNo, selectedDate, shift, bookedBy, address); SqlCommandObj.CommandText = query; SqlCommandObj.ExecuteNonQuery(); return true; } catch (Exception exceptionObj) { throw new Exception("Schedule can not be saved!",exceptionObj); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return false; }