private void btnUpdate_Click(object sender, EventArgs e)
{
if (main_schedule_dto != null)
{
if (KiemTraDuLieu())
{
int id = int.Parse(dgvSchedule.Rows[dgvSchedule.CurrentRow.Index].Cells["ID"].Value.ToString());
string busId = main_bus_dto.Id;
string driver = listDriver.SelectedValue.ToString();
string casher = listCasher.SelectedValue.ToString();
string departure_time = dtpDepatureTime.Value.ToString();
string back_time = dtpTimeBack.Value.ToString();
try
{
if (checkDateAccess())
{
main_schedule_dto = new BusStationGridView()
{
ID = id, BusID = busId, DepartureTime = departure_time, TimeBack = back_time, MSNVCAST = casher, MSNVDRIVER = driver
};
bus_bll.UpdateBusStation(main_schedule_dto);
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("Please choose scheduling before Update");
}
}
public List <BusStationGridView> SearchScheduleOfBusByBusId(string busId)
{
string query = "Select * from BusStation Where BusId = @id";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
{
Value = busId.ToString()
};
try
{
DataTable dt = conn.ExecuteSelectQuery(query, sqlParameters);
List <BusStationGridView> list = new List <BusStationGridView>();
foreach (DataRow r in dt.Rows)
{
BusStationGridView dto = GetBusStationDTOFromDataRow(r);
list.Add(dto);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (KiemTraDuLieu())
{
string busId = main_bus_dto.Id;
string driver = listDriver.SelectedValue.ToString();
string casher = listCasher.SelectedValue.ToString();
string departure_time = dtpDepatureTime.Value.ToString();
string back_time = dtpTimeBack.Value.ToString();
string status = "1";
try
{
if (checkDateAccess())
{
main_schedule_dto = new BusStationGridView()
{
BusID = busId, DepartureTime = departure_time, TimeBack = back_time, MSNVCAST = casher, MSNVDRIVER = driver, Status = status
};
bus_bll.AddBusStation(main_schedule_dto);
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void dgvSchedule_CellClick(object sender, DataGridViewCellEventArgs e)
{
int index = dgvSchedule.CurrentRow.Index;
dtpDepatureTime.Value = DateTime.Parse(dgvSchedule.Rows[index].Cells["DepartureTime"].Value.ToString());
dtpTimeBack.Value = DateTime.Parse(dgvSchedule.Rows[index].Cells["TimeBack"].Value.ToString());
main_schedule_dto = bus_bll.GetDetailOfScheduleById(int.Parse(dgvSchedule.Rows[index].Cells["Id"].Value.ToString()));
listDriver.SelectedValue = main_schedule_dto.MSNVDRIVER;
listCasher.SelectedValue = main_schedule_dto.MSNVCAST;
}
public void UpdateBusStation(BusStationGridView dto)
{
try
{
dao.UpdateBusStation(dto);
}
catch (Exception ex)
{
throw ex;
}
}
/// <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;
}
private BusStationGridView GetBusStationDTOFromDataRow(DataRow row)
{
BusStationGridView dto = new BusStationGridView();
dto.ID = int.Parse(row["ID"].ToString());
dto.BusID = row["BusID"].ToString();
dto.MSNVDRIVER = row["MSNVDRIVER"].ToString();
dto.MSNVCAST = row["MSNVCAST"].ToString();
dto.DepartureTime = row["DepartureTime"].ToString();
dto.TimeBack = row["TimeBack"].ToString();
dto.Status = row["Status"].ToString();
return(dto);
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (main_schedule_dto != null)
{
bus_bll.DeleteBusStationById(main_schedule_dto.ID);
main_schedule_dto = null;
LoadData();
}
else
{
MessageBox.Show("Please choose schedule before delete!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool UpdateBusStation(BusStationGridView dto)
{
string query = "Update BusStation set BusId = @busId, MSNVDRIVER= @MSNVDRIVER, DepartureTime = @DepartureTime , TimeBack = @TimeBack , MSNVCAST = @MSNVCAST Where id = @id";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.Int)
{
Value = dto.ID
};
sqlParameters[1] = new SqlParameter("@busId", SqlDbType.NVarChar)
{
Value = dto.BusID
};
sqlParameters[2] = new SqlParameter("@MSNVDRIVER", SqlDbType.NVarChar)
{
Value = dto.MSNVDRIVER
};
sqlParameters[3] = new SqlParameter("@DepartureTime", SqlDbType.NVarChar)
{
Value = dto.DepartureTime
};
sqlParameters[4] = new SqlParameter("@TimeBack", SqlDbType.NVarChar)
{
Value = dto.TimeBack
};
sqlParameters[5] = new SqlParameter("@MSNVCAST", SqlDbType.NVarChar)
{
Value = dto.MSNVCAST
};
//sqlParameters[5] = new SqlParameter("@Status", SqlDbType.NVarChar) { Value = dto.Status };
try
{
conn.ExecuteUpdateQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddBusStation(BusStationGridView dto)
{
string query = "Insert into BusStation values(@busId,@MSNVDRIVER,@DepartureTime,@TimeBack,@MSNVCAST,@Status)";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@busId", SqlDbType.NVarChar)
{
Value = dto.BusID
};
sqlParameters[1] = new SqlParameter("@MSNVDRIVER", SqlDbType.NVarChar)
{
Value = dto.MSNVDRIVER
};
sqlParameters[2] = new SqlParameter("@DepartureTime", SqlDbType.NVarChar)
{
Value = dto.DepartureTime
};
sqlParameters[3] = new SqlParameter("@TimeBack", SqlDbType.NVarChar)
{
Value = dto.TimeBack
};
sqlParameters[4] = new SqlParameter("@MSNVCAST", SqlDbType.NVarChar)
{
Value = dto.MSNVCAST
};
sqlParameters[5] = new SqlParameter("@Status", SqlDbType.NVarChar)
{
Value = dto.Status
};
try
{
conn.ExecuteInsertQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public BusStationGridView GetDetailOfScheduleById(int scheduleId)
{
string query = "Select * From BusStation Where Id = @id";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.Int);
sqlParameters[0].Value = scheduleId;
DataTable dt = conn.ExecuteSelectQuery(query, sqlParameters);
if (dt.Rows.Count > 0)
{
BusStationGridView dto = new BusStationGridView();
dto.ID = int.Parse(dt.Rows[0]["ID"].ToString());
dto.BusID = dt.Rows[0]["BusID"].ToString();
dto.MSNVDRIVER = dt.Rows[0]["MSNVDRIVER"].ToString();
dto.MSNVCAST = dt.Rows[0]["MSNVCAST"].ToString();
dto.DepartureTime = dt.Rows[0]["DepartureTime"].ToString();
dto.TimeBack = dt.Rows[0]["TimeBack"].ToString();
dto.Status = dt.Rows[0]["Status"].ToString();
return(dto);
}
return(null);
}
private void dgvSchedule_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (main_busDto == null)
{
MessageBox.Show("Please choose bus before create Schedule");
}
else
{
StaffBLL sBll = new StaffBLL();
int index = dgvSchedule.CurrentRow.Index;
BusStationGridView schedule_dto = bll.GetDetailOfScheduleById(int.Parse(dgvSchedule.Rows[index].Cells["Id"].Value.ToString()));
StaffDTO driver = sBll.SearchStaffById(schedule_dto.MSNVDRIVER);
StaffDTO casher = sBll.SearchStaffById(schedule_dto.MSNVCAST);
ScheduleDetailOfBus form = new ScheduleDetailOfBus(main_busDto, (RouteDTO)cbbRouteID.SelectedItem, schedule_dto, driver, casher);
form.ShowDialog();
main_scheduleDto = bll.SearchScheduleOfBusByBusId(txtId.Text);
foreach (var item in main_scheduleDto)
{
item.DepartureTime = item.DepartureTime.Split(' ')[1] + " " + item.DepartureTime.Split(' ')[2];
item.TimeBack = item.TimeBack.Split(' ')[1] + " " + item.TimeBack.Split(' ')[2];
}
LoadListSchedule();
}
}
