private void Save()
{
int employeeId = Int32.Parse(hdfEmployeeId.Value);
hdfUpdate.Value = "yes";
// Add salesman role
if ((rbtnAdd.Checked) && (ckbxSalesmanAdd.Checked))
{
// ...Update employee
EmployeeNavigator employeeNavigator = new EmployeeNavigator(employeeNavigatorTDS);
employeeNavigator.UpdateSalesman(employeeId, true);
// ...Update Salesman
string idForProjects = tbxSalesmanIdForProjects.Text.Trim();
SalesmanNavigator salesmanNavigator = new SalesmanNavigator(employeeNavigatorTDS);
salesmanNavigator.Update(employeeId, idForProjects);
}
// Remove salesman
if ((rbtnRemove.Checked) && (ckbxSalesmanRemove.Checked))
{
// ...Update employee
EmployeeNavigator employeeNavigator = new EmployeeNavigator(employeeNavigatorTDS);
employeeNavigator.UpdateSalesman(employeeId, false);
}
Session["employeeNavigatorTDS"] = employeeNavigatorTDS;
// Save to database
DB.Open();
DB.BeginTransaction();
try
{
EmployeeNavigator employeeNavigator = new EmployeeNavigator(employeeNavigatorTDS);
employeeNavigator.Save();
SalesmanNavigator salesmanNavigator = new SalesmanNavigator(employeeNavigatorTDS);
salesmanNavigator.Save();
DB.CommitTransaction();
// Store datasets
employeeNavigatorTDS.AcceptChanges();
Session["employeeNavigatorTDS"] = employeeNavigatorTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void BindSalesman()
{
// DataSet
int employeeId = Int32.Parse(hdfEmployeeId.Value);
SalesmanNavigator salesmanNavigator = new SalesmanNavigator(employeeNavigatorTDS);
salesmanNavigator.LoadBySalesmanId(employeeId);
// If salesman dont exists before
if (salesmanNavigator.Table.Rows.Count == 0)
{
// Insert salesman
salesmanNavigator.Insert(employeeId, "");
}
else
{
SalesmanNavigatorGateway salesmanNavigatorGateway = new SalesmanNavigatorGateway(employeeNavigatorTDS);
tbxSalesmanIdForProjects.Text = salesmanNavigatorGateway.GetIdForProjects(employeeId);
}
// Store dataset
Session["employeeNavigatorTDS"] = employeeNavigatorTDS;
}
