private void BTNUpdate_Click(object sender, RoutedEventArgs e)
{
try
{
TBikeDAL MyDAL = new TBikeDAL();
username = LBUsername.Text;
ConfirmWindow com = new ConfirmWindow(ImageType.Error, "Update", "Are you sure to modify these changes?", "Yes", "No");
com.ShowDialog();
if (com.Confirmed)
{
MyDAL.UpdateEmployee(LBEmployeeID.Text, LBEmployeeName.Text, Convert.ToDateTime(LBDob.Text), LBUsername.Text, LBEmployeeRankDesc.Text, LBEmail.Text, LBPhoneNo.Text, LBCity.Text, TLUsername.Text);
DataTable ResultTable = MyDAL.SelectEmployeeByEmployeeID(LBEmployeeID.Text);
LBEmployeeName.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeName"]).Trim();
LBEmployeeRankDesc.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeRankDesc"]).Trim();
LBUsername.Text = Convert.ToString(ResultTable.Rows[0]["Username"]).Trim();
LBEmail.Text = Convert.ToString(ResultTable.Rows[0]["Email"]).Trim();
LBDob.Text = Convert.ToString(ResultTable.Rows[0]["DateOfBirth"]).Trim();
LBPhoneNo.Text = Convert.ToString(ResultTable.Rows[0]["PhoneNo"]).Trim();
LBCity.Text = Convert.ToString(ResultTable.Rows[0]["Address"]).Trim();
LBLastLogin.Text = Convert.ToString(ResultTable.Rows[0]["LastLoginTime"]).Trim();
PopulateDataFromLogin(username);
}
}
catch (Exception ex)
{
PopWindow pop = new PopWindow(ImageType.Error, "Error", ex.Message, "OK");
pop.ShowDialog();
}
}
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (CBBicycle.Items.Count == 0)
{
MainWindow main = new MainWindow();
main.Framework.Visibility = Visibility.Collapsed;
}
else
{
if (CBBicycle.SelectedIndex == -1)
{
CBBicycle.SelectedIndex = 0;
}
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.SelectBicycleByID(CBBicycle.SelectedValue.ToString().Trim());
DataTable ResultTable2 = MyDAL.SelectServiceByBike(CBBicycle.SelectedValue.ToString().Trim());
LBBicycleName.Text = Convert.ToString(ResultTable.Rows[0]["BicycleName"]);
LBStatus.Text = Convert.ToString(ResultTable.Rows[0]["BicycleStatus"]);
if (LBStatus.Text == "I")
{
LBStatus.Text = "Invalid";
}
if (LBStatus.Text == "M")
{
LBStatus.Text = "Maintenance";
PickStart.SelectedDate = Convert.ToDateTime(ResultTable2.Rows[0]["ServiceStart"]);
PickEnd.SelectedDate = Convert.ToDateTime(ResultTable2.Rows[0]["ServiceEnd"]);
}
TBCondition.Text = Convert.ToString(ResultTable.Rows[0]["Condition"]);
}
}
private void BTNPromote_Click(object sender, RoutedEventArgs e)
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.SelectEmployeeByEmployeeID(LBEmployeeID.Text);
Rank = Convert.ToInt32(ResultTable.Rows[0]["EmployeeRank"]);
try
{
if (RankID > Rank)
{
ConfirmWindow com = new ConfirmWindow(ImageType.Question, "Confirm?", "Are you sure to Promote " + LBEmployeeName.Text + " ?", "Yes", "No");
com.ShowDialog();
if (com.Confirmed)
{
MyDAL.UpdateEmployeePromotion(LBEmployeeID.Text, Rank + 1, TLUsername.Text);
ResultTable = MyDAL.SelectEmployeeByEmployeeID(LBEmployeeID.Text);
LBEmployeeRankDesc.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeRankDesc"]);
}
}
else
{
ConfirmWindow com = new ConfirmWindow(ImageType.Error, "Error", "Cant Promote Rank Higher than self", "Ok", "Cancel");
com.ShowDialog();
}
}
catch (Exception ex)
{
PopWindow pop = new PopWindow(ImageType.Error, "Error", Convert.ToString(ex).Trim(), "OK");
pop.ShowDialog();
}
}
public void PopulateID(string BicycleID, string Status)
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.SelectServiceByBike(BicycleID);
DataTable ResultBikeTable = MyDAL.SelectBicycleByID(BicycleID);
LBBicycleName.Text = Convert.ToString(ResultBikeTable.Rows[0]["BicycleName"]);
LBStatus.Text = Convert.ToString(ResultBikeTable.Rows[0]["BicycleStatus"]);
BindComboBoxBicycle(CBBicycle);
CBBicycle.SelectedIndex = CBBicycle.Items.Count - 1;
if (LBStatus.Text == "M")
{
LBStatus.Text = "Maintenance";
TBCondition.Text = Convert.ToString(ResultTable.Rows[0]["Remark"]);
PickStart.SelectedDate = Convert.ToDateTime(ResultTable.Rows[0]["ServiceStart"]);
PickEnd.SelectedDate = Convert.ToDateTime(ResultTable.Rows[0]["ServiceEnd"]);
LBDuration.Text = Convert.ToString(PickEnd.SelectedDate.Value - PickStart.SelectedDate.Value) + "Days";
}
else if (LBStatus.Text == "I")
{
LBStatus.Text = "InActive";
TBCondition.Text = Convert.ToString(ResultBikeTable.Rows[0]["Condition"]);
}
}
private void CBBike_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (CBBike.Items.Count == 0)
{
MainWindow main = new MainWindow();
main.Framework.Visibility = Visibility.Collapsed;
}
else
{
if (CBBike.SelectedIndex == -1)
{
CBBike.SelectedIndex = 0;
}
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowBookingTableByBike(CBBike.SelectedValue.ToString().Trim(), "R");
TBIkeUtility.TranslateRecordStatusDescription(new List <string> {
"BookingStatus"
}, ref ResultTable);
LBCustomer.Text = Convert.ToString(ResultTable.Rows[0]["Customer"]);
Customer = LBCustomer.Text;
LBBookingDate.Text = Convert.ToString(ResultTable.Rows[0]["BookingDate"]);
LBBicycle.Text = Convert.ToString(ResultTable.Rows[0]["BicycleName"]);
LBRemarks.Text = Convert.ToString(ResultTable.Rows[0]["Remark"]);
}
}
public void LinkToEmployee()
{
TBikeDAL MyDAL = new TBikeDAL();
int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem);
DataTable ResultTable = MyDAL.ShowAllEmployeeDetails();
if (index == -1)
{
index = 0;
}
else
{
string id = Convert.ToString(ResultTable.Rows[index]["EmployeeID"]);
string self = Convert.ToString(ResultTable.Rows[index]["Username"]);
if (id != null)
{
if (RankID >= 4 || self == username)
{
EmployeeModify emp = new EmployeeModify();
emp.PopulateDataFromLogin(username);
emp.populateEmployee(id);
emp.ShowDialog();
}
else
{
PopWindow pop = new PopWindow(ImageType.Warning, "Error", "Rank too low to access this service", "Alright");
pop.ShowDialog();
}
}
}
}
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 BTNAddon_Click(object sender, RoutedEventArgs e)
{
try
{
if (ListBooking.SelectedIndex >= 0)
{
TBikeDAL MyDAl = new TBikeDAL();
DataTable ResultTable = MyDAl.SelectSnackSalesByBookIDCustomer(TBBookID.Text.Trim(), TBCustomer.Text.Trim());
if (ResultTable.Rows.Count > 0)
{
PopWindow pop = new PopWindow(ImageType.Information, "Addon Details", "Item :" + Convert.ToString(ResultTable.Rows[0]["SnackName"]).Trim() + " , Quantity :" + Convert.ToInt32(ResultTable.Rows[0]["Quantity"]) + " , Total Price :" + Convert.ToDouble(ResultTable.Rows[0]["TotalPrice"]), "OK");
pop.ShowDialog();
}
else
{
PopWindow pop = new PopWindow(ImageType.Warning, "No Detail", "No Data Found for this booking", "OK");
pop.ShowDialog();
}
}
else
{
PopWindow pop = new PopWindow(ImageType.Warning, "No Data..", "Please Select a List", "OK");
pop.ShowDialog();
}
}
catch (Exception ex) {
PopWindow pop = new PopWindow(ImageType.Error, "Error", "Error: " + ex.Message, "OK");
pop.ShowDialog();
}
}
public void LinkToServiceWindow()
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowAllServiceDetails();
int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem);
if (index == -1)
{
index = 0;
}
else
{
string BicycleID = Convert.ToString(ResultTable.Rows[index]["BicycleID"]);
string Status = Convert.ToString(ResultTable.Rows[index]["Status"]);
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();
}
}
}
public void PopulateDataFromLogin(string Values)
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.SelectEmployeeID("", Values);
if (ResultTable.Rows.Count > 0)
{
TLUsername.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeName"]).Trim();
TLRankDesc.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeRankDesc"]).Trim();
username = Convert.ToString(ResultTable.Rows[0]["Username"]).Trim();
RankID = Convert.ToInt32(ResultTable.Rows[0]["EmployeeRank"]);
if (RankID < 2)
{
ExpanderEmployee.AllowDrop = false;
ExpanderEmployee.IsEnabled = false;
ExpanderReports.IsEnabled = false;
ExpanderStore.IsEnabled = false;
}
Framework.Visibility = Visibility.Visible;
FinalizeReports search = new FinalizeReports();
search.RankID = RankID;
search.username = username;
Framework.Content = search.Content;
}
}
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;
}
private void BTNPayment_Click(object sender, RoutedEventArgs e)
{
//monthly earnings
TBikeDAL MyDAL = new TBikeDAL();
RentStack.Visibility = Visibility.Hidden;
MonthStack.Visibility = Visibility.Visible;
DataTable ResultTable = MyDAL.ShowAllBookingTable();
string status;
int i = 0;
double Price = 0;
double Total = 0;
DateTime date;
foreach (DataRow row in ResultTable.Rows)
{
status = Convert.ToString(ResultTable.Rows[i]["BookingStatus"]).Trim();
date = Convert.ToDateTime(ResultTable.Rows[i]["BookingDate"]);
if (date.Month == datebymonth)
{
if (status == "S")
{
Price = Convert.ToDouble(ResultTable.Rows[i]["TotalPrice"]);
Total = Total + Price;
}
}
i++;
}
TBMonthly.Text = "RM " + Total.ToString().Trim();
}
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 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;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
//button for creating new employee
string Address;
TBikeDAL MyDal = new TBikeDAL();
//String Builder
StringBuilder striBuild = new StringBuilder();
striBuild.AppendLine(TBAddress1.Text);
striBuild.AppendLine(TBAddress2.Text);
striBuild.AppendLine(TBAddress3.Text);
striBuild.Append(TBCity.Text);
striBuild.Append(" , " + TBZipCode.Text);
Address = striBuild.ToString().Trim();
MyDal.AddNewEmployeeDetails(TBEmpName.Text, DOBText.SelectedDate.Value.Date, TBEmail.Text, TBPhoneNo.Text, Address, "Tommy");
CreateNewUser emp = new CreateNewUser();
this.Close();
emp.PopulateDataFromLogin(username);
emp.Show();
PopWindow pop = new PopWindow(ImageType.Information, "Congratulations", "Create New User Success!!!", "OK");
}
catch (Exception ex)
{
PopWindow pop = new PopWindow(ImageType.Error, "Error", ex.Message, "OK");
pop.ShowDialog();
}
}
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 CalculateDoneRentedTime()
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowAllBookingTable();
DateTime date = DateTime.Now;
int i = 0;
foreach (DataRow row in ResultTable.Rows)
{
DateTime D = Convert.ToDateTime(ResultTable.Rows[i]["BookingDate"]);
string ID = Convert.ToString(ResultTable.Rows[i]["BookingID"]);
string Status = Convert.ToString(ResultTable.Rows[i]["BookingStatus"]);
string Bike = Convert.ToString(ResultTable.Rows[i]["BicycleID"]);
string Customer = Convert.ToString(ResultTable.Rows[i]["Customer"]);
if (date.Date > D.Date && Status == "A")
{
MyDAL.UpdateBookingDate(D, "E", ID);
MyDAL.UpdateBikeStatus(Bike, "", "A", "", null, null, TLUsername.Text);
}
else if (date.Date > D && Status == "R")
{
MyDAL.UpdateBookingDate(D, "N", ID);
MyDAL.UpdateBikeStatus(Bike, Customer, "N", "", null, null, TLUsername.Text);
}
i = i + 1;
}
}
public void Notification()
{
TBikeDAL MyDAL = new TBikeDAL();
MyDAL.bindListBoxCustomer(LBRent);
button.Content = "Current Bookings" + " (" + LBRent.Items.Count.ToString() + ")";
}
private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataRowView dataRow = (DataRowView)dataGrid1.SelectedItem;
int index = dataGrid1.Items.IndexOf(dataGrid1.CurrentItem);
//string cellValue = dataRow.Row.ItemArray[index].ToString();
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowAllEmployeeDetails();
id = Convert.ToString(ResultTable.Rows[index]["EmployeeID"]);
self = Convert.ToString(ResultTable.Rows[index]["username"]);
int Rank = Convert.ToInt32(ResultTable.Rows[index]["EmployeeRank"]);
if (RankID >= 4 || self == username)
{
if (self == username || RankID > Rank)
{
BTNPromote.Visibility = Visibility.Visible;
}
else
{
BTNPromote.Visibility = Visibility.Hidden;
}
}
else
{
BTNPromote.Visibility = Visibility.Hidden;
}
}
private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
if (LBTitle.Text == "Bicycle")
{
TBikeDAL MyDAL = new TBikeDAL();
ConfirmWindow confirm = new ConfirmWindow(ImageType.Question, "Delete?", "Are you sure to delete this bicycle?", "Yes", "No! Turn Back!");
if (confirm.Confirmed)
{
MyDAL.DeleteBicycleByID(LBID.Text);
PopulateBikeDataTable();
PopWindow pop = new PopWindow(ImageType.Information, "Bicycle Deleted", "Bicycle: " + LBName.Text + " Has been Deleted By " + TLUsername.Text, "Okay");
pop.ShowDialog();
}
}
else if (LBTitle.Text == "Snacks")
{
TBikeDAL MyDAL = new TBikeDAL();
ConfirmWindow confirm = new ConfirmWindow(ImageType.Question, "Delete?", "Are you sure to delete this Snack?", "Yes", "No! Turn Back!");
if (confirm.Confirmed)
{
MyDAL.DeleteSnackByID(LBID.Text);
PopulateBikeDataTable();
PopWindow pop = new PopWindow(ImageType.Information, "Snack Deleted", "Snack: " + LBName.Text + " Has been Deleted By " + TLUsername.Text, "Okay");
pop.ShowDialog();
}
}
}
private async void BTNPromote_Click(object sender, RoutedEventArgs e)
{
if (id != null)
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.SelectEmployeeByEmployeeID(id);
int Rank = Convert.ToInt32(ResultTable.Rows[0]["EmployeeRank"]);
if (RankID >= 4 || self == username)
{
if (self == username || RankID > Rank)
if (id != null)
{
EmployeeModify mod = new EmployeeModify();
mod.populateEmployee(id);
mod.PopulateDataFromLogin(username);
mod.Show();
this.Close();
}
}
}
else
{
var res = await this.ShowMessageAsync("Error", "Please Select Employee");
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
if (LBStatus.Text == "Invalid")
{
//send to repair button
string repairCondition = ("Servicing, Reason: " + TBCondition.Text);
TBikeDAL MyDAL = new TBikeDAL();
ConfirmWindow confirm = new ConfirmWindow(ImageType.Question, "Confirmation", "Are you sure to send this to Service? ", "Yes", "No");
confirm.ShowDialog();
if (confirm.Confirmed)
{
MyDAL.UpdateBikeStatus(CBBicycle.SelectedValue.ToString().Trim(), "", "M", repairCondition.Trim(), PickStart.SelectedDate, PickEnd.SelectedDate, TLUsername.Text);
PopWindow pop = new PopWindow(ImageType.Information, "Done", "Bicycle Send for Service", "OK");
pop.ShowDialog();
}
BindComboBoxBicycle(CBBicycle);
}
}
catch (Exception ex)
{
PopWindow pop = new PopWindow(ImageType.Error, "Error", ex.Message, "OK");
pop.ShowDialog();
}
}
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;
}
private void BTNTotalRent_Click(object sender, RoutedEventArgs e)
{
//Monthly Rents
TBikeDAL MyDAL = new TBikeDAL();
MonthStack.Visibility = Visibility.Hidden;
RentStack.Visibility = Visibility.Visible;
DataTable ResultTable = MyDAL.ShowAllBookingTable();
int i = 0;
int count = 0;
foreach (DataRow row in ResultTable.Rows)
{
DateTime date = Convert.ToDateTime(ResultTable.Rows[i]["BookingDate"]);
if (date.Month == datebymonth)
{
count++;
}
if (ResultTable.Rows.Count <= i)
{
break;
}
i++;
}
TBMonthlyRents.Text = Convert.ToString(count);
}
public void EmployeeMode()
{
TBikeDAL MyDAL = new TBikeDAL();
DetermineItemStatus();
DataTable ResultTable = MyDAL.SelectAllEmployeeByDynamic(TBID.Text, TBName.Text, TBRankDesc.Text, TBAddress.Text, TBEmail.Text, TBCreatedBy.Text);
Column1.Header = "Employee ID";
Column1.Binding = new Binding("EmployeeID");
Column2.Header = "Employee Name";
Column2.Binding = new Binding("EmployeeName");
Column3.Header = "Username";
Column3.Binding = new Binding("Username");
Column4.Header = "Rank Description";
Column4.Binding = new Binding("EmployeeRankDesc");
Column5.Header = "Email Address";
Column5.Binding = new Binding("Email");
Column6.Header = "Date Of Birth";
Column6.Binding = new Binding("DateOfBirth");
Column7.Header = "Home Address";
Column7.Binding = new Binding("[Address]");
Column8.Header = "Last Login-Time";
Column8.Binding = new Binding("LastLoginTime");
Column9.Header = "";
Column10.Header = "";
dataGrid1.ItemsSource = ResultTable.DefaultView;
dataGrid1.AutoGenerateColumns = false;
}
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 FinalizeReports()
{
InitializeComponent();
TBikeDAL MyDAL = new TBikeDAL();
MyDAL.BindAllBikeComboBox(TBBicycle);
MyDAL.BindAllBikeComboBox(TBBikeName);
MyDAL.BindAllBikeComboBox(TBBikeName2);
}
public rental()
{
InitializeComponent();
BindComboBoxBicycle(CBBicycle);
BindComboBox(CBBike);
TBikeDAL MyDAL = new TBikeDAL();
MyDAL.BindSnackCombo(CBSnack);
}
private void CBRankDesc_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
TBikeDAL MyDAL = new TBikeDAL();
DataTable ResultTable = MyDAL.ShowEmployeeRankByID(CBRankDesc.SelectedValue.ToString().Trim());
TBRankNo.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeRank"]);
TBRankDescModify.Text = Convert.ToString(ResultTable.Rows[0]["EmployeeRankDesc"]);
}
