public ValidationResult AddDocProperty(DSM_DocProperty docProperty, string action, out string status)
{
docPropertyDataService.AddDocProperty(docProperty, action, out status);
if (status.Length > 0)
{
return(new ValidationResult(status, localizationService.GetResource(status)));
}
return(ValidationResult.Success);
}
public async Task <dynamic> EditDocProperty(DSM_DocProperty obDocProperty)
{
if (ModelState.IsValid)
{
action = "edit";
obDocProperty.SetBy = UserID;
obDocProperty.ModifiedBy = obDocProperty.SetBy;
respStatus = await Task.Run(() => _docPropertyService.AddDocProperty(obDocProperty, action, out outStatus));
return(Json(new { Message = respStatus.Message, respStatus }, JsonRequestBehavior.AllowGet));
}
else
{
respStatus = new ValidationResult("E404", _localizationService.GetResource("E404"));
}
return(Json(new { Message = respStatus.Message, respStatus }, JsonRequestBehavior.AllowGet));
}
public string AddDocProperty(DSM_DocProperty docProperty, string action, out string errorNumber)
{
errorNumber = String.Empty;
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
SqlDatabase db = factory.CreateDefault() as SqlDatabase;
using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetDocProperty"))
{
// Set parameters
db.AddInParameter(dbCommandWrapper, "@DocPropertyID", SqlDbType.NVarChar, docProperty.DocPropertyID);
db.AddInParameter(dbCommandWrapper, "@DocCategoryID", SqlDbType.NVarChar, docProperty.DocCategoryID.Trim());
db.AddInParameter(dbCommandWrapper, "@OwnerLevelID", SqlDbType.NVarChar, docProperty.OwnerLevelID.Trim());
db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, docProperty.OwnerID.Trim());
db.AddInParameter(dbCommandWrapper, "@DocTypeID ", SqlDbType.NVarChar, docProperty.DocTypeID.Trim());
db.AddInParameter(dbCommandWrapper, "@DocPropertySL", SqlDbType.NVarChar, docProperty.DocPropertySL != null?docProperty.DocPropertySL.Trim():"");
db.AddInParameter(dbCommandWrapper, "@UDDocPropertyCode", SqlDbType.NVarChar, docProperty.UDDocPropertyCode != null? docProperty.UDDocPropertyCode.Trim():"");
db.AddInParameter(dbCommandWrapper, "@DocPropertyName", SqlDbType.NVarChar, docProperty.DocPropertyName != null? docProperty.DocPropertyName.Trim():"");
db.AddInParameter(dbCommandWrapper, "@DocClassification", SqlDbType.NVarChar, docProperty.DocClassification != null? docProperty.DocClassification.Trim():"");
db.AddInParameter(dbCommandWrapper, "@PreservationPolicy ", SqlDbType.NVarChar, docProperty.PreservationPolicy);
db.AddInParameter(dbCommandWrapper, "@PhysicalLocation", SqlDbType.NVarChar, docProperty.PhysicalLocation != null? docProperty.PhysicalLocation.Trim():"");
db.AddInParameter(dbCommandWrapper, "@Remarks", SqlDbType.NVarChar, docProperty.Remarks != null? docProperty.Remarks.Trim():"");
db.AddInParameter(dbCommandWrapper, "@SetBy ", SqlDbType.NVarChar, docProperty.SetBy.Trim());
db.AddInParameter(dbCommandWrapper, "@ModifiedBy", SqlDbType.NVarChar, docProperty.ModifiedBy.Trim());
db.AddInParameter(dbCommandWrapper, "@SerialNo", SqlDbType.Int, docProperty.SerialNo);
db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, docProperty.Status);
db.AddInParameter(dbCommandWrapper, "@Action", SqlDbType.VarChar, action);
db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10);
// Execute SP.
db.ExecuteNonQuery(dbCommandWrapper);
// Getting output parameters and setting response details.
if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero())
{
// Get the error number, if error occurred.
errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode();
}
}
}
catch (Exception ex)
{
errorNumber = "E404"; // Log ex.Message Insert Log Table
}
return(errorNumber);
}
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));
}
}
