public ActionResult Index(HttpPostedFileBase file, FormCollection formCollection, string submitButton)
{
if (submitButton != null)
{
submitButton = submitButton.ToLower().Trim();
}
string pageSizeDDL = string.Empty;
if (file == null && formCollection.Count == 0 && submitButton == null)
{
InvalidFileSelected();
}
else if (file != null)
{
if (Request.Files["file"].ContentLength > 0)
{
ReadExcelData validateEXT = new ReadExcelData();
bool extValidate = validateEXT.ValidateFileExtension(file);
if (!extValidate)
{
InvalidFileSelected();
}
else
{
string fileLocation = FileLocationPath();
Session.Add("fileLocation", fileLocation);
if (!CheckAnyErrorReadingFile())
{
//extract from excel file....
ReadExcelData loadExcelData = new ReadExcelData();
List <ExcelViewModel> loadedData = loadExcelData.LoadDataFromExcel(fileLocation);
if (loadedData.Count() > 0)
{
if (!CheckForInvalidDataInExcel())
{
ValidateExcelData validateExcelData = new ValidateExcelData();
validateExcelData.RunValidationCheck(loadedData);
}
}
}
}
}
}
else if (submitButton != null)
{
SubmitButton(formCollection, submitButton);
}
return(View(SessionWrapper.GetSession_Model()));
}
private static bool IsValidationGridDataFailed(FormCollection formCollection)
{
ImportViewModelManager model = new ImportViewModelManager();
model = SessionWrapper.GetSession_Model();
ExtractFormCollectionData extractFrmCollection = new ExtractFormCollectionData();
model.DataModel = extractFrmCollection.XtractFormCollectionData(formCollection);
ValidateExcelData validateExcelData = new ValidateExcelData();
validateExcelData.RunValidationCheck(model.DataModel);
//get the latest model data after validation done.
model = SessionWrapper.GetSession_Model();
if (model.ValidationFailed.Count > 0)
{
return(true);
}
return(false);
}
