using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
using TapeWeb.Models;
using TapeWeb.DB;


namespace TapeWeb.Reports.Contract.Status
{
    public partial class ShowCSD : System.Web.UI.Page
    {

        private IBuildingSiteRepository iBuildingSiteRepository = null;

        public ShowCSD()
        {

            iBuildingSiteRepository = new BuildingSiteRepository(new TapeWebDBDataContext());
        }


        public void ChangeDataSource()
        {
            //Get the connection string in the web.config file
            String connstr = System.Configuration.ConfigurationManager.ConnectionStrings["tapeweb_develConnectionString"].ToString();

            /*
                <add key="reportServerConnection" value="192.168.16.94"/>
                <add key="reportServerDB" value="tapeweb_devel"/>
                <add key="reportServerUserName" value="tapeweb_web"/>
                <add key="reportServerPassword" value="pqntslc"/>
             * */
            string server = System.Configuration.ConfigurationManager.AppSettings["reportServerConnection"];
            string db = System.Configuration.ConfigurationManager.AppSettings["reportServerDB"];
            string user = System.Configuration.ConfigurationManager.AppSettings["reportServerUserName"];
            string pass = System.Configuration.ConfigurationManager.AppSettings["reportServerPassword"];


            crSource.ReportDocument.SetDatabaseLogon(user, pass, server, db);

            //crSource.ReportDocument.VerifyDatabase();
            foreach (CrystalDecisions.CrystalReports.Engine.InternalConnectionInfo dsconn in crSource.ReportDocument.DataSourceConnections)
            {
                dsconn.SetConnection(server, db, user, pass);
            }
        }


        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack && User.Identity.IsAuthenticated)
            {
                ChangeDataSource();

                /* Obtenemos el parametro de la lista de contractId's */
                String contractIdList = Request["contractIdList"];

                if (contractIdList == null)
                    throw new ApplicationException("La lista de contratos no puede estar vacia");

                crSource.ReportDocument.RecordSelectionFormula = "{v_det_contra.numero} in [" + contractIdList + "]";
                crSource.ReportDocument.Refresh();

                /* Agregamos el parametro del BUILDINGID de la liquidacion */
                CrystalDecisions.Web.Parameter buildingId = new CrystalDecisions.Web.Parameter();
                buildingId.Name = "buildingId";
                buildingId.DefaultValue = (String)Session["selectedBuildingSiteId"].ToString();
                crSource.Report.Parameters.Add(buildingId);

                /* Agregamos el parametro del BUILDINGNAME de la liquidacion */
                CrystalDecisions.Web.Parameter buildingName = new CrystalDecisions.Web.Parameter();
                buildingName.Name = "buildingName";
                buildingName.DefaultValue = (String)Session["selectedBuildingSiteName"];
                crSource.Report.Parameters.Add(buildingName);


                /* Agregamos el parametro del BUILDINGNAME de la liquidacion */
                CrystalDecisions.Web.Parameter userName = new CrystalDecisions.Web.Parameter();
                userName.Name = "userName";
                userName.DefaultValue = (String)User.Identity.Name;
                crSource.Report.Parameters.Add(userName);



            }
        }
    }
}