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