public static List <AppOrder> getListaUser(int userId) { string sql = String.Format( $"select ao.\"idOrder\", ao.\"createDate\", pr.\"name\", au.\"fullname\", ad.\"address\"" + $" from \"AppOrder\" ao, \"Product\" pr, \"AppUser\" au, \"Address\" ad" + $" where ao.\"idProduct\"= pr.\"idProduct\" and ao.\"idAddress\" = ad.\"idAddress\"" + " and ad.\"idUser\"= au.\"idUser\"and au.\"idUser\"={0};", userId); DataTable dt = ConnectionBD.ExecuteQuery(sql); List <AppOrder> lista = new List <AppOrder>(); foreach (DataRow row in dt.Rows) { AppOrder o = new AppOrder(); o.idOrder = Convert.ToInt32(row[0].ToString()); o.createDate = DateTime.Parse(row[1].ToString()); o.idAddress = Convert.ToInt32(row[2].ToString()); o.idProduct = Convert.ToInt32(row[3].ToString()); lista.Add(o); } return(lista); }
public static List <AppOrder> getLista() { string query = $"select ao.\"idOrder\", ao.\"createDate\", pr.\"name\", au.\"fullname\", ad.\"address\"" + $" from \"AppOrder\" ao, \"Product\" pr, \"AppUser\" au, \"Address\" ad" + $" where ao.\"idProduct\"= pr.\"idProduct\" and ao.\"idAddress\" = ad.\"idAddress\"" + $" and ad.\"idUser\"= au.\"idUser\""; DataTable dt = ConnectionBD.ExecuteQuery(query); List <AppOrder> lista = new List <AppOrder>(); foreach (DataRow row in dt.Rows) { AppOrder o = new AppOrder(); lista.Add(o); } return(lista); }
public static List <Product> getLista() { string query = "select * from \"Product\" order by \"idBusiness\", \"idProduct\""; DataTable dt = ConnectionBD.ExecuteQuery(query); List <Product> lista = new List <Product>(); foreach (DataRow row in dt.Rows) { Product p = new Product(); p.idProduct = Convert.ToInt32(row[0].ToString()); p.idBusiness = Convert.ToInt32(row[1].ToString()); p.name = row[2].ToString(); lista.Add(p); } return(lista); }
public static List <Business> getLista() { string query = "Select * from \"Business\""; DataTable dt = ConnectionBD.ExecuteQuery(query); List <Business> lista = new List <Business>(); foreach (DataRow row in dt.Rows) { Business b = new Business(); b.idBusiness = Convert.ToInt32(row[0].ToString()); b.name = row[1].ToString(); b.description = row[2].ToString(); lista.Add(b); } return(lista); }
public static List <AppUser> getLista() { string query = "select * from \"AppUser\""; DataTable dt = ConnectionBD.ExecuteQuery(query); List <AppUser> lista = new List <AppUser>(); foreach (DataRow row in dt.Rows) { AppUser u = new AppUser(); u.id_User = Convert.ToInt32(row[0].ToString()); u.fullname = row[1].ToString(); u.username = row[2].ToString(); u.password = row[3].ToString(); u.admin = Convert.ToBoolean(row[4].ToString()); lista.Add(u); } return(lista); }
public static List <Address> getLista(int idUser) { string query = String.Format("SELECT * FROM \"Address\" INNER JOIN \"AppUser\" ON \"AppUser\".\"idUser\" = \"Address\".\"idUser\" where \"AppUser\".\"idUser\" = '{0}';", idUser); DataTable dt = ConnectionBD.ExecuteQuery(query); List <Address> lista = new List <Address>(); foreach (DataRow row in dt.Rows) { Address a = new Address(); a.idAddress = Convert.ToInt32(row[0].ToString()); a.idUser = Convert.ToInt32(row[1].ToString()); a.address = row[2].ToString(); lista.Add(a); } return(lista); }