protected void SubmitButton_Click(object sender, EventArgs e)
{
ValidateInputData();
List <UploadedFileInfo> resultFileInfos = new List <UploadedFileInfo>();
string description = cboDataUploadType.Text.ToString(); //DescriptionTextBox.Text;
bool allFilesExist = true;
if (UploadedFilesStorage == null)
{
UploadedFilesTokenBox.Tokens = new TokenCollection();
}
foreach (string fileName in UploadedFilesTokenBox.Tokens)
{
UploadedFileInfo demoFileInfo = UploadControlHelper.GetDemoFileInfo(SubmissionID, fileName);
FileInfo fileInfo = new FileInfo(demoFileInfo.FilePath);
if (fileInfo.Exists)
{
demoFileInfo.FileSize = FormatSize(fileInfo.Length);
resultFileInfos.Add(demoFileInfo);
}
else
{
allFilesExist = false;
}
}
if (allFilesExist && resultFileInfos.Count > 0)
{
ProcessSubmit(description, resultFileInfos);
UploadControlHelper.RemoveUploadedFilesStorage(SubmissionID);
ASPxEdit.ClearEditorsInContainer(FormLayout, true);
}
else
{
UploadedFilesTokenBox.ErrorText = "Submit failed because files have been removed from the server due to the 5 minute timeout.";
UploadedFilesTokenBox.IsValid = false;
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
ValidateInputData();
List <UploadedFileInfo> resultFileInfos = new List <UploadedFileInfo>();
DataTable data = null;
bool allFilesExist = true;
if (UploadedFilesStorage == null)
{
UploadedFilesTokenBox.Tokens = new TokenCollection();
}
if (UploadedFilesTokenBox.Tokens.Count > 0)
{
foreach (var UploadedFile in UploadedFilesTokenBox.Tokens)
{
UploadedFileInfo demoFileInfo = UploadControlHelper.GetDemoFileInfo(SubmissionID, UploadedFile);
FileInfo fileInfo = new FileInfo(demoFileInfo.FilePath);
if (fileInfo.Exists)
{
demoFileInfo.FileSize = Utils.FormatSize(fileInfo.Length);
resultFileInfos.Add(demoFileInfo);
var excel = new ExcelPackage(new FileInfo(demoFileInfo.FilePath));
if (data == null)
{
data = Utils.ToDataTable(excel);
}
else
{
data.Merge(Utils.ToDataTable(excel));
}
}
}
if (resultFileInfos.Count() > 0)
{
//List<string> errors = Utils.ValidateExcelData(data);
//if (errors.Count == 0)
//{
//feed list to sp
int columnscount = data.Columns.Count;
if (columnscount == 13)
{
data.Columns.Add("IsDataUploaded", typeof(Boolean));
var AssessmentData = rtm_services.UploadAssessmentExcelData(data, true);
Session["UploadedData"] = AssessmentData;
gvAssesmentUpload.DataSource = AssessmentData;
gvAssesmentUpload.DataBind();
gvAssesmentUpload.Visible = true;
}
else
{
data.Columns.Add("IsDataDuplicate", typeof(Boolean));
var dupData = rtm_services.UploadAssessmentExcelData(data);
Session["UploadedData"] = dupData;
gvAssesmentUpload.DataSource = dupData;
gvAssesmentUpload.DataBind();
gvAssesmentUpload.Visible = true;
}
SubmitButton.Enabled = true;
//}
//else
//{
// gvAssesmentUpload.DataSource = errors;
// gvAssesmentUpload.DataBind();
// gvAssesmentUpload.Visible = true;
//}
}
else
{
allFilesExist = false;
}
}
if (allFilesExist && resultFileInfos.Count > 0)
{
UploadControlHelper.RemoveUploadedFilesStorage(SubmissionID);
ASPxEdit.ClearEditorsInContainer(FormLayout, true);
}
else
{
UploadedFilesTokenBox.ErrorText = "Submit failed.";
UploadedFilesTokenBox.IsValid = false;
}
void ValidateInputData()
{
bool isInvalid = UploadedFilesTokenBox.Tokens.Count == 0;
if (isInvalid)
{
throw new Exception("Invalid input data");
}
}
}
