public virtual ActionResult AdminTRMUpsert()
        {
            BackOffice.Models.Provider.ProviderViewModel oModel = new Models.Provider.ProviderViewModel()
            {
                ProviderOptions = ProveedoresOnLine.CompanyProvider.Controller.CompanyProvider.CatalogGetProviderOptions(),
            };

            oModel.ProviderMenu = GetAdminMenu(oModel);
            return(View(oModel));
        }
        public virtual ActionResult AdminRLUploadProvider(HttpPostedFileBase ExcelFile)
        {
            BackOffice.Models.Provider.ProviderViewModel oModel = new Models.Provider.ProviderViewModel()
            {
                ProviderOptions = ProveedoresOnLine.CompanyProvider.Controller.CompanyProvider.CatalogGetProviderOptions(),
            };

            if (ExcelFile != null)
            {
                string strFolder = System.Web.HttpContext.Current.Server.MapPath
                                       (BackOffice.Models.General.InternalSettings.Instance
                                       [BackOffice.Models.General.Constants.C_Settings_File_TempDirectory].Value);

                if (!System.IO.Directory.Exists(strFolder))
                {
                    System.IO.Directory.CreateDirectory(strFolder);
                }

                //get File
                string strFile = strFolder.TrimEnd('\\') +
                                 DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
                string ErrorFilePath = strFile.Replace(".xls", "_log.csv");
                ExcelFile.SaveAs(strFile);

                //load file to s3
                string strRemoteFile = ProveedoresOnLine.FileManager.FileController.LoadFile
                                           (strFile,
                                           BackOffice.Models.General.InternalSettings.Instance[BackOffice.Models.General.Constants.C_Settings_File_ExcelDirectory].Value);

                //update file into db
                string logFile = this.ProcessProviderFile(strFile, ErrorFilePath, strRemoteFile, ExcelFile.FileName);

                //remove temporal file
                if (System.IO.File.Exists(strFile))
                {
                    System.IO.File.Delete(strFile);
                }

                //ViewData.Add(strRemoteFile);
                List <string> urlList = new List <string>();
                urlList.Add(strRemoteFile);
                urlList.Add(logFile);

                ViewData["UrlReturn"] = urlList;
            }
            else
            {
                ViewData["UrlReturn"] = "No has seleccionado ningún archivo";
            }

            oModel.ProviderMenu = GetAdminMenu(oModel);
            return(View(oModel));
        }