private void PopulateComboBoxes()
{
Employee emp = new Employee();
EmployeeCollection empCol = new EmployeeCollection();
SalesPerson sp = new SalesPerson();
// DataSet ds = null;
try
{
//Employee combo box.
//ds = emp.GetAllEmployeesDataSet();
empCol = emp.GetAllEmployeesCollection();
emp.EmployeeID = 0;
emp.FullName = "<Select One>";
emp.FirstName = "";
emp.LastName = "";
empCol.Insert(0, emp);
cmbEmployeeName.DataSource = empCol;
cmbEmployeeName.DisplayMember = "FullName";
cmbEmployeeName.ValueMember = "EmployeeID";
//DataTable dt = ds.Tables[0];
//DataRow dr = dt.NewRow();
//dr["EmployeeID"] = "0";
//dr["FullName"] = "<Select One>";
//dt.Rows.InsertAt(dr, 0);
//cmbEmployeeName.DataSource = dt;
//cmbEmployeeName.DisplayMember = "FullName";
//cmbEmployeeName.ValueMember = "EmployeeID";
//sale person comb box
DataSet dsSalePerson = sp.GetAllSalesPersonViewDataSet();
DataTable dtSalePerson = dsSalePerson.Tables[0];
DataRow drSalePerson = dtSalePerson.NewRow();
drSalePerson["SalesPersonID"] = "0";
drSalePerson["FullName"] = "<Select One>";
dtSalePerson.Rows.InsertAt(drSalePerson, 0);
cmbSalesPerson.DataSource = dtSalePerson;
cmbSalesPerson.DisplayMember = "FullName";
cmbSalesPerson.ValueMember = "SalesPersonID";
foreach (DataRow drow in dtSalePerson.Rows)
{
string item = drow["SalesPersonID"].ToString();
string name = drow["FullName"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "MICS", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error);
}
finally
{
//ds = null;
}
}
private void PopulateGrids()
{
SalesPerson sp = new SalesPerson();
SalesTerritoryHistory hist = new SalesTerritoryHistory();
DataSet ds = null;
try
{
//sale person grid
ds = sp.GetAllSalesPersonViewDataSet();
DataTable dt = ds.Tables[0];
dt.Columns.Remove("FirstName");
dt.Columns.Remove("LastName");
dt.Columns.Remove("MiddleName");
dt.Columns[0].ColumnName = "ID";
dt.Columns[1].ColumnName = "Name";
dt.Columns[2].ColumnName = "Quota";
dt.Columns[3].ColumnName = "Bonus";
dt.Columns[4].ColumnName = "Commission";
dgSalesPerson.DataSource = dt;
//sale territory grid
ds = hist.GetSalesTerritoryBySalesPerson();
dtTerritoryList = ds.Tables[0];
dgTerritoryList.DataSource = dtTerritoryList;
dgTerritoryList.Columns["ID"].Visible = false;
dgTerritoryList.Columns["territoryid"].Visible = false;
dgTerritoryList.Columns["SalesPersonID"].Visible = false;
//ds = hist.GetSalesTerritoryHistoryViewDataSet();
//dt = ds.Tables[0];
//int i = 0;
//TerritoryHistId = new int[dT.Rows.Count];
//foreach (DataRow dr in dt.Rows
//{
// TerritoryHistId[i+ ] = Int32.Parse(dr["ID"].ToString());
//}
//dt.Columns.Remove("SalesPersonID");
//dt.Columns.Remove("ID");
//dt.Columns[0].ColumnName = "ID";
//dt.Columns[1].ColumnName = "Territory";
//dt.Columns[2].ColumnName = "Sale Person";
//dt.Columns[3].ColumnName = "Start Date";
//dt.Columns[4].ColumnName = "End Date";
//dgTerritoryList.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
}
}