private void Button_ClickDel(object sender, RoutedEventArgs e) { int pNum = Convert.ToInt32((sender as Button).Uid); var delProdFromBasket = db.Basketts.Where(b => b.ProdNum == pNum).FirstOrDefault(); db.Basketts.Remove(delProdFromBasket); db.SaveChanges(); NavigationService.Navigate(new viewBasket(CNum)); }
private void Button_ClickBasket(object sender, RoutedEventArgs e) { var CNum = db.Clients.Where(n => n.Email == email).FirstOrDefault(); var PNUm = Convert.ToInt32((sender as Button).Uid); var checkBas = db.Basketts.Where(b => b.ProdNum == PNUm && b.ClientNum == CNum.ClientNum).FirstOrDefault(); var checkProdQuan = db.Products.Where(p => p.ProductNum == PNUm).FirstOrDefault(); if (checkBas == null && checkProdQuan.Quantity > 0) { Basketts newPoint = new Basketts { ClientNum = CNum.ClientNum, ProdNum = PNUm, Quantity = 1 }; db.Basketts.Add(newPoint); MessageBox.Show("Товар добавлен в корзину"); } else if (checkProdQuan.Quantity > checkBas.Quantity + 1) { checkBas.Quantity += 1; MessageBox.Show("Увеличели количество товара в корзине"); } else { MessageBox.Show("Товара закончился"); } db.SaveChanges(); }
private void Button_ClickUpdate2(object sender, RoutedEventArgs e) { string patternEmail = @"^(?("")(""[^""]+?""@)|(([0-9a-z]((\.(?!\.))|[-!#\$%&'\*\+/=\?\^`\{\}\|~\w])*)(?<=[0-9a-z])@))" + @"(?(\[)(\[(\d{1,3}\.){3}\d{1,3}\])|(([0-9a-z][-\w]*[0-9a-z]*\.)+[a-z0-9]{2,17}))$"; Users changeLoginUser = db.Users.Where(c => c.Email == email1).FirstOrDefault(); Clients changeLoginClient = db.Clients.Where(c => c.Email == email1).FirstOrDefault(); if (LastPassword.Password.Trim() == changeLoginUser.Password) { if (!Regex.IsMatch(ChangeLogin.Text, patternEmail)) { MessageBox.Show("Неправильный формат Email"); } else { changeLoginClient.Email = ChangeLogin.Text; changeLoginUser.Email = ChangeLogin.Text; changeLoginUser.Password = NewPassword.Password.Trim(); db.SaveChanges(); email1 = ChangeLogin.Text; MessageBox.Show("Изменения сохранены"); NavigationService.Navigate(new changeLoginPassword(email1)); } } else { MessageBox.Show("Неправильный пароль!"); } }
private void Button_ClickRegistration(object sender, RoutedEventArgs e) { string patternNum = @"[+7|8]{1}[0-9]{10}"; string patternEmail = @"^(?("")(""[^""]+?""@)|(([0-9a-z]((\.(?!\.))|[-!#\$%&'\*\+/=\?\^`\{\}\|~\w])*)(?<=[0-9a-z])@))" + @"(?(\[)(\[(\d{1,3}\.){3}\d{1,3}\])|(([0-9a-z][-\w]*[0-9a-z]*\.)+[a-z0-9]{2,17}))$"; String Surname = TSurname.Text.Trim(); String Name = TName.Text.Trim(); String Patronymic = TSurname.Text.Trim(); String Email = TEmail.Text.Trim(); String Phone = TPhone.Text.Trim(); String Password = TPassword.Password.Trim(); Users checkEmail = db.Users.Where(u => u.Email == Email).FirstOrDefault(); if (String.IsNullOrEmpty(Surname) || String.IsNullOrEmpty(Name) || String.IsNullOrEmpty(Patronymic) || String.IsNullOrEmpty(Email) || String.IsNullOrEmpty(Phone) || String.IsNullOrEmpty(Password)) { MessageBox.Show("Все поля должны быть заполнены!"); } else if (checkEmail != null) { MessageBox.Show("Пользователь с таким email уже зарегистрирован"); } else if (!Regex.IsMatch(Phone, patternNum)) { MessageBox.Show("Неправильный формат номера телефона"); } else if (!Regex.IsMatch(Email, patternEmail)) { MessageBox.Show("Неправильный формат Email"); } else { Users checkUser = db.Users.FirstOrDefault(u => u.Email == Email); if (checkUser == null) { Users newUser = new Users { Email = Email, Password = Password, Rights = "3" }; Clients newClient = new Clients { Surname = Surname, Name = Name, Patronymic = Patronymic, Email = Email // Phone = Phone }; db.Users.Add(newUser); db.Clients.Add(newClient); db.SaveChanges(); MessageBox.Show("Вы успешно зарегистрировались"); NavigationService.GoBack(); } else { MessageBox.Show("Пользователь с таким Email зарегистрирован"); } } }
private void Button_ClickBasket(object sender, RoutedEventArgs e) { CompEntities5 db = new CompEntities5(); var CNum = db.Clients.Where(n => n.Email == email).FirstOrDefault(); var PNUm = Convert.ToInt32((sender as Button).Uid); var checkBas = db.Basketts.Where(b => b.ProdNum == PNUm && b.ClientNum == CNum.ClientNum).FirstOrDefault(); if (checkBas == null) { Basketts newPoint = new Basketts { ClientNum = CNum.ClientNum, ProdNum = PNUm, Quantity = 1 }; db.Basketts.Add(newPoint); } else { checkBas.Quantity += 1; } db.SaveChanges(); MessageBox.Show("Товар добавлен в корзину"); }
private void Button_ClickUpdate(object sender, RoutedEventArgs e) { string patternNum = @"[+7|8]{1}[0-9]{10}"; Clients clientsCab = db.Clients.Where(c => c.Email == email).FirstOrDefault(); if (!Regex.IsMatch(OutputPhone.Text, patternNum)) { MessageBox.Show("Неправильный формат номера телефона"); } else { clientsCab.Phone = OutputPhone.Text; clientsCab.Surname = OutputSurname.Text; clientsCab.Name = OutputName.Text; clientsCab.Patronymic = OutputPatronymic.Text; db.SaveChanges(); MessageBox.Show("Изменения сохранены"); NavigationService.Navigate(new ClientInfo(email)); } }