public static async Task <StockItem> RetrieveBySkuCode(String skuCode) { StockItem stockItem = new StockItem(); string sqlCmdString = "Select * From dbo.stock_items Where item_sku_code = @item_sku_code"; Database myDb = new Database(); SqlCommand sqlCmd = new SqlCommand(sqlCmdString, myDb.Connection); SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlCmd); DataTable table = new DataTable(); await Task.Run(() => { try { myDb.OpenConnection(); sqlCmd.Parameters.Add(new SqlParameter("@item_sku_code", skuCode)); sqlAdapt.Fill(table); foreach (DataRow row in table.Rows) { stockItem = new StockItem() { ItemSkuCode = (string)row["item_sku_code"], ItemRate = Convert.ToInt32(row["item_rate"]), StockQty = Convert.ToInt32(row["stock_qty"]), ItemName = (string)row["item_name"], //ItemDescription = (String)(reader["item_description"] == null ? "" : reader["item_description"]), IsPersist = true }; } } finally { sqlAdapt.Dispose(); table.Dispose(); myDb.CloseConnection(); } }); return(stockItem); }
public static async Task<StockItem> RetrieveBySkuCode(String skuCode) { StockItem stockItem = new StockItem(); string sqlCmdString = "Select * From dbo.stock_items Where item_sku_code = @item_sku_code"; Database myDb = new Database(); SqlCommand sqlCmd = new SqlCommand(sqlCmdString, myDb.Connection); SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlCmd); DataTable table = new DataTable(); await Task.Run(() => { try { myDb.OpenConnection(); sqlCmd.Parameters.Add(new SqlParameter("@item_sku_code", skuCode)); sqlAdapt.Fill(table); foreach (DataRow row in table.Rows) { stockItem = new StockItem() { ItemSkuCode = (string)row["item_sku_code"], ItemRate = Convert.ToInt32(row["item_rate"]), StockQty = Convert.ToInt32(row["stock_qty"]), ItemName = (string)row["item_name"], //ItemDescription = (String)(reader["item_description"] == null ? "" : reader["item_description"]), IsPersist = true }; } } finally { sqlAdapt.Dispose(); table.Dispose(); myDb.CloseConnection(); } }); return stockItem; }
private void but_AddItem_Click(object sender, RoutedEventArgs e) { StockItem item = new StockItem() { ItemName = NewItem.ItemName, ItemSkuCode = NewItem.ItemSkuCode, ItemRate = NewItem.ItemRate, ItemDescription = NewItem.ItemDescription, StockQty = NewItem.StockQty }; StockItems.Add(item); NewItems.Add(item); NewItem = new StockItem(); }
public static async Task<List<StockItem>> RetrieveAllStockItems() { List<StockItem> itemList = new List<StockItem>(); string sqlCmdString = "Select * From dbo.stock_items"; Database myDb = new Database(); SqlCommand sqlCmd = new SqlCommand(sqlCmdString, myDb.Connection); SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlCmd); DataTable table = new DataTable(); StockItem item = null; await Task.Run(() => { try { myDb.OpenConnection(); sqlAdapt.Fill(table); foreach (DataRow row in table.Rows) { item = new StockItem() { ItemSkuCode = row["item_sku_code"] as String, ItemRate = Convert.ToInt32(row["item_rate"]), StockQty = Convert.ToInt32(row["stock_qty"]), ItemName = row["item_name"] as String, ItemDescription = row["item_description"] as String, IsPersist = true }; itemList.Add(item); } } finally { sqlAdapt.Dispose(); table.Dispose(); myDb.CloseConnection(); } }); return itemList; }