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