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