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"]); }