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