public TableFrame()
{
InitializeComponent();
using (MyBase db = new MyBase())
{
var t = db.USERS_LOG.FirstOrDefault();
db.USERS_LOG.Load();
TableGrid.ItemsSource = db.USERS_LOG.Local.ToList();
}
}
public AddFrame()
{
InitializeComponent();
using (MyBase db = new MyBase())
{
unitOfWork._UsersInfoUnits.ListOfInfo = db.USERS_INFO.ToList();
unitOfWork._UsersLogUnits.ListOfLog = db.USERS_LOG.ToList();
db.SaveChanges();
}
}
private void FindObj_Click(object sender, RoutedEventArgs e)
{
using (MyBase db = new MyBase())
{
var forDel = db.USERS_LOG.Where(p => p.UserLogID == 5);
foreach (var f in forDel)
{
MessageBox.Show(f.UserLogName);
}
}
}
public EditFrame()
{
InitializeComponent();
using (MyBase db = new MyBase())
{
unitOfWork._UsersInfoUnits.ListOfInfo = db.USERS_INFO.ToList();
unitOfWork._UsersLogUnits.ListOfLog = db.USERS_LOG.ToList();
var t = db.USERS_LOG.FirstOrDefault();
db.USERS_LOG.Load();
TableGrid.ItemsSource = db.USERS_LOG.Local.ToList();
}
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
using (MyBase db = new MyBase())
{
var log = unitOfWork._UsersLogUnits._UsersLogContext.USERS_LOG.Where(x => x.UserLogName == DeleteName.Text);
foreach (var x in log)
{
unitOfWork._UsersLogUnits._UsersLogContext.USERS_LOG.Remove(x);
}
unitOfWork.Save();
MessageBox.Show("Объект удалён!");
}
}
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
try
{
using (MyBase db = new MyBase())
{
USERS_LOG lec = new USERS_LOG();
lec.UserLogName = PulpitName.Text;
lec.UserLogPassword = AuditoriumName.Text;
unitOfWork._UsersLogUnits._UsersLogContext.USERS_LOG.Add(lec);
unitOfWork.Save();
MessageBox.Show("Успешно добавлено!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}