/// <summary>
/// Save
/// </summary>
public void Save()
{
EmployeeNavigatorTDS salesmanNavigatorChanges = (EmployeeNavigatorTDS)Data.GetChanges();
if (salesmanNavigatorChanges.SalesmanNavigator.Rows.Count > 0)
{
SalesmanNavigatorGateway salesmanNavigatorGateway = new SalesmanNavigatorGateway(salesmanNavigatorChanges);
// Update employees
foreach (EmployeeNavigatorTDS.SalesmanNavigatorRow row in (EmployeeNavigatorTDS.SalesmanNavigatorDataTable)salesmanNavigatorChanges.SalesmanNavigator)
{
Salesman salesman = new Salesman(null);
if (!row.InDatabase)
{
string idForProjects = ""; if (!row.IsIdForProjectsNull()) idForProjects = row.IdForProjects;
salesman.InsertDirect(row.SalesmanID, idForProjects);
}
else
{
int salesmanId = row.SalesmanID;
string originalIdForProjects = salesmanNavigatorGateway.GetIdForProjectsOriginal(salesmanId);
string newIdForProjects = salesmanNavigatorGateway.GetIdForProjects(salesmanId);
salesman.UpdateDirect(salesmanId, originalIdForProjects, newIdForProjects);
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadBySalesmanId
/// </summary>
/// <param name="salesmanId">salesmanId</param>
public void LoadBySalesmanId(int salesmanId)
{
SalesmanNavigatorGateway salesmanNavigatorGateway = new SalesmanNavigatorGateway(Data);
salesmanNavigatorGateway.LoadBySalesmanId(salesmanId);
}
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;
}