public List<Cart> GetCarts()
{
List<Cart> carts = new List<Cart>();
DataSet ds = new DataSet();
DataSetTableAdapters.cartsTableAdapter adapter = new DataSetTableAdapters.cartsTableAdapter();
adapter.Fill(ds.carts);
DataSet.cartsDataTable table = adapter.GetCartData();
// load all carts into the list
foreach (DataSet.cartsRow row in table.Rows)
{
// create memory for new cart & fill in properties
Cart c = new Cart();
c = FillCart(row);
// add this cart to the list
carts.Add(c);
}
// returns the list w/ 0 or more Carts
return carts;
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns>A cart if found; null if cart not found</returns>
public Cart GetCartByUserName(String userName)
{
DataSet ds = new DataSet();
DataSetTableAdapters.cartsTableAdapter adapter = new DataSetTableAdapters.cartsTableAdapter();
adapter.Fill(ds.carts);
Cart c = new Cart();
// find the cart
DataSet.cartsDataTable table = adapter.GetCartByUserName(userName);
// if a cart was found, then fill in the details
if (table.Rows.Count > 0)
{
// use the 1st row's data
DataSet.cartsRow row = (DataSet.cartsRow)table.Rows[0];
c = FillCart(row);
return c;
}
else
{
return null;
}
}
public int InsertCart(Cart c)
{
return InsertCart(c.UserName, c.Details, c.CatalogId);
}
public int DeleteCart(Cart c)
{
return DeleteCart(c.UserName);
}
private Cart FillCart(DataSet.cartsRow row)
{
Cart c = new Cart();
c.UserName = row.userName;
c.CatalogId = row.catalogId;
try
{
c.Details = row.details;
}
catch (StrongTypingException)
{
c.Details = "";
}
return c;
}
public int UpdateCart(Cart c)
{
return UpdateCart(c.UserName, c.Details, c.CatalogId);
}
