/// <remarks/>
public System.IAsyncResult BeginUpdateInventoryCount(InventoryCount[] inventoryCountList, System.AsyncCallback callback, object asyncState) {
return this.BeginInvoke("UpdateInventoryCount", new object[] {
inventoryCountList}, callback, asyncState);
}
public static void SendInventoryCount()
{
Int16 iWrittenToDB = 0;
using (var cnn = new SQLiteConnection(Common.getDBConnection()))
{
try
{
string sql = "";
SasolWax.OneMobileWS_Wax.InventoryCount inventoryCountItem;
DataTable dtInventoryCount = new DataTable();
SQLiteCommand cmd = new SQLiteCommand(cnn);
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
cnn.Open();
if (IsTableExists(cnn, "InventoryCount"))
{
sql = "SELECT * FROM InventoryCount;";
cmd.CommandText = sql;
da.Fill(dtInventoryCount);
List<SasolWax.OneMobileWS_Wax.InventoryCount> iCountList = new List<SasolWax.OneMobileWS_Wax.InventoryCount>();
foreach (DataRow dr in dtInventoryCount.Rows)
{
inventoryCountItem = new InventoryCount();
inventoryCountItem.dBagWeight = Convert.ToDecimal(dr["dBagWeight"].ToString());
inventoryCountItem.dtCount = Convert.ToDateTime(dr["dtCount"].ToString());
inventoryCountItem.iBagStation = dr["iBagStation"].ToString();
inventoryCountItem.iCountQuantity = Convert.ToInt32(dr["iCountQuantity"].ToString());
inventoryCountItem.ifkUser = Convert.ToInt16(dr["ifkUser"].ToString());
inventoryCountItem.ifkVersion = Convert.ToInt16(dr["ifkVersion"].ToString());
inventoryCountItem.ipk = Convert.ToInt32(dr["ipk"].ToString());
inventoryCountItem.sBatchCode = dr["sBatchCode"].ToString();
inventoryCountItem.sSerial = dr["sSerial"].ToString();
inventoryCountItem.sStockCode = dr["sStockCode"].ToString();
inventoryCountItem.sWarehouse = dr["sWarehouse"].ToString();
inventoryCountItem.gUID = new Guid(dr["gUID"].ToString().Trim());
iCountList.Add(inventoryCountItem);
iWrittenToDB++;
}
cnn.Close();
Common.wsWax.UpdateInventoryCount(iCountList.ToArray());
}
}
catch (System.Exception ex)
{
}
}
}
public void UpdateInventoryCount(InventoryCount[] inventoryCountList) {
this.Invoke("UpdateInventoryCount", new object[] {
inventoryCountList});
}