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 )); } }