public ActionResult Dashboard()
{
using (LoginDBEntities db = new LoginDBEntities())
{
return(View(db.clientTables.ToList()));
}
}
private bool ValidateBySqlConnection(ref string inputUsername, ref string inputPassword)
{
string connectionString;
using (LoginDBEntities db = new LoginDBEntities())
{
connectionString = db.Database.Connection.ConnectionString;
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand()
{
CommandText = "validateUserByUP",
Connection = connection,
CommandType = System.Data.CommandType.StoredProcedure
})
{
command.Parameters.Add(new SqlParameter("@username", inputUsername));
command.Parameters.Add(new SqlParameter("@password", inputPassword));
// Adding parameter for the returned value.
SqlParameter returnValueParameter = new SqlParameter("returner", System.Data.SqlDbType.Int);
returnValueParameter.Direction = System.Data.ParameterDirection.ReturnValue;
command.Parameters.Add(returnValueParameter);
command.ExecuteNonQuery();
int returner = (int)command.Parameters["returner"].Value;
return(returner == 1);
}
}
}
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());
}
}
public ActionResult Edit(int id)
{
using (LoginDBEntities dbm = new LoginDBEntities())
{
return(View(dbm.clientTables.Where(x => x.clientID == id).FirstOrDefault()));
}
}
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());
}
}
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");
}
}
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 GetData()
{
LoginDBEntities dbm = new LoginDBEntities();
//var groupData = from student in dbm.clientTables
// group new { student.clientID }
// by student.clientID > 0 into studentGroup
// select studentGroup;
//var groupData1 = from p in dbm.phoneTables
// group p.phoneNumber by p.clientID into g
// select new { clientID = g.Key, phoneNumber = g.ToList() };
//var groupData=from employee in dbm.phoneTables
// group employee by employee.clientID into depGroup
//orderby depGroup.Key ascending
//select depGroup;
IEnumerable <Custom> signatures = from p in dbm.phoneTables
join c in dbm.clientTables on p.clientID equals c.clientID
group p.phoneNumber by c.fname into g
select new Custom
{
CountOfClients = g.Count(),
FirstName = g.Key
};
//var materializedUser = groupData1.FirstOrDefault();
//g.GroupData = groupData;
//var dg= data.Select(x=> new)
return(View(signatures));
}
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 DateRangeO(DateRangeViewModel dateRangeViewModel)
{
var strt = dateRangeViewModel.FromDate;
var end = dateRangeViewModel.ToDate;
LoginDBEntities dbm = new LoginDBEntities();
IEnumerable <clientTable> signatures = from p in dbm.clientTables
where p.DOB >= strt.Date && p.DOB <= end.Date
select p;
dateRangeViewModel.ClientTable = signatures.ToList();
return(View("DateRange", dateRangeViewModel));
}
// GET: Usuario
public ActionResult Index()
{
try
{
using (LoginDBEntities db = new LoginDBEntities())
{
List <Usuario> lista = db.Usuarios.Where(a => a.Estatus.Value).ToList();
return(View(lista));
}
}
catch (Exception ex)
{
throw;
}
}
private bool ValidateByEntity(string inputUsername, string inputPassword)
{
using (LoginDBEntities db = new LoginDBEntities())
{
user foundUser = db.users.SingleOrDefault(user => user.username.Equals(inputUsername, StringComparison.Ordinal));
if (foundUser == null || foundUser.password != inputPassword)
{
return(false);
}
else
{
return(true);
}
}
}
public ActionResult Editar(int id)
{
try
{
using (LoginDBEntities db = new LoginDBEntities())
{
Usuario usuario = db.Usuarios.Find(id);
usuario.Password = "******";
return(View(usuario));
}
}
catch (Exception)
{
throw;
}
}
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 Tuple <User, int> Login(string username, string password)
{
LoginDBEntities context = new LoginDBEntities();
var result = new ObjectParameter("result", typeof(int));
context.sp_Login(username, password, result);
int output = Int32.Parse(result.Value.ToString());
if (output == 0)
{
return(new Tuple <User, int>(context.User.FirstOrDefault(x => x.Username == username && x.Password == password), output));
}
else
{
return(new Tuple <User, int>(null, output));
}
}
public ActionResult Authorize(QuikAid.Models.UserTable userModels)
{
using (LoginDBEntities db = new LoginDBEntities())
{
var userDetails = db.UserTables.Where(x => x.userName == userModels.userName && x.password == userModels.password).FirstOrDefault();
if (userDetails == null)
{
ViewBag.errorLogin = "******";
return(View("Index", userModels));
}
else
{
Session["userID"] = userDetails.UserId;
return(RedirectToAction("Dashboard", "Home"));
}
}
}
public ActionResult Authorize(MVCLogin.Models.User userModel)
{
using (LoginDBEntities db = new LoginDBEntities())
{
var userDetails = db.Users.Where(x => x.UserName == userModel.UserName && x.Password == userModel.Password).FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "Wrong Username or Password";
return(View("Index", userModel));
}
else
{
Session["userID"] = userDetails.UserID;
return(RedirectToAction("Index", "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 Autherize(User userModel)
{
using (LoginDBEntities db = new LoginDBEntities())
{
var userDetails = db.User.Where(x => x.UserName == userModel.UserName && x.Password == userModel.Password).FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "A belépési adatok nem jók.";
return(View("Index", userModel));
}
else
{
Session["userID"] = userDetails.UserID;
Session["userName"] = userDetails.UserName;
return(RedirectToAction("Index", "Home"));
}
}
}
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 Autorizar(WebLogin.Models.Usuario userModel)
{
using (LoginDBEntities db = new LoginDBEntities())
{
userModel.Password = SHA256(userModel.Password);
var usuarioDet = db.Usuarios.Where(x => x.Usuario1 == userModel.Usuario1 && x.Password == userModel.Password).FirstOrDefault();
if (usuarioDet == null)
{
userModel.MensajeDeError = "Usuario o PW incorrectos";
return(View("Index", userModel));
}
else
{
Session["IdUsuario"] = userModel.Usuario1;
return(RedirectToAction("Index", "Usuario"));
}
}
}
public ActionResult Authorise(UserLogin user)
{
using (LoginDBEntities loginDBEntities = new LoginDBEntities())
{
var UserDetailes = loginDBEntities.UserLogins.Where(x => x.Username == user.Username && x.Password == user.Password).FirstOrDefault();
if (UserDetailes == null)
{
user.LoginErrorMessage = "Invalid Attempt";
return(View("Login", user));
}
else
{
Session["UserName"] = user.Username;
return(RedirectToAction("Index", "Family"));
}
}
return(View());
}
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 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!!");
}
}
public ActionResult GetData()
{
LoginDBEntities dbm = new LoginDBEntities();
IEnumerable <MyClass> signatures = from p in dbm.phoneTables
join c in dbm.clientTables on p.clientID equals c.clientID
group p.phoneNumber by c.fname into g
select new MyClass
{
CountOfClients = g.Count(),
FirstName = g.Key
};
//g.GroupData = groupData;
//var dg= data.Select(x=> new)
return(View(signatures));
}
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");
}
}
public ActionResult DateRangeO(FormCollection form)
{
var strt = form["StartDate"];
var end = form["EndDate"];
LoginDBEntities dbm = new LoginDBEntities();
//IEnumerable<clientTable> signatures = from p in dbm.clientTables
// where p.DOB >= StartDate && p.DOB <= EndDate
// select new clientTable
// {
// fname = g.Count(),
// lName = g.Key
// userId
// };
//IEnumerable<clientTable> signatures =
//var q=dbm.clientTables.Where(x=> )
return(View());
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
InfoProductFromPeople.ItemsSource = null;
db = new LoginDBEntities();
InfoProductFromPeople.ItemsSource = db.ProductFromPeoples.ToList();
}
private void Winows_load(object sender, RoutedEventArgs e)
{
InfoProductCustomer.ItemsSource = null;
dbcustomer = new LoginDBEntities();
InfoProductCustomer.ItemsSource = dbcustomer.tableCustomers.ToList();
}
