public bool IsScheduleBooked(VehicleInformation vehicle, DateTime selectedDate, string shift)
{
VehicleSchedule vehicleSchedule = new VehicleSchedule();
vehicleSchedule = _vehicleScheduleGateway.IsScheduleBooked(vehicle, selectedDate, shift);
if(vehicleSchedule!=null)
{
message = string.Format("This schedule is already booked by : {0}", vehicleSchedule.BookedBy);
return true;
}
message = string.Format("New Schedule is saved!");
return false;
}
public VehicleSchedule 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())
{
VehicleSchedule vehicleSchedule = new VehicleSchedule();
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;
}