public SalesTerritoryCollection GetAllSalesTerritorysDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritorysDynamic"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SalesTerritoryCollection GetAllSalesTerritorysCollection() { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritoryAll"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
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); } }