/************************************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);
}