public int Upload(string fileName, out string message)
{
message = string.Empty;
if (String.IsNullOrEmpty(fileName))
{
return(-2);
}
var fi = new FileInfo(fileName);
using (var package = new ExcelPackage(fi))
{
var listOfRequests = new List <Request>();
var workbook = package.Workbook;
foreach (var worksheet in workbook.Worksheets)
{
RequestHeader headerObj;
IList <Request> readData = ReadRequestRecords(worksheet, out headerObj); //Read Request Records form Excels file
listOfRequests.AddRange(readData);
_requestHeaderRepository.Add(headerObj);
_requestRepository.AddRange(listOfRequests);
}
try
{
_requestHeaderRepository.Save();
_requestRepository.Save();
return(1);
}
catch (Exception e)
{
return(0);
}
}
}
//Add new reuest header for form submission
private void AddNewRequestHeader()
{
if (!CurrentActivity().CurrAction.FormDataProcessing.IsAddNewRequestHeader)
{
return;
}
string folio = null;
string activity = CurrentActivity().ActivityName;
if (!IsSaveDraft())
{
folio = requestHeaderRepository.GetRequestNo(GetRequestCodePrefix(), GetRequestCode());
}
var requestHeader = new RequestHeader();
requestHeader.LastActionBy = "k2:" + WorkflowInstance.CurrentUser;
requestHeader.LastActivity = activity;
requestHeader.LastActionDate = DateTime.Now;
requestHeader.Priority = WorkflowInstance.Priority;
requestHeader.RequestorId = WorkflowInstance.Requestor.Id;
requestHeader.SubmittedBy = "k2:" + WorkflowInstance.CurrentUser;
requestHeader.CurrentActivity = activity;
requestHeader.Status = CurrentActivity().CurrAction.ActionName;
requestHeader.RequestCode = GetRequestCode();
requestHeader.Title = folio;
requestHeader.NoneK2 = true;
requestHeaderRepository.Add(requestHeader);
_requestHeader = requestHeader;
// record requestor log
if (requestHeader.Id > 0)
{
requestHeaderRepository.executeSqlCommand(
string.Format("EXEC [BPMDATA].[REQUESTOR_TRACKING] @RequestHeaderId = {0}",
requestHeader.Id
));
}
}
