Web Development

J4amieC wrote:

Oh George, your questions are still as obscure as they've always been.

/// <summary>
 /// retrieves a dataset for all the Chains selected
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void Button1_Click(object sender, EventArgs e)
 {
     HeadCount_Controller controller = new HeadCount_Controller();
     int Filter = System.Convert.ToInt32(RadioButtonList1.SelectedValue);
     string DateFrom = txb_DateFrom.Text;
     string DateTo = txb_DateTo.Text;
     int TrafficTol = System.Convert.ToInt32(tb_TrafficTol.Text);
     int TransTol = System.Convert.ToInt32(tb_TransTol.Text);
     List<Chain> ChainList = new List<Chain>();
     foreach (GridViewRow row in GridView1.Rows)
     {
         CheckBox cb = ((CheckBox)row.FindControl("cb_Select"));
         if (cb != null && cb.Checked)
         {
             Chain me = new Chain();
             me.Chain_Name = row.Cells[0].Text.ToString();
             ChainList.Add(me);
         }
     }

     HeadCountDataSet.DB_vs_App_CompareDataDataTable dt_CompareData = new HeadCountDataSet.DB_vs_App_CompareDataDataTable();
     dt_CompareData = controller.CompareData(ChainList, DateFrom, DateTo, Filter);
     ReportDocument MyReport = new ReportDocument();
     MyReport.Load(Server.MapPath("~/MyReport.rpt"));
     MyReport.SetDataSource(dt_CompareData);
     CrystalReportViewer1.ReportSource = MyReport;
     CrystalReportViewer1.RefreshReport();


 }

/// <summary>
     /// retrieves a dataset of Serial Boxes, Store Names, Traffic/Transaction
     /// results from the App. and traffic/Transaction results from the DB for
     /// each ChainName in a list and combines the datasets into a single dataset.
     /// uses a stored procedure in the DB to Load the data
     /// to a table and compare the data with the Statistics table data.
     /// </summary>
     /// <param name="Chain_Name">The Chain Name as found in the Headcount.Chain table</param>
     /// <param name="DateFrom">a date string mm/dd/yyyy</param>
     /// <param name="DateTo">a date string mm/dd/yyyy</param>
     /// <param name="Filter">1 for sites where data matches, 2 for sites where data does not
     /// match, any other integer will return all site data</param>
     /// <returns></returns>
     public HeadCountDataSet.DB_vs_App_CompareDataDataTable CompareData(List<Chain> ChainList, string DateFrom, string DateTo, int Filter)
     {
         HeadCountDataSet.DB_vs_App_CompareDataDataTable dt_CompareResults = new HeadCountDataSet.DB_vs_App_CompareDataDataTable();
         foreach (Chain row in ChainList)
         {
             HeadCountDataSet.DB_vs_App_CompareDataDataTable dt_ChainData = new HeadCountDataSet.DB_vs_App_CompareDataDataTable();
             dt_ChainData = HeadcountDB.CompareData(row.Chain_Name, DateFrom, DateTo, Filter);
             foreach (HeadCountDataSet.DB_vs_App_CompareDataRow arow in dt_ChainData)
             {
                 dt_CompareResults.ImportRow(arow);
             }
         }
         return dt_CompareResults;
     }

Ponzano Paolo wrote:

I was looking on the net for the best practice on Web UI navigation but I found no valid solution

static public String GetClientIP(Page page)
    {
        //Find the users own IP
        String strIpAddress = String.Empty;
        try
        {
            strIpAddress = page.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
            if (strIpAddress == null)
                strIpAddress = page.Request.ServerVariables["REMOTE_ADDR"];
            if (strIpAddress == null)
                strIpAddress = page.Request.UserHostAddress;
        }
        catch 
        {
            strIpAddress = "IP address not Found";
        }
        return strIpAddress;
    }