public BusDetailOfOwner(BusDTO dto, List <BusDTO> _listBus, string _ownerName)
{
InitializeComponent();
this.dto = dto;
this._listBus = _listBus;
this._ownerName = _ownerName;
}
/// <summary>
/// The Update.
/// </summary>
/// <param name="busId">The busId<see cref="int"/>.</param>
/// <param name="busDTO">The busDTO<see cref="BusDTO"/>.</param>
/// <returns>The <see cref="OperationResult"/>.</returns>
public OperationResult Update(int busId, BusDTO busDTO)
{
OperationResult result = new OperationResult();
try
{
Bus busInDB = UnitOfWork.Buses.Get(busId);
if (busInDB != null)
{
Mapper.Map <BusDTO, Bus>(busDTO, busInDB);
UnitOfWork.Complete();
result.SetSuccessResult();
}
else
{
//TODO move to resource file.
result.SetFailureResult("No bus with this id");
}
}
catch (Exception e)
{
result.SetExceptionResult(e.StackTrace);
}
return(result);
}
private void btnDelete_Click(object sender, EventArgs e)
{
string id = lbId.Text;
try
{
BusBLL bll = new BusBLL();
bll.DeleteBus(id);
BusDTO busflag = null;
foreach (var bus in _listBus)
{
if (bus.Id.Equals(id))
{
busflag = bus;
}
}
_listBus.Remove((BusDTO)listBus.SelectedItem);
loadListBus();
if (_listBus.Count != 0)
{
listBus.SelectedIndex = 0;
dto = _listBus[0];
FillBusDetail();
}
else
{
MessageBox.Show("Delete successful");
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public BusDTO Read(int busID)
{
BusDTO bus = new BusDTO();
using var connection = Connection.GetConnection();
{
using var command = connection.CreateCommand();
command.CommandText = "SELECT Bus.BusID, Bus.PeriodicCleaning, Bus.PeriodicMaintenance, Bus.SmallCleaning, Bus.SmallMaintenance, Bus.BusNumber, Bus.BatteryLevel, Bus.Status, ParkingSpace.ParkingSpaceID FROM Bus INNER JOIN ParkingSpace ON Bus.BusID = ParkingSpace.BusID AND Bus.BusID = @busID;";
command.Parameters.AddWithValue("@busID", busID);
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
bus = new BusDTO(
reader.GetInt32("BusID"),
reader.GetDateTime("PeriodicCleaning"),
reader.GetDateTime("SmallCleaning"),
reader.GetDateTime("PeriodicMaintenance"),
reader.GetDateTime("SmallMaintenance"),
reader.GetInt32("BusNumber"),
reader.GetInt32("BatteryLevel"),
reader.GetInt32("Status"),
reader.GetInt32("ParkingSpaceID")
);
}
}
connection.Close();
return(bus);
}
}
public Bus()
{
InitializeComponent();
DTO = new BusDTO();
sqlCon = new SqlConnection("Data Source=DESKTOP-63Q74F5;Initial Catalog=Project;Integrated Security=True");
cmd = new SqlCommand();
}
public bool Update(BusDTO bus)
{
using var connection = Connection.GetConnection();
{
try
{
using var command = connection.CreateCommand();
command.CommandText = "UPDATE Bus Set PeriodicCleaning = @periodicCleaning, SmallCleaning = @smallCleaning, PeriodicMaintenance = @periodicMaintenance, SmallMaintenance = @smallMaintenance, BusNumber = @busNumber, BatteryLevel = @batteryLevel, Status = @status WHERE BusID = @busID;";
command.Parameters.AddWithValue("@busID", bus.BusID);
command.Parameters.AddWithValue("@periodicCleaning", bus.PeriodicCleaning);
command.Parameters.AddWithValue("@smallCleaning", bus.SmallCleaning);
command.Parameters.AddWithValue("@periodicMaintenance", bus.PeriodicMaintenance);
command.Parameters.AddWithValue("@smallMaintenance", bus.SmallMaintenance);
command.Parameters.AddWithValue("@busNumber", bus.BusNumber);
command.Parameters.AddWithValue("@batteryLevel", bus.BatteryLevel);
command.Parameters.AddWithValue("@status", bus.Status);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
return(true);
}
catch { connection.Close(); return(false); }
}
}
public List <BusDTO> GetListBusOfOwner(string id)
{
string query = string.Format("select * from Bus , Owner Where bus.OwnerId = Owner.Id and Owner.Id = @id");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
{
Value = id
};
DataTable dt = conn.ExecuteSelectQuery(query, sqlParameters);
List <BusDTO> list = new List <BusDTO>();
foreach (DataRow r in dt.Rows)
{
BusDTO bus = new BusDTO();
bus.Id = r["BusID"].ToString();
bus.BSX = r["BSX"].ToString();
bus.Brand = r["Brand"].ToString();
bus.DateRegistration = DateTime.Parse(r["DateRegistration"].ToString());
bus.OwnerID = r["OwnerId"].ToString();
bus.RouteID = r["IDTuyenDuong"].ToString();
list.Add(bus);
}
return(list);
}
/// <summary>
/// Khi click vao Create Schedule
/// </summary>
/// <param name="dto"></param>
/// <param name="oDto"></param>
public ScheduleDetailOfBus(BusDTO dto, RouteDTO rDto)
{
InitializeComponent();
main_bus_dto = dto;
main_route_dto = rDto;
main_staff_bll = new StaffBLL();
bus_bll = new BusBLL();
staff_form = null;
}
private void listBus_Click(object sender, EventArgs e)
{
foreach (var bus in _listBus)
{
if (bus.Id.Equals(listBus.SelectedValue))
{
dto = bus;
}
}
FillBusDetail();
}
/// <summary>
/// Khi cell click dgvSchdule (Ben BusView)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public ScheduleDetailOfBus(BusDTO dto, RouteDTO rDto, BusStationGridView bDto, StaffDTO casher, StaffDTO driver)
{
InitializeComponent();
main_bus_dto = dto;
main_route_dto = rDto;
main_schedule_dto = bDto;
main_driver_dto = driver;
main_casher_dto = casher;
main_staff_bll = new StaffBLL();
bus_bll = new BusBLL();
staff_form = null;
}
/// <summary>
/// Update main_busDto form textfield
/// </summary>
private void UpdateMainBusDto()
{
main_busDto = new BusDTO()
{
Id = txtId.Text,
BSX = txtBSX.Text,
Brand = txtBrand.Text,
DateRegistration = dtpDateRegistration.Value,
OwnerID = cbbOwner.SelectedValue.ToString(),
RouteID = cbbRouteID.Text
};
}
public Bus Read(int busID)
{
BusDTO busDTO = busHandler.Read(busID);
if (busDTO.BusID == 0)
{
return(null);
}
Bus bus = new Bus(busDTO.BusID, busDTO.PeriodicCleaning, busDTO.SmallCleaning, busDTO.PeriodicMaintenance, busDTO.SmallMaintenance, busDTO.BusNumber, busDTO.BatteryLevel, (BusStatusEnum)busDTO.Status, busDTO.ParkingSpace);
return(bus);
}
public void UpdateBus(string id, string bsx, string brand, DateTime dateRegistration, string ownerId, string routeId)
{
try
{
BusDTO dto = new BusDTO {
Id = id, Brand = brand, BSX = bsx, DateRegistration = dateRegistration, OwnerID = ownerId, RouteID = routeId
};
dao.Update(dto);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult Create(BusDTO busDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var bus = Mapper.Map <BusDTO, Bus>(busDTO);
_UnityOfWork.Buses.Add(bus);
_UnityOfWork.SaveChanges();
busDTO.BusId = bus.BusId;
return(Created(new Uri(Request.RequestUri + "/" + bus.BusId), busDTO));
}
/// <summary>
/// Will get bus with given id.
/// </summary>
/// <param name="busId">The busId<see cref="int"/>.</param>
/// <returns>The <see cref="OperationResult{BusDTO}"/>.</returns>
public OperationResult <BusDTO> Get(int busId)
{
OperationResult <BusDTO> result = new OperationResult <BusDTO>();
try
{
Bus busInDB = UnitOfWork.Buses.Get(busId);
BusDTO bus = Mapper.Map <Bus, BusDTO>(busInDB);
result.SetSuccessResult(bus);
}
catch (Exception e)
{
result.SetExceptionResult(e.StackTrace);
}
return(result);
}
/// <summary>
/// Will add new bus.
/// </summary>
/// <param name="busDTO">Bus detail as <see cref="BusDTO"/>.</param>
/// <returns>Status as <see cref="OperationResult"/>.</returns>
public OperationResult Add(BusDTO busDTO)
{
// TODO: Fluent Validations
OperationResult result = new OperationResult();
try
{
Bus bus = Mapper.Map <BusDTO, Bus>(busDTO);
UnitOfWork.Buses.Add(bus);
UnitOfWork.Complete();
result.SetSuccessResult();
}
catch (Exception e)
{
result.SetExceptionResult(e.StackTrace);
}
return(result);
}
public IHttpActionResult Update(int id, BusDTO BusDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var busInPersistence = _UnityOfWork.Buses.Get(id);
if (busInPersistence == null)
{
return(NotFound());
}
Mapper.Map <BusDTO, Bus>(BusDTO, busInPersistence);
_UnityOfWork.SaveChanges();
return(Ok(BusDTO));
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
main_busDto = bll.GetBusById(txtSearch.Text);
if (main_busDto != null)
{
dgvBus.DataSource = null;
List <BusDTO> listBus = new List <BusDTO>();
listBus.Add(main_busDto);
dgvBus.DataSource = listBus;
}
else
{
throw new Exception("Bus does not existed");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (KiemTraDuLieu())
{
string id = lbId.Text;
string bsx = txtBSX.Text;
string brand = txtBrand.Text;
DateTime dateRegistration = dtpDateRegistration.Value; // DateTime.Parse(dtpDateRegistration.Value.ToShortDateString());
string ownerId = dto.OwnerID;
string routeId = cbbRouteID.Text;
dto = new BusDTO()
{
Id = id, Brand = brand, BSX = bsx, DateRegistration = dateRegistration, OwnerID = ownerId, RouteID = routeId
};
BusBLL bll = new BusBLL();
try
{
bll.UpdateBus(id, bsx, brand, dateRegistration, ownerId, routeId);
BusDTO busflag = null;
foreach (var bus in _listBus)
{
if (bus.Id.Equals(id))
{
busflag = bus;
}
}
_listBus.Remove(busflag);
busflag = dto;
_listBus.Add(busflag);
loadListBus();
FillBusDetail();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtId.ReadOnly)
{
try
{
if (MessageBox.Show("Delete Bus will delete all Schedule of Bus? (Y/N)", "Thông báo", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
bll.DeleteBus(txtId.Text);
main_busDto = null;
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Please choose bus before Delete");
}
}
/// <summary>
/// Initialise une nouvelle instance de Bus
/// </summary>
public Bus()
{
Data = new BusDTO();
}
/// <summary>
/// Initialise une nouvelle instance de Bus à partir d'un DTO existant.
/// </summary>
/// <param name="dto">Un dto.</param>
public Bus(BusDTO dto)
{
Data = dto;
}
