/// <summary> /// This method is used to get Document details. /// </summary> /// <param name="i_sConnectionString">Connection string</param> /// <param name="i_nDocumentDetailsID">DocumentDetailsID to delete</param> /// <returns>Returns boolean value based on the result</returns> public DocumentDetailsDTO GetDocumentDetails(string i_sConnectionString, int i_nDocumentDetailsID) { DocumentDetailsDTO objDocumentDetailsDTO = new DocumentDetailsDTO(); try { //DocumentDetailsDAL objDocumentDetailsDAL = new DocumentDetailsDAL(); using (var objDocumentDetailsDAL = new DocumentDetailsDAL()) { objDocumentDetailsDTO = objDocumentDetailsDAL.GetDocumentDetails(i_sConnectionString, i_nDocumentDetailsID); } } catch (Exception exp) { throw exp; } return(objDocumentDetailsDTO); }
/// <summary> /// This method is used for the insert/Update SaveDocumentDetails details. /// </summary> /// <param name="i_sConnectionString">Connection string</param> /// <param name="i_objDocumentDetailsDTO">DocumentDetails Object</param> /// <param name="nLoggedInUserId">Logged In User</param> /// <returns>Returns boolean value based on the result</returns> public List <DocumentDetailsModel> SaveDocumentDetails(string i_sConnectionString, List <DocumentDetailsModel> i_lstDocumentDetailsModel, int i_nMapToCodeTypeId, int i_nMaptoID, int i_nLoggedInUserId, string companyName = null) { List <DocumentDetailsModel> retListDocumentDetailsModel = new List <DocumentDetailsModel>(); DocumentDetailsDTO objDocumentDetailsDTO = new DocumentDetailsDTO(); string directory = ConfigurationManager.AppSettings["Document"]; string rootDirectory = directory; DirectoryInfo di; LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); try { //DocumentDetailsDAL objDocumentDetailsDAL = new DocumentDetailsDAL(); //check file is uploaded by checking document model if (i_lstDocumentDetailsModel != null && i_lstDocumentDetailsModel.Count > 0) { foreach (DocumentDetailsModel objDocumentDetailsModel in i_lstDocumentDetailsModel) { //check file is uploaded for same code type as in model if (objDocumentDetailsModel.MapToTypeCodeId == i_nMapToCodeTypeId) { //check GUID - guid null means file does not exists on system - either in temp folder or actual folder if (objDocumentDetailsModel.GUID == null) { //check if actual file is uploaded by checking model document property if (objDocumentDetailsModel.Document != null) { //get file property for uploaded file and set model property string extension = System.IO.Path.GetExtension(objDocumentDetailsModel.Document.FileName); string newFileName = Guid.NewGuid() + extension; objDocumentDetailsModel.DocumentName = objDocumentDetailsModel.Document.FileName; objDocumentDetailsModel.GUID = newFileName; objDocumentDetailsModel.DocumentPath = Path.Combine(directory, objDocumentDetailsModel.MapToTypeCodeId.ToString(), objDocumentDetailsModel.MapToId.ToString(), newFileName); objDocumentDetailsModel.FileSize = objDocumentDetailsModel.Document.ContentLength; objDocumentDetailsModel.FileType = extension; //check directory folder and if not exists then create folder to upload file if (!Directory.Exists(Path.Combine(directory, objDocumentDetailsModel.MapToTypeCodeId.ToString(), objDocumentDetailsModel.MapToId.ToString()))) { di = Directory.CreateDirectory(Path.Combine(directory, objDocumentDetailsModel.MapToTypeCodeId.ToString(), objDocumentDetailsModel.MapToId.ToString())); } //save existing document with new document uploaded objDocumentDetailsModel.Document.SaveAs(objDocumentDetailsModel.DocumentPath); Common.Common.CopyObjectPropertyByName(objDocumentDetailsModel, objDocumentDetailsDTO); //save record into DB for file upload using (var objDocumentDetailsDAL = new DocumentDetailsDAL()) { objDocumentDetailsDTO = objDocumentDetailsDAL.SaveDocumentDetails(i_sConnectionString, objDocumentDetailsDTO, objLoginUserDetails.LoggedInUserID); } Common.Common.CopyObjectPropertyByName(objDocumentDetailsDTO, objDocumentDetailsModel); //add save/updated record into list retListDocumentDetailsModel.Add(objDocumentDetailsModel); } } else { // file is exists on system as GUID is exists //check document id for existing records or new records if (objDocumentDetailsModel.DocumentId != 0) { //check if actual file is uploaded by checking model document property if (objDocumentDetailsModel.Document != null) { //get file property for uploaded file and set model property string extension = Path.GetExtension(objDocumentDetailsModel.Document.FileName); //set document path property because it is remove from UI objDocumentDetailsModel.DocumentPath = Path.Combine(directory, objDocumentDetailsModel.MapToTypeCodeId.ToString(), objDocumentDetailsModel.MapToId.ToString(), objDocumentDetailsModel.GUID); //rename existing file - break file and extention, add "_old" to file, String file_name_without_ext = Path.GetFileNameWithoutExtension(objDocumentDetailsModel.DocumentPath); String old_file_extention = Path.GetExtension(objDocumentDetailsModel.DocumentPath); string src_file_folder = Path.GetDirectoryName(objDocumentDetailsModel.DocumentPath); String des_old_file_path = Path.Combine(src_file_folder, file_name_without_ext + "_old" + old_file_extention); File.Move(objDocumentDetailsModel.DocumentPath, des_old_file_path); //replace new file extenstion for existing guid objDocumentDetailsModel.GUID = file_name_without_ext + extension; objDocumentDetailsModel.DocumentName = (objDocumentDetailsModel.MapToTypeCodeId == ConstEnum.Code.UserDocument) ? objDocumentDetailsModel.DocumentName: objDocumentDetailsModel.Document.FileName; objDocumentDetailsModel.DocumentPath = Path.Combine(directory, objDocumentDetailsModel.MapToTypeCodeId.ToString(), objDocumentDetailsModel.MapToId.ToString(), objDocumentDetailsModel.GUID); objDocumentDetailsModel.FileSize = objDocumentDetailsModel.Document.ContentLength; objDocumentDetailsModel.FileType = extension; //save existing document with new document uploaded objDocumentDetailsModel.Document.SaveAs(objDocumentDetailsModel.DocumentPath);//copy new file with same guid and new extension //delete old file FileInfo del_file = new FileInfo(des_old_file_path); del_file.Delete(); Common.Common.CopyObjectPropertyByName(objDocumentDetailsModel, objDocumentDetailsDTO); } else { using (var objDocumentDetailsDAL = new DocumentDetailsDAL()) { objDocumentDetailsDTO = objDocumentDetailsDAL.GetDocumentDetails(i_sConnectionString, Convert.ToInt32(objDocumentDetailsModel.DocumentId)); } objDocumentDetailsDTO.DocumentName = objDocumentDetailsModel.DocumentName; objDocumentDetailsDTO.Description = objDocumentDetailsModel.Description; } //update record into DB for file upload using (var objDocumentDetailsDAL = new DocumentDetailsDAL()) { objDocumentDetailsDTO = objDocumentDetailsDAL.SaveDocumentDetails(i_sConnectionString, objDocumentDetailsDTO, objLoginUserDetails.LoggedInUserID); } Common.Common.CopyObjectPropertyByName(objDocumentDetailsDTO, objDocumentDetailsModel); //add save/updated record into list retListDocumentDetailsModel.Add(objDocumentDetailsModel); } else if (objLoginUserDetails.DocumentDetails.Count > 0)//check user session for document uploaded when MaptoID not exists { //i_nMaptoID is not exists so save document in temp folder Dictionary <string, DocumentDetailsDTO> objDetailsDTO = new Dictionary <string, DocumentDetailsDTO>(); //get document details from session foreach (KeyValuePair <string, DocumentDetailsDTO> entry in objLoginUserDetails.DocumentDetails) { objDetailsDTO.Add(entry.Key, (DocumentDetailsDTO)entry.Value); } //process details to save foreach (KeyValuePair <string, DocumentDetailsDTO> dicDocumentDetailsDTO in objDetailsDTO) { //check existing session document to update record - compare MapToTypeCodeId and GUID with already saved session records if (dicDocumentDetailsDTO.Value.MapToTypeCodeId == objDocumentDetailsModel.MapToTypeCodeId && dicDocumentDetailsDTO.Value.GUID == objDocumentDetailsModel.GUID) { dicDocumentDetailsDTO.Value.MapToId = i_nMaptoID; objDocumentDetailsDTO = dicDocumentDetailsDTO.Value; string sSourceFile = Path.Combine(directory, "temp", objDocumentDetailsDTO.GUID); string sTargetFile = string.Empty; if (companyName != null) { sTargetFile = Path.Combine(directory, companyName, objDocumentDetailsDTO.MapToTypeCodeId.ToString(), objDocumentDetailsDTO.MapToId.ToString(), objDocumentDetailsDTO.GUID); } else { sTargetFile = Path.Combine(directory, objDocumentDetailsDTO.MapToTypeCodeId.ToString(), objDocumentDetailsDTO.MapToId.ToString(), objDocumentDetailsDTO.GUID); } objDocumentDetailsDTO.DocumentPath = sTargetFile; //check temp folder exists if (Directory.Exists(Path.Combine(directory, "temp"))) { if (companyName != null) { if (!Directory.Exists(Path.Combine(directory, companyName, objDocumentDetailsDTO.MapToTypeCodeId.ToString(), objDocumentDetailsDTO.MapToId.ToString()))) { di = Directory.CreateDirectory(Path.Combine(directory, companyName, objDocumentDetailsDTO.MapToTypeCodeId.ToString(), objDocumentDetailsDTO.MapToId.ToString())); } } else { //check directory folder and if not exists then create folder to upload file if (!Directory.Exists(Path.Combine(directory, objDocumentDetailsDTO.MapToTypeCodeId.ToString(), objDocumentDetailsDTO.MapToId.ToString()))) { di = Directory.CreateDirectory(Path.Combine(directory, objDocumentDetailsDTO.MapToTypeCodeId.ToString(), objDocumentDetailsDTO.MapToId.ToString())); } } //copy file from temp folder to target folder System.IO.File.Copy(sSourceFile, sTargetFile, true); //update record into DB for file upload using (var objDocumentDetailsDAL = new DocumentDetailsDAL()) { objDocumentDetailsDTO = objDocumentDetailsDAL.SaveDocumentDetails(i_sConnectionString, objDocumentDetailsDTO, objLoginUserDetails.LoggedInUserID); } //check if document details save in DB or not - if not save in DB then delete uploaded file if (objDocumentDetailsDTO == null) { //delete uploaded file and throw exception File.Delete(sTargetFile); Exception ex = new Exception("Document Details not saved"); throw ex; } else { DocumentDetailsModel objTempDocumentDetailsModel = new DocumentDetailsModel(); Common.Common.CopyObjectPropertyByName(objDocumentDetailsDTO, objTempDocumentDetailsModel); //add save/updated record into list retListDocumentDetailsModel.Add(objTempDocumentDetailsModel); //delete temp folder file File.Delete(sSourceFile); //delete/remove from session objLoginUserDetails.DocumentDetails.Remove(dicDocumentDetailsDTO.Value.GUID); //reset session after remove/delete from session Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); //when all document are removed from session break loop if (objLoginUserDetails.DocumentDetails.Count == 0) { break; } } } else { Exception ex = new Exception("Source File does not exist"); throw ex; } } } //save into user session Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); } } } } } } catch (Exception exp) { throw exp; } return(retListDocumentDetailsModel); }