private MrNavigatorTDS SubmitSearch()
{
// Retrieve clauses
string whereClause = GetWhereClause();
string orderByClause = GetOrderByClause();
string workType = hdfWorkType.Value.Trim();
string conditionValue1 = "";
string conditionValue2 = "";
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
bool inProject = bool.Parse(hdfInProject.Value);
MrNavigator mrNavigator = new MrNavigator();
// ... Load data
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId);
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
mrNavigator.Load(whereClause, orderByClause, conditionValue1, conditionValue2, tbxCondition1.Text.Trim(), tbxCondition2.Text.Trim(), companyId, currentProjectId, workType, inProject);
return (MrNavigatorTDS)mrNavigator.Data;
}
private MrNavigatorTDS SubmitSearchForViews()
{
string sqlCommand = "";
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
MrNavigator mrNavigator = new MrNavigator();
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
bool inProject = bool.Parse(hdfInProject.Value);
// ... Load SqlCommand
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
sqlCommand = workViewGateway.GetSqlCommand(viewId);
// ... Load data
mrNavigator.LoadForViewsProjectIdCompanyIdWorkType(sqlCommand, currentProjectId, companyId, workType, inProject);
return (MrNavigatorTDS)mrNavigator.Data;
}
private void PostPageChanges()
{
MrNavigator mrNavigator = new MrNavigator(mrNavigatorTDS);
// Update navigator rows
foreach (GridViewRow row in grdMRNavigator.Rows)
{
string assetIdLabel = ((Label)row.FindControl("lblAssetId")).Text.Trim();
int assetId = Int32.Parse(assetIdLabel.ToString().Trim());
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
mrNavigator.Update(assetId, selected);
}
mrNavigator.Data.AcceptChanges();
// Store datasets
Session["mrNavigatorTDS"] = mrNavigatorTDS;
}
