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