/// <summary>
/// SaveForEdit
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="loginId">loginId</param>
/// <param name="name">name</param>
/// <param name="type">type</param>
/// <param name="logic">logic</param>
/// <param name="sqlCommand">sqlCommand</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
public void SaveForEdit(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string workType, int companyId, string newName, string newType)
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
int originalViewId = viewId;
int originalLoginId = workViewGateway.GetLoginId(viewId);
string originalName = workViewGateway.GetName(viewId);
string originalType = workViewGateway.GetType(viewId);
string originalLogic = workViewGateway.GetLogic(viewId);
string originalSqlCommand = workViewGateway.GetSqlCommand(viewId);
string originalWorkType = workViewGateway.GetWorkType(viewId);
bool originalDeleted = workViewGateway.GetDeleted(viewId);
int originalCompanyId = workViewGateway.GetCompanyId(viewId);
UpdateDirect(originalViewId, originalLoginId, originalName, originalType, originalLogic, originalSqlCommand, originalWorkType, originalDeleted, originalCompanyId, viewId, loginId, newName, newType, logic, sqlCommand, workType, false, companyId);
}
protected void btnViewDelete_Click(object sender, EventArgs e)
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
if (!Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_DELETE"]))
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
string viewType = workViewGateway.GetType(viewId);
if (viewType == "Global")
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
UpdateDatabaseForViews();
// ... For view ddl
string workType = hdfWorkType.Value;
int loginId = Convert.ToInt32(Session["loginID"]);
string viewTypeGlobal = "";
string viewTypePersonal = "Personal";
// Global Views check
if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
{
viewTypeGlobal = "Global";
}
WorkViewList workViewList = new WorkViewList();
workViewList.LoadAndAddItem(workType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
ddlView.DataSource = workViewList.Table;
ddlView.DataValueField = "ViewID";
ddlView.DataTextField = "Name";
ddlView.DataBind();
ddlView.SelectedIndex = 1;
}
// ////////////////////////////////////////////////////////////////////////
// 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) || ((string)Request.QueryString["view_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in view_edit.aspx");
}
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_EDIT"])))
{
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"];
hdfCompanyId.Value = Session["companyID"].ToString();
hdfViewId.Value = (string)Request.QueryString["view_id"];
hdfProjectId.Value = (string)Request.QueryString["project_id"];
int viewId = int.Parse(hdfViewId.Value);
int companyId = int.Parse(hdfCompanyId.Value);
hdfUpdate.Value = "no";
// Security check for global views
if (!(Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_EDIT"])))
{
if ((string)Request.QueryString["work_type"] == "Rehab Assessment")
{
if (Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]))
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(Int32.Parse(hdfViewId.Value), Int32.Parse(hdfCompanyId.Value));
string viewType = workViewGateway.GetType(Int32.Parse(hdfViewId.Value));
if (viewType == "Global")
{
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"]))
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(Int32.Parse(hdfViewId.Value), Int32.Parse(hdfCompanyId.Value));
string viewType = workViewGateway.GetType(Int32.Parse(hdfViewId.Value));
if (viewType == "Global")
{
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"]))
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(Int32.Parse(hdfViewId.Value), Int32.Parse(hdfCompanyId.Value));
string viewType = workViewGateway.GetType(Int32.Parse(hdfViewId.Value));
if (viewType == "Global")
{
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"]))
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(Int32.Parse(hdfViewId.Value), Int32.Parse(hdfCompanyId.Value));
string viewType = workViewGateway.GetType(Int32.Parse(hdfViewId.Value));
if (viewType == "Global")
{
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"]))
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(Int32.Parse(hdfViewId.Value), Int32.Parse(hdfCompanyId.Value));
string viewType = workViewGateway.GetType(Int32.Parse(hdfViewId.Value));
if (viewType == "Global")
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
ViewState["columnsToDisplayPageIndex"] = 0;
ViewState["sortPageIndex"] = 0;
Session.Remove("workTypeViewDisplay");
Session.Remove("workTypeViewDisplayDummy");
Session.Remove("workViewDisplayTemp");
Session.Remove("workViewDisplay");
Session.Remove("workViewConditionNew");
Session.Remove("workViewConditionTemp");
Session.Remove("workViewConditionNewDummy");
Session.Remove("workViewConditionTempDummy");
// Prepare initial data
// ... For view type
WorkViewTypeList workViewTypeList = new WorkViewTypeList(new DataSet());
workViewTypeList.LoadAndAddItem("(Select a type)", int.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_VIEW"]))
{
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();
workViewConditionTemp = new WorkViewTDS.WorkViewConditionTempDataTable();
// Initiaize view data
// ... Loading views and data
WorkViewGateway workViewGateway = new WorkViewGateway(workViewTDS);
workViewGateway.LoadByViewId(viewId, companyId);
tbxName.Text = workViewGateway.GetName(viewId);
ddlType.SelectedValue = workViewGateway.GetType(viewId);
// ... Store datasets
Session["workTypeViewDisplay"] = workTypeViewDisplay;
Session["workTypeViewSort"] = workTypeViewSort;
Session["workViewDisplayTemp"] = workViewDisplayTemp;
Session["workViewSortTemp"] = workViewSortTemp;
Session["workViewConditionNew"] = workViewConditionNew;
Session["workViewConditionTemp"] = workViewConditionTemp;
}
// 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"];
workViewConditionTemp = (WorkViewTDS.WorkViewConditionTempDataTable)Session["workViewConditionTemp"];
}
// control for postback
hdfTag.Value = DateTime.Now.ToLongTimeString();
}