public List<DocumentDTO> SaveDocumentWithOZformForAssembleIWP(List<FiwpDTO> fiwps, UpfileDTOS upFileCollection, string curStepCode, string userId) { //TransactionScope scope = null; //byte[] bytes = null; string fileType = string.Empty; //Check FileType switch (curStepCode) { case Element.Reveal.DataLibrary.Utilities.AssembleStep.SUMMARY: fileType = Element.Reveal.DataLibrary.Utilities.FileType.SUMMARY; break; case Element.Reveal.DataLibrary.Utilities.AssembleStep.SAFETY_CHECK: fileType = Element.Reveal.DataLibrary.Utilities.FileType.SAFETY_CHECK; break; case Element.Reveal.DataLibrary.Utilities.AssembleStep.SCAFFOLD_CHECK: fileType = Element.Reveal.DataLibrary.Utilities.FileType.SCAFFOLD_CHECK; break; } int iwpDocumentId = 0; int fileStoreId = 0; //string fileExtension = "jpg"; string fileName = fiwps[0].FiwpName + "_" + fileType; //Get Default Info rptProjectCwaIwpDTO rptInfo = GetProjectCwaIwpByIwp(fiwps[0].FiwpID); //Check existence List<ComboBoxDTO> exists = GetIwpDocumentByIwpProjectFileType_Combo(fiwps[0].FiwpID, fiwps[0].ProjectID, fileType, "Y"); if (exists != null && exists.Count > 0) { iwpDocumentId = exists[0].DataID; int.TryParse(exists[0].ExtraValue3, out fileStoreId); fileName = exists[0].DataName; //fileExtension = exists[0].ExtraValue4; } //using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) //{ #region Upload Report File & Save File Info if (upFileCollection.fileStoreDTOList == null || upFileCollection.fileStoreDTOList.Count <= 0) { List<FileStoreDTO> fileStoreList = new List<FileStoreDTO>(); //List<UploadedFileInfoDTO> uploadFileList = new List<UploadedFileInfoDTO>(); FileStoreDTO fileStore = new FileStoreDTO(); fileStore.FileTitle = fileName; fileStore.FileDescription = DateTime.Now.ToString(); fileStore.FileCategory = Element.Reveal.DataLibrary.Utilities.FileCategory.REPORT; fileStore.FileTypeCode = fileType; fileStore.CreatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; fileStore.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; fileStore.FileStoreId = fileStoreId; fileStore.ProjectId = fiwps[0].ProjectID; fileStoreList.Add(fileStore); upFileCollection.fileStoreDTOList = fileStoreList; } //UploadedFileInfoDTO uploadFile = new UploadedFileInfoDTO(); //uploadFile.Name = fileName; //uploadFile.Size = bytes.Length; //uploadFile.FileExtension = fileExtension; //uploadFile.UploadedBy = fiwps[0].UpdatedBy; //uploadFile.UploadedDate = DateTime.Now; //uploadFile.CreatedBy = fiwps[0].UpdatedBy; //uploadFile.UpdatedBy = fiwps[0].UpdatedBy; ////uploadFile.byteFile = bytes; //uploadFile.UploadedFileInfoId = 0; //uploadFile.FileStoreId = fileStoreId; //uploadFileList.Add(uploadFile); //upFileCollection.uploadedFileDTOList = uploadFileList; upFileCollection = (new TrueTask.Common()).SaveMultiUploadFile(upFileCollection, userId, fileName); #endregion #region Save Report Document Info List<DocumentDTO> documents = new List<DocumentDTO>(); #region "old code _ uploadedFileInfo" //foreach (UploadedFileInfoDTO uploadFile in upFileCollection.uploadedFileDTOList) //{ // DocumentDTO iwpDocument = new DocumentDTO(); // //iwpDocument.DocumentID = iwpDocumentId; // iwpDocument.FIWPID = fiwps[0].FiwpID; // iwpDocument.SPCollectionID = uploadFile.UploadedFileInfoId; // iwpDocument.UpdatedBy = fiwps[0].UpdatedBy; // if (uploadFile.FileExtension.ToLower() == "jpg") // iwpDocument.IsDisplayable = "Y"; // else // iwpDocument.IsDisplayable = "N"; // //if (iwpDocument.DocumentID > 0) // // iwpDocument.DTOStatus = (int)RowStatusNo.Update; // //else // iwpDocument.DTOStatus = (int)RowStatusNo.New; // documents.Add(iwpDocument); //} #endregion DocumentDTO iwpDocument = new DocumentDTO(); iwpDocument.DocumentID = iwpDocumentId; iwpDocument.FIWPID = fiwps[0].FiwpID; iwpDocument.FileStoreId = upFileCollection.uploadedFileDTOList[0].FileStoreId; iwpDocument.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; iwpDocument.IsDisplayable = "Y"; if (iwpDocument.DocumentID > 0) iwpDocument.DTOStatus = (int)RowStatusNo.Update; else iwpDocument.DTOStatus = (int)RowStatusNo.New; documents.Add(iwpDocument); documents = SaveDocument(documents); #endregion //Update Assemble Step if (fiwps[0].DocEstablishedLUID != Element.Reveal.DataLibrary.Utilities.AssembleStep.APPROVER) fiwps = (new TrueTask.Build()).SaveIwp(fiwps); // scope.Complete(); //} return documents; }
/// <summary> /// SaveFiwpMaterialForAssembleIWP /// </summary> /// <param name="fiwpmaterials"></param> /// <param name="fiwps"></param> /// <param name="documents"></param> /// <returns></returns> public List<FiwpmaterialDTO> SaveFiwpMaterialForAssembleIWP(List<FiwpmaterialDTO> fiwpmaterials, List<FiwpDTO> fiwps, string userId) { //TransactionScope scope = null; byte[] bytes = null; string fileType = Element.Reveal.DataLibrary.Utilities.FileType.CONSUMABLE; int iwpDocumentId = 0; int fileStoreId = 0; string fileExtension = "jpg"; string fileName = fiwps[0].FiwpName + "_" + fileType; //Get Default Info rptProjectCwaIwpDTO rptInfo = GetProjectCwaIwpByIwp(fiwps[0].FiwpID); //Check existence List<ComboBoxDTO> exists = GetIwpDocumentByIwpProjectFileType_Combo(fiwps[0].FiwpID, fiwps[0].ProjectID, fileType, "Y"); if (exists != null && exists.Count > 0) { iwpDocumentId = exists[0].DataID; int.TryParse(exists[0].ExtraValue3, out fileStoreId); fileName = exists[0].DataName; fileExtension = exists[0].ExtraValue4; } //using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) //{ //Save user manipulated data if (fiwpmaterials != null && fiwpmaterials.Count > 0) fiwpmaterials = SaveFiwpMaterial(fiwpmaterials); //Get Latest Data fiwpmaterials = (new TrueTask.Build()).GetFiwpMaterialByFIWP(fiwps[0].FiwpID, fiwps[0].ProjectID, ""); //Generate Report bytes = GenerateReportForMaterial(fiwpmaterials, rptInfo); #region Upload Report File & Save File Info UpfileDTOS upFileCollection = new UpfileDTOS(); List<FileStoreDTO> fileStoreList = new List<FileStoreDTO>(); List<UploadedFileInfoDTO> uploadFileList = new List<UploadedFileInfoDTO>(); FileStoreDTO fileStore = new FileStoreDTO(); fileStore.FileTitle = fileName; fileStore.FileDescription = DateTime.Now.ToString(); fileStore.FileCategory = Element.Reveal.DataLibrary.Utilities.FileCategory.REPORT; fileStore.FileTypeCode = fileType; fileStore.CreatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; fileStore.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; fileStore.FileStoreId = fileStoreId; fileStore.ProjectId = fiwps[0].ProjectID; fileStoreList.Add(fileStore); upFileCollection.fileStoreDTOList = fileStoreList; UploadedFileInfoDTO uploadFile = new UploadedFileInfoDTO(); uploadFile.Name = fileName; uploadFile.Size = bytes.Length; uploadFile.FileExtension = fileExtension; uploadFile.UploadedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; uploadFile.UploadedDate = DateTime.Now; uploadFile.CreatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; uploadFile.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; uploadFile.byteFile = bytes; uploadFile.UploadedFileInfoId = 0; uploadFile.FileStoreId = fileStoreId; uploadFileList.Add(uploadFile); upFileCollection.uploadedFileDTOList = uploadFileList; upFileCollection = (new TrueTask.Common()).SaveSingleUploadFile(upFileCollection, userId); #endregion #region Save Report Document Info List<DocumentDTO> documents = new List<DocumentDTO>(); DocumentDTO iwpDocument = new DocumentDTO(); iwpDocument.DocumentID = iwpDocumentId; iwpDocument.FIWPID = fiwps[0].FiwpID; //iwpDocument.SPCollectionID = upFileCollection.uploadedFileDTOList[0].UploadedFileInfoId; iwpDocument.FileStoreId = upFileCollection.uploadedFileDTOList[0].FileStoreId; iwpDocument.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; iwpDocument.IsDisplayable = "Y"; if (iwpDocument.DocumentID > 0) iwpDocument.DTOStatus = (int)RowStatusNo.Update; else iwpDocument.DTOStatus = (int)RowStatusNo.New; documents.Add(iwpDocument); documents = SaveDocument(documents); #endregion //Update Assemble Step if (fiwps[0].DocEstablishedLUID != Element.Reveal.DataLibrary.Utilities.AssembleStep.APPROVER) fiwps = (new TrueTask.Build()).SaveIwp(fiwps); // scope.Complete(); //} return fiwpmaterials; }
public async Task<List<DataLibrary.DocumentDTO>> SaveDocumentWithOZformForAssembleIWP(List<DataLibrary.FiwpDTO> fiwps, UpfileDTOS upFileCollection, string curStepCode, string userId) { Dictionary<string, dynamic> dParams = new Dictionary<string, dynamic>(); dParams.Add("fiwps", fiwps); dParams.Add("upFileCollection", upFileCollection); dParams.Add("curStepCode", curStepCode); dParams.Add("userId", userId); return await JsonHelper.PutDataAsync<List<DataLibrary.DocumentDTO>>("JsonSaveDocumentWithOZformForAssembleIWP", dParams, JsonHelper.ProjectService); }
/// <summary> /// SaveDocumentForAssembleIWP /// </summary> /// <param name="documents"></param> /// <param name="fiwps"></param> /// <returns></returns> public List<DocumentDTO> SaveDocumentForAssembleIWP(List<FiwpDTO> fiwps, List<DocumentDTO> documents, string curStepCode, string userId, string webPath) { //TransactionScope scope = null; byte[] bytes = null; string fileType = string.Empty; //Check FileType switch (curStepCode) { case Element.Reveal.DataLibrary.Utilities.AssembleStep.COVER: fileType = Element.Reveal.DataLibrary.Utilities.FileType.COVER; break; case Element.Reveal.DataLibrary.Utilities.AssembleStep.SAFETY_FORM: fileType = Element.Reveal.DataLibrary.Utilities.FileType.SAFETY_FORM; break; case Element.Reveal.DataLibrary.Utilities.AssembleStep.ITR: fileType = Element.Reveal.DataLibrary.Utilities.FileType.ITR; break; case Element.Reveal.DataLibrary.Utilities.AssembleStep.SPEC: fileType = Element.Reveal.DataLibrary.Utilities.FileType.SPEC; break; case Element.Reveal.DataLibrary.Utilities.AssembleStep.MOC: fileType = Element.Reveal.DataLibrary.Utilities.FileType.MOC; break; } int iwpDocumentId = 0; int fileStoreId = 0; string fileExtension = "jpg"; string fileName = fiwps[0].FiwpName + "_" + fileType; string coverImageUrl = string.Empty; //Get Default Info rptProjectCwaIwpDTO rptInfo = GetProjectCwaIwpByIwp(fiwps[0].FiwpID); //Check existence List<ComboBoxDTO> exists = GetIwpDocumentByIwpProjectFileType_Combo(fiwps[0].FiwpID, fiwps[0].ProjectID, fileType, "Y"); if (exists != null && exists.Count > 0) { iwpDocumentId = exists[0].DataID; int.TryParse(exists[0].ExtraValue3, out fileStoreId); fileName = exists[0].DataName; fileExtension = exists[0].ExtraValue4; } //using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) //{ //Save user manipulated data if (documents != null && documents.Count > 0) { coverImageUrl = string.IsNullOrEmpty(documents[0].LocationURL) ? "" : HttpContext.Current.Server.MapPath(documents[0].LocationURL.Replace(webPath, "")); documents[0].IsDisplayable = "N"; documents = SaveDocument(documents); } //Generate Report if (curStepCode == Element.Reveal.DataLibrary.Utilities.AssembleStep.COVER) bytes = GenerateReportForCover(coverImageUrl, rptInfo); else { string listTitle = "List"; List<ComboBoxDTO> combos = GetIwpDocumentByIwpProjectFileType_Combo(fiwps[0].FiwpID, fiwps[0].ProjectID, fileType, "N"); List<ComboCodeBoxDTO> type = (new TrueTask.Common()).GetSigmaCodeByCodeCategory_Code_Combo(null, fileType); if (type != null && type.Count > 0) listTitle = type[0].DataName; bytes = GenerateReportForCombo(combos, rptInfo, listTitle); } #region Upload Report File & Save File Info UpfileDTOS upFileCollection = new UpfileDTOS(); List<FileStoreDTO> fileStoreList = new List<FileStoreDTO>(); List<UploadedFileInfoDTO> uploadFileList = new List<UploadedFileInfoDTO>(); FileStoreDTO fileStore = new FileStoreDTO(); fileStore.FileTitle = fileName; fileStore.FileDescription = DateTime.Now.ToString(); fileStore.FileCategory = Element.Reveal.DataLibrary.Utilities.FileCategory.REPORT; fileStore.FileTypeCode = fileType; fileStore.CreatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; fileStore.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; fileStore.FileStoreId = fileStoreId; fileStore.ProjectId = fiwps[0].ProjectID; fileStoreList.Add(fileStore); upFileCollection.fileStoreDTOList = fileStoreList; UploadedFileInfoDTO uploadFile = new UploadedFileInfoDTO(); uploadFile.Name = fileName; uploadFile.Size = bytes.Length; uploadFile.FileExtension = fileExtension; uploadFile.UploadedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; uploadFile.UploadedDate = DateTime.Now; uploadFile.CreatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; uploadFile.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; uploadFile.byteFile = bytes; uploadFile.UploadedFileInfoId = 0; uploadFile.FileStoreId = fileStoreId; uploadFileList.Add(uploadFile); upFileCollection.uploadedFileDTOList = uploadFileList; upFileCollection = (new TrueTask.Common()).SaveSingleUploadFile(upFileCollection, userId); #endregion #region Save Report Document Info DocumentDTO iwpDocument = new DocumentDTO(); iwpDocument.DocumentID = iwpDocumentId; iwpDocument.FIWPID = fiwps[0].FiwpID; //iwpDocument.SPCollectionID = upFileCollection.uploadedFileDTOList[0].UploadedFileInfoId; iwpDocument.FileStoreId = upFileCollection.uploadedFileDTOList[0].FileStoreId; iwpDocument.UpdatedBy = string.IsNullOrEmpty(fiwps[0].UpdatedBy) ? userId : fiwps[0].UpdatedBy; iwpDocument.IsDisplayable = "Y"; if (iwpDocument.DocumentID > 0) iwpDocument.DTOStatus = (int)RowStatusNo.Update; else iwpDocument.DTOStatus = (int)RowStatusNo.New; documents.Clear(); documents.Add(iwpDocument); documents = SaveDocument(documents); #endregion //Update Assemble Step if (fiwps[0].DocEstablishedLUID != Element.Reveal.DataLibrary.Utilities.AssembleStep.APPROVER) fiwps = (new TrueTask.Build()).SaveIwp(fiwps); // scope.Complete(); //} return documents; }
public List<DocumentDTO> JsonSaveDocumentWithOZformForAssembleIWP(List<FiwpDTO> fiwps, UpfileDTOS upFileCollection, string curStepCode, string userId) { return (new Element.Sigma.Web.Biz.TrueTask.Assemble()).SaveDocumentWithOZformForAssembleIWP(fiwps, upFileCollection, Helper.RemoveJsonParameterWrapper(curStepCode), Helper.RemoveJsonParameterWrapper(userId)); }
//public void UpdateQaqcformForSign(int qaqcformId, string savedUrl, int SPCollectionID, bool isSubmitted) //{ // (new Element.Reveal.Server.BALC.ProjectWriter()).UpdateQaqcformForSign(qaqcformId, savedUrl, SPCollectionID, isSubmitted); //} //public void JsonUpdateQaqcformForSign(string qaqcformId, string savedUrl, string SPCollectionID, string isSubmitted) //{ // (new Element.Reveal.Server.BALC.ProjectWriter()).UpdateQaqcformForSign(Int32.Parse(qaqcformId), savedUrl, Int32.Parse(SPCollectionID), bool.Parse(isSubmitted)); //} //public void UpdateSingleMaterialWithReelNo(int materialId, string newReelNo) //{ // (new Element.Reveal.Server.BALC.ProjectWriter()).UpdateMaterialWithReelNo(materialId, newReelNo); //} //public void JsonUpdateSingleMaterialWithReelNo(string materialId, string newReelNo) //{ // (new Element.Reveal.Server.BALC.ProjectWriter()).UpdateMaterialWithReelNo(Int32.Parse(materialId), newReelNo); //} //public void UpdateSingleProgressWithCWP(int progressId, int newCwpId) //{ // (new Element.Reveal.Server.BALC.ProjectWriter()).UpdateProgressWithCWP(progressId, newCwpId); //} //public void JsonUpdateSingleProgressWithCWP(string progressId, string newCwpId) //{ // (new Element.Reveal.Server.BALC.ProjectWriter()).UpdateProgressWithCWP(Int32.Parse(progressId), Int32.Parse(newCwpId)); //} //public void UpdateTimesheetToP6(int fiwpId, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).UpdateTimesheetToP6(fiwpId, userName, password); //} //public void JsonUpdateTimesheetToP6(string fiwpId, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).UpdateTimesheetToP6(Int32.Parse(fiwpId), userName, password); //} //public void SyncProjectScheduleToP6(int projectscheduleId, int projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncProjectScheduleToP6(projectscheduleId, projectId, Helper.RemoveJsonParameterWrapper(disciplineCode), userName, password); //} //public void JsonSyncProjectScheduleToP6(string projectscheduleId, string projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncProjectScheduleToP6(Int32.Parse(projectscheduleId), Int32.Parse(projectId), Int32.Parse(disciplineCode), userName, password); //} //public void SyncFIWPResourceToP6(int fiwpId, int projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncFIWPResourceToP6(fiwpId, projectId, Helper.RemoveJsonParameterWrapper(disciplineCode), userName, password); //} //public void JsonSyncFIWPResourceToP6(string fiwpId, string projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncFIWPResourceToP6(Int32.Parse(fiwpId), Int32.Parse(projectId), Int32.Parse(disciplineCode), userName, password); //} //public void SyncScheduleResourceToP6(int fiwpId, int projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncScheduleResourceToP6(fiwpId, projectId, Helper.RemoveJsonParameterWrapper(disciplineCode), userName, password); //} //public void JsonSyncScheduleResourceToP6(string fiwpId, string projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncScheduleResourceToP6(Int32.Parse(fiwpId), Int32.Parse(projectId), Int32.Parse(disciplineCode), userName, password); //} //public void SyncScheduleResourceToP6ByProjectSchedule(int projectscheduleId, int projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncScheduleResourceToP6ByProjectSchedule(projectscheduleId, projectId, Helper.RemoveJsonParameterWrapper(disciplineCode), userName, password); //} //public void JsonSyncScheduleResourceToP6ByProjectSchedule(string projectscheduleId, string projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncScheduleResourceToP6ByProjectSchedule(Int32.Parse(projectscheduleId), Int32.Parse(projectId), Int32.Parse(disciplineCode), userName, password); //} //public void SyncScheduleFIWPResourceToP6(int fiwpId, int projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncScheduleFIWPResourceToP6(fiwpId, projectId, Helper.RemoveJsonParameterWrapper(disciplineCode), userName, password); //} //public void JsonSyncScheduleFIWPResourceToP6(string fiwpId, string projectId, string disciplineCode, string userName, string password) //{ // (new Element.Reveal.Server.BALC.ScheduleWriter()).SyncScheduleFIWPResourceToP6(Int32.Parse(fiwpId), Int32.Parse(projectId), Int32.Parse(disciplineCode), userName, password); //} ////LibInsul------------------------------------------------------------- //public List<LibinsulfactorDTO> SaveLibinsulfactor(List<LibinsulfactorDTO> lib) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveLibinsulfactor(lib); //} //public List<LibinsulpaintmanhourDTO> SaveLibinsulpaintmanhour(List<LibinsulpaintmanhourDTO> lib) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveLibinsulpaintmanhour(lib); //} //public List<LibinsulpipefactorDTO> SaveLibinsulpipefactor(List<LibinsulpipefactorDTO> lib) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveLibinsulpipefactor(lib); //} //public List<LibinsulpipemanhourDTO> SaveLibinsulpipemanhour(List<LibinsulpipemanhourDTO> lib) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveLibinsulpipemanhour(lib); //} //public int UploadSharePointForSPCollectionID(int projectId, string collection, string docName) //{ // try // { // return (new Element.Reveal.Server.BALC.ProjectWriter()).UploadSharePointForSPCollectionID(projectId, collection, docName, null, null, null, null, null, Cookies.GetSPCredential()); // } // catch (Exception ex) // { // throw ex; // } //} //public int JsonUploadSharePointForSPCollectionID(string projectId, string collection, string docName) //{ // try // { // return (new Element.Reveal.Server.BALC.ProjectWriter()).UploadSharePointForSPCollectionID(Int32.Parse(projectId), collection, docName, null, null, null, null, null, Cookies.GetSPCredential()); // } // catch (Exception ex) // { // throw ex; // } //} ///// <summary> ///// 2013-11-25 ///// </summary> ///// <param name="dbInstance"></param> ///// <param name="DrawingData"></param> ///// <param name="drwaings"></param> ///// <param name="fileNm"></param> ///// <param name="siteInstance"></param> ///// <param name="webPath"></param> ///// <param name="physicalpath"></param> ///// <returns></returns> //public DrawingDTO SaveMultiDrawingAndUpload(byte[] DrawingData, DrawingDTO drwaings, string fileNm, string siteInstance, string webPath, string physicalpath) //{ // try // { // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveMultiDrawingAndUpload(DrawingData, drwaings, siteInstance, webPath, physicalpath, fileNm, Cookies.GetSPCredential()); // } // catch (Exception ex) // { // throw ex; // } //} //public List<DrawingDTO> SaveMultiDrawingAndUpload2(List<DrawingDTO> drwaings) //{ // try // { // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveMultiDrawingAndUpload2(drwaings, Cookies.GetSPCredential()); // } // catch (Exception ex) // { // throw ex; // } //} //public DrawingDTO SaveDrawingAndUpload(DrawingDTO drwaings, string fileNm, string siteInstance, string webPath, string physicalpath) //{ // try // { // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveDrawingAndUpload(drwaings, siteInstance, webPath, physicalpath, fileNm, Cookies.GetSPCredential()); // } // catch (Exception ex) // { // throw ex; // } //} //public DrawingDTO SaveDrawingAndGenerate(DrawingDTO drwaings, string siteInstance, string webPath) //{ // try // { // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveDrawingAndGenerate(drwaings, siteInstance, webPath, Helper.GetImagePhysicalPath()); // } // catch (Exception ex) // { // throw ex; // } //} //public void RegenerateCXML(int projectId, string siteInstance, string webPath) //{ // (new Element.Reveal.Server.BALC.ProjectWriter()).RegenerateCXML(projectId, siteInstance, webPath, Helper.GetImagePhysicalPath()); //} //public string GetImagePhysicalPath() //{ // try // { // return Helper.GetImagePhysicalPath(); // } // catch (Exception ex) // { // throw ex; // } //} //public string GetImageLocationURL() //{ // try // { // return Helper.GetImageLocationURL(); // } // catch (Exception ex) // { // throw ex; // } //} ///// <summary> ///// Delete MTO and Importedfilename objects which object contains the specified ImportedfilenameID to match. ///// </summary> ///// <param name="dbInstance">The name of the database instance is what you use to refer to a particular connection string for a particular provider via code</param> ///// <param name="importedfilenameId">ImportedfilenameID to search for</param> ///// <returns></returns> ///// <summary> ///// Save(contains Update and Delete) Documentmarkup objects. ///// </summary> ///// <param name="dbInstance">The name of the database instance is what you use to refer to a particular connection string for a particular provider via code</param> ///// <param name="documentmarkup">Documentmarkup objects to save</param> ///// <returns>DocumentmarkupDTO</returns> //public List<DocumentmarkupDTO> SaveDocumentmarkup(List<DocumentmarkupDTO> documentmarkup) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveDocumentmarkup(documentmarkup); //} ///// <summary> ///// Save(contains Update and Delete) Documentmarkup objects. ///// </summary> ///// <param name="dbInstance">The name of the database instance is what you use to refer to a particular connection string for a particular provider via code</param> ///// <param name="documentmarkup">Documentmarkup objects to save</param> ///// <returns>DocumentmarkupDTO</returns> //public List<DocumentmarkupDTO> JsonSaveDocumentmarkup(List<DocumentmarkupDTO> documentmarkup) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveDocumentmarkup(documentmarkup); //} ///// <summary> ///// Create Documentmarkup object and Make default sharepoint item. ///// </summary> ///// <param name="dbInstance">The name of the database instance is what you use to refer to a particular connection string for a particular provider via code</param> ///// <param name="projectId">ProjectID to search for</param> ///// <param name="documentmarkup">Documentmarkup object to save</param> ///// <returns>DocumentmarkupDTO</returns> //public DocumentmarkupDTO SaveDocumentmarkupWithSharePoint(int projectId, DocumentmarkupDTO documentmarkup) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveDocumentmarkupWithSharePoint(projectId, documentmarkup, Cookies.GetSPCredential()); //} ///// <summary> ///// Create Documentmarkup object and Make default sharepoint item. ///// </summary> ///// <param name="dbInstance">The name of the database instance is what you use to refer to a particular connection string for a particular provider via code</param> ///// <param name="projectId">ProjectID to search for</param> ///// <param name="documentmarkup">Documentmarkup object to save</param> ///// <returns>DocumentmarkupDTO</returns> //public DocumentmarkupDTO JsonSaveDocumentmarkupWithSharePoint(string projectId, DocumentmarkupDTO documentmarkup) //{ // return (new Element.Reveal.Server.BALC.ProjectWriter()).SaveDocumentmarkupWithSharePoint(Int32.Parse(projectId), documentmarkup, Cookies.GetSPCredential()); //} public DocumentmarkupDTO JsonSaveDocumentmarkupWithMarkupImage(DocumentmarkupDTO documentmarkup, UpfileDTOS upFileCollection) { return (new Element.Sigma.Web.Biz.TrueTask.Viewer()).SaveDocumentmarkupWithMarkupImage(documentmarkup, upFileCollection); }
//#endregion public UpfileDTOS JsonSaveUploadFile(UpfileDTOS upFileDS, string userId) { //string rootPath = System.Web.Configuration.WebConfigurationManager.AppSettings["DocumentUpload"]; //return (new Element.Sigma.Web.Biz.TrueTask.Common()).JsonSaveUploadFile(upFileInfo, rootPath); return (new Element.Sigma.Web.Biz.TrueTask.Common()).SaveSingleUploadFile(upFileDS, userId); }
public DocumentmarkupDTO SaveDocumentmarkupWithMarkupImage(DocumentmarkupDTO documentmarkup, UpfileDTOS upFileCollection) { //TransactionScope scope = null; //byte[] bytes = null; string fileType = Element.Reveal.DataLibrary.Utilities.FileType.DRAWING_MARKUP; string fileName = documentmarkup.PersonnelID + "_" + documentmarkup.DrawingID + "_" + fileType; //using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) //{ #region Upload Report File & Save File Info upFileCollection.fileStoreDTOList[0].FileTitle = fileName; upFileCollection.fileStoreDTOList[0].FileDescription = DateTime.Now.ToString(); upFileCollection.fileStoreDTOList[0].FileCategory = Element.Reveal.DataLibrary.Utilities.FileCategory.REPORT; upFileCollection.fileStoreDTOList[0].FileTypeCode = fileType; upFileCollection.uploadedFileDTOList[0].Name = fileName; upFileCollection.uploadedFileDTOList[0].UploadedBy = documentmarkup.UpdatedBy; upFileCollection.uploadedFileDTOList[0].UploadedDate = DateTime.Now; upFileCollection.uploadedFileDTOList[0].CreatedBy = documentmarkup.UpdatedBy; upFileCollection.uploadedFileDTOList[0].UpdatedBy = documentmarkup.UpdatedBy; upFileCollection = (new TrueTask.Common()).SaveSingleUploadFile(upFileCollection, documentmarkup.PersonnelID); #endregion #region Save Report Document Info List<DocumentmarkupDTO> documentmarkups = new List<DocumentmarkupDTO>(); //documentmarkup.SPCollectionID = upFileCollection.uploadedFileDTOList[0].UploadedFileInfoId; documentmarkup.FileStoreId = upFileCollection.uploadedFileDTOList[0].FileStoreId; documentmarkups.Add(documentmarkup); documentmarkups = SaveDrawingMarkup(documentmarkups); if (documentmarkups != null && documentmarkups.Count > 0) documentmarkup = documentmarkups[0]; #endregion // scope.Complete(); //} return documentmarkup; }
public SigmaResultTypeDTO SaveCrewAttendance_Rpt(int dailybrassId, string sigmauserId) { SigmaResultTypeDTO result = new SigmaResultTypeDTO(); DataSet ds = GetCrewAttendance_Rpt(dailybrassId); int projectId = 0; List<rptDailyBrassInOutDTO> brassList = DTOHelper.DataTableToListDTO<rptDailyBrassInOutDTO>(ds, 0); List<rptCrewAttendanceHeader> headerList = DTOHelper.DataTableToListDTO<rptCrewAttendanceHeader>(ds, 1); if (brassList.Count > 0 && headerList.Count > 0) { projectId = headerList[0].ProjectId; List<ReportParameter> Params = new List<ReportParameter>(); Params.Add(new ReportParameter("DailyBrassID", dailybrassId.ToString())); Params.Add(new ReportParameter("ProjectID", projectId.ToString())); //Params.Add(new ReportParameter("imgurl", @".\Resource\images\Logo.png")); LocalReport report = new LocalReport(); report.ReportPath = @"..\Element.Sigma.Web.Biz\TrueTask\Resource\rdl\RPTCrewAttendance.rdl"; report.EnableExternalImages = true; report.SetParameters(Params); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource("dsDailyBrassSign", brassList)); report.DataSources.Add(new ReportDataSource("dsHeader", headerList)); byte[] bytes = report.Render("Image"); string fileName = headerList[0].ForemanId + '_' + dailybrassId.ToString(); #region Upload Report File & Save File Info string fileType = Element.Reveal.DataLibrary.Utilities.FileType.CREW_ATTENDANCE; int dailyBrassReportId = 0; int fileStoreId = 0; string fileExtension = "jpg"; //Check existence List<ComboBoxDTO> exists = GetDailybrassreportByDailybrassFiletype_Combo(dailybrassId, fileType); if (exists != null && exists.Count > 0) { dailyBrassReportId = exists[0].DataID; int.TryParse(exists[0].ExtraValue3, out fileStoreId); fileName = exists[0].DataName; fileExtension = exists[0].ExtraValue4; } UpfileDTOS upFileCollection = new UpfileDTOS(); List<FileStoreDTO> fileStoreList = new List<FileStoreDTO>(); List<UploadedFileInfoDTO> uploadFileList = new List<UploadedFileInfoDTO>(); FileStoreDTO fileStore = new FileStoreDTO(); fileStore.FileTitle = fileName; fileStore.FileDescription = DateTime.Now.ToString(); fileStore.FileCategory = Element.Reveal.DataLibrary.Utilities.FileCategory.REPORT; fileStore.FileTypeCode = fileType; fileStore.CreatedBy = sigmauserId; fileStore.UpdatedBy = sigmauserId; fileStore.FileStoreId = fileStoreId; fileStore.ProjectId = projectId; fileStoreList.Add(fileStore); upFileCollection.fileStoreDTOList = fileStoreList; UploadedFileInfoDTO uploadFile = new UploadedFileInfoDTO(); uploadFile.Name = fileName; uploadFile.Size = bytes.Length; uploadFile.FileExtension = fileExtension; uploadFile.UploadedBy = sigmauserId; uploadFile.UploadedDate = DateTime.Now; uploadFile.CreatedBy = sigmauserId; uploadFile.UpdatedBy = sigmauserId; uploadFile.byteFile = bytes; uploadFile.UploadedFileInfoId = 0; uploadFile.FileStoreId = fileStoreId; uploadFileList.Add(uploadFile); upFileCollection.uploadedFileDTOList = uploadFileList; upFileCollection = (new TrueTask.Common()).SaveSingleUploadFile(upFileCollection, sigmauserId); #endregion #region Save Report Document Info List<DailybrassreportDTO> reportDTOList = new List<DailybrassreportDTO>(); DailybrassreportDTO reportDTO = new DailybrassreportDTO(); reportDTO.DailyBrassReportId = dailyBrassReportId; reportDTO.DailyBrassId = dailybrassId; reportDTO.UploadedFileInfoId = upFileCollection.uploadedFileDTOList[0].UploadedFileInfoId; reportDTO.UpdatedBy = sigmauserId; reportDTO.DTOStatus = (int)RowStatusNo.New; reportDTOList.Add(reportDTO); reportDTOList = SaveDailyBrassReport(reportDTOList); #endregion result.IsSuccessful = true; } else { result.AffectedRow = -1; result.ErrorCode = ""; result.ErrorMessage = "no data"; result.IsSuccessful = false; } return result; }