private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (CBBicycle.Items.Count == 0)
{
MainWindow main = new MainWindow();
main.Framework.Visibility = Visibility.Collapsed;
}
else
{
if (CBBicycle.SelectedIndex == -1)
{
CBBicycle.SelectedIndex = 0;
}
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.SelectBicycleByID(CBBicycle.SelectedValue.ToString().Trim());
DataTable ResultTable2 = MyDAL.SelectServiceByBike(CBBicycle.SelectedValue.ToString().Trim());
LBBicycleName.Text = Convert.ToString(ResultTable.Rows[0]["BicycleName"]);
LBStatus.Text = Convert.ToString(ResultTable.Rows[0]["BicycleStatus"]);
if (LBStatus.Text == "I")
{
LBStatus.Text = "Invalid";
}
if (LBStatus.Text == "M")
{
LBStatus.Text = "Maintenance";
PickStart.SelectedDate = Convert.ToDateTime(ResultTable2.Rows[0]["ServiceStart"]);
PickEnd.SelectedDate = Convert.ToDateTime(ResultTable2.Rows[0]["ServiceEnd"]);
}
TBCondition.Text = Convert.ToString(ResultTable.Rows[0]["Condition"]);
}
}
public void PopulateID(string BicycleID, string Status)
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.SelectServiceByBike(BicycleID);
DataTable ResultBikeTable = MyDAL.SelectBicycleByID(BicycleID);
LBBicycleName.Text = Convert.ToString(ResultBikeTable.Rows[0]["BicycleName"]);
LBStatus.Text = Convert.ToString(ResultBikeTable.Rows[0]["BicycleStatus"]);
BindComboBoxBicycle(CBBicycle);
CBBicycle.SelectedIndex = CBBicycle.Items.Count - 1;
if (LBStatus.Text == "M")
{
LBStatus.Text = "Maintenance";
TBCondition.Text = Convert.ToString(ResultTable.Rows[0]["Remark"]);
PickStart.SelectedDate = Convert.ToDateTime(ResultTable.Rows[0]["ServiceStart"]);
PickEnd.SelectedDate = Convert.ToDateTime(ResultTable.Rows[0]["ServiceEnd"]);
LBDuration.Text = Convert.ToString(PickEnd.SelectedDate.Value - PickStart.SelectedDate.Value) + "Days";
}
else if (LBStatus.Text == "I")
{
LBStatus.Text = "InActive";
TBCondition.Text = Convert.ToString(ResultBikeTable.Rows[0]["Condition"]);
}
}
