public static List<LocalItem> GetRecentlyModifiedItemList()
{
string RMDBLocation = Properties.Settings.Default.RMDBLocation;
DateTime lastSync = Helpers.GetLastSync();
List<LocalItem> itemList = new List<LocalItem>();
if (lastSync != DateTime.MinValue)
{
try
{
OleDbConnection RMDBconnection = null;
OleDbDataReader dbReader = null;
RMDBconnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source=" + RMDBLocation);
RMDBconnection.Open();
OleDbCommand syncCmd = RMDBconnection.CreateCommand();
//Get items.
string commandText = "SELECT stock_id, Barcode, description, cost, sell, quantity, static_quantity, supplier_id from Stock where stock_id > 0 and date_modified > ? ";
syncCmd.CommandText = commandText;
syncCmd.Parameters.Add("@date_modified", OleDbType.Date).Value = lastSync;
dbReader = syncCmd.ExecuteReader();
if (dbReader.HasRows)
{
while (dbReader.Read())
{
LocalItem newItem = new LocalItem();
newItem.product_code = dbReader.GetValue(0).ToString();
newItem.product_barcode = dbReader.GetValue(1).ToString();
newItem.description = (string)dbReader.GetValue(2);
newItem.cost_price = dbReader.GetDecimal(3);
newItem.sale_price = dbReader.GetDecimal(4);
newItem.quantity = dbReader.GetDouble(5);
newItem.is_static = dbReader.GetBoolean(6);
int supplierID = dbReader.GetInt32(7);
if (supplierID != 0)
{
newItem.supplier_code = supplierID.ToString();
}
itemList.Add(newItem);
}
}
dbReader.Close();
RMDBconnection.Close();
}
catch (Exception ex)
{
throw;
}
}
Helpers.CreateSyncTimestamp();
return itemList;
}
public static List<LocalItem> GetCompleteItemList()
{
string RMDBLocation = Properties.Settings.Default.RMDBLocation;
List<LocalItem> itemList = new List<LocalItem>();
try
{
OleDbConnection RMDBconnection = null;
OleDbDataReader dbReader = null;
RMDBconnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source=" + RMDBLocation);
RMDBconnection.Open();
OleDbCommand SyncCmd = RMDBconnection.CreateCommand();
//Get customers.
string commandText = "SELECT stock_id, Barcode, description, cost, sell, quantity, static_quantity, supplier_id from Stock where stock_id > 0";
SyncCmd.CommandText = commandText;
dbReader = SyncCmd.ExecuteReader();
if (dbReader.HasRows)
{
while (dbReader.Read())
{
LocalItem newItem = new LocalItem();
newItem.product_code = dbReader.GetValue(0).ToString();
newItem.product_barcode = dbReader.GetValue(1).ToString();
newItem.description = (string)dbReader.GetValue(2);
newItem.cost_price = dbReader.GetDecimal(3);
newItem.sale_price = dbReader.GetDecimal(4);
newItem.quantity = dbReader.GetDouble(5);
newItem.is_static = dbReader.GetBoolean(6);
int supplierID = dbReader.GetInt32(7);
newItem.supplier_code = supplierID.ToString();
itemList.Add(newItem);
}
}
dbReader.Close();
RMDBconnection.Close();
}
catch (Exception ex)
{
throw;
}
Helpers.CreateSyncTimestamp();
return itemList;
}