public IEnumerable <Product> Get() { try { //i added a new Procedure to get the products DataTable dt = db.GetData("GET_ALL_PRODUCTS", "<parameters></parameters>"); var result = (from rw in dt.Select() select new Product { PRODUCTID = Convert.ToInt32(rw["PRODUCTID"]), PRODNAME = Convert.ToString(rw["PRODNAME"]), BUYPRICE = Convert.ToDecimal(rw["BUYPRICE"]), SELLPRICE = Convert.ToDecimal(rw["SELLPRICE"]) }).ToList(); return(result); } catch (Exception ex) { throw ex; } }
public IEnumerable <account> Get() { try { //i added a new Procedure to get the accounts DataTable dt = db.GetData("GET_ALL_ACCOUNTS", "<parameters></parameters>"); var result = (from rw in dt.Select() select new account { ACCOUNTID = Convert.ToInt32(rw["ACCOUNTID"]), ACCTNAME = Convert.ToString(rw["ACCTNAME"]), BALANCE = Convert.ToDecimal(rw["BALANCE"]), CREDITLIMIT = Convert.ToDecimal(rw["CREDITLIMIT"]) }).ToList(); return(result); } catch (Exception ex) { throw ex; } }
public IEnumerable <Location> Get() { try { //i added a new Procedure to get the locations DataTable dt = db.GetData("GET_ALL_LOCATIONS", "<parameters></parameters>"); var result = (from rw in dt.Select() select new Location { LOCATIONID = Convert.ToString(rw["LOCATIONID"]), LOCNAME = Convert.ToString(rw["LOCNAME"]), ADDRESS = Convert.ToString(rw["ADDRESS"]), MANAGER = Convert.ToString(rw["MANAGER"]) }).ToList(); return(result); } catch (Exception ex) { throw ex; } }
public IEnumerable <order> Get() { try { //i changed the procedure because im not really sure what to do with a cursor in this context. DataTable dt = db.GetData("GET_OPEN_ORDERS", "<parameters></parameters>"); var result = (from rw in dt.Select() select new order { ORDERID = Convert.ToInt32(rw["ORDERID"]), SHIPPINGADDRESS = Convert.ToString(rw["SHIPPINGADDRESS"]), DATETIMECREATED = Convert.ToString(rw["DATETIMECREATED"]), DATETIMEDISPATCHED = Convert.ToString(rw["DATETIMEDISPATCHED"]), TOTAL = Convert.ToDecimal(rw["TOTAL"]), USERID = Convert.ToInt32(rw["USERID"]) }).ToList(); return(result); } catch (Exception ex) { throw ex; } }