public ActionResult ImportStep1(int id)
        {
            PolicyHotelCapRateImportStep1WithFileVM cdrLinkImportFileVM = new PolicyHotelCapRateImportStep1WithFileVM();

            cdrLinkImportFileVM.PolicyGroupId = id;

            PolicyGroup policyGroup = new PolicyGroup();

            policyGroup = policyGroupRepository.GetGroup(id);

            cdrLinkImportFileVM.PolicyGroup = policyGroup;

            return(View(cdrLinkImportFileVM));
        }
        public ActionResult ImportStep1(PolicyHotelCapRateImportStep1WithFileVM csvfile)
        {
            //used for return only
            PolicyGroup policyGroup = new PolicyGroup();

            policyGroup         = policyGroupRepository.GetGroup(csvfile.PolicyGroupId);
            csvfile.PolicyGroup = policyGroup;


            if (!ModelState.IsValid)
            {
                return(View(csvfile));
            }
            string fileExtension = Path.GetExtension(csvfile.File.FileName);

            if (fileExtension != ".csv") // && fileExtension != ".xls" && fileExtension != ".xlsx")
            {
                ModelState.AddModelError("file", "This is not a valid entry");
                return(View(csvfile));
            }

            if (csvfile.File.ContentLength > 0)
            {
                PolicyHotelCapRateImportStep2VM preImportCheckResult = new PolicyHotelCapRateImportStep2VM();
                List <string> returnMessages = new List <string>();

                preImportCheckResult = policyHotelCapRateGroupItemRepository.PreImportCheck(csvfile.File, csvfile.PolicyGroupId);

                PolicyHotelCapRateImportStep1VM preImportCheckResultVM = new PolicyHotelCapRateImportStep1VM();
                preImportCheckResultVM.PolicyGroup   = policyGroup;
                preImportCheckResultVM.ImportStep2VM = preImportCheckResult;
                preImportCheckResultVM.PolicyGroupId = csvfile.PolicyGroupId;

                TempData["PreImportCheckResultVM"] = preImportCheckResultVM;
                return(RedirectToAction("ImportStep2"));
            }

            return(View());
        }