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