public void LoadUSDDetailsData(int page = 1) { using (var db = new RoomManagerEntities2()) { db.UsedServices.Attach(UsedServices); db.Entry(UsedServices).Collection(s => s.USDDetails).Load(); USDDetailList = UsedServices.USDDetails.ToList(); //Load Datagrid dgUSDDetails.ItemsSource = USDDetailList.Skip((page - 1) * 10).Take(10); tbTotalPageUSDDetails.Text = (USDDetailList.Count() % 10 != 0 ? USDDetailList.Count() / 10 + 1 : USDDetailList.Count() / 10).ToString(); tbxCurrentPageUSDDetails.Text = currentUSDDetailsPage.ToString(); } }
public List <USDDetail> getUSDDetailFromData() { using (var db = new RoomManagerEntities2()) { db.RentRooms.Attach(rentRoom); db.Entry(rentRoom).Collection(s => s.UsedServices).Load(); var us = rentRoom.UsedServices.Where(i => i.status == 0).ToList(); if (us.Count > 0) { return(us[0].USDDetails.ToList()); } return(null); } }
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(); } }