private void StepSortProcessGrid()
{
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.LFS_WORK_TYPE_VIEW_SORT.Merge(workTypeViewSort, true);
WorkTypeViewSort model = new WorkTypeViewSort(dataSet);
// update rows
if (Session["workTypeViewSortDummy"] == null)
{
foreach (GridViewRow row in grdSort.Rows)
{
int sortId = int.Parse(grdSort.DataKeys[row.RowIndex].Values["SortID"].ToString());
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
int order = 0;
try
{
order = int.Parse(((DropDownList)row.FindControl("ddlOrder")).SelectedValue);
}
catch
{
order = 0;
}
model.Update(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), sortId, order, selected);
}
model.Table.AcceptChanges();
workTypeViewSort = (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)model.Table;
Session["workTypeViewSort"] = workTypeViewSort;
}
}
private bool StepLogicNext()
{
Page.Validate("Logic");
if (Page.IsValid)
{
// Load
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.LFS_WORK_TYPE_VIEW_SORT.Merge(workTypeViewSort, true);
WorkTypeViewSort model = new WorkTypeViewSort(dataSet);
if (dataSet.LFS_WORK_TYPE_VIEW_SORT.Rows.Count <= 0)
{
model.LoadByWorkTypeInView(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), true);
}
// Store tables
workTypeViewSort = (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)model.Table;
Session["workTypeViewSort"] = workTypeViewSort;
return true;
}
else
{
return false;
}
}
private bool StepSortByNext()
{
ViewState["sortPageIndex"] = grdSort.PageIndex;
Page.Validate("SortBy");
if (Page.IsValid)
{
StepSortProcessGrid();
workViewSortTemp.Rows.Clear();
// create dataset
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.LFS_WORK_TYPE_VIEW_SORT.Merge(workTypeViewSort, true);
dataSet.WorkViewSortTemp.Merge(workViewSortTemp, true);
// process sort by
WorkViewSortTemp model = new WorkViewSortTemp(dataSet);
model.Process(int.Parse(hdfViewId.Value), hdfWorkType.Value, int.Parse(hdfCompanyId.Value));
// get changes
workViewSortTemp.Rows.Clear();
workViewSortTemp.Merge(model.Table);
// store tables
Session.Remove("workTypeViewSortDummy");
Session["workTypeViewSort"] = workTypeViewSort;
Session["workViewSortTemp"] = workViewSortTemp;
return true;
}
else
{
return false;
}
}
private void StepColumnsToDisplayProcessGrid()
{
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.LFS_WORK_TYPE_VIEW_DISPLAY.Merge(workTypeViewDisplay, true);
WorkTypeViewDisplay model = new WorkTypeViewDisplay(dataSet);
// update rows
if (Session["workTypeViewDisplayDummy"] == null)
{
foreach (GridViewRow row in grdColumnsToDisplay.Rows)
{
int displayId = int.Parse(grdColumnsToDisplay.DataKeys[row.RowIndex].Values["DisplayID"].ToString());
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
model.Update(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), displayId, selected);
}
model.Table.AcceptChanges();
workTypeViewDisplay = (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)model.Table;
Session["workTypeViewDisplay"] = workTypeViewDisplay;
}
}
private bool StepConditionsNext()
{
// Validate data
bool validData = true;
// Edit if there is data to save
Page.Validate("ConditionsUpdate");
if (!Page.IsValid) validData = false;
if (validData)
{
// Conditions Gridview, if the gridview is edition mode
if (grdConditions.EditIndex >= 0)
{
grdConditions.UpdateRow(grdConditions.EditIndex, true);
grdConditions.DataBind();
}
}
Page.Validate("ConditionsNext");
if (!Page.IsValid) validData = false;
if (validData)
{
// Add conditions if exists at footer
if (ValidateFooterNext())
{
GrdConditionsAdd();
}
// create dataset
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
// process new conditions
WorkViewConditionNew model = new WorkViewConditionNew(dataSet);
tbxLogic.Text = model.GetConditionsByDefault();
// get changes
workViewConditionNew.Rows.Clear();
workViewConditionNew.Merge(model.Table);
// store tables
Session.Remove("workViewConditionNewDummy");
Session["workViewConditionNew"] = workViewConditionNew;
hdfStep.Value = "StepConditions";
return true;
}
else
{
return false;
}
}
protected void grdConditions_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
int conditionId = 0; conditionId = int.Parse(((DropDownList)e.Row.FindControl("ddlName")).SelectedValue);
DropDownList ddlOperator = ((DropDownList)e.Row.FindControl("ddlOperator"));
if (conditionId > 0)
{
DropDownList ddlConditionNumber = ((DropDownList)e.Row.FindControl("ddlConditionNumber"));
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
WorkViewConditionNew model = new WorkViewConditionNew(dataSet);
int conditionNumber = model.GetNewConditionNumber();
ddlConditionNumber.SelectedValue = conditionNumber.ToString();
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(hdfWorkType.Value, conditionId, int.Parse(hdfCompanyId.Value));
string type = workTypeViewConditionGateway.GetType(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), conditionId);
if (ddlOperator.SelectedItem == null)
{
WorkTypeViewOperatorList workTypeViewOperatorList = new WorkTypeViewOperatorList(new DataSet());
workTypeViewOperatorList.LoadAndAddItem(type, Int32.Parse(hdfCompanyId.Value));
ddlOperator.DataSource = workTypeViewOperatorList.Table;
ddlOperator.DataValueField = "Sign";
ddlOperator.DataTextField = "Operator";
ddlOperator.DataBind();
ddlOperator.SelectedIndex = 0;
}
if ((type == "String") || (type == "Date") || (type == "Int") || (type == "Decimal") || (type == "Distance"))
{
ddlOperator.Enabled = true;
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = true;
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = false;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = false;
}
if ((type == "FixedItems") || (type == "DynamicItems") || (type == "Boolean"))
{
ddlOperator.Enabled = false;
if (type == "FixedItems")
{
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = true;
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = false;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = false;
}
if (type == "DynamicItems")
{
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = true;
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = false;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = false;
}
if (type == "Boolean")
{
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = false;
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = true;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = true;
}
}
}
}
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
WorkViewConditionNewGateway gateway = new WorkViewConditionNewGateway(dataSet);
int id = int.Parse(((Label)e.Row.FindControl("lblId")).Text);
int conditionId = gateway.GetConditionId(id);
DropDownList ddlName = ((DropDownList)e.Row.FindControl("ddlName"));
DropDownList ddlOperator = ((DropDownList)e.Row.FindControl("ddlOperator"));
if (conditionId > 0)
{
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(hdfWorkType.Value, conditionId, int.Parse(hdfCompanyId.Value));
string type = workTypeViewConditionGateway.GetType(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), conditionId);
ddlName.DataBind();
ddlName.SelectedValue = conditionId.ToString();
WorkTypeViewOperatorList workTypeViewOperatorList = new WorkTypeViewOperatorList(new DataSet());
workTypeViewOperatorList.LoadAndAddItem(type, Int32.Parse(hdfCompanyId.Value));
ddlOperator.DataSource = workTypeViewOperatorList.Table;
ddlOperator.DataValueField = "Sign";
ddlOperator.DataTextField = "Operator";
ddlOperator.DataBind();
ddlOperator.SelectedValue = gateway.GetSign(id);
if ((type == "String") || (type == "Date") || (type == "Int") || (type == "Decimal") || (type == "Distance"))
{
ddlOperator.Enabled = true;
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = true;
tbxValue.Text = gateway.GetValue_(id);
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = false;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = false;
}
if ((type == "FixedItems") || (type == "DynamicItems") || (type == "Boolean"))
{
ddlOperator.Enabled = false;
if (type == "FixedItems")
{
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = true;
// Prepare initial data
// ... For view type
WorkTypeViewConditionItemList workTypeViewConditionItemList = new WorkTypeViewConditionItemList(new DataSet());
workTypeViewConditionItemList.LoadAndAddItemInView(hdfWorkType.Value, Int32.Parse(hdfCompanyId.Value), conditionId);
ddlValue.DataSource = workTypeViewConditionItemList.Table;
ddlValue.DataValueField = "Name";
ddlValue.DataTextField = "Name";
ddlValue.DataBind();
ddlValue.SelectedValue = gateway.GetValue_(id);
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = false;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = false;
}
if (type == "DynamicItems")
{
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = true;
// Prepare initial data
// ... For view type
WorkTypeViewSubAreaList workTypeViewSubAreaList = new WorkTypeViewSubAreaList(new DataSet());
workTypeViewSubAreaList.LoadAndAddItem(hdfWorkType.Value, Int32.Parse(hdfCompanyId.Value), int.Parse(hdfProjectId.Value));
if (workTypeViewSubAreaList.Table.Rows.Count > 0)
{
ddlValue.DataSource = workTypeViewSubAreaList.Table;
ddlValue.DataValueField = "SubArea";
ddlValue.DataTextField = "SubArea";
ddlValue.DataBind();
ddlValue.SelectedValue = gateway.GetValue_(id);
}
else
{
ddlValue.Visible = false;
}
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = false;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = false;
}
if (type == "Boolean")
{
DropDownList ddlValue = ((DropDownList)e.Row.FindControl("ddlValue"));
ddlValue.Visible = false;
TextBox tbxValue = ((TextBox)e.Row.FindControl("tbxValue"));
tbxValue.Visible = false;
RadioButton rbtnYes = ((RadioButton)e.Row.FindControl("rbtnYes"));
rbtnYes.Visible = true;
RadioButton rbtnNo = ((RadioButton)e.Row.FindControl("rbtnNo"));
rbtnNo.Visible = true;
if (gateway.GetValue_(id) == "Yes")
{
rbtnYes.Checked = true;
}
else
{
rbtnNo.Checked = true;
}
}
}
}
}
}
private bool StepConditionsNext()
{
// Validate data
bool validData = true;
// Edit if there is data to save
Page.Validate("ConditionsUpdate");
if (!Page.IsValid) validData = false;
if (validData)
{
// Conditions Gridview, if the gridview is edition mode
if (grdConditions.EditIndex >= 0)
{
grdConditions.UpdateRow(grdConditions.EditIndex, true);
grdConditions.DataBind();
}
}
Page.Validate("ConditionsNext");
if (!Page.IsValid) validData = false;
if (validData)
{
// Add conditions if exists at footer
if (ValidateFooterNext())
{
GrdConditionsAdd();
}
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(int.Parse(hdfViewId.Value), int.Parse(hdfCompanyId.Value));
workViewConditionTemp.Rows.Clear();
// create dataset
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
dataSet.WorkViewConditionTemp.Merge(workViewConditionTemp, true);
// process conditions
WorkViewConditionTemp model = new WorkViewConditionTemp(dataSet);
WorkViewConditionNew modelLogic = new WorkViewConditionNew(dataSet);
string originalLogic = workViewGateway.GetLogic(int.Parse(hdfViewId.Value));
string newLogic = modelLogic.GetConditionsByDefault();
ArrayList aConditions = new ArrayList();
aConditions = modelLogic.GetConditions();
bool isConditionsUpdate = false;
if (originalLogic.Trim() != newLogic.Trim())
{
foreach (string conditionNumber in aConditions)
{
if (!originalLogic.Contains(conditionNumber))
{
isConditionsUpdate = true;
}
}
if (!isConditionsUpdate)
{
if (Session["conditionsUpdate"] != null)
{
if (Session["conditionsUpdate"].ToString() == "true")
{
isConditionsUpdate = true;
}
}
}
}
else
{
tbxLogic.Text = originalLogic.Trim();
}
if (isConditionsUpdate)
{
tbxLogic.Text = newLogic.Trim();
}
else
{
tbxLogic.Text = originalLogic.Trim();
}
// get changes
workViewConditionNew.Rows.Clear();
workViewConditionNew.Merge(modelLogic.Table);
workViewConditionTemp.Rows.Clear();
workViewConditionTemp.Merge(model.Table);
//// store tables
Session.Remove("workViewConditionNewDummy");
Session.Remove("workViewConditionTempDummy");
Session["workViewConditionNew"] = workViewConditionNew;
Session["workViewConditionTemp"] = workViewConditionTemp;
Session["conditionsUpdate"] = null;
return true;
}
else
{
return false;
}
}
private void GrdConditionsAdd()
{
if (ValidateFooterAdd())
{
Page.Validate("Conditions");
if (Page.IsValid)
{
int conditionId = int.Parse(((DropDownList)grdConditions.FooterRow.FindControl("ddlName")).SelectedValue);
string name = ((DropDownList)grdConditions.FooterRow.FindControl("ddlName")).SelectedItem.Text;
string operator_ = ((DropDownList)grdConditions.FooterRow.FindControl("ddlOperator")).SelectedItem.Text;
string sign = ((DropDownList)grdConditions.FooterRow.FindControl("ddlOperator")).SelectedValue;
int conditionNumber = int.Parse(((DropDownList)grdConditions.FooterRow.FindControl("ddlConditionNumber")).SelectedValue);
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(hdfWorkType.Value, conditionId, int.Parse(hdfCompanyId.Value));
string type = workTypeViewConditionGateway.GetType(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), conditionId);
string value = "";
if ((type == "String") || (type == "Date") || (type == "Int") || (type == "Decimal") || (type == "Distance"))
{
value = ((TextBox)grdConditions.FooterRow.FindControl("tbxValue")).Text;
}
if ((type == "FixedItems") || (type == "DynamicItems"))
{
value = ((DropDownList)grdConditions.FooterRow.FindControl("ddlValue")).SelectedItem.Text;
}
if (type == "Boolean")
{
if (((RadioButton)grdConditions.FooterRow.FindControl("rbtnYes")).Checked)
value = "Yes";
if (((RadioButton)grdConditions.FooterRow.FindControl("rbtnNo")).Checked)
value = "No";
}
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
WorkViewConditionNew model = new WorkViewConditionNew(dataSet);
model.Insert(conditionId, name, operator_, sign, conditionNumber, value, false, false);
Session.Remove("workViewConditionNewDummy");
workViewConditionNew = dataSet.WorkViewConditionNew;
Session["workViewConditionNew"] = dataSet.WorkViewConditionNew;
grdConditions.DataBind();
grdConditions.PageIndex = grdConditions.PageCount - 1;
}
}
}
private void Save()
{
// process view
WorkViewTDS dataset = new WorkViewTDS();
dataset.WorkViewDisplayTemp.Merge(workViewDisplayTemp, true);
dataset.WorkViewConditionNew.Merge(workViewConditionNew, true);
dataset.WorkViewSortTemp.Merge(workViewSortTemp, true);
WorkViewDisplayTemp modelWorkViewDisplayTemp = new WorkViewDisplayTemp(dataset);
WorkViewConditionNew modelWorkViewConditionNew = new WorkViewConditionNew(dataset);
WorkViewSortTemp modelWorkViewSortTemp = new WorkViewSortTemp(dataset);
// get parameters
int viewId = int.Parse(hdfViewId.Value);
int companyId = int.Parse(hdfCompanyId.Value);
int loginId = Convert.ToInt32(Session["loginID"]);
string name = tbxName.Text;
string type = ddlType.SelectedValue;
string logic = tbxLogic.Text;
string sqlCommand = GetSqlCommand();
string workType = hdfWorkType.Value;
if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"])))
{
if ((string)Request.QueryString["fm_type"] == "Rehab Assessment")
{
if (Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]))
{
type = "Personal";
}
}
if ((string)Request.QueryString["fm_type"] == "Full Length Lining")
{
if (Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]))
{
type = "Personal";
}
}
if ((string)Request.QueryString["fm_type"] == "Junction Lining")
{
if (Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"]))
{
type = "Personal";
}
}
if ((string)Request.QueryString["fm_type"] == "Point Repairs")
{
if (Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"]))
{
type = "Personal";
}
}
if ((string)Request.QueryString["fm_type"] == "Manhole Repairs")
{
if (Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_VIEW"]))
{
type = "Personal";
}
}
}
// save to database
DB.Open();
DB.BeginTransaction();
try
{
WorkView workView = new WorkView(null);
workView.InsertDirect(viewId, loginId, name, type, logic, sqlCommand, workType, false, companyId);
modelWorkViewDisplayTemp.Save();
modelWorkViewConditionNew.Save(viewId, companyId, workType);
modelWorkViewSortTemp.Save(viewId, workType, companyId);
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private string GetOrder()
{
// process view
WorkViewTDS dataset = new WorkViewTDS();
dataset.WorkViewSortTemp.Merge(workViewSortTemp, true);
WorkViewSortTemp modelWorkSortTemp = new WorkViewSortTemp(dataset);
string orderClause = "";
orderClause = modelWorkSortTemp.GetSortForSql();
if (orderClause == "")
{
orderClause = "AASS.AssetID";
}
return orderClause;
}
private string GetWhere()
{
// process view
WorkViewTDS dataset = new WorkViewTDS();
dataset.WorkViewConditionNew.Merge(workViewConditionNew, true);
WorkViewConditionNew modelWorkViewConditionNew = new WorkViewConditionNew(dataset);
string whereClause = "";
whereClause = modelWorkViewConditionNew.ParserLogic(tbxLogic.Text, hdfWorkType.Value, int.Parse(hdfCompanyId.Value));
return whereClause;
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["work_type"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in view_add.aspx");
}
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"])))
{
if ((string)Request.QueryString["work_type"] == "Rehab Assessment")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
if ((string)Request.QueryString["work_type"] == "Full Length Lining")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
if ((string)Request.QueryString["work_type"] == "Junction Lining")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
if ((string)Request.QueryString["work_type"] == "Point Repairs")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
if ((string)Request.QueryString["work_type"] == "Manhole Rehabilitation")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
// Tag page
hdfWorkType.Value = (string)Request.QueryString["work_type"];
hdfProjectId.Value = (string)Request.QueryString["project_id"];
hdfCompanyId.Value = Session["companyID"].ToString();
hdfUpdate.Value = "no";
ViewState["columnsToDisplayPageIndex"] = 0;
ViewState["sortPageIndex"] = 0;
Session.Remove("workTypeViewDisplay");
Session.Remove("workTypeViewDisplayDummy");
Session.Remove("workTypeViewSort");
Session.Remove("workTypeViewSortDummy");
Session.Remove("workViewDisplayTemp");
Session.Remove("workViewSortTemp");
Session.Remove("workViewConditionNew");
Session.Remove("workViewConditionNewDummy");
WorkViewGateway workViewGateway = new WorkViewGateway();
hdfViewId.Value = (workViewGateway.GetLastViewId()+1).ToString().Trim();
// Prepare initial data
// ... For view type
WorkViewTypeList workViewTypeList = new WorkViewTypeList(new DataSet());
workViewTypeList.LoadAndAddItem("(Select a type)", Int32.Parse(hdfCompanyId.Value));
ddlType.DataSource = workViewTypeList.Table;
ddlType.DataValueField = "Type";
ddlType.DataTextField = "Type";
ddlType.DataBind();
ddlType.SelectedIndex = 0;
// ... Global Views check
if (!Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_ADD"]))
{
ddlType.Items.Remove("Global");
}
// If coming from
// ... ra_navigator.aspx, ra_navigator2.aspx, fl_navigator.aspx, fl_navigator2.aspx, jl_navigator.aspx, jl_navigator2.aspx, pr_navigator.aspx or pr_navigator2.aspx , mr_navigator.aspx, mr_navigator2.aspx
if ((Request.QueryString["source_page"] == "ra_navigator.aspx") || (Request.QueryString["source_page"] == "ra_navigator2.aspx") || (Request.QueryString["source_page"] == "fl_navigator.aspx") || (Request.QueryString["source_page"] == "fl_navigator2.aspx") || (Request.QueryString["source_page"] == "jl_navigator.aspx") || (Request.QueryString["source_page"] == "jl_navigator2.aspx") || (Request.QueryString["source_page"] == "pr_navigator.aspx") || (Request.QueryString["source_page"] == "pr_navigator2.aspx") || (Request.QueryString["source_page"] == "mr_navigator.aspx") || (Request.QueryString["source_page"] == "mr_navigator2.aspx"))
{
// ... For Grids
workViewTDS = new WorkViewTDS();
workTypeViewDisplay = new WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable();
workTypeViewSort = new WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable();
workViewDisplayTemp = new WorkViewTDS.WorkViewDisplayTempDataTable();
workViewSortTemp = new WorkViewTDS.WorkViewSortTempDataTable();
workViewConditionNew = new WorkViewTDS.WorkViewConditionNewDataTable();
// ... Store datasets
Session["workViewTDS"] = workViewTDS;
Session["workTypeViewDisplay"] = workTypeViewDisplay;
Session["workTypeViewSort"] = workTypeViewSort;
Session["workViewDisplayTemp"] = workViewDisplayTemp;
Session["workViewSortTemp"] = workViewSortTemp;
Session["workViewConditionNew"] = workViewConditionNew;
}
// StepSection1In
wzViews.ActiveStepIndex = 0;
StepBeginIn();
}
else
{
// Restore datasets
workViewTDS = (WorkViewTDS)Session["workViewTDS"];
workTypeViewDisplay = (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)Session["workTypeViewDisplay"];
workTypeViewSort = (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)Session["workTypeViewSort"];
workViewDisplayTemp = (WorkViewTDS.WorkViewDisplayTempDataTable)Session["workViewDisplayTemp"];
workViewSortTemp = (WorkViewTDS.WorkViewSortTempDataTable)Session["workViewSortTemp"];
workViewConditionNew = (WorkViewTDS.WorkViewConditionNewDataTable)Session["workViewConditionNew"];
}
// control for postback
hdfTag.Value = DateTime.Now.ToLongTimeString();
}
protected void grdConditions_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("ConditionsUpdate");
if (Page.IsValid)
{
int id = (int)e.Keys["ID"];
int conditionId = int.Parse(((DropDownList)grdConditions.Rows[e.RowIndex].Cells[3].FindControl("ddlName")).SelectedValue);
string name = ((DropDownList)grdConditions.Rows[e.RowIndex].Cells[3].FindControl("ddlName")).SelectedItem.Text;
DropDownList ddlOperator = ((DropDownList)grdConditions.Rows[grdConditions.EditIndex].FindControl("ddlOperator"));
string operator_ = ddlOperator.SelectedItem.Text;
string sign = ddlOperator.SelectedValue;
int conditionNumber = int.Parse(((DropDownList)grdConditions.Rows[e.RowIndex].Cells[2].FindControl("ddlConditionNumber")).SelectedValue);
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(hdfWorkType.Value, conditionId, int.Parse(hdfCompanyId.Value));
string type = workTypeViewConditionGateway.GetType(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), conditionId);
string value = "";
if ((type == "String") || (type == "Date") || (type == "Int") || (type == "Decimal") || (type == "Distance"))
{
value = ((TextBox)grdConditions.Rows[e.RowIndex].Cells[5].FindControl("tbxValue")).Text;
}
if ((type == "FixedItems") || (type == "DynamicItems"))
{
value = ((DropDownList)grdConditions.Rows[e.RowIndex].Cells[5].FindControl("ddlValue")).SelectedItem.Text;
}
if (type == "Boolean")
{
if (((RadioButton)grdConditions.Rows[e.RowIndex].Cells[5].FindControl("rbtnYes")).Checked)
value = "Yes";
if (((RadioButton)grdConditions.Rows[e.RowIndex].Cells[5].FindControl("rbtnNo")).Checked)
value = "No";
}
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
WorkViewConditionNew model = new WorkViewConditionNew(dataSet);
model.Update(id, conditionId, name, operator_, sign, conditionNumber, value, false, false);
Session["workViewConditionNew"] = dataSet.WorkViewConditionNew;
workViewConditionNew = dataSet.WorkViewConditionNew;
}
else
{
e.Cancel = true;
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP3 - CONDITIONS
//
// ////////////////////////////////////////////////////////////////////////
// STEP3 - CONDITIONS - EVENTS
//
protected void grdConditions_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Conditions Gridview, if the gridview is edition mode
if (grdConditions.EditIndex >= 0)
{
grdConditions.UpdateRow(grdConditions.EditIndex, true);
}
// Delete conditions
int id = (int)e.Keys["ID"];
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
WorkViewConditionNew model = new WorkViewConditionNew(dataSet);
model.Delete(id);
Session["workViewConditionNew"] = dataSet.WorkViewConditionNew;
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP6 - SUMMARY
//
// ////////////////////////////////////////////////////////////////////////
// STEP6 - SUMMARY - METHODS
//
private void StepSummaryIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Summary";
// Tag Page
hdfStep.Value = "StepSummary";
hdfUpdate.Value = "yes";
// Initialize summary
WorkView workView = new WorkView(workViewTDS);
// process view
WorkViewTDS dataset = new WorkViewTDS();
dataset.WorkViewDisplayTemp.Merge(workViewDisplayTemp, true);
dataset.WorkViewConditionNew.Merge(workViewConditionNew, true);
dataset.WorkViewSortTemp.Merge(workViewSortTemp, true);
WorkViewDisplayTemp modelWorkViewDisplayTemp = new WorkViewDisplayTemp(dataset);
WorkViewConditionNew modelWorkViewConditionNew = new WorkViewConditionNew(dataset);
WorkViewSortTemp modelWorkViewSortTemp = new WorkViewSortTemp(dataset);
string summary = "";
summary = summary + "Name: " + tbxName.Text + "\n\n";
summary = summary + "Columns To Display; " + modelWorkViewDisplayTemp.GetColumnsToDisplay() + "\n\n";
summary = summary + "Conditions: " + modelWorkViewConditionNew.GetConditionsForSummary(hdfWorkType.Value, int.Parse(hdfCompanyId.Value)) + "\n\n";
summary = summary + "Logical Expression: " + tbxLogic.Text + "\n\n";
summary = summary + "Order by: " + modelWorkViewSortTemp.GetSortForSummary() + "\n\n";
tbxSummary.Text = summary;
}
private bool StepBeginNext()
{
Page.Validate("StepBegin");
if (Page.IsValid)
{
// Load
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.LFS_WORK_TYPE_VIEW_DISPLAY.Merge(workTypeViewDisplay, true);
WorkTypeViewDisplay model = new WorkTypeViewDisplay(dataSet);
if (dataSet.LFS_WORK_TYPE_VIEW_DISPLAY.Rows.Count <= 0)
{
model.LoadByWorkType(hdfWorkType.Value, int.Parse(hdfCompanyId.Value));
}
// Store tables
workTypeViewDisplay = (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)model.Table;
Session["workTypeViewDisplay"] = workTypeViewDisplay;
return true;
}
return false;
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP4 - LOGIC
//
// ////////////////////////////////////////////////////////////////////////
// STEP4 - LOGIC - AUXILIAR EVENTS
//
protected void cvLogic_ServerValidate(object source, ServerValidateEventArgs args)
{
LogicValidator logicValidator = new LogicValidator();
string message;
ArrayList conditions = new ArrayList();
// create dataset
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
// process new conditions
WorkViewConditionNew model = new WorkViewConditionNew(dataSet);
conditions = model.GetConditions();
// get changes
workViewConditionNew.Rows.Clear();
workViewConditionNew.Merge(model.Table);
// store tables
Session["workViewConditionNew"] = workViewConditionNew;
if (conditions.Count > 0)
{
bool bOk = logicValidator.Validate(tbxLogic.Text, conditions, out message);
if (bOk)
{
args.IsValid = true;
}
else
{
args.IsValid = false;
cvLogic.ErrorMessage = message;
}
}
else
{
if (tbxLogic.Text == "")
{
args.IsValid = true;
}
else
{
args.IsValid = false;
cvLogic.ErrorMessage = "There are no conditions, The logical expression must be empty";
}
}
}
private bool StepColumnsToDisplayNext()
{
ViewState["columnsToDisplayPageIndex"] = grdColumnsToDisplay.PageIndex;
Page.Validate("ColumsToDisplay");
if (Page.IsValid)
{
StepColumnsToDisplayProcessGrid();
workViewDisplayTemp.Rows.Clear();
// create dataset
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.LFS_WORK_TYPE_VIEW_DISPLAY.Merge(workTypeViewDisplay, true);
dataSet.WorkViewDisplayTemp.Merge(workViewDisplayTemp, true);
// process new sections
WorkViewDisplayTemp model = new WorkViewDisplayTemp(dataSet);
model.Process(int.Parse(hdfViewId.Value), hdfWorkType.Value, int.Parse(hdfCompanyId.Value));
// get changes
workViewDisplayTemp.Rows.Clear();
workViewDisplayTemp.Merge(model.Table);
// store tables
Session.Remove("workTypeViewDisplayDummy");
Session["workTypeViewDisplay"] = workTypeViewDisplay;
Session["workViewDisplayTemp"] = workViewDisplayTemp;
return true;
}
else
{
return false;
}
}
/// <summary>
/// InitData.
/// </summary>
protected override void InitData()
{
_data = new WorkViewTDS();
}
private bool StepColumnsToDisplayNext()
{
ViewState["columnsToDisplayPageIndex"] = grdColumnsToDisplay.PageIndex;
Page.Validate("ColumsToDisplay");
if (Page.IsValid)
{
hdfStep.Value = "StepColumnsToDisplay";
StepColumnsToDisplayProcessGrid();
workViewDisplayTemp.Rows.Clear();
// create dataset
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.LFS_WORK_TYPE_VIEW_DISPLAY.Merge(workTypeViewDisplay, true);
dataSet.WorkViewDisplayTemp.Merge(workViewDisplayTemp, true);
// process
WorkViewDisplayTemp model = new WorkViewDisplayTemp(dataSet);
model.ProcessForEdit(int.Parse(hdfViewId.Value), hdfWorkType.Value, int.Parse(hdfCompanyId.Value));
// get changes
workViewDisplayTemp.Rows.Clear();
workViewDisplayTemp.Merge(model.Table);
// store tables
Session.Remove("workTypeViewDisplayDummy");
Session["workTypeViewDisplay"] = workTypeViewDisplay;
Session["workViewDisplayTemp"] = workViewDisplayTemp;
// load conditions for next step
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
dataSet.WorkViewConditionTemp.Merge(workViewConditionTemp, true);
WorkViewConditionNew modelConditionNew = new WorkViewConditionNew(dataSet);
modelConditionNew.LoadByViewIdCompanyIdWorkType(int.Parse(hdfViewId.Value), int.Parse(hdfCompanyId.Value), hdfWorkType.Value);
// Store tables
workViewConditionNew = (WorkViewTDS.WorkViewConditionNewDataTable)modelConditionNew.Table;
Session["workViewConditionNew"] = workViewConditionNew;
return true;
}
else
{
return false;
}
}
