// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="companyId">companyId</param>
public void DeleteDirect(int viewId, int companyId)
{
FmViewDisplay fmViewDisplay = new FmViewDisplay(null);
fmViewDisplay.DeleteDirect(viewId, companyId);
FmViewCondition fmViewCondition = new FmViewCondition(null);
fmViewCondition.DeleteDirect(viewId, companyId);
FmViewSort fmViewSort = new FmViewSort(null);
fmViewSort.DeleteDirect(viewId, companyId);
FmViewGateway fmViewGateway = new FmViewGateway(null);
fmViewGateway.Delete(viewId, companyId);
}
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;
}
// ////////////////////////////////////////////////////////////////////////
// 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_add.aspx");
}
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"])))
{
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();
hdfUpdate.Value = "no";
ViewState["columnsToDisplayPageIndex"] = 0;
ViewState["sortPageIndex"] = 0;
Session.Remove("fmTypeViewDisplay");
Session.Remove("fmTypeViewDisplayDummy");
Session.Remove("fmTypeViewSort");
Session.Remove("fmTypeViewSortDummy");
Session.Remove("fmViewDisplayTemp");
Session.Remove("fmViewSortTemp");
Session.Remove("fmViewConditionNew");
Session.Remove("fmViewConditionNewDummy");
Session.Remove("categoriesTDSForAddView");
FmViewGateway fmViewGateway = new FmViewGateway();
hdfViewId.Value = (fmViewGateway.GetLastViewId() + 1).ToString().Trim();
// Prepare initial data
// ... For view type
FmViewTypeList fmViewTypeList = new FmViewTypeList(new DataSet());
fmViewTypeList.LoadAndAddItem("(Select a type)", Int32.Parse(hdfCompanyId.Value));
ddlType.DataSource = fmViewTypeList.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
// ... 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();
// ... for Categories
categoriesTDS = new CategoriesTDS();
// ... Store datasets
Session["fmViewTDS"] = fmViewTDS;
Session["fmTypeViewDisplay"] = fmTypeViewDisplay;
Session["fmTypeViewSort"] = fmTypeViewSort;
Session["fmViewDisplayTemp"] = fmViewDisplayTemp;
Session["fmViewSortTemp"] = fmViewSortTemp;
Session["fmViewConditionNew"] = fmViewConditionNew;
Session["categoriesTDSForAddView"] = categoriesTDS;
}
// StepSection1In
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"];
categoriesTDS = (CategoriesTDS)Session["categoriesTDSForAddView"];
}
// Control for postback
hdfTag.Value = DateTime.Now.ToLongTimeString();
}
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);
}
/// <summary>
/// InsertDirect
/// </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="deleted">deleted</param>
/// <param name="companyId">companyId</param>
public void InsertDirect(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string fmType, bool deleted, int companyId)
{
FmViewGateway fmViewGateway = new FmViewGateway(null);
fmViewGateway.Insert(viewId, loginId, name, type, logic, sqlCommand, fmType, deleted, companyId);
}
/// <summary>
/// UpdateDirect
/// </summary>
/// <param name="originalViewId">originalViewId</param>
/// <param name="originalLoginId">originalLoginId</param>
/// <param name="originalName">originalName</param>
/// <param name="originalType">originalType</param>
/// <param name="origianlLogic">origianlLogic</param>
/// <param name="originalSqlCommand">originalSqlCommand</param>
/// <param name="originalFmType">originalFmType</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="newViewID">newViewID</param>
/// <param name="newLoginId">newLoginId</param>
/// <param name="newName">newName</param>
/// <param name="newType">newType</param>
/// <param name="newLogic">newLogic</param>
/// <param name="newSqlCommand">newSqlCommand</param>
/// <param name="newFmType">newFmType</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
public void UpdateDirect(int originalViewId, int originalLoginId, string originalName, string originalType, string origianlLogic, string originalSqlCommand, string originalFmType, bool originalDeleted, int originalCompanyId, int newViewID, int newLoginId, string newName, string newType, string newLogic, string newSqlCommand, string newFmType, bool newDeleted, int newCompanyId)
{
FmViewGateway fmViewGateway = new FmViewGateway(null);
fmViewGateway.Update(originalViewId, originalLoginId, originalName, originalType, origianlLogic, originalSqlCommand, originalFmType, originalDeleted, originalCompanyId, newViewID, newLoginId, newName, newType, newLogic, newSqlCommand, newFmType, newDeleted, newCompanyId);
}
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;
}
}
