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();
}
}
}