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