public UsedServicesInfoWindow(int Type, UsedService sv = null, int rentRoomID = -1) { this.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen; InitializeComponent(); this.type = Type; this.rentRoomID = rentRoomID; if (sv != null) { this.UsedServices = sv; } else { this.UsedServices = new UsedService(); } this.DataContext = this.bindingUsedServices; if (type == EDITACTION) { switchToEditAction(); } else if (type == ADDACTION) { switchToAddAction(); } else { switchToInfoAction(); } //this.DialogResult = false; }
public void setDataToForm(UsedService UsedServices) { tbxID.Text = UsedServices.id.ToString(); tbxRentRoomID.Text = UsedServices.rentRoomID.ToString(); tbxStatus.Text = UsedServices.status.ToString(); var dateString = UsedServices.date.ToString(); dpDate.SelectedDate = UsedServices.date; }
public UsedService getDataFromForm() { UsedService result = new UsedService(); //result.id = 0;// int.Parse( tbxID.Text); result.rentRoomID = int.Parse(tbxRentRoomID.Text); result.status = int.Parse(tbxStatus.Text); result.date = dpDate.SelectedDate.Value; return(result); }
private void dgUsedServices_MouseDoubleClick(object sender, MouseButtonEventArgs e) { UsedService sv = dgUsedServices.SelectedItem as UsedService; if (sv != null) { var screen = new UsedServicesInfoWindow(UsedServicesInfoWindow.INFOACTION, sv); this.IsEnabled = false; screen.ShowDialog(); this.IsEnabled = true; } LoadDuLieu(); }
public void switchToInfoAction() { type = INFOACTION; lbTitle.Content = "Info Used Services"; spUsedServicesInfo.Visibility = Visibility.Visible; spUsedServicesAE.Visibility = Visibility.Collapsed; //data if (type == INFOACTION) { UsedServices = getUsedServicesFromData(UsedServices.id); tbID.Text = UsedServices.id.ToString(); tbRentRoomID.Text = UsedServices.rentRoomID.ToString(); tbStatus.Text = UsedServices.status.ToString(); tbDate.Text = UsedServices.date.ToString(); LoadUSDDetailsData(currentUSDDetailsPage); } }
private void btnDeleteUsedServices_Click(object sender, RoutedEventArgs e) { try { using (var db = new RoomManagerEntities2()) { this.IsEnabled = false; var screen = new ConfirmWindow($"Ban Co Chac Muon Xoa Used Services {UsedServices.id}"); screen.ShowDialog(); if (screen.DialogResult == true) { var deleteItem = new UsedService() { id = UsedServices.id }; var deleteDetailItem = new USDDetail() { usID = UsedServices.id }; db.Entry(deleteDetailItem).State = EntityState.Modified; db.USDDetails.Attach(deleteDetailItem); db.USDDetails.Remove(deleteDetailItem); db.SaveChanges(); switchToInfoAction(); //db.UsedServices.Attach(deleteItem); //db.UsedServices.Remove(deleteItem); //db.SaveChanges(); //this.Close(); } this.IsEnabled = true; } } catch (Exception ex) { this.IsEnabled = true; MessageBox.Show("delete failure"); switchToInfoAction(); } }
private void btnImportUsedServices_Click(object sender, RoutedEventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); if (openFileDialog.ShowDialog() == true) { var wookbook = new Workbook(openFileDialog.FileName); var tabs = wookbook.Worksheets; using (var db = new RoomManagerEntities2()) { foreach (var tab in tabs) { try { if (tab.Name == "Services") { var col = 'B'; var row = 2; var cell = tab.Cells[$"{ col}{ row}"]; while (cell.Value != null) { var newUService = new UsedService() { rentRoomID = tab.Cells[$"B{row}"].IntValue, date = tab.Cells[$"C{row}"].DateTimeValue, status = tab.Cells[$"D{row}"].IntValue, }; db.UsedServices.Add(newUService); db.SaveChanges(); row++; cell = tab.Cells[$"{ col}{ row}"]; } LoadServicesData(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } foreach (var tab in tabs) { try { if (tab.Name == "USDDetails") { var col = 'B'; var row = 2; var cell = tab.Cells[$"{ col}{ row}"]; while (cell.Value != null) { var newUSDDetail = new USDDetail() { usID = tab.Cells[$"B{row}"].IntValue, sID = tab.Cells[$"C{row}"].IntValue, times = tab.Cells[$"D{row}"].IntValue, price = tab.Cells[$"E{row}"].DoubleValue, date = tab.Cells[$"F{row}"].DateTimeValue, }; db.USDDetails .Add(newUSDDetail); db.SaveChanges(); row++; cell = tab.Cells[$"{ col}{ row}"]; } LoadServicesData(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } }