public static AccountingEquipmentEntities GetContext()
{
if (_context == null)
{
_context = new AccountingEquipmentEntities();
}
return(_context);
}
private void Page_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)
{
if (Visibility == Visibility.Visible)
{
AccountingEquipmentEntities.GetContext().ChangeTracker.Entries().ToList().ForEach(p => p.Reload());
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().EquipmentCard.ToList();
}
}
public EquipmentPage()
{
InitializeComponent();
DataContext = _CurrentEquipment;
manufacturers = AccountingEquipmentEntities.GetContext().Manufacturer.ToList();
manufacturers.Insert(0, new Manufacturer {
ManufacturerName = "All"
});
FilteCmb.ItemsSource = manufacturers;
}
public void loadWorker()
{
Worker Wrk = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == SenderMail.IntId).FirstOrDefault();
UIasd.FioTxt.Text = Wrk.FIO;
UIasd.PositionTxt.Text = Wrk.Position.PostionName;
UIasd.ImageByte = LoadImage(Wrk.Photo);
if (Wrk.CheckFirstVisit == true)
{
PasswordWindow psd = new PasswordWindow();
psd.ShowDialog();
}
}
private void FilteCmb_DropDownClosed(object sender, EventArgs e)
{
if (FilteCmb.SelectedIndex == 0)
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().EquipmentCard.ToList();
}
else if (SearchTxt.Text == "")
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().EquipmentCard.Where(w => w.Equipment.Manufacturer.ManufacturerName == FilteCmb.Text).ToList();
}
else
{
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().
EquipmentCard.Where(w => w.SerialNumber.StartsWith(SearchTxt.Text) && w.Equipment.Manufacturer.ManufacturerName == FilteCmb.Text).ToList();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var WorkerFPs = AccountingEquipmentEntities.GetContext().Worker.Where(w => w.id == SenderMail.IntId).FirstOrDefault();
if (FirstEnterPass.Text != SecondEnterPass.Text)
{
MessageBox.Show("Введеные пароли не совпадают", "Внимание", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
WorkerFPs.Password = FirstEnterPass.Text;
WorkerFPs.CheckFirstVisit = false;
AccountingEquipmentEntities.GetContext().SaveChanges();
this.Close();
}
}
private void BtnDel_Click(object sender, RoutedEventArgs e)
{
var EquipmentForRemoving = DgridMyPage.SelectedItems.Cast <EquipmentCard>().ToList();
if (MessageBox.Show($"Вы точно хотите удалить следующие {EquipmentForRemoving.Count} элементов?", "Внимание",
MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
AccountingEquipmentEntities.GetContext().EquipmentCard.RemoveRange(EquipmentForRemoving);
AccountingEquipmentEntities.GetContext().SaveChanges();
MessageBox.Show("Данные удалены");
DgridMyPage.ItemsSource = AccountingEquipmentEntities.GetContext().EquipmentCard.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}