public static List <StockReal> sel(Guid IdEstablishment) { List <StockReal> r = new List <StockReal>(); List <object[]> l = new ClassDB(null).queryResonse("SELECT * FROM StockReal WHERE Establishment_CustomerId='" + IdEstablishment + "'"); r = ListObjToStockReal(l); return(r); }
public static Guid getProdCustomerId(string CodeBar) { string cmd = "SELECT CustumerId FROM Products WHERE CodeBare ='" + CodeBar + "'"; List <object[]> o = new ClassDB(null).queryResonse(cmd); if (o.Count > 0) { return((Guid)o[0][0]); } else { return(Guid.Empty); } }
public static List <Establishment> sel() { List <object[]> l = new ClassDB(null).queryResonse("SELECT * FROM Establishment"); List <Establishment> res_ = new List <Establishment>(); foreach (var o in l) { Establishment res = new Establishment(); res.CustomerId = (Guid)o[0]; res.Type = (int)o[1]; res.Name = (string)o[2]; res.CP = (string)o[3]; res.Ville = (string)o[4]; res.Adresse = (string)o[5]; res.Phone = (string)o[6]; res.Mail = (string)o[7]; res_.Add(res); } return(res_); }