protected override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); var parameter = e.Parameter as string; string sql = "SELECT title, nick_name, last_update, is_notice, document_srl FROM web.xe_documents WHERE module_srl=\"" + parameter + "\" ORDER BY update_order ASC"; App.conn.Open(); MySqlDataReader connreader = new MySqlCommand(sql, App.conn).ExecuteReader(); DocumentsInfo docsInfo; ObservableCollection <DocumentsInfo> docsInfoList = new ObservableCollection <DocumentsInfo>(); while (connreader.Read()) { docsInfo = new DocumentsInfo { title = connreader["title"].ToString(), name = connreader["nick_name"].ToString(), date = connreader["last_update"].ToString().Substring(0, 4) + "." + connreader["last_update"].ToString().Substring(4, 2) + "." + connreader["last_update"].ToString().Substring(6, 2), notice = connreader["is_notice"].ToString(), docNumber = connreader["document_srl"].ToString() }; docsInfoList.Add(docsInfo); } SeminarList.ItemsSource = docsInfoList; connreader.Close(); App.conn.Close(); }
public async Task <dynamic> UpdateDocMetaInfo(DocumentsInfo _modelDocumentsInfo) { Session["UserID"].ToString(); respStatus = await Task.Run(() => _originalDocSearchingService.UpdateDocMetaInfo(_modelDocumentsInfo, UserID, out outStatus)); return(Json(new { Message = respStatus.Message, respStatus }, JsonRequestBehavior.AllowGet)); }
public ValidationResult AddDocumentInfo(DocumentsInfo modelDocumentsInfo, string selectedPropId, List <DocMetaValue> lstMetaValues, string action, out string outStatus) { _docDistDataService.AddDocumentInfo(modelDocumentsInfo, selectedPropId, lstMetaValues, action, out outStatus); if (outStatus.Length > 0) { return(new ValidationResult(outStatus, _localizationService.GetResource(outStatus))); } return(ValidationResult.Success); }
private void SeminarList_ItemClick(object sender, ItemClickEventArgs e) { DocumentsInfo info = e.ClickedItem as DocumentsInfo; string docsNum = info.docNumber; string sql = "SELECT * FROM web.xe_documents WHERE document_srl=\"" + docsNum + "\""; var parameter = info; App.titleStack.Push(App.titleStack.Peek()); this.Frame.Navigate(typeof(DocumentView), parameter); }
public ValidationResult UpdateDocMetaInfo(DocumentsInfo _modelDocumentsInfo, string _UserID, out string outStatus) { _versionDocSearchingDataService.UpdateDocMetaInfo(_modelDocumentsInfo, _UserID, out outStatus); if (outStatus.Length > 0) { return(new ValidationResult(outStatus, _localizationService.GetResource(outStatus))); } return(ValidationResult.Success); }
protected void btnSave_Click(object sender, EventArgs e) { PortalSecurity objSecurity = new PortalSecurity(); var d = new DocumentsInfo(); var dc = new DocumentsInfoRepository(); if (Page.IsValid == true) { if (DocumentId > 0) { d = dc.GetItem(DocumentId, ModuleId); if (d != null) { d.CohortStartDate = DateTime.Parse(txtCohortStartDate.Text.ToString()); //d.Action = rdbAction.SelectedValue.ToString(); d.Action = dplAction.SelectedValue.ToString(); FileInfo documentFile = (FileInfo)FileManager.Instance.GetFile(d.FileId); d.GroupId = GroupId; } } else { d = new DocumentsInfo() { CreatedByUserId = UserId, CreatedOnDate = DateTime.UtcNow, CohortStartDate = DateTime.Parse(txtCohortStartDate.Text.ToString()), //Action = rdbAction.SelectedValue.ToString(), Action = dplAction.SelectedValue.ToString(), FileId = UploadFile(GroupId), GroupId = GroupId, }; } d.LastModifiedOnDate = DateTime.Now; d.LastModifiedByUserId = UserId; d.ModuleId = ModuleId; if (d.DocumentId > 0) { dc.UpdateItem(d); } else { dc.CreateItem(d); } //Response.Redirect(DotNetNuke.Common.Globals.NavigateURL()); //Response.Redirect(Globals.NavigateURL(PortalSettings.ActiveTab.TabID, PortalSettings, string.Empty , "groupId=" + GroupId.ToString())); Response.Redirect(Globals.NavigateURL(37, PortalSettings, string.Empty, "groupId=" + GroupId.ToString())); } }
public ValidationResult AddVersionDocumentInfo(DocumentsInfo _modelDocumentsInfo, string action, out DSM_DocPropIdentify docPropIdentifyList) { docPropIdentifyList = _versioningOfOriginalDocDataService.AddVersionDocumentInfo (_modelDocumentsInfo, action, out _errorNumber); if (_errorNumber.Length > 0) { return(new ValidationResult(_errorNumber, _localizationService.GetResource(_errorNumber))); } return(ValidationResult.Success); }
public async static Task <LanguageInformation> DetectLanguagesAsync(List <string> documents) { LanguageInformation detectedLanguage = null; HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("Ocp-Apim-Subscription-Key", Common.CoreConstants.TextAnalyticsSubscriptionKey); DocumentsInfo documentsInfo = new DocumentsInfo() { documents = new List <DocumentInfo>() }; foreach (var document in documents) { documentsInfo.documents.Add(new DocumentInfo() { id = Guid.NewGuid().ToString(), text = document }); } var payload = new HttpStringContent(JsonConvert.SerializeObject(documentsInfo)); payload.Headers.ContentType = new HttpMediaTypeHeaderValue("application/json"); var response = await client.PostAsync(new Uri($"{CogsExplorer.Common.CoreConstants.CognitiveServicesBaseUrl}/text/analytics/v2.0/languages"), payload); try { var results = await response.Content.ReadAsStringAsync(); var languageResults = JsonConvert.DeserializeObject <DocumentLanguageResult>(results); if (languageResults.documents.Count() > 0) { var primaryLanguage = languageResults.documents.FirstOrDefault().detectedLanguages.FirstOrDefault(); detectedLanguage = new LanguageInformation() { DisplayName = primaryLanguage.name, Abbreviation = primaryLanguage.iso6391Name, }; } } catch (Exception ex) { } return(detectedLanguage); }
public ValidationResult AddDocumentInfo(DocumentsInfo _modelDocumentsInfo, string _selectedPropID, List <DocMetaValue> _docMetaValues, string action, out List <DSM_DocPropIdentify> docPropIdentifyList) { docPropIdentifyList = _multiDocScanDataService.AddDocumentInfo (_modelDocumentsInfo, _selectedPropID, _docMetaValues, action, out _errorNumber); if (_errorNumber.Length > 0) { return(new ValidationResult(_errorNumber, _localizationService.GetResource(_errorNumber))); } return(ValidationResult.Success); }
public async static Task <List <DocumentSentimentInformation> > AnalyzeSentimentAsync(List <string> documents) { List <DocumentSentimentInformation> documentSentiments = new List <DocumentSentimentInformation>();; HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("Ocp-Apim-Subscription-Key", Common.CoreConstants.TextAnalyticsSubscriptionKey); DocumentsInfo documentsInfo = new DocumentsInfo() { documents = new List <DocumentInfo>() }; foreach (var document in documents) { documentsInfo.documents.Add(new DocumentInfo() { id = Guid.NewGuid().ToString(), language = "en", text = document }); } var payload = new HttpStringContent(JsonConvert.SerializeObject(documentsInfo)); payload.Headers.ContentType = new HttpMediaTypeHeaderValue("application/json"); var response = await client.PostAsync(new Uri($"{CogsExplorer.Common.CoreConstants.CognitiveServicesBaseUrl}/text/analytics/v2.0/sentiment"), payload); try { var results = await response.Content.ReadAsStringAsync(); var sentimentResults = JsonConvert.DeserializeObject <DocumentSentimentResult>(results); documentSentiments = (from result in sentimentResults.documents select new DocumentSentimentInformation() { Id = result.id, Score = result.score, }).ToList(); } catch (Exception ex) { } return(documentSentiments); }
public async static Task <List <string> > ExtractKeyPhrasesAsync(List <string> documents, string language) { List <string> keyPhrases = new List <string>(); HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("Ocp-Apim-Subscription-Key", Common.CoreConstants.TextAnalyticsSubscriptionKey); DocumentsInfo documentsInfo = new DocumentsInfo() { documents = new List <DocumentInfo>() }; foreach (var document in documents) { documentsInfo.documents.Add(new DocumentInfo() { id = Guid.NewGuid().ToString(), language = language, text = document }); } var payload = new HttpStringContent(JsonConvert.SerializeObject(documentsInfo)); payload.Headers.ContentType = new HttpMediaTypeHeaderValue("application/json"); var response = await client.PostAsync(new Uri($"{CogsExplorer.Common.CoreConstants.CognitiveServicesBaseUrl}/text/analytics/v2.0/keyPhrases"), payload); try { var results = await response.Content.ReadAsStringAsync(); var keyPhrasesResults = JsonConvert.DeserializeObject <KeyPhrases.DocumentKeyPhrasesResult>(results); foreach (var document in keyPhrasesResults.documents) { keyPhrases.AddRange(document.keyPhrases); } } catch (Exception ex) { } return(keyPhrases); }
public string UpdateDocMetaInfo(DocumentsInfo _modelDocumentsInfo, string userId, out string errorNumber) { errorNumber = String.Empty; try { DatabaseProviderFactory factory = new DatabaseProviderFactory(); SqlDatabase db = factory.CreateDefault() as SqlDatabase; DataTable docMetaDataTable = new DataTable(); docMetaDataTable.Columns.Add("DocMetaID"); docMetaDataTable.Columns.Add("MetaValue"); foreach (var item in _modelDocumentsInfo.DocMetaValues) { DataRow objDataRow = docMetaDataTable.NewRow(); objDataRow[0] = item.DocMetaID; objDataRow[1] = item.MetaValue; docMetaDataTable.Rows.Add(objDataRow); } using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("UpdateDocMetaVersionInfo")) { db.AddInParameter(dbCommandWrapper, "@Doc_Meta", SqlDbType.Structured, docMetaDataTable); db.AddInParameter(dbCommandWrapper, "@UserID", SqlDbType.NVarChar, userId); db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10); db.ExecuteNonQuery(dbCommandWrapper); if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero()) { errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode(); } } } catch (Exception ex) { errorNumber = "E404"; } return(errorNumber); }
public async Task <dynamic> AddVersionDocumentInfo(DocumentsInfo _modelDocumentsInfo) { DSM_DocPropIdentify objDocPropIdentifies = new DSM_DocPropIdentify(); if (ModelState.IsValid) { action = "add"; _modelDocumentsInfo.SetBy = UserID; _modelDocumentsInfo.ModifiedBy = _modelDocumentsInfo.SetBy; _modelDocumentsInfo.UploaderIP = GetIPAddress.LocalIPAddress(); respStatus.Message = "Success"; respStatus = await Task.Run(() => _versioningOfOriginalDocService.AddVersionDocumentInfo( _modelDocumentsInfo, action, out objDocPropIdentifies)); try { FolderGenerator.MakeFTPDir(objDocPropIdentifies.ServerIP, objDocPropIdentifies.ServerPort, objDocPropIdentifies.FileServerUrl, objDocPropIdentifies.FtpUserName, objDocPropIdentifies.FtpPassword); } catch (Exception e) { } return(Json(new { Message = respStatus.Message, result = objDocPropIdentifies, //DistinctID = DistinctDocIDs }, JsonRequestBehavior.AllowGet)); } else { //var errors = ModelState.Values.SelectMany(v => v.Errors); respStatus = new ValidationResult("E404", _localizationService.GetResource("E404")); return(Json(new { Message = respStatus.Message, respStatus }, JsonRequestBehavior.AllowGet)); } }
public void UpdateItem(DocumentsInfo i) { repo.UpdateItem(i); }
public void DeleteItem(DocumentsInfo i) { repo.DeleteItem(i); }
public void CreateItem(DocumentsInfo i) { repo.CreateItem(i); }
public async Task <dynamic> AddDocumentInfo(DocumentsInfo _modelDocumentsInfo, string _selectedPropID, List <DocMetaValue> _docMetaValues) { List <DSM_DocPropIdentify> objDocPropIdentifies = null; if (ModelState.IsValid) { action = "add"; _modelDocumentsInfo.SetBy = UserID; _modelDocumentsInfo.ModifiedBy = _modelDocumentsInfo.SetBy; _modelDocumentsInfo.UploaderIP = GetIPAddress.LocalIPAddress(); respStatus.Message = "Success"; respStatus = await Task.Run(() => _multiDocScanService.AddDocumentInfo(_modelDocumentsInfo, _selectedPropID, _docMetaValues, action, out objDocPropIdentifies)); var DistinctDocIDs1 = (from s in objDocPropIdentifies group s by new { s.DocumentID } into g select new { DocPropID = g.Select(p => p.DocPropertyID).FirstOrDefault(), DocumentID = g.Select(p => p.DocumentID).FirstOrDefault(), FileServerUrl = g.Select(x => x.FileServerUrl).FirstOrDefault() }).ToList(); List <DSM_DocProperty> proplList = new List <DSM_DocProperty>(); string[] docPropIDs = _selectedPropID.Split(','); foreach (var item in docPropIDs) { DSM_DocProperty objDocProperty = new DSM_DocProperty(); objDocProperty.DocPropertyID = item; proplList.Add(objDocProperty); } var DistinctDocIDs = (from p in proplList join d in DistinctDocIDs1 on p.DocPropertyID equals d.DocPropID select new { DocPropID = d.DocPropID, DocumentID = d.DocumentID, FileServerUrl = d.FileServerUrl }).ToList(); foreach (var item in DistinctDocIDs) { try { FolderGenerator.MakeFTPDir(objDocPropIdentifies.FirstOrDefault().ServerIP, objDocPropIdentifies.FirstOrDefault().ServerPort, item.FileServerUrl, objDocPropIdentifies.FirstOrDefault().FtpUserName, objDocPropIdentifies.FirstOrDefault().FtpPassword); } catch (Exception e) { } } return(Json(new { Message = respStatus.Message, result = objDocPropIdentifies, DistinctID = DistinctDocIDs }, JsonRequestBehavior.AllowGet)); } else { //var errors = ModelState.Values.SelectMany(v => v.Errors); respStatus = new ValidationResult("E404", _localizationService.GetResource("E404")); return(Json(new { Message = respStatus.Message, respStatus }, JsonRequestBehavior.AllowGet)); } }
public DSM_DocPropIdentify AddVersionDocumentInfo(DocumentsInfo _modelDocumentsInfo, string _action, out string _errorNumber) { DataTable docMetaDataTable = new DataTable(); docMetaDataTable.Columns.Add("DocPropertyID"); docMetaDataTable.Columns.Add("MetaValue"); docMetaDataTable.Columns.Add("Remarks"); docMetaDataTable.Columns.Add("DocPropIdentifyID"); docMetaDataTable.Columns.Add("DocMetaID"); foreach (var item in _modelDocumentsInfo.DocMetaValues) { if (item.VersionMetaValue != null) { DataRow objDataRow = docMetaDataTable.NewRow(); objDataRow[0] = _modelDocumentsInfo.DocPropertyID; objDataRow[1] = item.VersionMetaValue; objDataRow[2] = item.Remarks; objDataRow[3] = item.DocPropIdentifyID; objDataRow[4] = item.DocMetaID; docMetaDataTable.Rows.Add(objDataRow); } } DataTable docPropertyIDDataTable = new DataTable(); docPropertyIDDataTable.Columns.Add("DocPropertyID"); DataRow objDataRow2 = docPropertyIDDataTable.NewRow(); objDataRow2[0] = _modelDocumentsInfo.DocPropertyID; docPropertyIDDataTable.Rows.Add(objDataRow2); DSM_DocPropIdentify docPropIdentifyList = new DSM_DocPropIdentify(); _errorNumber = String.Empty; DatabaseProviderFactory factory = new DatabaseProviderFactory(); SqlDatabase db = factory.CreateDefault() as SqlDatabase; using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetVersionDocumentsInfo")) { db.AddInParameter(dbCommandWrapper, "@OwnerLevelID", SqlDbType.NVarChar, _modelDocumentsInfo.OwnerLevelID); db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, _modelDocumentsInfo.OwnerID); db.AddInParameter(dbCommandWrapper, "@DocCategoryID ", SqlDbType.NVarChar, _modelDocumentsInfo.DocCategoryID); db.AddInParameter(dbCommandWrapper, "@DocTypeID", SqlDbType.NVarChar, _modelDocumentsInfo.DocTypeID); db.AddInParameter(dbCommandWrapper, "@DocumentID", SqlDbType.NVarChar, _modelDocumentsInfo.DocumentID); db.AddInParameter(dbCommandWrapper, "@VersionID", SqlDbType.NVarChar, _modelDocumentsInfo.DocVersionID); db.AddInParameter(dbCommandWrapper, "@FileOriginalName", SqlDbType.NVarChar, ""); db.AddInParameter(dbCommandWrapper, "@FileCodeName", SqlDbType.NVarChar, ""); db.AddInParameter(dbCommandWrapper, "@FileExtension", SqlDbType.NVarChar, ""); db.AddInParameter(dbCommandWrapper, "@UploaderIP", SqlDbType.NVarChar, _modelDocumentsInfo.UploaderIP); db.AddInParameter(dbCommandWrapper, "@SetBy ", SqlDbType.NVarChar, _modelDocumentsInfo.SetBy); db.AddInParameter(dbCommandWrapper, "@ModifiedBy", SqlDbType.NVarChar, _modelDocumentsInfo.ModifiedBy); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, 1); db.AddInParameter(dbCommandWrapper, "@Doc_MetaTypeVersion", SqlDbType.Structured, docMetaDataTable); db.AddInParameter(dbCommandWrapper, "@Doc_PropertyType", SqlDbType.Structured, docPropertyIDDataTable); db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10); DataSet ds = db.ExecuteDataSet(dbCommandWrapper); if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero()) { _errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode(); if (ds.Tables[0].Rows.Count > 0) { DataTable dt1 = ds.Tables[0]; docPropIdentifyList = dt1.AsEnumerable().Select(reader => new DSM_DocPropIdentify { //DocMetaIDVersion = reader.GetString("DocMetaIDVersion"), //DocMetaID = reader.GetString("DocMetaID"), //DocumentID = reader.GetString("DocumentID"), //DocPropIdentifyID = reader.GetString("DocPropIdentifyID"), //DocPropertyID = reader.GetString("DocPropertyID"), //DocCategoryID = reader.GetString("DocCategoryID"), //DocTypeID = reader.GetString("DocTypeID"), //OwnerID = reader.GetString("OwnerID"), //IdentificationCode = reader.GetString("IdentificationCode"), //DocPropertyName = reader.GetString("DocPropertyName"), //AttributeGroup = reader.GetString("AttributeGroup"), //IdentificationAttribute = reader.GetString("IdentificationAttribute"), //MetaValue = reader.GetString("MetaValue"), //Remarks = reader.GetString("Remarks"), FileServerUrl = reader.GetString("FileServerUrl"), ServerIP = reader.GetString("ServerIP"), ServerPort = reader.GetString("ServerPort"), FtpUserName = reader.GetString("FtpUserName"), FtpPassword = reader.GetString("FtpPassword"), DocVersionID = reader.GetString("DocVersionID"), VersionNo = reader.GetString("VersionNo") }).FirstOrDefault(); } } } return(docPropIdentifyList); }
public string AddDocumentInfoForVersion(DocumentsInfo _modelDocumentsInfo, string _selectedPropID, List <DocMetaValue> _docMetaValues, string action, out string _errorNumber) { DataTable docMetaDataTable = new DataTable(); docMetaDataTable.Columns.Add("DocPropertyID"); docMetaDataTable.Columns.Add("MetaValue"); docMetaDataTable.Columns.Add("Remarks"); docMetaDataTable.Columns.Add("DocPropIdentifyID"); docMetaDataTable.Columns.Add("DocMetaID"); foreach (var item in _docMetaValues) { DataRow objDataRow = docMetaDataTable.NewRow(); objDataRow[0] = item.DocPropertyID; objDataRow[1] = item.MetaValue; objDataRow[2] = item.Remarks; objDataRow[3] = item.DocPropIdentifyID; objDataRow[4] = item.DocMetaID; docMetaDataTable.Rows.Add(objDataRow); } DataTable docPropertyIDDataTable = new DataTable(); docPropertyIDDataTable.Columns.Add("DocPropertyID"); string[] docPropIDs = _selectedPropID.Split(','); foreach (var item in docPropIDs) { DataRow objDataRow = docPropertyIDDataTable.NewRow(); objDataRow[0] = item; docPropertyIDDataTable.Rows.Add(objDataRow); } _errorNumber = String.Empty; DatabaseProviderFactory factory = new DatabaseProviderFactory(); SqlDatabase db = factory.CreateDefault() as SqlDatabase; using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetDocumentDistributionForVersion")) { db.AddInParameter(dbCommandWrapper, "@Doc_MetaTypeForVersion", SqlDbType.Structured, docMetaDataTable); db.AddInParameter(dbCommandWrapper, "@DocumentID", SqlDbType.NVarChar, _docMetaValues[0].DocumentID); db.AddInParameter(dbCommandWrapper, "@DocVersionID", SqlDbType.NVarChar, _docMetaValues[0].DocVersionID); //db.AddInParameter(dbCommandWrapper, "@OwnerLevelID", SqlDbType.NVarChar, _modelDocumentsInfo.OwnerLevel.OwnerLevelID); db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, _modelDocumentsInfo.Owner.OwnerID); db.AddInParameter(dbCommandWrapper, "@DocCategoryID ", SqlDbType.NVarChar, _modelDocumentsInfo.DocCategory.DocCategoryID); db.AddInParameter(dbCommandWrapper, "@DocTypeID", SqlDbType.NVarChar, _modelDocumentsInfo.DocType.DocTypeID); db.AddInParameter(dbCommandWrapper, "@DocPropertyID", SqlDbType.NVarChar, _selectedPropID); db.AddInParameter(dbCommandWrapper, "@Remarks", SqlDbType.NVarChar, _docMetaValues[0].Remarks == null ? "" : _docMetaValues[0].Remarks.Trim()); db.AddInParameter(dbCommandWrapper, "@SetBy ", SqlDbType.NVarChar, _modelDocumentsInfo.SetBy); db.AddInParameter(dbCommandWrapper, "@ModifiedBy", SqlDbType.NVarChar, _modelDocumentsInfo.ModifiedBy); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, 1); db.AddInParameter(dbCommandWrapper, "@DidtributionOf", SqlDbType.NVarChar, _modelDocumentsInfo.DidtributionOf); //db.AddInParameter(dbCommandWrapper, "@Doc_PropertyType", SqlDbType.Structured, docPropertyIDDataTable); db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10); DataSet ds = db.ExecuteDataSet(dbCommandWrapper); if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero()) { _errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode(); } } return(_errorNumber); }
public dynamic AddDocumentInfo(DocumentsInfo modelDocumentsInfo, string selectedPropId, DocMetaValue docMetaValues) { List <DocMetaValue> lstMetaValues = new List <DocMetaValue>(); List <DSM_DocPropIdentify> objDocPropIdentifies = new List <DSM_DocPropIdentify>(); List <string> existColumnName = new List <string>(); var action = ""; if (ModelState.IsValid) { action = "add"; modelDocumentsInfo.SetBy = _userId; modelDocumentsInfo.ModifiedBy = modelDocumentsInfo.SetBy; DataTable dt = (DataTable)TempData["ExcelData"]; if (dt != null) { _docPropertyIdentityService.GetDocPropIdentify(_userId, "", out objDocPropIdentifies); var documentList = objDocPropIdentifies.Where(ob => ob.DocPropertyID == modelDocumentsInfo.DocProperty.DocPropertyID).Select(ob => ob.IdentificationAttribute).ToList(); var arrayNames = (from DataColumn x in dt.Columns select x.ColumnName).ToArray(); foreach (string item in arrayNames) { if (documentList.Contains(item)) { existColumnName.Add(item); } } if (existColumnName.Count > 0) { // Database and Import File match column foreach (var columnName in existColumnName) { foreach (DataRow row in dt.Rows) { DocMetaValue ob = new DocMetaValue(); ob.DocumentID = docMetaValues.DocumentID; ob.MetaValue = row[columnName].ToString(); ob.DocPropIdentifyID = ( from t in objDocPropIdentifies where (t.DocCategoryID == modelDocumentsInfo.DocCategory.DocCategoryID) && (t.DocTypeID == modelDocumentsInfo.DocType.DocTypeID) && (t.IdentificationAttribute == columnName) select t.DocPropIdentifyID).FirstOrDefault();// docMetaValues.DocPropIdentifyID; ob.DocPropertyID = selectedPropId; ob.DocMetaID = docMetaValues.DocMetaID; ob.DocumentID = docMetaValues.DocumentID; ob.DocVersionID = docMetaValues.DocVersionID; lstMetaValues.Add(ob); } } if (lstMetaValues.Count > 0) { if (modelDocumentsInfo.DidtributionOf.Equals("Original")) { _respStatus = _docDistributionService.AddDocumentInfo(modelDocumentsInfo, selectedPropId, lstMetaValues, action, out outStatus); } else { _respStatus = _docDistributionService.AddDocumentInfoForVersion(modelDocumentsInfo, selectedPropId, lstMetaValues, action, out outStatus); } _respStatus = new SILDMS.Utillity.ValidationResult(outStatus, _localizationService.GetResource(outStatus)); } } else { _respStatus = new SILDMS.Utillity.ValidationResult("E411", _localizationService.GetResource("E411")); } } } else { //var errors = ModelState.Values.SelectMany(v => v.Errors); _respStatus = new SILDMS.Utillity.ValidationResult("E404", _localizationService.GetResource("E404")); // return Json(new { Message = _respStatus.Message, _respStatus }, JsonRequestBehavior.AllowGet); } return(Json(new { Message = _respStatus.Message, _respStatus }, JsonRequestBehavior.AllowGet)); }