public void PopulateID(string ID, string Category, string Status)
{
MainStatus = Status;
TBikeDAL MyDAL = new TBikeDAL();
if (Status == "Modification")
{
BTNPro.Content = "Update";
BtnDelete.Visibility = Visibility.Visible;
if (Category == "Bicycle")
{
LBTitle.Text = "Bicycle";
DataTable ResultTable = MyDAL.SelectBicycleByID(ID);
if (ResultTable.Rows.Count != 0)
{
if (RankID > 3)
{
CBStatus.Visibility = Visibility.Visible;
LBStatus.Visibility = Visibility.Visible;
}
LBID.Text = ID;
TBName.Text = Convert.ToString(ResultTable.Rows[0]["BicycleName"]).Trim();
TBType.Text = Convert.ToString(ResultTable.Rows[0]["BicycleType"]).Trim();
TBPrice.Text = Convert.ToString(ResultTable.Rows[0]["Price"]).Trim();
TBColor.Text = Convert.ToString(ResultTable.Rows[0]["Color"]).Trim();
string BikeStatus = Convert.ToString(ResultTable.Rows[0]["BicycleStatus"]).Trim();
TBQuantity.Text = Convert.ToString(ResultTable.Rows[0]["Quantity"]).Trim();
if (BikeStatus == "A")
{
CBStatus.SelectedIndex = 0;
ItemStatus = "A";
}
else if (BikeStatus == "E")
{
CBStatus.SelectedIndex = 1;
ItemStatus = "E";
}
else if (BikeStatus == "N")
{
CBStatus.SelectedIndex = 2;
ItemStatus = "N";
}
else if (BikeStatus == "S")
{
CBStatus.SelectedIndex = 3;
ItemStatus = "S";
}
else if (BikeStatus == "R")
{
CBStatus.SelectedIndex = 4;
ItemStatus = "R";
}
else if (BikeStatus == "I")
{
CBStatus.SelectedIndex = 5;
ItemStatus = "I";
}
else if (BikeStatus == "M")
{
CBStatus.SelectedIndex = 6;
ItemStatus = "M";
}
PopulateBikeDataTable();
}
else
{
PopWindow pop = new PopWindow(ImageType.Information, "Error", "No data Found!!!", "OK");
pop.ShowDialog();
}
}
else if (Category == "Snacks")
{
if (RankID > 3)
{
CBSnackStatus.Visibility = Visibility.Visible;
LBStatus.Visibility = Visibility.Visible;
}
LBTitle.Text = "Snacks";
LBColor.Text = "Quantity";
DataTable ResultTable = MyDAL.SelectSnackByID(ID);
if (ResultTable.Rows.Count != 0)
{
LBID.Text = ID;
}
TBName.Text = Convert.ToString(ResultTable.Rows[0]["SnackName"]).Trim();
TBType.Text = Convert.ToString(ResultTable.Rows[0]["SnackType"]).Trim();
TBPrice.Text = Convert.ToString(ResultTable.Rows[0]["Price"]).Trim();
TBColor.Text = Convert.ToString(ResultTable.Rows[0]["Quantity"]).Trim();
CBSnackStatus.SelectedIndex = ComboIndex;
PopulateSnackDataTable();
}
else
{
PopWindow pop = new PopWindow(ImageType.Information, "Error", "Incorrect Category", "OK");
pop.ShowDialog();
}
}
else if (Status == "Add")
{
LBTitle.Text = Category;
LBID.Text = "** New **";
BTNPro.Content = "Add";
BtnDelete.Visibility = Visibility.Hidden;
if (Category == "Snacks")
{
LBColor.Text = "Quantity";
PopulateSnackDataTable();
}
else if (Category == "Bicycle")
{
PopulateBikeDataTable();
}
}
}
