public void BicycleMode()
{
TBikeDAL MyDAL = new TBikeDAL();
DetermineItemStatus();
DataTable ResultTable = MyDAL.SelectAllBicycleByDynamic(TBBicycleID.Text, TBBikeName2.Text, TBCurrentRenter.Text, TBBikeColor.Text, TBBikeStatus.Text, TBBikeType2.Text);
Column1.Header = "Bicycle ID";
Column1.Binding = new Binding("BicycleID");
Column2.Header = "Bicycle Name";
Column2.Binding = new Binding("BicycleName");
Column3.Header = "Bicycle Type";
Column3.Binding = new Binding("BicycleType");
Column4.Header = "Bicycle Status";
Column4.Binding = new Binding("BicycleStatusInFull");
Column5.Header = "Current Renter";
Column5.Binding = new Binding("CurrentRenter");
Column6.Header = "Color";
Column6.Binding = new Binding("Color");
Column7.Header = "Total Rents";
Column7.Binding = new Binding("TotalRents");
Column8.Header = "Price (RM)";
Column8.Binding = new Binding("Price");
Column9.Header = "Condition";
Column9.Binding = new Binding("Condition");
Column10.Header = "CreatedBy";
Column10.Binding = new Binding("CreatedBy");
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"BicycleStatus"
}, ref ResultTable);
dataGrid1.ItemsSource = ResultTable.DefaultView;
dataGrid1.IsReadOnly = true;
dataGrid1.AutoGenerateColumns = false;
}
public void SnackMode()
{
TBikeDAL MyDAL = new TBikeDAL();
DetermineItemStatus();
DataTable ResultTable = MyDAL.SelectAllSnackByDynamic(TBSnackID.Text, TBSnackName.Text, TBSnackStatus.Text, TBSnackType.Text);
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 = "Snack Quantity";
Column5.Binding = new Binding("Quantity");
Column6.Header = "Snack Price";
Column6.Binding = new Binding("Price");
Column7.Header = "";
Column8.Header = "";
Column9.Header = "";
Column10.Header = "";
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"SnackStatus"
}, ref ResultTable);
dataGrid1.ItemsSource = ResultTable.DefaultView;
dataGrid1.IsReadOnly = true;
dataGrid1.AutoGenerateColumns = false;
}
public void ServiceMode()
{
TBikeDAL MyDAL = new TBikeDAL();
DetermineItemStatus();
DataTable ResultTable = MyDAL.SelAllServiceByDynamic(TBServiceId.Text, TBServiceStatus.Text, TBServiceRemark.Text, TBServiceStatus.Text);
Column1.Header = "Service ID";
Column1.Binding = new Binding("ServiceID");
Column2.Header = "Employee Name";
Column2.Binding = new Binding("BicycleID");
Column3.Header = "Service Start-Time";
Column3.Binding = new Binding("ServiceStart");
Column4.Header = "Service End-Time";
Column4.Binding = new Binding("ServiceEnd");
Column5.Header = "Service Status";
Column5.Binding = new Binding("StatusInFull");
Column6.Header = "Service Remark";
Column6.Binding = new Binding("Remark");
Column7.Header = "";
Column8.Header = "";
Column9.Header = "";
Column10.Header = "";
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"Status"
}, ref ResultTable);
dataGrid1.ItemsSource = ResultTable.DefaultView;
dataGrid1.IsReadOnly = true;
dataGrid1.AutoGenerateColumns = 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;
}
private void detailGrd_Selected(object sender, RoutedEventArgs e)
{
TBikeDAL MyDAL = new TBikeDAL();
int index = BookGrd.Items.IndexOf(BookGrd.CurrentItem);
DataTable BicycleTable = MyDAL.ShowAllBikeTable();
if (index == -1)
{
index = 0;
}
else
{
string BicycleName = Convert.ToString(BicycleTable.Rows[index]["BicycleName"]).Trim();
DataTable ResultTable = MyDAL.SelectAllBookingByDynamic("", BicycleName, "", "", "", "", null);
TBBicycleID.Text = "Booking Details By: " + Convert.ToString(BicycleTable.Rows[index]["BicycleName"]).Trim();
Column1.Header = "Booking ID";
Column1.Binding = new Binding("BookingID");
Column2.Header = "Bicycle";
Column2.Binding = new Binding("BicycleName");
Column3.Header = "Bicycle Type";
Column3.Binding = new Binding("BicycleType");
Column4.Header = "Booking Date";
Column4.Binding = new Binding("BookingDate");
Column5.Header = "Booking Status";
Column5.Binding = new Binding("BookingStatusInFull");
Column6.Header = "Booking Start-Time";
Column6.Binding = new Binding("StartTime");
Column7.Header = "Booking End-Time";
Column7.Binding = new Binding("EndTime");
Column8.Header = "Deposit";
Column8.Binding = new Binding("BookingDeposit");
Column9.Header = "Customer Name";
Column9.Binding = new Binding("Customer");
Column10.Header = "Total Price";
Column10.Binding = new Binding("TotalPrice");
Column11.Header = "Remarks";
Column11.Binding = new Binding("Remark");
Column12.Header = "Created By";
Column12.Binding = new Binding("CreatedBy");
Column13.Header = "Created At";
Column13.Binding = new Binding("CreatedAt");
Column14.Header = "Last Updated By";
Column14.Binding = new Binding("LastUpdatedBy");
Column15.Header = "Last Updated At";
Column15.Binding = new Binding("LastUpdatedAt");
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"BookingStatus"
}, ref ResultTable);
detailGrd.ItemsSource = ResultTable.DefaultView;
detailGrd.AutoGenerateColumns = false;
}
}
public void BookingMode()
{
TBikeDAL MyDAL = new TBikeDAL();
DetermineItemStatus();
DataTable ResultTable = MyDAL.SelectAllBookingByDynamic(TBBookID.Text, TBBikeName.Text, TBBookingStatus.Text, TBCustomer.Text, TBRemarks.Text, TBBikeType.Text, DPBook.SelectedDate);
Column1.Header = "Booking ID";
Column1.Binding = new Binding("BookingID");
Column2.Header = "Bicycle";
Column2.Binding = new Binding("BicycleName");
Column3.Header = "Bicycle Type";
Column3.Binding = new Binding("BicycleType");
Column4.Header = "Booking Date";
Column4.Binding = new Binding("BookingDate");
Column5.Header = "Booking Status";
Column5.Binding = new Binding("BookingStatusInFull");
Column6.Header = "Booking Start-Time";
Column6.Binding = new Binding("StartTime");
Column7.Header = "Booking End-Time";
Column7.Binding = new Binding("EndTime");
Column8.Header = "Deposit";
Column8.Binding = new Binding("BookingDeposit");
Column9.Header = "Customer Name";
Column9.Binding = new Binding("Customer");
Column10.Header = "Total Price";
Column10.Binding = new Binding("TotalPrice");
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"BookingStatus"
}, ref ResultTable);
dataGrid1.ItemsSource = ResultTable.DefaultView;
dataGrid1.AutoGenerateColumns = false;
dataGrid1.CanUserAddRows = false;
dataGrid1.IsReadOnly = true;
}
public void PopulateBookGrd()
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowAllBikeTable();
dColumn1.Header = "Bicycle ID";
dColumn1.Binding = new Binding("BicycleID");
dColumn2.Header = "Bicycle Name";
dColumn2.Binding = new Binding("BicycleName");
dColumn3.Header = "Bicycle Type";
dColumn3.Binding = new Binding("BicycleType");
dColumn4.Header = "Bicycle Status";
dColumn4.Binding = new Binding("BicycleStatusInFull");
dColumn5.Header = "Current Renter";
dColumn5.Binding = new Binding("CurrentRenter");
dColumn6.Header = "Total Rents";
dColumn6.Binding = new Binding("TotalRents");
dColumn7.Header = "Price";
dColumn7.Binding = new Binding("Price");
dColumn8.Header = "Color";
dColumn8.Binding = new Binding("Color");
dColumn9.Header = "Condition";
dColumn9.Binding = new Binding("Condition");
dColumn10.Header = "Created By";
dColumn10.Binding = new Binding("CreatedBy");
dColumn11.Header = "Created At";
dColumn11.Binding = new Binding("Created At");
dColumn12.Header = "Last Updated By";
dColumn12.Binding = new Binding("LastUpdatedBy");
dColumn13.Header = "Last Updated At";
dColumn13.Binding = new Binding("Last Updated At");
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"BicycleStatus"
}, ref ResultTable);
BookGrd.ItemsSource = ResultTable.DefaultView;
BookGrd.AutoGenerateColumns = false;
}