public void ExportTerritories() { SqlCompactConnection conn = new SqlCompactConnection(); SalesTerritory ter = new SalesTerritory(); try { SalesTerritoryCollection colTerr = ter.GetAllSalesTerritoryCollection(); conn.SynchForm = this; conn.DropSalesTerritoryTable(); conn.CreateTerritoryTable(); conn.AddSalesTerritory(colTerr); ter = null; colTerr = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.CloseDatabase(); conn = null; } }
private void LoadTerritoris() { SalesTerritory terr = new SalesTerritory(); SalesTerritoryCollection terrCol = new SalesTerritoryCollection(); try { terrCol = terr.GetAllSalesTerritoryCollection(); terr.TerritoryID = 0; terr.Name = "All"; terr.ModifiedDate = DateTime.Now; terrCol.Insert(0, terr); cmbTerritory.DataSource = terrCol; cmbTerritory.DisplayMember = "Name"; cmbTerritory.ValueMember = "TerritoryID"; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { terr = null; } }
private void PopulateTerritories(int selectedID) { SalesTerritory st = new SalesTerritory(); colTerritories = new SalesTerritoryCollection(); try { colTerritories = st.GetAllSalesTerritoryCollection(); gridTerritory.DataSource = colTerritories; gridTerritory.Columns.Remove("ModifiedDate"); gridTerritory.Columns["TerritoryID"].Visible = false; gridTerritory.Columns.Remove("CountryRegionCode"); int index = 0; foreach (SalesTerritory t in colTerritories) { if (t.TerritoryID == selectedID) { gridTerritory.Rows[index].Selected = true; gridTerritory.FirstDisplayedScrollingRowIndex = index; break; } index++; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Sales Territory", MessageBoxButtons.OK, MessageBoxIcon.Error); } }