private void AddItem(object sender, RoutedEventArgs e) { if (ItemBox1.Text != "" || PriceBox1.Text != "") { float price = 0; price = Convert.ToUInt64(PriceBox1.Text); using (var context = new LoginDBEntities()) { var product = new ProductFromStore() { UserName = Person.Login, ProductName = ItemBox1.Text, Price = price }; context.ProductFromStores.Add(product); context.SaveChanges(); ItemBox1.Clear(); PriceBox1.Clear(); } ItemBox1.Text = ""; PriceBox1.Text = ""; } else { MessageBox.Show("Incorrect"); } }
public ActionResult Editar(Usuario rowUsuario) { try { if (!ModelState.IsValid) { return(View()); } using (LoginDBEntities db = new LoginDBEntities()) { Usuario usuarioReg = db.Usuarios.Find(rowUsuario.Id); usuarioReg.Correo = rowUsuario.Correo; usuarioReg.Sexo = rowUsuario.Sexo; usuarioReg.Password = SHA256(rowUsuario.Password); usuarioReg.ConfirmaPassword = SHA256(rowUsuario.Password); db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { ModelState.AddModelError("", "Error al editar usuario" + ex.Message); return(View()); } }
public void Login() { Validate(); if (IsValid) { var passwordHash = this.getMd5Hash(this.Password); var hasUser = db.User.Any(u => u.UserName.ToLower() == this.UserName.ToLower() && u.Password == passwordHash); if (!hasUser) { this.Message = "Sikertelen bejelentkezés, hibás adatok!"; this.MsgVisible = true; } else { //TODO:Egy komplex user objektum tárolása célszerűbb lenne var userId = db.User.First(u => u.UserName == this.UserName).UserId; Application.Current.Properties["userId"] = userId; this.Message = "Sikeres bejelentkezés!"; this.MsgVisible = true; var log = new LoginLog() { UserId = userId, DateTime = DateTime.Now }; db.LoginLog.Add(log); db.SaveChanges(); new LoginWPF.View.LogList().Show(); Application.Current.MainWindow.Close(); } } }
private void Button_Click(object sender, RoutedEventArgs e) { if (UserName.Text != "" || Product.Text != "" || Price.Text != "") { using (LoginDBEntities db = new LoginDBEntities()) { float price = Convert.ToUInt64(Price.Text); ProductFromPeople p1 = new ProductFromPeople { UserName = UserName.Text, ProductName = Product.Text, Price = price }; p1 = db.ProductFromPeoples.FirstOrDefault(); if (p1.ProductName != null) { db.Entry(p1).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } UserName.Text = ""; Product.Text = ""; Price.Text = ""; } else { MessageBox.Show("Incorrect"); } }
public ActionResult Agregar(Usuario rowUsuario) { if (!ModelState.IsValid) { return(View()); } try { using (LoginDBEntities db = new LoginDBEntities()) { var usuarioExist = db.Usuarios.Where(x => x.Usuario1 == rowUsuario.Usuario1 && x.Correo == rowUsuario.Correo).FirstOrDefault(); if (!(usuarioExist == null)) { ModelState.AddModelError("", "Ya existe un usuario con la misma información"); return(View()); } rowUsuario.Estatus = true; rowUsuario.Password = SHA256(rowUsuario.Password); rowUsuario.ConfirmaPassword = SHA256(rowUsuario.ConfirmaPassword); db.Usuarios.Add(rowUsuario); db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { ModelState.AddModelError("", "Error al agregar usuario" + ex.Message); return(View()); } }
private void AddItem(object sender, RoutedEventArgs e) { if (ItemBox.Text != "" || PriceBox.Text != "") { float price = 0; price = Convert.ToUInt64(PriceBox.Text); using (var context = new LoginDBEntities()) { var product = new ProductFromPeople() { UserName = Person.Login, ProductName = ItemBox.Text, Price = price }; context.ProductFromPeoples.Add(product); context.SaveChanges(); ItemBox.Clear(); PriceBox.Clear(); MessageBox.Show("Wait , when admin to add your thing to the main list"); } } else { MessageBox.Show("Incorrect"); } }
public void Registration() { Validate(); var hasUser = HasUserName(this.UserName); if (hasUser) { this.Message = "A felhasználónév már használatban van, kérem válaszon másikat!"; this.MsgVisible = true; } else if (IsValid) { var user = new User() { FirstName = this.FirstName, LastName = this.LastName, UserName = this.UserName, Password = this.getMd5Hash(this.Password) }; db.User.Add(user); db.SaveChanges(); this.Message = "A regisztráció sikeres!"; this.MsgVisible = true; } }
public ActionResult Eliminar(int id) { try { using (LoginDBEntities db = new LoginDBEntities()) { Usuario usuario = db.Usuarios.Find(id); usuario.Estatus = false; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception) { throw; } }
public ActionResult AddPh(phoneTable p) { { try { using (LoginDBEntities dbm = new LoginDBEntities()) { dbm.phoneTables.Add(p); dbm.SaveChanges(); } return(RedirectToAction("Dashboard", "Home")); } catch (Exception e) { return(RedirectToAction("Dashboard", "Home")); } } }
public ActionResult Create(clientTable c) { try { c.SSN = c.SSN.ToString(); c.DOB = DateTime.Now; using (LoginDBEntities dbm = new LoginDBEntities()) { dbm.clientTables.Add(c); dbm.SaveChanges(); } return(RedirectToAction("Dashboard", "Home")); } catch { return(RedirectToAction("Dashboard", "Home")); } }
public ActionResult Edit(int id, clientTable c) { try { using (LoginDBEntities dbm = new LoginDBEntities()) { dbm.Entry(c).State = EntityState.Modified; dbm.SaveChanges(); } return(RedirectToAction("Dashboard", "Home")); } catch (Exception e) { return(RedirectToAction("Dashboard", "Home")); } }
public ActionResult Delete(int id, FormCollection colection) { try { using (LoginDBEntities dbm = new LoginDBEntities()) { clientTable c = dbm.clientTables.Where(x => x.clientID == id).FirstOrDefault(); dbm.clientTables.Remove(c); dbm.SaveChanges(); } return(RedirectToAction("Dashboard", "Home")); } catch (Exception e) { return(RedirectToAction("Dashboard", "Home")); } }
private void Add_in_Main_list(object sender, RoutedEventArgs e) { float price = 0; price = Convert.ToUInt64(Price.Text); using (var context = new LoginDBEntities()) { var product = new ProductFromStore() { UserName = UserName.Text, ProductName = Product.Text, Price = price }; context.ProductFromStores.Add(product); context.SaveChanges(); UserName.Clear(); Product.Clear(); Price.Clear(); MessageBox.Show("You add in main list"); } }
private void Button_Click(object sender, RoutedEventArgs e) { float price = 0; price = Convert.ToUInt64(Price.Text); using (var context = new LoginDBEntities()) { var product = new tableCustomer() { UserName = login, ProductName = Product1.Text, Price = price }; context.tableCustomers.Add(product); context.SaveChanges(); Product1.Clear(); Price.Clear(); MessageBox.Show("You buy it!!"); } }