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!!");
}
}
