public ValidationResult EditOwnerPropIdentity(DSM_DocPropIdentify modelDsmDocPropIdentify,
string action, out string status)
{
_OwnerProperIdentityDataService.AddOwnerPropIdentity(modelDsmDocPropIdentify, action,
out status);
if (status.Length > 0)
{
return(new ValidationResult(status, _localizationService.GetResource(status)));
}
return(ValidationResult.Success);
}
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 Task <dynamic> EditOwnerPropIdentity(DSM_DocPropIdentify modelDsmDocPropIdentify)
{
if (ModelState.IsValid)
{
action = "edit";
modelDsmDocPropIdentify.SetBy = UserID;
modelDsmDocPropIdentify.ModifiedBy = modelDsmDocPropIdentify.SetBy;
respStatus = await Task.Run(() => _ownerProperIdentityService.EditOwnerPropIdentity(modelDsmDocPropIdentify, 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 AddOwnerPropIdentity(DSM_DocPropIdentify modelDsmDocPropIdentify, string action, out string errorNumber)
{
errorNumber = String.Empty;
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
SqlDatabase db = factory.CreateDefault() as SqlDatabase;
using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetOwnerPropIdentity"))
{
db.AddInParameter(dbCommandWrapper, "@DocPropIdentifyID", SqlDbType.NVarChar, modelDsmDocPropIdentify.DocPropIdentifyID);
db.AddInParameter(dbCommandWrapper, "@OwnerLevelID", SqlDbType.NVarChar, modelDsmDocPropIdentify.OwnerLevel.OwnerLevelID);
db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, modelDsmDocPropIdentify.Owner.OwnerID);
db.AddInParameter(dbCommandWrapper, "@DocCategoryID ", SqlDbType.NVarChar, modelDsmDocPropIdentify.DocCategory.DocCategoryID);
db.AddInParameter(dbCommandWrapper, "@DocTypeID", SqlDbType.NVarChar, modelDsmDocPropIdentify.DocType.DocTypeID);
db.AddInParameter(dbCommandWrapper, "@DocPropertyID", SqlDbType.NVarChar, modelDsmDocPropIdentify.DocProperty.DocPropertyID);
db.AddInParameter(dbCommandWrapper, "@IdentificationCode", SqlDbType.NVarChar, modelDsmDocPropIdentify.IdentificationCode);
db.AddInParameter(dbCommandWrapper, "@IdentificationSL", SqlDbType.NVarChar, modelDsmDocPropIdentify.IdentificationSL);
db.AddInParameter(dbCommandWrapper, "@AttributeGroup ", SqlDbType.NVarChar, modelDsmDocPropIdentify.AttributeGroup);
db.AddInParameter(dbCommandWrapper, "@IdentificationAttribute", SqlDbType.NVarChar, modelDsmDocPropIdentify.IdentificationAttribute);
db.AddInParameter(dbCommandWrapper, "@IsRequired", SqlDbType.Bit, modelDsmDocPropIdentify.IsRequired);
db.AddInParameter(dbCommandWrapper, "@IsAuto", SqlDbType.Bit, modelDsmDocPropIdentify.IsAuto);
db.AddInParameter(dbCommandWrapper, "@IsRestriction", SqlDbType.Bit, modelDsmDocPropIdentify.IsRestricted);
db.AddInParameter(dbCommandWrapper, "@Remarks", SqlDbType.NVarChar, modelDsmDocPropIdentify.Remarks);
db.AddInParameter(dbCommandWrapper, "@SetBy ", SqlDbType.NVarChar, modelDsmDocPropIdentify.SetBy);
db.AddInParameter(dbCommandWrapper, "@ModifiedBy", SqlDbType.NVarChar, modelDsmDocPropIdentify.ModifiedBy);
db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, modelDsmDocPropIdentify.Status);
db.AddInParameter(dbCommandWrapper, "@Action", SqlDbType.VarChar, action);
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 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);
}
