public dynamic GetCierreDiario(string country, string region, string date, ref int cantDiferencias, bool excluirBP = true)

        {

​

            SqlCommand cmd = new SqlCommand();

            DataSet dataSet = new DataSet();

            DataTable dt = new DataTable();

            dynamic result = null;

​

            try

            {

                if (!Boolean.Parse(ConfigurationManager.AppSettings["TestExcel"]))

                {

​

                    string server = ConfigurationManager.AppSettings["DBServerExactusCA"];

                    string db = ConfigurationManager.AppSettings["EXAIFCOR"];

                    string sqlConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString().Replace("@@@", server).Replace("###", db);

                    string basePath = AppDomain.CurrentDomain.BaseDirectory;

                    string path = Path.Combine(basePath, @"Scripts\00-Revisa Cierre Diario.sql");

                    //string country = cmbPais.Text.ToString();

                    //string region = cmbPais.SelectedValue.ToString();

                    string script = File.ReadAllText(path);

                    //string date = dtpFecha.Value.ToString("yyyy-MM-dd");

                    script = script.Replace("$$FECHA$$", date).Replace("$$PAIS$$", country).Replace("$$REGION$$", region);

​

                    cmd.Connection = new SqlConnection(sqlConnectionString);

                    cmd.CommandTimeout = int.Parse(ConfigurationManager.AppSettings["ConnectionTimeoutDB"]);

                    cmd.CommandText = script;

                    cmd.CommandType = CommandType.Text;

​

                    //cmd.Parameters.AddWithValue("@ProductoID", codigo);

​

                    using (SqlDataAdapter SqlData = new SqlDataAdapter(cmd))

                    {

                        SqlData.Fill(dataSet);

                    }

​

                    if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)

                    {

                        //result = dataSet.Tables[0];

                        dt = dataSet.Tables[0];

​

                        result = ExcelHelper.RevisarDataTable(dt, ref cantDiferencias, excluirBP);

​

                    }

                    else

                    {

                        MessageBox.Show("No se encontró ningún registro.");

                    }

​

                }

                else

                {

                    Util util = new Util();

​

                    result = util.LeerExcelPruebas(ConfigurationManager.AppSettings["TestExcelFileName"].ToString(), ref cantDiferencias, excluirBP);

​

                }

​

            }

            catch (Exception ex)

            {

                MessageBox.Show("Error al intentar recuperar los datos, " + ex.ToString() + ex.InnerException != null ? "InnerException: " + ex.InnerException.ToString() : "");

            }

            finally

            {

                cmd.Dispose();

                dataSet.Dispose();

            }

​

            return result;

​

        }