public static APPUSER GetUser(String user, String password)
{
string sql = String.Format("SELECT * FROM appuser WHERE username = '******' AND password = '******';", user, password);
DataTable dt = ConnectionDB.realizarConsulta(sql);
APPUSER add = new APPUSER();
foreach (DataRow fila in dt.Rows)
{
add.username = fila[1].ToString();
add.password = fila[2].ToString();
}
return(add);
}
public static DataTable verDirecciones(APPUSER appuser)
{
DataTable dt = null;
try
{
dt = ConnectionDB.realizarConsulta(string.Format("SELECT ad.idAddress, ad.idUser, ad.address FROM ADDRESS ad, APPUSER us " +
"WHERE us.username = '******' and ad.idUser = us.idUser ", appuser.username));
}
catch (Exception)
{
return(null);
}
return(dt);
}
public static List <Negocio> getLista()
{
string sql = "select * from business";
var dt = ConnectionDB.realizarConsulta(sql);
List <Negocio> lista = new List <Negocio>();
foreach (DataRow fila in dt.Rows)
{
Negocio negocio = new Negocio();
negocio.idBusiness = Convert.ToInt32(fila[0].ToString());
negocio.name = fila[1].ToString();
negocio.description = fila[2].ToString();
lista.Add(negocio);
}
return(lista);
}
public static List <Orden> GetLista()
{
string sql = "select * from APPORDER";
var dt = ConnectionDB.realizarConsulta(sql);
List <Orden> lista = new List <Orden>();
foreach (DataRow fila in dt.Rows)
{
Orden orden = new Orden();
orden.idOrder = Convert.ToInt32(fila[0].ToString());
orden.createOrder = Convert.ToDateTime(fila[1].ToString());
orden.idProduct = Convert.ToInt32(fila[2].ToString());
orden.idAdress = Convert.ToInt32(fila[3].ToString());
lista.Add(orden);
}
return(lista);
}
public static List <Producto> getLista()
{
string sql = "SELECT * FROM product";
DataTable dt = ConnectionDB.realizarConsulta(sql);
List <Producto> lista = new List <Producto>();
foreach (DataRow fila in dt.Rows)
{
Producto prod = new Producto();
prod.idProduct = Convert.ToInt32(fila[0].ToString());
prod.idBusiness = Convert.ToInt32(fila[1].ToString());
prod.name = fila[2].ToString();
lista.Add(prod);
}
return(lista);
}
public static List <Direccion> getLista()
{
string sql = "select * from address";
DataTable dt = ConnectionDB.realizarConsulta(sql);
List <Direccion> lista = new List <Direccion>();
foreach (DataRow fila in dt.Rows)
{
Direccion add = new Direccion();
add.idAddres = Convert.ToInt32(fila[0].ToString());
add.idUser = Convert.ToInt32(fila[1].ToString());
add.address = fila[2].ToString();
lista.Add(add);
}
return(lista);
}
public static List <Direccion> getLista(APPUSER u)
{
string sql = string.Format("SELECT ad.idAddress, ad.address FROM ADDRESS ad " +
"WHERE idUser = {0}", u.idUser);
DataTable dt = ConnectionDB.realizarConsulta(sql);
List <Direccion> lista = new List <Direccion>();
foreach (DataRow fila in dt.Rows)
{
Direccion add = new Direccion();
add.idAddres = Convert.ToInt32(fila[0].ToString());
add.idUser = u.idUser;
add.address = fila[1].ToString();
lista.Add(add);
}
return(lista);
}
public static List <APPUSER> GetLista()
{
string sql = "SELECT * from appuser";
DataTable dt = ConnectionDB.realizarConsulta(sql);
List <APPUSER> lista = new List <APPUSER>();
foreach (DataRow fila in dt.Rows)
{
APPUSER user = new APPUSER();
user.idUser = Convert.ToInt32(fila[0].ToString());
user.fullname = fila[1].ToString();
user.username = fila[2].ToString();
user.password = fila[3].ToString();
user.type = Convert.ToBoolean(fila[4].ToString());
lista.Add(user);
}
return(lista);
}
public static List <Orden> getOListP(int pidUser)
{
string sql = $"SELECT ao.idOrder, ao.createDate, pr.idProduct, ad.idAddress " +
"FROM APPORDER ao, ADDRESS ad, PRODUCT pr, APPUSER au " +
"WHERE ao.idProduct = pr.idProduct " +
"AND ao.idAddress = ad.idAddress " +
"AND ad.idUser = au.idUser " +
$"AND au.idUser = {pidUser};";
var dt = ConnectionDB.realizarConsulta(sql);
List <Orden> lista = new List <Orden>();
foreach (DataRow fila in dt.Rows)
{
Orden orden = new Orden();
orden.idOrder = Convert.ToInt32(fila[0].ToString());
orden.createOrder = Convert.ToDateTime(fila[1]);
orden.idProduct = Convert.ToInt32(fila[2].ToString());
orden.idAdress = Convert.ToInt32(fila[3].ToString());
lista.Add(orden);
}
return(lista);
}
