public static List <AppOrder> getListaAppOrder(string iduser)
{
string sql = String.Format(
"SELECT ao.idorder, ao.createdate, pr.name, au.fullname, ad.address " +
"FROM APPORDER ao, ADRESS ad, PRODUCT pr, APPUSER au " +
$"WHERE ao.idproduct =pr.idproduct " +
$"AND ao.idadress =ad.idadress " +
$"AND ad.iduser =au.iduser " +
$"AND au.iduser ='******'; ", iduser);
DataTable dt = ConexionDB.RealizarConsulta(sql);
List <AppOrder> listaAppOrders = new List <AppOrder>();
foreach (DataRow fila in dt.Rows)
{
AppOrder qp = new AppOrder();
qp.idorder = fila[0].ToString();
qp.createdate = Convert.ToDateTime(fila[1].ToString());
qp.idproduct = fila[2].ToString();
qp.idadress = fila[3].ToString();
listaAppOrders.Add(qp);
}
return(listaAppOrders);
}
public static List <Business> getLista()
{
string sql = "select * from business";
DataTable dt = ConexionDB.RealizarConsulta(sql);
List <Business> list = new List <Business>();
foreach (DataRow fila in dt.Rows)
{
Business b = new Business();
b.idbusiness = Convert.ToInt32(fila[0].ToString());
b.name = fila[1].ToString();
b.description = fila[2].ToString();
list.Add(b);
}
return(list);
}
public static List <Adress> getLista()
{
string sql = "select * from adress";
DataTable dt = ConexionDB.RealizarConsulta(sql);
List <Adress> listAdress = new List <Adress>();
foreach (DataRow fila in dt.Rows)
{
Adress ad = new Adress();
ad.idadress = fila[0].ToString();
ad.iduser = fila[1].ToString();
ad.address = fila[2].ToString();
listAdress.Add(ad);
}
return(listAdress);
}
public static List <Product> getLista()
{
string sql = "select * from product";
DataTable dt = ConexionDB.RealizarConsulta(sql);
List <Product> lis = new List <Product>();
foreach (DataRow fila in dt.Rows)
{
Product p = new Product();
p.idproduct = fila[0].ToString();
p.idbusiness = fila[1].ToString();
p.name = fila[2].ToString();
lis.Add(p);
}
return(lis);
}
public static List <AppOrder> getLista()
{
string sql = "select * from apporder";
DataTable dt = ConexionDB.RealizarConsulta(sql);
List <AppOrder> listOrders = new List <AppOrder>();
foreach (DataRow fila in dt.Rows)
{
AppOrder ap = new AppOrder();
ap.idorder = fila[0].ToString();
ap.createdate = Convert.ToDateTime(fila[1].ToString());
ap.idproduct = fila[2].ToString();
ap.idadress = fila[3].ToString();
listOrders.Add(ap);
}
return(listOrders);
}
public static List <AppUser> getLista()
{
string sql = "select * from appuser";
DataTable dt = ConexionDB.RealizarConsulta(sql);
List <AppUser> lista = new List <AppUser>();
foreach (DataRow fila in dt.Rows)
{
AppUser us = new AppUser();
us.iduser = fila[0].ToString();
us.fullname = fila[1].ToString();
us.username = fila[2].ToString();
us.password = fila[3].ToString();
us.usertype = Convert.ToBoolean(fila[4].ToString());
lista.Add(us);
}
return(lista);
}
public static List <Adress> getListaAdress(string idur)
{
string sql = String.Format(
"select ad.idadress, ad.address from adress ad where iduser = '******';",
idur);
DataTable dt = ConexionDB.RealizarConsulta(sql);
List <Adress> listaAdress = new List <Adress>();
foreach (DataRow fila in dt.Rows)
{
Adress a = new Adress();
a.idadress = fila[0].ToString();
a.address = fila[1].ToString();
listaAdress.Add(a);
}
return(listaAdress);
}
