public void TotalBookBike() { TBikeDAL MyDAL = new TBikeDAL(); DataTable ResultTableBike = MyDAL.ShowAllBikeTable(); int i = 0; int TotalCount = 0; string MostBookBike = ""; string BicycleName = ""; foreach (DataRow Row in ResultTableBike.Rows) { string BicycleID = Convert.ToString(ResultTableBike.Rows[i]["BicycleID"]); DataTable ResultTable = MyDAL.SelectBookingByMonthBicycle(BicycleID, datebymonth); int MaxCounter = 0; foreach (DataRow row in ResultTable.Rows) { BicycleName = Convert.ToString(ResultTable.Rows[MaxCounter]["BicycleName"]); MaxCounter++; } if (TotalCount < MaxCounter) { TotalCount = MaxCounter; MostBookBike = BicycleName; } i++; } TBMostBook.Text = MostBookBike; }
public void TotalBikeType() { TBikeDAL MyDAL = new TBikeDAL(); DataTable ResultTableBike = MyDAL.ShowAllBikeTable(); int i = 0; int TotalCount = 0; string MostBookBike = ""; string BicycleName = ""; //get total Booking for a type---- WORKING PROCESS foreach (DataRow Row in ResultTableBike.Rows) { string BicycleType = Convert.ToString(ResultTableBike.Rows[i]["BicycleType"]); DataTable ResultTable = MyDAL.SelectBookingByMonthType(BicycleType, datebymonth); int MaxCounter = 0; foreach (DataRow row in ResultTable.Rows) { BicycleName = Convert.ToString(ResultTable.Rows[MaxCounter]["BicycleType"]); MaxCounter++; } if (TotalCount < MaxCounter) { TotalCount = MaxCounter; MostBookBike = BicycleName; } i++; } TBBookType.Text = MostBookBike; }
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"); } } } }
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 PopulateBicycleData(ComboBox CBBike) { TBikeDAL MyDal = new TBikeDAL(); DataTable ResultTable = MyDal.ShowAllBikeTable(); string BikeID = Convert.ToString(ResultTable.Rows[0]["BicycleID"]).Trim(); string BikeName = Convert.ToString(ResultTable.Rows[0]["BicycleName"]).Trim(); CBBike.DataContext = ResultTable; CBBike.ItemsSource = ResultTable.Rows; CBBike.DisplayMemberPath = BikeName; CBBike.SelectedValuePath = BikeID; }
public void LinkToBicycleWindow() { TBikeDAL MyDAL = new TBikeDAL(); int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem); DataTable ResultTable = MyDAL.ShowAllBikeTable(); if (index == -1) { index = 0; } else { string BicycleID = Convert.ToString(ResultTable.Rows[index]["BicycleID"]); string Status = Convert.ToString(ResultTable.Rows[index]["BicycleStatus"]); if (Status == "M") { Service ret = new Service(); ret.PopulateDataFromLogin(username); ret.PopulateID(BicycleID, Status); ret.ShowDialog(); } else if (Status == "I") { Service ret = new Service(); ret.PopulateDataFromLogin(username); ret.PopulateID(BicycleID, Status); ret.ShowDialog(); } else { InventoryModi mod = new InventoryModi(); mod.PopulateDataFromLogin(username); mod.PopulateID(BicycleID, "Bicycle", "Modification"); mod.ShowDialog(); } } }
public void PopulateBikeDataTable() { TBikeDAL MyDAL = new TBikeDAL(); DataTable ResultTable = MyDAL.ShowAllBikeTable(); 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 = "Quantity"; Column6.Binding = new Binding("Quantity"); Column7.Header = "Total Rents"; Column7.Binding = new Binding("Total Rents"); Column8.Header = "Price"; Column8.Binding = new Binding("Price"); Column9.Header = "Color"; Column9.Binding = new Binding("Color"); Column10.Header = "Condition"; Column10.Binding = new Binding("Condition"); Column11.Header = "Last Date Booked"; Column11.Binding = new Binding("LastUpdatedAt"); Column12.Header = "Created By"; Column12.Binding = new Binding("CreatedBy"); TBIkeUtility.TranslateRecordStatusDescription(new List <string> { "BicycleStatus" }, ref ResultTable); dataGrid1.ItemsSource = ResultTable.DefaultView; dataGrid1.AutoGenerateColumns = false; dataGrid1.CanUserAddRows = false; }
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(); } } }