public AddShop() { InitializeComponent(); database = new PharmasyContext(); database.Medicaments.Load(); // загружаем данные medicamentsGrid.ItemsSource = database.Medicaments.Local.ToBindingList(); // устанавливаем привязку к кэшу }
public void Authorize(object sender, RoutedEventArgs e) { if (Login.Text == "") { Error.Text = "Enter your login"; return; } if (Password.Password == "") { Error.Text = "Enter your password"; return; } Database = new PharmasyContext(); User user = Database.Users.Where(u => u.Login == Login.Text && u.Password == Password.Password).FirstOrDefault(); if (user == null) { Error.Text = "Invalid login or password"; return; } GoToMain(user); }
public void Register(object sender, RoutedEventArgs e) { if (Login.Text == "") { Error.Text = "Enter your login"; return; } if (Password.Password == "") { Error.Text = "Enter your password"; return; } Database = new PharmasyContext(); var existUser = Database.Users.Where(u => u.Login == Login.Text).FirstOrDefault(); if (existUser != null) { Error.Text = "User with this login are already exist"; return; } User newUser = new User(); newUser.Login = Login.Text; newUser.Password = Password.Password; newUser.RoleId = (Convert.ToBoolean(Admin.IsChecked)) ? ModelConstants.AdminRoleId : ModelConstants.UserRoleId; Database.Users.Add(newUser); Database.SaveChanges(); GoToMain(newUser); }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { /*PharmasyContext database = new PharmasyContext(); * Goods.Items.Clear(); * var userList = database.Medicaments; * Goods.ItemsSource = userList.ToList();*/ database = new PharmasyContext(); database.Medicaments.Load(); medicamentsList.ItemsSource = database.Medicaments.Local.ToBindingList(); }
public void DbSeed(object sender, RoutedEventArgs e) { Database = new PharmasyContext(); if (!Database.Roles.Any()) { Database.Roles.Add(new Role { Id = ModelConstants.AdminRoleId, RoleName = ModelConstants.AdminRoleName }); Database.SaveChanges(); Database.Roles.Add(new Role { Id = ModelConstants.UserRoleId, RoleName = ModelConstants.UserRoleName }); Database.SaveChanges(); Database.Users.Add(new User { Login = "******", Password = "******", RoleId = ModelConstants.AdminRoleId }); Database.SaveChanges(); } }
public MedicamentBuilder HasContraindications(string[] contraindicationsNames, PharmasyContext context) { var contraindications = from c in context.Medicaments where contraindicationsNames.Contains(c.Name) select c; //this.item.HasContraindications = ?? new List<Medicament>(); this.item.HasContraindications.Concat(contraindications); return(this); }