private RaNavigatorTDS SubmitSearch() { // Retrieve clauses string whereClause = GetWhereClause(); string orderByClause = GetOrderByClause(); string workType = hdfWorkType.Value.Trim(); string conditionValue = ""; int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); RaNavigator raNavigator = new RaNavigator(); // ... Load data WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway(); workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId); conditionValue = workTypeViewConditionGateway.GetColumn_(workType, companyId, int.Parse(ddlCondition1.SelectedValue)); raNavigator.Load(whereClause, orderByClause, conditionValue, tbxCondition1.Text.Trim(), companyId, currentProjectId, workType); return (RaNavigatorTDS)raNavigator.Data; }
private RaNavigatorTDS SubmitSearchForViews() { string sqlCommand = ""; int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); RaNavigator raNavigator = new RaNavigator(); string workType = hdfWorkType.Value.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); // ... Load SqlCommand WorkViewGateway workViewGateway = new WorkViewGateway(); workViewGateway.LoadByViewId(viewId, companyId); sqlCommand = workViewGateway.GetSqlCommand(viewId); // ... Load data raNavigator.LoadForViewsProjectIdCompanyIdWorkType(sqlCommand, currentProjectId, companyId, workType); return (RaNavigatorTDS)raNavigator.Data; }
private void PostPageChanges() { RaNavigator raNavigator = new RaNavigator(raNavigatorTDS); // Update grid rows foreach (GridViewRow row in grdRANavigator.Rows) { string assetIdLabel = ((Label)row.FindControl("lblAssetId")).Text.Trim(); int assetId = Int32.Parse(assetIdLabel.ToString().Trim()); bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; raNavigator.Update(assetId, selected); } raNavigator.Data.AcceptChanges(); // Store datasets Session["raNavigatorTDS"] = raNavigatorTDS; }