private FlNavigatorTDS SubmitSearch()
{
// Retrieve clauses
string whereClause = GetWhereClause();
string orderByClause = GetOrderByClause();
string conditionValue1 = "";
string conditionValue2 = "";
string name = "";
FlNavigator flNavigator = new FlNavigator();
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
// ... Load data for condition 1
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId);
name = workTypeViewConditionGateway.GetName(workType, companyId, int.Parse(ddlCondition1.SelectedValue));
conditionValue1 = workTypeViewConditionGateway.GetColumn_(workType, companyId, int.Parse(ddlCondition1.SelectedValue));
// ... If condition 2 exists
if (ddlCondition2.SelectedValue != "-1")
{
// ... Load data for condition 2
WorkTypeViewConditionGateway workTypeViewConditionGateway2 = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway2.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition2.SelectedValue), companyId);
conditionValue2 = workTypeViewConditionGateway2.GetColumn_(workType, companyId, int.Parse(ddlCondition2.SelectedValue));
}
// ... Load data
flNavigator.Load(whereClause, orderByClause, conditionValue1, tbxCondition1.Text.Trim(), conditionValue2, tbxCondition2.Text.Trim(), companyId, currentProjectId, workType, name);
return (FlNavigatorTDS)flNavigator.Data;
}
private FlNavigatorTDS SubmitSearchForViews()
{
string sqlCommand = "";
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
FlNavigator flNavigator = new FlNavigator();
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
flNavigator.LoadForViewsProjectIdCompanyIdWorkType(sqlCommand, currentProjectId, companyId, workType);
return (FlNavigatorTDS)flNavigator.Data;
}
private void PostPageChanges()
{
FlNavigator flNavigator = new FlNavigator(flNavigatorTDS);
// Update navigator rows
foreach (GridViewRow row in grdFLNavigator.Rows)
{
string assetIdLabel = ((Label)row.FindControl("lblAssetId")).Text.Trim();
//int assetId = Int32.Parse(assetIdLabel.ToString().Trim());
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
flNavigator.Update(assetIdLabel, selected);
}
flNavigator.Data.AcceptChanges();
// Store datasets
Session["flNavigatorTDS"] = flNavigatorTDS;
}