/// <summary> /// GetNextRefId /// </summary> /// <param name="RevenueNavigatorTDS">RevenueNavigatorTDS</param> /// <param name="currentProjectId">currentProjectId</param> /// <param name="currentRefID">currentRefID</param> /// <returns>nextRefID</returns> public static int GetNextRefId(RevenueNavigatorTDS RevenueNavigatorTDS, int currentProjectId, int currentRefId) { int nextRefId = currentRefId; for (int i = 0; i < RevenueNavigatorTDS.RevenueNavigator.DefaultView.Count; i++) { if (((int)RevenueNavigatorTDS.RevenueNavigator.DefaultView[i]["RefID"] == currentRefId) && ((int)RevenueNavigatorTDS.RevenueNavigator.DefaultView[i]["ProjectID"] == currentProjectId)) { if (i == RevenueNavigatorTDS.RevenueNavigator.DefaultView.Count - 1) { nextRefId = currentRefId; } else { nextRefId = (int)RevenueNavigatorTDS.RevenueNavigator.DefaultView[i + 1]["RefID"]; } break; } } return nextRefId; }
/// <summary> /// InitData /// </summary> protected override void InitData() { _data = new RevenueNavigatorTDS(); }
/// <summary> /// GetPreviousRefId /// </summary> /// <param name="RevenueNavigatorTDS">RevenueNavigatorTDS</param> /// <param name="currentProjectId">currentProjectId</param> /// <param name="currentRefID">currentRefID</param> /// <returns>prevRefID</returns> public static int GetPreviousRefId(RevenueNavigatorTDS RevenueNavigatorTDS, int currentProjectId, int currentRefId) { int prevRefId = currentRefId; for (int i = 0; i < RevenueNavigatorTDS.RevenueNavigator.DefaultView.Count; i++) { if (((int)RevenueNavigatorTDS.RevenueNavigator.DefaultView[i]["RefID"] == currentRefId) && ((int)RevenueNavigatorTDS.RevenueNavigator.DefaultView[i]["ProjectID"] == currentProjectId)) { if (i == 0) { prevRefId = currentRefId; } else { prevRefId = (int)RevenueNavigatorTDS.RevenueNavigator.DefaultView[i - 1]["RefID"]; } break; } } return prevRefId; }
private RevenueNavigatorTDS SubmitSearch() { // Retrieve clauses string whereClause = GetWhereClause(); string orderByClause = GetOrderByClause(); RevenueNavigatorTDS dataSet = new RevenueNavigatorTDS(); RevenueNavigatorGateway revenueNavigatorGateway = new RevenueNavigatorGateway(dataSet); //... Load data RevenueNavigator revenueNavigator = new RevenueNavigator(dataSet); revenueNavigator.Load(whereClause, orderByClause); return dataSet; }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_PROJECTS_REVENUE_VIEW"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if ((string)Request.QueryString["source_page"] == null) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in revenue_navigator2.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); Session.Remove("revenueNavigatorNewDummy"); // If coming from // ... revenue_navigator.aspx or revenue_navigator2.aspx if ((Request.QueryString["source_page"] == "revenue_navigator.aspx") || (Request.QueryString["source_page"] == "revenue_navigator2.aspx")) { RestoreNavigatorState(); revenueNavigatorTDS = (RevenueNavigatorTDS)Session["revenueNavigatorTDS"]; } // ... revenue_edit.aspx, revenue_summary.aspx or revenue_delete.aspx if ((Request.QueryString["source_page"] == "revenue_edit.aspx") || (Request.QueryString["source_page"] == "revenue_summary.aspx") || (Request.QueryString["source_page"] == "revenue_delete.aspx")) { RestoreNavigatorState(); if (Request.QueryString["update"] == "no") { revenueNavigatorTDS = (RevenueNavigatorTDS)Session["revenueNavigatorTDS"]; } else { // ... Delete store data Session.Contents.Remove("revenueNavigatorTDS"); // ... Search data with updates revenueNavigatorTDS = SubmitSearch(); // ... store datasets Session["revenueNavigatorTDS"] = revenueNavigatorTDS; } } // ... revenue_delete.aspx, revenue_summary.aspx or revenue_edit.aspx if ((Request.QueryString["source_page"] == "revenue_delete.aspx") || (Request.QueryString["source_page"] == "revenue_summary.aspx") || (Request.QueryString["source_page"] == "revenue_edit.aspx")) { if (revenueNavigatorTDS.RevenueNavigator.Rows.Count == 0) { string url = "./revenue_navigator.aspx?source_page=revenue_navigator2.aspx" + GetNavigatorState() + "&no_results=yes"; Response.Redirect(url); } } Session["revenueNavigatorTDS"] = revenueNavigatorTDS; Session["revenueNavigator"] = revenueNavigatorTDS.RevenueNavigator; // ... for the total rows if (revenueNavigatorTDS.RevenueNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + revenueNavigatorTDS.RevenueNavigator.Rows.Count; lblTotalRows.Visible = true; } else { lblTotalRows.Visible = false; } } else { // Restore searched data (if any) revenueNavigatorTDS = (RevenueNavigatorTDS)Session["revenueNavigatorTDS"]; revenueNavigator = revenueNavigatorTDS.RevenueNavigator; // ... for the total rows if (revenueNavigatorTDS.RevenueNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + revenueNavigatorTDS.RevenueNavigator.Rows.Count; lblTotalRows.Visible = true; } else { lblTotalRows.Visible = false; } } }
protected void btnSearch_Click(object sender, EventArgs e) { if (Page.IsValid) { // Tag Page string url = ""; // Delete store data Session.Contents.Remove("revenueNavigatorTDS"); // Get data from DA gateway revenueNavigatorTDS = SubmitSearch(); // Show results if (revenueNavigatorTDS.RevenueNavigator.Rows.Count > 0) { // ... Store data Session["revenueNavigatorTDS"] = revenueNavigatorTDS; // ... Go to the results page url = "./revenue_navigator2.aspx?source_page=revenue_navigator2.aspx"+ GetNavigatorState(); } else { // ... Go to the search page url = "./revenue_navigator.aspx?source_page=revenue_navigator2.aspx" + GetNavigatorState() + "&no_results=yes"; } Response.Redirect(url); } }