private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataRowView dataRow = (DataRowView)dataGrid1.SelectedItem;
int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem);
if (index >= 0)
{
TBikeDAL MyDAL = new TBikeDAL();
if (LBTitle.Text == "Bicycle")
{
DataTable ResultTable = MyDAL.ShowAllBikeTable();
string BicycleID = Convert.ToString(ResultTable.Rows[index]["BicycleID"]);
if (BicycleID != null)
{
PopulateID(BicycleID, LBTitle.Text, "Modification");
}
}
else if (LBTitle.Text == "Snacks")
{
DataTable ResultTable = MyDAL.ShowAllSnackTable();
string SnackID = Convert.ToString(ResultTable.Rows[index]["SnackID"]);
if (SnackID != null)
{
PopulateID(SnackID, LBTitle.Text, "Modification");
}
}
}
}
public void PopulateSnackDataTable()
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowAllSnackTable();
Column1.Header = "Snack ID";
Column1.Binding = new Binding("SnackID");
Column2.Header = "Snack Name";
Column2.Binding = new Binding("SnackName");
Column3.Header = "Snack Type";
Column3.Binding = new Binding("SnackType");
Column4.Header = "Snack Status";
Column4.Binding = new Binding("SnackStatusInFull");
Column5.Header = "Quantity";
Column5.Binding = new Binding("Quantity");
Column6.Header = "Price";
Column6.Binding = new Binding("Price");
Column7.Header = "CreatedBy";
Column7.Binding = new Binding("CreatedBy");
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"SnackStatus"
}, ref ResultTable);
dataGrid1.ItemsSource = ResultTable.DefaultView;
dataGrid1.AutoGenerateColumns = false;
dataGrid1.CanUserAddRows = false;
}
public void PopulateSnackGrd()
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowAllSnackTable();
SdColumn1.Header = "Snack ID";
SdColumn1.Binding = new Binding("SnackID");
SdColumn2.Header = "Snack Name";
SdColumn2.Binding = new Binding("SnackName");
SdColumn3.Header = "Type";
SdColumn3.Binding = new Binding("SnackType");
SdColumn4.Header = "Status";
SdColumn4.Binding = new Binding("SnackStatusInFull");
SdColumn5.Header = "Quantity";
SdColumn5.Binding = new Binding("Quantity");
SdColumn6.Header = "Price";
SdColumn6.Binding = new Binding("Price");
SdColumn7.Header = "Created By";
SdColumn7.Binding = new Binding("CreatedBy");
SdColumn8.Header = "Created At";
SdColumn8.Binding = new Binding("CreatedAt");
SdColumn9.Header = "Last Updated By";
SdColumn9.Binding = new Binding("LastUpdatedBy");
SdColumn10.Header = "Last Updated At";
SdColumn10.Binding = new Binding("LastUpdatedAt");
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"SnackStatus"
}, ref ResultTable);
SnackGrd.ItemsSource = ResultTable.DefaultView;
SnackGrd.AutoGenerateColumns = false;
}
public void LinkToSnackWindow()
{
TBikeDAL MyDAL = new TBikeDAL();
int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem);
DataTable ResultTable = MyDAL.ShowAllSnackTable();
if (index == -1)
{
index = 0;
}
else
{
string SnackID = Convert.ToString(ResultTable.Rows[index]["SnackID"]);
string Status = Convert.ToString(ResultTable.Rows[index]["SnackStatus"]);
InventoryModi modi = new InventoryModi();
modi.PopulateDataFromLogin(username);
modi.PopulateID(SnackID, "Snacks", "Modification");
modi.ShowDialog();
}
}
private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataRowView dataRow = (DataRowView)dataGrid1.SelectedItem;
int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem);
if (index == -1)
{
index = 0;
Category = "";
}
TBikeDAL MyDAL = new TBikeDAL();
if (Category == "Bicycle")
{
DataTable ResultTable = MyDAL.ShowAllBikeTable();
string BicycleID = Convert.ToString(ResultTable.Rows[index]["BicycleID"]);
if (BicycleID != null)
{
InventoryModi mod = new InventoryModi();
mod.Show();
mod.PopulateDataFromLogin(username);
mod.PopulateID(BicycleID, Category, "Modification");
this.Close();
}
}
else if (Category == "Snacks")
{
DataTable ResultTable = MyDAL.ShowAllSnackTable();
string SnackID = Convert.ToString(ResultTable.Rows[index]["SnackID"]);
if (SnackID != null)
{
InventoryModi mod = new InventoryModi();
mod.Show();
mod.PopulateDataFromLogin(username);
mod.PopulateID(SnackID, Category, "Modification");
this.Close();
}
}
}
private void SnackGrd_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
TBikeDAL MyDAL = new TBikeDAL();
int index = SnackGrd.Items.IndexOf(SnackGrd.CurrentItem);
DataTable SnackTable = MyDAL.ShowAllSnackTable();
if (index == -1)
{
index = 0;
}
else
{
string SnackID = Convert.ToString(SnackTable.Rows[index]["SnackID"]).Trim();
DataTable ResultTable = MyDAL.SelectSnackSalesBySnackID(SnackID);
TBSnackID.Text = "Sales Details for: " + Convert.ToString(SnackTable.Rows[index]["SnackName"]).Trim();
SColumn1.Header = "Sales ID";
SColumn1.Binding = new Binding("SalesID");
SColumn2.Header = "Booking ID";
SColumn2.Binding = new Binding("BookingID");
SColumn3.Header = "Snack ID";
SColumn3.Binding = new Binding("SnackID");
SColumn4.Header = "Quantity";
SColumn4.Binding = new Binding("Quantity");
SColumn5.Header = "Customer";
SColumn5.Binding = new Binding("Customer");
SColumn6.Header = "Total Price";
SColumn6.Binding = new Binding("TotalPrice");
SColumn7.Header = "Created By";
SColumn7.Binding = new Binding("CreatedBy");
SColumn8.Header = "Created At";
SColumn8.Binding = new Binding("CreatedAt");
detailSnackGrd.ItemsSource = ResultTable.DefaultView;
detailSnackGrd.AutoGenerateColumns = false;
}
}