private void btnFilter_Click(object sender, EventArgs e)
        {
            using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
            {
                var MedicalCenter = new ServiceBL().GetInfoMedicalCenter();

                List <string> Filters       = new List <string>();
                DateTime?     pdatBeginDate = dtpDateTimeStar.Value.Date;
                DateTime?     pdatEndDate   = dptDateTimeEnd.Value.Date.AddDays(1);

                if (ddlCustomerOrganization.SelectedValue.ToString() != "-1")
                {
                    var id3 = ddlCustomerOrganization.SelectedValue.ToString().Split('|');
                    Filters.Add("v_CustomerOrganizationId==" + "\"" + id3[0] + "\"&&v_CustomerLocationId==" + "\"" + id3[1] + "\"");
                }

                if (ddlProtocolId.SelectedValue.ToString() != "-1")
                {
                    Filters.Add("IdProtocolId==" + "\"" + ddlProtocolId.SelectedValue + "\"");
                }

                // Create the Filter Expression
                strFilterExpression = null;
                if (Filters.Count > 0)
                {
                    foreach (string item in Filters)
                    {
                        strFilterExpression = strFilterExpression + item + " && ";
                    }
                    strFilterExpression = strFilterExpression.Substring(0, strFilterExpression.Length - 4);
                }

                var objData = new PacientBL().GetInterfaceSeguimiento(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
                grdData.DataSource  = objData;
                lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
            }
        }
        private void btnFilter_Click(object sender, EventArgs e)
        {
            using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
            {
                var MedicalCenter = new ServiceBL().GetInfoMedicalCenter();

                List <string> Filters       = new List <string>();
                DateTime?     pdatBeginDate = dtpDateTimeStar.Value.Date;
                DateTime?     pdatEndDate   = dptDateTimeEnd.Value.Date.AddDays(1);

                if (ddlCustomerOrganization.SelectedValue.ToString() != "-1")
                {
                    var id3 = ddlCustomerOrganization.SelectedValue.ToString().Split('|');
                    Filters.Add("v_CustomerOrganizationId==" + "\"" + id3[0] + "\"&&v_CustomerLocationId==" + "\"" + id3[1] + "\"");
                }

                if (ddlEmployerOrganization.SelectedValue.ToString() != "-1")
                {
                    var id3 = ddlEmployerOrganization.SelectedValue.ToString().Split('|');
                    Filters.Add("v_EmployerOrganizationId==" + "\"" + id3[0] + "\"&&v_EmployerLocationId==" + "\"" + id3[1] + "\"");
                }

                if (ddlWorkingOrganization.SelectedValue.ToString() != "-1")
                {
                    var id3 = ddlWorkingOrganization.SelectedValue.ToString().Split('|');
                    Filters.Add("v_WorkingOrganizationId==" + "\"" + id3[0] + "\"&&v_WorkingLocationId==" + "\"" + id3[1] + "\"");
                }

                if (ddlProtocolId.SelectedValue.ToString() != "-1")
                {
                    Filters.Add("ProtocolId==" + "\"" + ddlProtocolId.SelectedValue + "\"");
                }

                // Create the Filter Expression
                strFilterExpression = null;
                if (Filters.Count > 0)
                {
                    foreach (string item in Filters)
                    {
                        strFilterExpression = strFilterExpression + item + " && ";
                    }
                    strFilterExpression = strFilterExpression.Substring(0, strFilterExpression.Length - 4);
                }

                if (tabControl1.SelectedTab.Name == "tpShauindo")
                {
                    var objData = new PacientBL().ReporteMatrizShauindo(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
                    grdShauindo.DataSource    = objData;
                    lblRecordCount.Text       = string.Format("Se encontraron {0} registros.", objData.Count());
                    btnExportShauindo.Enabled = true;
                }
                else if (tabControl1.SelectedTab.Name == "tpLaZanja")
                {
                    var objData = new PacientBL().ReporteMatrizLaZanja(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
                    grdLaZanja.DataSource    = objData;
                    lblRecordCount.Text      = string.Format("Se encontraron {0} registros.", objData.Count());
                    btnExportLaZanja.Enabled = true;
                }
                else if (tabControl1.SelectedTab.Name == "tpGoldFields")
                {
                    var objData = new PacientBL().ReporteMatrizGoldFields(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
                    grdGolFields.DataSource    = objData;
                    lblRecordCount.Text        = string.Format("Se encontraron {0} registros.", objData.Count());
                    btnExportGolFields.Enabled = true;
                }
                else if (tabControl1.SelectedTab.Name == "tpSolucManteIntegra")
                {
                    var objData = new PacientBL().ReporteMatrizSolucManteIntegra(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
                    grdSoluc.DataSource    = objData;
                    lblRecordCount.Text    = string.Format("Se encontraron {0} registros.", objData.Count());
                    btnExportSoluc.Enabled = true;
                }
                else if (tabControl1.SelectedTab.Name == "tpMiBanco")
                {
                    var objData = new PacientBL().ReporteMatrizMiBanco(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
                    grdMiBanco.DataSource    = objData;
                    lblRecordCount.Text      = string.Format("Se encontraron {0} registros.", objData.Count());
                    btnExportMiBanco.Enabled = true;
                }
            }
        }