private EmployeeNavigatorTDS SubmitSearch()
{
// Retrieve clauses
string whereClause = GetWhereClause();
string orderByClause = GetOrderByClause();
string conditionValue = "";
EmployeeNavigator employeeNavigator = new EmployeeNavigator();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string resourceType = hdfResourceType.Value.Trim();
// ... Load data
ResourceTypeViewConditionGateway resourceTypeViewConditionGateway = new ResourceTypeViewConditionGateway();
resourceTypeViewConditionGateway.LoadByResourceTypeConditionId(resourceType, companyId, int.Parse(ddlCondition1.SelectedValue));
conditionValue = resourceTypeViewConditionGateway.GetColumn_(resourceType, companyId, int.Parse(ddlCondition1.SelectedValue));
employeeNavigator.Load(whereClause, orderByClause, conditionValue, tbxCondition1.Text.Trim(), companyId, resourceType);
return (EmployeeNavigatorTDS)employeeNavigator.Data;
}
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 PostPageChanges()
{
EmployeeNavigator employeeNavigator = new EmployeeNavigator(employeeNavigatorTDS);
// Update
foreach (GridViewRow row in grdNavigator.Rows)
{
int employeeId = Int32.Parse(((Label)row.FindControl("lblEmployeeId")).Text.Trim());
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
employeeNavigator.Update(employeeId, selected);
}
employeeNavigator.Data.AcceptChanges();
// Store datasets
Session["employeeNavigatorTDS"] = employeeNavigatorTDS;
}
private void Delete()
{
int currentEmployeeId = int.Parse(hdfCurrentEmployeeId.Value);
// Delete type history
EmployeeInformationTDS employeeInformationTDS = new EmployeeInformationTDS();
EmployeeInformationTypeHistoryInformation employeeInformationTypeHistoryInformation = new EmployeeInformationTypeHistoryInformation(employeeInformationTDS);
employeeInformationTypeHistoryInformation.DeleteAll(currentEmployeeId);
// Delete employee
EmployeeNavigator employeeNavigator = new EmployeeNavigator(employeeNavigatorTDS);
employeeNavigator.Delete(currentEmployeeId);
// Store datasets
Session["employeeNavigatorTDS"] = employeeNavigatorTDS;
Session["employeeInformationTDS"] = employeeInformationTDS;
}
