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