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