public Storage(Storekeeper storekeeper) { dataBase = new VeredContext(); InitializeComponent(); storekeeper1 = storekeeper; showData(); }
public IActionResult DeleteKeeperDB([FromBody] int kepId) //Удаление записи КЛАДОВЩИК из БД { Storekeeper b = _context.Storekeepers.Find(kepId); if (b == null) { return(Json("Запись удалена ранее. Обновите страницу!")); } var detail = _context.Details.FromSql("SELECT * From Details").ToList(); int count = detail.Count; for (int i = 0; i < count; i++) { if (b.Id == detail.ElementAt(i).StorekeeperId&& detail.ElementAt(i).Count != null && detail.ElementAt(i).Count != 0) { return(Json("Запись не может быть удалена:за кладовщиком числятся детали!")); } } if (b != null) { _context.Storekeepers.Remove(b); _context.SaveChanges(); } return(Json("Запись успешно удалена")); }
public void InputHandler() { var storekeeper = new Storekeeper(); storekeeper = LoginStorekeeper(); if (storekeeper.Id != 0) { int userInput = 0; do { userInput = StorekeeperMenu(); if (userInput == 1) { GetTransactions(); } if (userInput == 2) { GetInProgressTransactions(); } if (userInput == 3) { CreateReceipt(storekeeper.Id); } if (userInput == 4) { StorekeeperMenu(); } } while (userInput != 0); } }
public Menu(Storekeeper storekeeper) { InitializeComponent(); dataBase = new VeredContext(); storekeeper1 = storekeeper; btnBuyThrroughPos.Visibility = Visibility.Hidden; btnAllDataShop.Visibility = Visibility.Hidden; }
/// <summary> /// Constructor with one parameter /// </summary> /// <param name="storeOpen">Storekeeper window</param> public StorekeeperViewModel(Storekeeper storeOpen) { storekeeper = storeOpen; using (WarehouseDBEntities context = new WarehouseDBEntities()) { ProductList = context.Products.ToList(); } service.GetCurrentWarehouseQuantity(); }
private static void CreateStorekeepersData() { firstStorekeeper = new Storekeeper { FullName = "Белов Андрей Владимирович" }; secondStorekeeper = new Storekeeper { FullName = "Попова Александра Михайловна" }; }
public void Add(Store store, Waybill waybill, Storekeeper storekeeper) { var sql = "Insert into AcceptedWaybills (Id, StoreId, WaybillId, StorekeeperId) Values (@Id, @StoreId, @WaybillId, @StorekeeperId);"; using (var connection = new SqlConnection(connectionString)) { connection.Execute(sql, new { Id = Guid.NewGuid(), StoreId = store.Id, WaybillId = waybill.Id, StorekeeperId = storekeeper.Id }); } }
public void Delete(int storekeeperId) { Storekeeper storekeeperDetail = _context.Storekeepers.FirstOrDefault(x => x.Id == storekeeperId); if (_context.Details.Any(a => a.StorekeeperId == storekeeperId)) { throw new ValidationException("Нельзя удалить кладовщика, за которым числятся детали"); } _context.Storekeepers.Remove(storekeeperDetail ?? throw new InvalidOperationException()); _context.SaveChanges(); }
private void Entry_Click(object sender, EventArgs e) { string mySelectQuery = "SELECT Роль FROM dbo.Пользователь WHERE [Логин] = '" + textBox1.Text + "'and [Пароль]='" + textBox2.Text + "'"; SqlConnection ThisConnection = new SqlConnection(MainForm.CS); ThisConnection.Open(); SqlCommand thisCommand = ThisConnection.CreateCommand(); thisCommand.CommandText = "SELECT Роль FROM dbo.Пользователь WHERE Логин = '" + textBox1.Text + "'and Пароль ='" + textBox2.Text + "'"; SqlDataReader thisReader = thisCommand.ExecuteReader(); string res = string.Empty; while (thisReader.Read()) { res += thisReader["Роль"]; } thisReader.Close(); ThisConnection.Close(); switch (res) { case "Сlient": Client CL = new Client(); CL.Show(); Logname = textBox1.Text; this.Visible = false; break; case "Storekeeper": Storekeeper SK = new Storekeeper(); SK.Show(); Logname = textBox1.Text; this.Visible = false; break; case "Director": Director Dr = new Director(); Dr.Show(); Logname = textBox1.Text; this.Visible = false; break; case "Manager": Manager Mn = new Manager(); Mn.Show(); Logname = textBox1.Text; this.Visible = false; break; default: MessageBox.Show("Пользователь не найден"); break; } }
public void Add(Storekeeper storekeeper) { string query = "Insert into Storekeepers values(@Id, @CreationDate, @DeletedDate, @FullName)"; using (var connection = new SqlConnection(configurationService.connectionString)) { var rowsAffected = connection.Execute(query, storekeeper); if (rowsAffected != 1) { throw new Exception("Error"); } } }
private static bool Entry() { Console.Clear(); Console.WriteLine("Введите Имя: "); string name = Console.ReadLine(); Console.WriteLine("Введите пароль: "); string pass = Console.ReadLine(); if (storekeeperRepository.Authorization(name, pass)) { storekeeper = storekeeperRepository.GetStorekeeper(name); return(true); } return(false); }
public Waybill MakeWaybill(Dictionary <Product, int> waybillDetails, Storekeeper storekeeper) { var waybill = new Waybill { WaybillNumber = $"{new Random().Next(1000, 10000)}", StorekeeperId = storekeeper.Id }; foreach (var waybillDetail in waybillDetails) { context.WaibillDetails.Add(new WaybillDetail { ProductId = waybillDetail.Key.Id, WaibillId = waybill.Id, Count = waybillDetail.Value }); } return(waybill); }
private StockOrder MakeStockOrder(Storekeeper storekeeper) { var provider = _providerService.GetProvider("BricoWorld"); var articles = new List <Article>(); articles.Add(ArticleConsts.Screwdriver); articles.Add(ArticleConsts.Probe); articles.Add(ArticleConsts.WoodenGardenChair); articles.Add(ArticleConsts.RJ45Cable3Meters); var stockOrder = _stockOrderService.AddStockOrder( provider, storekeeper, articles ); return(stockOrder); }
private void BtStoCreate_Click(object sender, EventArgs e) { if (TxtStoName.Text == "" || TxtStoPhone.Text == "" || TxtStoEmail.Text == "" || TxtStoAddress.Text == "") { MessageBox.Show("Fill in all information"); return; } Storekeeper Sto = new Storekeeper(); Sto.Ad = TxtStoAddress.Text; Sto.Email = TxtStoEmail.Text; Sto.Name = TxtStoName.Text; Sto.PhoneNumber = TxtStoPhone.Text; Sto.DateOfBirth = BirthDay.Value; db.Storekeepers.Add(Sto); db.SaveChanges(); MessageBox.Show("Add item successfully"); LoadDgv(); LoadDetail(); }
public StockOrder AddStockOrder( Provider provider, Storekeeper backer, IEnumerable <Article> articles ) { var stockOrder = new StockOrder( Guid.NewGuid().ToString(), provider, backer, articles, new OrderReport( OrderReportStatus.Created, DateTime.Now ) ); _stockOrders.Add(stockOrder); return(stockOrder); }
public async Task <IActionResult> Get() { List <Storekeeper> keeper_ = new List <Storekeeper>(); var Keepers = await(from data in _context.Storekeepers select new { Id = data.Id, KeeperName = data.KeeperName }).ToListAsync(); Keepers.ForEach(x => { Storekeeper pro = new Storekeeper(); pro.Id = x.Id; pro.KeeperName = x.KeeperName; keeper_.Add(pro); }); return(Json(keeper_)); }
/// <summary> /// Checks if its possible to login depending on the given username and password /// </summary> /// <param name="obj"></param> private void LoginExecute(object obj) { string password = (obj as PasswordBox).Password; if (Username == "Mag2019" && password == "Mag2019") { Storekeeper sk = new Storekeeper(); LabelInfo = "Logged in"; view.Close(); sk.Show(); } else if (Username == "Man2019" && password == "Man2019") { MainWindow mw = new MainWindow(); LabelInfo = "Logged in"; view.Close(); mw.Show(); } else { LabelInfo = "Wrong Username or Password"; } }
//raktáros belépés private static Storekeeper LoginStorekeeper() { var storekeeper = new Storekeeper(); return(storekeeper.Login()); }
public ConcreteStrategyE(Storekeeper storekeeper) { Storekeeper = storekeeper; }
private void AddUser_Click(object sender, RoutedEventArgs e) { try { if ((chkbx1.IsChecked == true && chkbx2.IsChecked == true) || (chkbx1.IsChecked == true && chkbx3.IsChecked == true) || (chkbx3.IsChecked == true && chkbx2.IsChecked == true) || (chkbx1.IsChecked == true && chkbx2.IsChecked == true && chkbx3.IsChecked == true)) { MessageBox.Show("You can choose only one table!", "Caution", MessageBoxButton.OK); txbxUserFirstName.Clear(); txbxUserLastName.Clear(); txbxEmail.Clear(); txbxPassword.Clear(); txbxSalary.Clear(); } if (txbxUserFirstName.Text == "" || txbxUserLastName.Text == "" || txbxEmail.Text == "" || txbxPassword.Text == "") { MessageBox.Show("Name Should be Filled!", "Warning!", MessageBoxButton.OK); txbxUserFirstName.Focus(); txbxUserLastName.Focus(); txbxEmail.Focus(); txbxPassword.Focus(); } else if (chkbx1.IsChecked == true) { txbxSalary.IsEnabled = false; var client = new Client() { FirstName = txbxUserFirstName.Text, LastName = txbxUserLastName.Text, Email = txbxEmail.Text, Password = txbxPassword.Text, }; dataBase.Clients.Add(client); dataBase.SaveChanges(); showData(); MessageBox.Show("New Client Is Added"); txbxUserFirstName.Clear(); txbxUserLastName.Clear(); txbxEmail.Clear(); txbxPassword.Clear(); txbxSalary.Clear(); } if (chkbx2.IsChecked == true) { if (txbxUserFirstName.Text == "" || txbxUserLastName.Text == "" || txbxEmail.Text == "" || txbxPassword.Text == "" || txbxSalary.Text == "") { MessageBox.Show("Name Should be Filled!", "Warning!", MessageBoxButton.OK); txbxUserFirstName.Focus(); txbxUserLastName.Focus(); txbxEmail.Focus(); txbxPassword.Focus(); txbxSalary.Focus(); } var seller = new Seller() { FirstName = txbxUserFirstName.Text, LastName = txbxUserLastName.Text, Email = txbxEmail.Text, Password = txbxPassword.Text, Salary = Convert.ToInt32(txbxSalary.Text), }; dataBase.Sellers.Add(seller); dataBase.SaveChanges(); showData(); MessageBox.Show("New Seller Is Added"); txbxUserFirstName.Clear(); txbxUserLastName.Clear(); txbxEmail.Clear(); txbxPassword.Clear(); txbxSalary.Clear(); } if (chkbx3.IsChecked == true) { if (txbxUserFirstName.Text == "" || txbxUserLastName.Text == "" || txbxEmail.Text == "" || txbxPassword.Text == "" || txbxSalary.Text == "") { MessageBox.Show("Name Should be Filled!", "Warning!", MessageBoxButton.OK); txbxUserFirstName.Focus(); txbxUserLastName.Focus(); txbxEmail.Focus(); txbxPassword.Focus(); txbxSalary.Focus(); } var storekeeper = new Storekeeper() { FirstName = txbxUserFirstName.Text, LastName = txbxUserLastName.Text, Email = txbxEmail.Text, Password = txbxPassword.Text, Salary = Convert.ToInt32(txbxSalary.Text), }; dataBase.Storekeepers.Add(storekeeper); dataBase.SaveChanges(); showData(); MessageBox.Show("New Storekepper Is Added"); txbxUserFirstName.Clear(); txbxUserLastName.Clear(); txbxEmail.Clear(); txbxPassword.Clear(); txbxSalary.Clear(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Login_Click(object sender, RoutedEventArgs e) { Manager manager = Manager.Instance(); manager.ManagerOperation(); string managerEmail = manager.GetManagerEmail(); string managerPassword = manager.GetManagerPassword(); if (LoginBox.Text == managerEmail && PassBox.Password == managerPassword) { context = new Context(new ConcreteStrategyE()); context.ContextInterface(); this.Close(); } else { try { var email = DB.Clients.Where(u => u.Email == LoginBox.Text).FirstOrDefault(); var email2 = DB.Sellers.Where(u => u.Email == LoginBox.Text).FirstOrDefault(); var email3 = DB.Storekeepers.Where(u => u.Email == LoginBox.Text).FirstOrDefault(); if ((LoginBox.Text == "") || (PassBox.Password == "")) { if (LoginBox.Text == "") { MessageBox.Show("Email is Required!", "Caution", MessageBoxButton.OK); LoginBox.Focus(); } else if (PassBox.Password == "") { MessageBox.Show("Password is Required!", "Caution", MessageBoxButton.OK); PassBox.Focus(); } } else { if (email != null) { var pass = email.Password; pass = PassBox.Password; if (PassBox.Password == pass) { MessageBox.Show("Login Successfully!", "Login Success", MessageBoxButton.OK); client = DB.Clients.Where(u => u.Email == LoginBox.Text).FirstOrDefault(); context = new Context(new ConcreteStrategyE(client)); context.ContextInterface(); this.Close(); } else { MessageBox.Show("Email or Password are wrong!"); } } else if (email2 != null) { var pass = email2.Password; pass = PassBox.Password; if (PassBox.Password == pass) { MessageBox.Show("Login Successfully!", "Login Success", MessageBoxButton.OK); seller = DB.Sellers.Where(u => u.Email == LoginBox.Text).FirstOrDefault(); context = new Context(new ConcreteStrategyE(seller)); context.ContextInterface(); this.Close(); } else { MessageBox.Show("Email and Password or wrong!"); } } else if (email3 != null) { var pass = email3.Password; pass = PassBox.Password; if (PassBox.Password == pass) { MessageBox.Show("Login Successfully!", "Login Success", MessageBoxButton.OK); storekeeper = DB.Storekeepers.Where(u => u.Email == LoginBox.Text).FirstOrDefault(); context = new Context(new ConcreteStrategyE(storekeeper)); context.ContextInterface(); this.Close(); } else { MessageBox.Show("Email and Password or wrong!"); } } else { MessageBox.Show("Email and Password is invalid"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public void Add(StorekeeperDto storekeeper) { Storekeeper result = _mapper.Map <StorekeeperDto, Storekeeper>(storekeeper); _dalFactory.StorekeeperDal.Add(result); }
public void AddNewUser(UserViewModel newUser) { Person person = null; SystemUser systemUser = new SystemUser { UserName = newUser.UserName, Email = newUser.Email, PhoneNumber = newUser.PhoneNumber }; string passHash = userManager.PasswordHasher.HashPassword(systemUser, newUser.Password); systemUser.PasswordHash = passHash; userManager.CreateAsync(systemUser).Wait(); string role = newUser.Role.ToString(); userManager.AddToRoleAsync(systemUser, role).Wait(); switch (newUser.Role) { case UserRoleTypes.Admin: person = new Admin(); SetPersonProperties(person, newUser, systemUser); context.Admins.Add(person as Admin); break; case UserRoleTypes.Patient: person = new Patient(); SetPersonProperties(person, newUser, systemUser); context.Patients.Add(person as Patient); break; case UserRoleTypes.Doctor: person = new Doctor(); SetPersonProperties(person, newUser, systemUser); context.Doctors.Add(person as Doctor); break; case UserRoleTypes.Nurse: person = new Nurse(); SetPersonProperties(person, newUser, systemUser); context.Nurses.Add(person as Nurse); break; case UserRoleTypes.InternalPharmacist: person = new InternalPharmacist(); SetPersonProperties(person, newUser, systemUser); context.InternalPharmacists.Add(person as InternalPharmacist); break; case UserRoleTypes.ExternalPharmacist: person = new ExternalPharmacist(); SetPersonProperties(person, newUser, systemUser); context.ExternalPharmacists.Add(person as ExternalPharmacist); break; case UserRoleTypes.Storekeeper: person = new Storekeeper(); SetPersonProperties(person, newUser, systemUser); context.Storekeepers.Add(person as Storekeeper); break; default: throw new Exception("Unknown user type when creating new user!"); } context.SaveChanges(); }
public IActionResult AddKeeper([FromBody] Storekeeper kepObj) { _context.Storekeepers.Add(kepObj); _context.SaveChanges(); return(Json("OK")); }
public void Update(StorekeeperDto data) { Storekeeper result = _mapper.Map <StorekeeperDto, Storekeeper>(data); _dalFactory.StorekeeperDal.UpdateVoid(result, result.Id); }