public static List<LocalSupplier> GetCompleteSupplierList() { string RMDBLocation = Properties.Settings.Default.RMDBLocation; List<LocalSupplier> suppliers = new List<LocalSupplier>(); 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 supplier_id, supplier from Supplier"; SyncCmd.CommandText = commandText; dbReader = SyncCmd.ExecuteReader(); if (dbReader.HasRows) { while (dbReader.Read()) { LocalSupplier newSupplier = new LocalSupplier(); newSupplier.supplier_code = dbReader.GetValue(0).ToString(); newSupplier.name = dbReader.GetString(1); suppliers.Add(newSupplier); } } dbReader.Close(); RMDBconnection.Close(); } catch (Exception ex) { throw; } return suppliers; }
/// <remarks/> public void UpdateSuppliersAsync(int storeID, string password, LocalSupplier[] suppliers) { this.UpdateSuppliersAsync(storeID, password, suppliers, null); }
/// <remarks/> public void UpdateSuppliersAsync(int storeID, string password, LocalSupplier[] suppliers, object userState) { if ((this.UpdateSuppliersOperationCompleted == null)) { this.UpdateSuppliersOperationCompleted = new System.Threading.SendOrPostCallback(this.OnUpdateSuppliersOperationCompleted); } this.InvokeAsync("UpdateSuppliers", new object[] { storeID, password, suppliers}, this.UpdateSuppliersOperationCompleted, userState); }
public ItemResponse UpdateSuppliers(int storeID, string password, LocalSupplier[] suppliers) { object[] results = this.Invoke("UpdateSuppliers", new object[] { storeID, password, suppliers}); return ((ItemResponse)(results[0])); }