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;
}
private ServicesNavigatorTDS SubmitSearchForViews()
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
// ... Load SqlCommand
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId);
string sqlCommand = "";
sqlCommand = fmViewGateway.GetSqlCommand(viewId);
// ... Load data
string fmType = hdfFmType.Value.Trim();
ServicesNavigator servicesNavigator = new ServicesNavigator();
servicesNavigator.LoadForViewsFmTypeCompanyId(sqlCommand, fmType, companyId);
return (ServicesNavigatorTDS)servicesNavigator.Data;
}
protected void btnExportList_Click(object sender, EventArgs e)
{
string url = "";
string headerValues = "";
int totalColumnsExport = 29;
int totalColumnsPreview = 28;
string title = "Services Search Results";
string columnsForReport = "";
int j;
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
// ... Load name view
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId);
title = fmViewGateway.GetName(viewId);
}
// ... For comments option
string comments = "None";
headerValues = "";
columnsForReport = "";
// Establishing header values
if (grdServicesNavigator.Columns[2].Visible) headerValues += "Service Number";
if (grdServicesNavigator.Columns[3].Visible) headerValues += " * Date";
if (grdServicesNavigator.Columns[4].Visible) headerValues += " * Fixed Date";
if (grdServicesNavigator.Columns[5].Visible) headerValues += " * Service State";
if (grdServicesNavigator.Columns[6].Visible) headerValues += " * Problem Description";
if (grdServicesNavigator.Columns[7].Visible) headerValues += " * Unit Code";
if (grdServicesNavigator.Columns[8].Visible) headerValues += " * Unit Description";
if (grdServicesNavigator.Columns[9].Visible) headerValues += " * VIN/SN";
if (grdServicesNavigator.Columns[10].Visible) headerValues += " * Unit State";
if (grdServicesNavigator.Columns[11].Visible) headerValues += " * Checklist Rule";
if (grdServicesNavigator.Columns[12].Visible) headerValues += " * Checklist State";
if (grdServicesNavigator.Columns[13].Visible) headerValues += " * Created by";
if (grdServicesNavigator.Columns[14].Visible) headerValues += " * Mileage";
if (grdServicesNavigator.Columns[15].Visible) headerValues += " * Assign Date";
if (grdServicesNavigator.Columns[16].Visible) headerValues += " * Deadline Date";
if (grdServicesNavigator.Columns[17].Visible) headerValues += " * Assigned to";
if (grdServicesNavigator.Columns[18].Visible) headerValues += " * Accepted Date";
if (grdServicesNavigator.Columns[19].Visible) headerValues += " * Start Date";
if (grdServicesNavigator.Columns[20].Visible) headerValues += " * Unit Out Of Service Date";
if (grdServicesNavigator.Columns[21].Visible) headerValues += " * Unit Out Of Service Time";
if (grdServicesNavigator.Columns[22].Visible) headerValues += " * Start Work Mileage";
if (grdServicesNavigator.Columns[23].Visible) headerValues += " * Complete Date";
if (grdServicesNavigator.Columns[24].Visible) headerValues += " * Unit Back In Service Date";
if (grdServicesNavigator.Columns[25].Visible) headerValues += " * Unit Back In Service Time";
if (grdServicesNavigator.Columns[26].Visible) headerValues += " * Complete Work Mileage";
if (grdServicesNavigator.Columns[27].Visible) headerValues += " * Work Details";
if (grdServicesNavigator.Columns[28].Visible) headerValues += " * Preventable";
if (grdServicesNavigator.Columns[29].Visible) headerValues += " * Labour Hours";
if (grdServicesNavigator.Columns[30].Visible) headerValues += " * Notes";
// Establishing columns to display
string[] columnsExcel = headerValues.Split('*');
// ... for visible columns
for (int i = 0; i < columnsExcel.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columnsExcel[i].Trim();
}
// ... For not visible columns
for (int i = columnsExcel.Length; i < totalColumnsExport; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
if (grdServicesNavigator.Columns[30].Visible) comments = "Comments";
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
title = title.Replace("'", "%27");
Response.Write("<script language='javascript'> {window.open('./services_print_search_results_report.aspx?" + columnsForReport + "&comments=" + comments + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columnsExcel.Length + "&title=" + title + "&format=excel', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
if (url != "") Response.Redirect(url);
}
protected void btnPreviewList_Click(object sender, EventArgs e)
{
string url = "";
string headerValues = "";
int totalColumnsExport = 37;
int totalColumnsPreview = 36;
string title = "Units Search Results";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
// ... Load name view
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId);
title = fmViewGateway.GetName(viewId);
}
// ... For notes option
string notes = "None";
// Establishing header values
if (grdUnitsNavigator.Columns[2].Visible) headerValues += "Code";
if (grdUnitsNavigator.Columns[3].Visible) headerValues += " * Description";
if (grdUnitsNavigator.Columns[4].Visible) headerValues += " * VIN/SN";
if (grdUnitsNavigator.Columns[5].Visible) headerValues += " * State";
if (grdUnitsNavigator.Columns[6].Visible) headerValues += " * Manufacturer";
if (grdUnitsNavigator.Columns[7].Visible) headerValues += " * Model";
if (grdUnitsNavigator.Columns[8].Visible) headerValues += " * Is Towable?";
if (grdUnitsNavigator.Columns[9].Visible) headerValues += " * Insurance Class";
if (grdUnitsNavigator.Columns[10].Visible) headerValues += " * Ryder Specified";
// before columns 9 after columns 11
if (grdUnitsNavigator.Columns[11].Visible) headerValues += " * Model Year";
if (grdUnitsNavigator.Columns[12].Visible) headerValues += " * Category";
if (grdUnitsNavigator.Columns[13].Visible) headerValues += " * Company Level";
if (grdUnitsNavigator.Columns[14].Visible) headerValues += " * Acquisition Date";
if (grdUnitsNavigator.Columns[15].Visible) headerValues += " * Cost (CAD)";
if (grdUnitsNavigator.Columns[16].Visible) headerValues += " * Cost (USD)";
if (grdUnitsNavigator.Columns[17].Visible) headerValues += " * License Country";
if (grdUnitsNavigator.Columns[18].Visible) headerValues += " * License State";
if (grdUnitsNavigator.Columns[19].Visible) headerValues += " * License Plate Number";
if (grdUnitsNavigator.Columns[20].Visible) headerValues += " * Apportioned Tag Number";
if (grdUnitsNavigator.Columns[21].Visible) headerValues += " * Actual Weight";
if (grdUnitsNavigator.Columns[22].Visible) headerValues += " * Registered Weight";
if (grdUnitsNavigator.Columns[23].Visible) headerValues += " * Tire Size Front";
if (grdUnitsNavigator.Columns[24].Visible) headerValues += " * Tire Size Back";
if (grdUnitsNavigator.Columns[25].Visible) headerValues += " * Number Of Axes";
if (grdUnitsNavigator.Columns[26].Visible) headerValues += " * Fuel Type";
if (grdUnitsNavigator.Columns[27].Visible) headerValues += " * Beginning Odometer";
if (grdUnitsNavigator.Columns[28].Visible) headerValues += " * Is Reefer Equipped?";
if (grdUnitsNavigator.Columns[29].Visible) headerValues += " * Is PTO Equipped?";
if (grdUnitsNavigator.Columns[30].Visible) headerValues += " * Owner Type";
if (grdUnitsNavigator.Columns[31].Visible) headerValues += " * Owner Country";
if (grdUnitsNavigator.Columns[32].Visible) headerValues += " * Owner State";
if (grdUnitsNavigator.Columns[33].Visible) headerValues += " * Owner Name";
if (grdUnitsNavigator.Columns[34].Visible) headerValues += " * Contact Info";
if (grdUnitsNavigator.Columns[35].Visible) headerValues += " * Qualified Date";
if (grdUnitsNavigator.Columns[36].Visible) headerValues += " * Not Qualified Date";
if (grdUnitsNavigator.Columns[37].Visible) headerValues += " * Not Qualified Explain";
// Establishing columns to display
string[] columns = headerValues.Split('*');
string columnsForReport = "";
int j;
// ... For visible columns
for (int i = 0; i < columns.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columns[i].Trim();
}
// ... For not visible columns
for (int i = columns.Length; i < totalColumnsPreview; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
if (grdUnitsNavigator.Columns[38].Visible) { notes = "Notes"; }
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
title = title.Replace("'", "%27");
Response.Write("<script language='javascript'> {window.open('./units_print_search_results_report.aspx?" + columnsForReport + "¬es=" + notes + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columns.Length + "&title=" + title + "&format=pdf', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
if (url != "") Response.Redirect(url);
}
/// <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);
}
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();
}
int companyId = Int32.Parse(hdfCompanyId.Value);
int viewId = Int32.Parse(hdfViewId.Value);
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId );
fmViewConditionTemp.Rows.Clear();
// Create dataset
FmViewTDS dataSet = new FmViewTDS();
dataSet.FmViewConditionNew.Merge(fmViewConditionNew, true);
dataSet.FmViewConditionTemp.Merge(fmViewConditionTemp, true);
// Process conditions
FmViewConditionTemp model = new FmViewConditionTemp(dataSet);
FmViewConditionNew modelLogic = new FmViewConditionNew(dataSet);
string originalLogic = fmViewGateway.GetLogic(viewId);
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
fmViewConditionNew.Rows.Clear();
fmViewConditionNew.Merge(modelLogic.Table);
fmViewConditionTemp.Rows.Clear();
fmViewConditionTemp.Merge(model.Table);
// Store tables
Session.Remove("fmViewConditionNewDummy");
Session.Remove("fmViewConditionTempDummy");
Session["fmViewConditionNew"] = fmViewConditionNew;
Session["fmViewConditionTemp"] = fmViewConditionTemp;
Session["conditionsUpdate"] = null;
return true;
}
else
{
return false;
}
}
// ////////////////////////////////////////////////////////////////////////
// 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();
}