protected void btnViewDelete_Click(object sender, EventArgs e)
{
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
if (!(Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_DELETE"])))
{
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId);
string viewType = fmViewGateway.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 fmType = hdfFmType.Value;
int loginId = Convert.ToInt32(Session["loginID"]);
string viewTypeGlobal = "";
string viewTypePersonal = "Personal";
// Global Views check
if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
{
viewTypeGlobal = "Global";
}
FmViewList fmViewList = new FmViewList();
fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
ddlView.DataSource = fmViewList.Table;
ddlView.DataValueField = "ViewID";
ddlView.DataTextField = "Name";
ddlView.DataBind();
ddlView.SelectedIndex = 1;
}
/// <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="fmType">fmType</param>
/// <param name="companyId">companyId</param>
public void SaveForEdit(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string fmType, int companyId, string newName, string newType)
{
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId);
int originalViewId = viewId;
int originalLoginId = fmViewGateway.GetLoginId(viewId);
string originalName = fmViewGateway.GetName(viewId);
string originalType = fmViewGateway.GetType(viewId);
string originalLogic = fmViewGateway.GetLogic(viewId);
string originalSqlCommand = fmViewGateway.GetSqlCommand(viewId);
string originalFmType = fmViewGateway.GetFmType(viewId);
bool originalDeleted = fmViewGateway.GetDeleted(viewId);
int originalCompanyId = fmViewGateway.GetCompanyId(viewId);
UpdateDirect(originalViewId, originalLoginId, originalName, originalType, originalLogic, originalSqlCommand, originalFmType, originalDeleted, originalCompanyId, viewId, loginId, newName, newType, logic, sqlCommand, fmType, false, companyId);
}
// ////////////////////////////////////////////////////////////////////////
// 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["fm_type"] == 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["fm_type"] == "Services")
{
if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
if ((string)Request.QueryString["fm_type"] == "Units")
{
if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
// Tag page
hdfFmType.Value = (string)Request.QueryString["fm_type"];
hdfCompanyId.Value = Session["companyID"].ToString();
hdfViewId.Value = (string)Request.QueryString["view_id"];
hdfProjectId.Value = (string)Request.QueryString["project_id"];
hdfUpdate.Value = "no";
// Security check for global views
if (!(Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_EDIT"])))
{
if ((string)Request.QueryString["fm_type"] == "Services")
{
if (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"]))
{
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(Int32.Parse(hdfViewId.Value), Int32.Parse(hdfCompanyId.Value));
string viewType = fmViewGateway.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["fm_type"] == "Units")
{
if (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]))
{
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(Int32.Parse(hdfViewId.Value), Int32.Parse(hdfCompanyId.Value));
string viewType = fmViewGateway.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("fmTypeViewDisplay");
Session.Remove("fmTypeViewDisplayDummy");
Session.Remove("fmViewDisplayTemp");
Session.Remove("fmViewDisplay");
Session.Remove("fmViewConditionNew");
Session.Remove("fmViewConditionTemp");
Session.Remove("fmViewConditionNewDummy");
Session.Remove("fmViewConditionTempDummy");
Session.Remove("categoriesTDSForEditView");
// Prepare initial data
// ... For view type
int viewId = Int32.Parse(hdfViewId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
FmViewTypeList fmViewTypeList = new FmViewTypeList(new DataSet());
fmViewTypeList.LoadAndAddItem("(Select a type)", companyId);
ddlType.DataSource = fmViewTypeList.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
// ... services_navigator.aspx, services_navigator2.aspx, units_navigator.aspx or units_navigator2.aspx
if ((Request.QueryString["source_page"] == "services_navigator.aspx") || (Request.QueryString["source_page"] == "services_navigator2.aspx") || (Request.QueryString["source_page"] == "units_navigator.aspx") || (Request.QueryString["source_page"] == "unit_navigator2.aspx"))
{
// ... For Grids
fmViewTDS = new FmViewTDS();
fmTypeViewDisplay = new FmViewTDS.LFS_FM_TYPE_VIEW_DISPLAYDataTable();
fmTypeViewSort = new FmViewTDS.LFS_FM_TYPE_VIEW_SORTDataTable();
fmViewDisplayTemp = new FmViewTDS.FmViewDisplayTempDataTable();
fmViewSortTemp = new FmViewTDS.FmViewSortTempDataTable();
fmViewConditionNew = new FmViewTDS.FmViewConditionNewDataTable();
fmViewConditionTemp = new FmViewTDS.FmViewConditionTempDataTable();
// ... for Categories
categoriesTDS = new CategoriesTDS();
// Initiaize view data
// ... Loading views and data
FmViewGateway fmViewGateway = new FmViewGateway(fmViewTDS);
fmViewGateway.LoadByViewId(viewId, companyId);
tbxName.Text = fmViewGateway.GetName(viewId);
ddlType.SelectedValue = fmViewGateway.GetType(viewId);
// ... Store datasets
Session["fmTypeViewDisplay"] = fmTypeViewDisplay;
Session["fmTypeViewSort"] = fmTypeViewSort;
Session["fmViewDisplayTemp"] = fmViewDisplayTemp;
Session["fmViewSortTemp"] = fmViewSortTemp;
Session["fmViewConditionNew"] = fmViewConditionNew;
Session["fmViewConditionTemp"] = fmViewConditionTemp;
Session["categoriesTDSForEditView"] = categoriesTDS;
}
// StepSection In
wzViews.ActiveStepIndex = 0;
StepBeginIn();
}
else
{
// Restore datasets
fmViewTDS = (FmViewTDS)Session["fmViewTDS"];
fmTypeViewDisplay = (FmViewTDS.LFS_FM_TYPE_VIEW_DISPLAYDataTable)Session["fmTypeViewDisplay"];
fmTypeViewSort = (FmViewTDS.LFS_FM_TYPE_VIEW_SORTDataTable)Session["fmTypeViewSort"];
fmViewDisplayTemp = (FmViewTDS.FmViewDisplayTempDataTable)Session["fmViewDisplayTemp"];
fmViewSortTemp = (FmViewTDS.FmViewSortTempDataTable)Session["fmViewSortTemp"];
fmViewConditionNew = (FmViewTDS.FmViewConditionNewDataTable)Session["fmViewConditionNew"];
fmViewConditionTemp = (FmViewTDS.FmViewConditionTempDataTable)Session["fmViewConditionTemp"];
categoriesTDS = (CategoriesTDS)Session["categoriesTDSForEditView"];
}
// Control for postback
hdfTag.Value = DateTime.Now.ToLongTimeString();
}