private void Button_Click_5(object sender, RoutedEventArgs e)
{
try
{
var firstSelectedCellContent = ((TextBlock)(this.DgridMedicament.Columns[0].GetCellContent(DgridMedicament.SelectedItem))).Text;
var name = dbContext.MEDICAMENTs.Where(m => m.M_NAME == firstSelectedCellContent);
if (MessageBox.Show($"Вы точно хотите удалить следующие {firstSelectedCellContent.Count()} элементов",
"Внмимание", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
FARMOKAIPKAEntities._context.MEDICAMENTs.RemoveRange(name);
FARMOKAIPKAEntities.GetContext().SaveChanges();
MessageBox.Show("Данные удалены");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
DgridMedicament.Items.Clear();
queryMainCatalog();
}
catch (Exception)
{
MessageBox.Show($"Выделите строку, которую хотите удалить");
}
}
public MainWindow()
{
InitializeComponent();
using (var ctx = new FARMOKAIPKAEntities())
{
ctx.Database.Initialize(true);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
FARMOKAIPKAEntities dbContext = FARMOKAIPKAEntities.GetContext();
string Login = login.Text;
//string Password = password.Text;
if (string.IsNullOrEmpty(Login))
{
MessageBox.Show("Введите логин");
}
else if (string.IsNullOrEmpty(password.Text))
{
MessageBox.Show("Введите пароль");
}
else
{
var transaction = from user in dbContext.Sellers
where user.S_LOGIN == Login && user.S_PASSWORD == password.Text
select new
{
name = user.S_FIRST_NAME,
last_name = user.S_LAST_NAME,
patranymic = user.S_PATRONYMIC,
login = user.S_LOGIN,
password = user.S_PASSWORD
};
foreach (var item in transaction)
{
NameSeller = $"{item.last_name} {item.name} {item.patranymic}";
}
if (transaction.Count() == 0)
{
MessageBox.Show("Неверно введен логин или пароль");
}
else
{
var sel = dbContext.Sellers.Where(s => s.S_LOGIN == Login);
foreach (var item in sel)
{
seller = item;
}
MessageBox.Show("Пользователь авторизовался");
access = seller.Access_Seller.NAME;
var MainPage = new MainPage();
MainPage.Show();
this.Close();
}
}
}
public AddAtx(FARMOKAIPKAEntities entities)
{
InitializeComponent();
}
public registration()
{
InitializeComponent();
listAccess.ItemsSource = FARMOKAIPKAEntities.GetContext().Access_Seller.ToList();
}
