/************************************Inventory************************************************************/ public void Load(object sender, EventArgs e) { _view = (InventoryForm)((InventoryForm)sender).FindForm(); servicesTable = franchisee_inventory.getServices(user.getFranchiseeId(_view.getUser())); productsTable = franchisee_inventory.getProducts(user.getFranchiseeId(_view.getUser())); DataTable categoryTable = category.get(); DataTable supplierTable = supplier.get(); _view.getCategory().DataSource = categoryTable; _view.getCategory().DisplayMember = "type"; _view.getCategory().ValueMember = "id"; _view.getSupplier().DataSource = supplierTable; _view.getSupplier().DisplayMember = "name"; _view.getSupplier().ValueMember = "service_id"; fillProductcombo(); fillServicecombo(); try { _view.SetProductsTable(productsTable); _view.SetServicesTable(servicesTable); } catch (InvalidCastException ef) { MessageBox.Show("Incorrect data was loaded in this form."); } }
public syncController(int UserId) { FranchiseeID = _users.getFranchiseeId(UserId.ToString()); String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); con.Open(); SqlCommand Franchisee_command = new SqlCommand("SELECT franchisee_id, company_name FROM Franchisee WHERE franchisee_id = " + FranchiseeID, con); SqlDataReader reader = Franchisee_command.ExecuteReader(); reader.Read(); String[] Franchisee_data = new String[2] { reader[0].ToString(), reader[1].ToString() }; XML = new InspectionData(Franchisee_data); }