public ValidationResult SetDocDestroyPolicy(DSM_DestroyPolicy model, string action, out string status) { _docDestroyPolicyDataService.SetDocDestroyPolicy(model, action, out status); if (status.Length > 0) { return(new ValidationResult(status, _localizationService.GetResource(status))); } return(ValidationResult.Success); }
public async Task <dynamic> SetDocDestroyPolicy(DSM_DestroyPolicy model) { if (ModelState.IsValid) { action = "add"; model.SetBy = UserID; model.ModifiedBy = model.SetBy; respStatus = await Task.Run(() => _destroyPolicyService.SetDocDestroyPolicy(model, action, out outStatus)); return(Json(new { Message = respStatus.Message, respStatus }, 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 string SetDocDestroy(DSM_DestroyPolicy model, string action, out string errorNumber) { errorNumber = String.Empty; try { IFormatProvider culture = new System.Globalization.CultureInfo("fr-FR", true); DatabaseProviderFactory factory = new DatabaseProviderFactory(); SqlDatabase db = factory.CreateDefault() as SqlDatabase; if (model.DocCategoryModel != null) { DataTable docCategoryDataTable = new DataTable(); docCategoryDataTable.Columns.Add("DestroyPolicyDtlID"); docCategoryDataTable.Columns.Add("DocCategoryID"); docCategoryDataTable.Columns.Add("TimeValue"); docCategoryDataTable.Columns.Add("TimeUnit"); docCategoryDataTable.Columns.Add("ExceptionValue"); foreach (var item in model.DocCategoryModel) { DataRow objDataRow = docCategoryDataTable.NewRow(); objDataRow[0] = item.DestroyPolicyDtlID; objDataRow[1] = item.CategoryID; objDataRow[2] = item.TimeValue; objDataRow[3] = item.TimeUnit; objDataRow[4] = item.ExceptionValue; docCategoryDataTable.Rows.Add(objDataRow); } using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetDocCategoryToDocDestroy")) { db.AddInParameter(dbCommandWrapper, "@DestroyID", SqlDbType.NVarChar, model.DestroyID ?? ""); db.AddInParameter(dbCommandWrapper, "@DestroyPolicyID", SqlDbType.NVarChar, model.DestroyPolicyID); db.AddInParameter(dbCommandWrapper, "@DestroyDate", SqlDbType.NVarChar, DateTime.Parse(model.DestroyDate, culture, System.Globalization.DateTimeStyles.AssumeLocal)); db.AddInParameter(dbCommandWrapper, "@DocumentNature", SqlDbType.NVarChar, model.DocumentNature); db.AddInParameter(dbCommandWrapper, "@PolicyApplicableTo", SqlDbType.NVarChar, model.PolicyApplicableTo); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.NVarChar, model.Status); db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, model.OwnerID); db.AddInParameter(dbCommandWrapper, "@UserID", SqlDbType.NVarChar, model.SetBy); db.AddInParameter(dbCommandWrapper, "@Doc_Category", SqlDbType.Structured, docCategoryDataTable); db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10); db.ExecuteNonQuery(dbCommandWrapper); if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero()) { errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode(); } } } else if (model.DocTypeModel != null) { DataTable docTypeDataTable = new DataTable(); docTypeDataTable.Columns.Add("DestroyPolicyDtlID"); docTypeDataTable.Columns.Add("DocTypeID"); docTypeDataTable.Columns.Add("TimeValue"); docTypeDataTable.Columns.Add("TimeUnit"); docTypeDataTable.Columns.Add("ExceptionValue"); foreach (var item in model.DocTypeModel) { DataRow objDataRow = docTypeDataTable.NewRow(); objDataRow[0] = item.DestroyPolicyDtlID; objDataRow[1] = item.TypeID; objDataRow[2] = item.TimeValue; objDataRow[3] = item.TimeUnit; objDataRow[4] = item.ExceptionValue; docTypeDataTable.Rows.Add(objDataRow); } using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetDocTypeToDocDestroy")) { db.AddInParameter(dbCommandWrapper, "@DestroyID", SqlDbType.NVarChar, model.DestroyID ?? ""); db.AddInParameter(dbCommandWrapper, "@DestroyPolicyID", SqlDbType.NVarChar, model.DestroyPolicyID); db.AddInParameter(dbCommandWrapper, "@DestroyDate", SqlDbType.NVarChar, DateTime.Parse(model.DestroyDate, culture, System.Globalization.DateTimeStyles.AssumeLocal)); db.AddInParameter(dbCommandWrapper, "@DocumentNature", SqlDbType.NVarChar, model.DocumentNature); db.AddInParameter(dbCommandWrapper, "@PolicyApplicableTo", SqlDbType.NVarChar, model.PolicyApplicableTo); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.NVarChar, model.Status); db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, model.OwnerID); db.AddInParameter(dbCommandWrapper, "@UserID", SqlDbType.NVarChar, model.SetBy); db.AddInParameter(dbCommandWrapper, "@DocCategoryID", SqlDbType.NVarChar, model.DocCategoryID); db.AddInParameter(dbCommandWrapper, "@Doc_Type", SqlDbType.Structured, docTypeDataTable); db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10); db.ExecuteNonQuery(dbCommandWrapper); if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero()) { errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode(); } } } else if (model.DocPropertyModel != null) { DataTable docPropertyDataTable = new DataTable(); docPropertyDataTable.Columns.Add("DestroyPolicyDtlID"); docPropertyDataTable.Columns.Add("DocPropertyID"); docPropertyDataTable.Columns.Add("TimeValue"); docPropertyDataTable.Columns.Add("TimeUnit"); docPropertyDataTable.Columns.Add("ExceptionValue"); foreach (var item in model.DocPropertyModel) { DataRow objDataRow = docPropertyDataTable.NewRow(); objDataRow[0] = item.DestroyPolicyDtlID; objDataRow[1] = item.PropertyID; objDataRow[2] = item.TimeValue; objDataRow[3] = item.TimeUnit; objDataRow[4] = item.ExceptionValue; docPropertyDataTable.Rows.Add(objDataRow); } using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetDocPropertyToDocDestroy")) { db.AddInParameter(dbCommandWrapper, "@DestroyID", SqlDbType.NVarChar, model.DestroyID ?? ""); db.AddInParameter(dbCommandWrapper, "@DestroyPolicyID", SqlDbType.NVarChar, model.DestroyPolicyID); db.AddInParameter(dbCommandWrapper, "@DestroyDate", SqlDbType.NVarChar, DateTime.Parse(model.DestroyDate, culture, System.Globalization.DateTimeStyles.AssumeLocal)); db.AddInParameter(dbCommandWrapper, "@DocumentNature", SqlDbType.NVarChar, model.DocumentNature); db.AddInParameter(dbCommandWrapper, "@PolicyApplicableTo", SqlDbType.NVarChar, model.PolicyApplicableTo); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.NVarChar, model.Status); db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, model.OwnerID); db.AddInParameter(dbCommandWrapper, "@UserID", SqlDbType.NVarChar, model.SetBy); db.AddInParameter(dbCommandWrapper, "@DocCategoryID", SqlDbType.NVarChar, model.DocCategoryID); db.AddInParameter(dbCommandWrapper, "@DocTypeID", SqlDbType.NVarChar, model.DocTypeID); db.AddInParameter(dbCommandWrapper, "@Doc_Property", SqlDbType.Structured, docPropertyDataTable); db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10); db.ExecuteNonQuery(dbCommandWrapper); if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero()) { errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode(); } } } else if (model.DocPropIdentityModel != null) { DataTable docPropIdentifyDataTable = new DataTable(); docPropIdentifyDataTable.Columns.Add("DestroyPolicyDtlID"); docPropIdentifyDataTable.Columns.Add("DocPropIdentifyID"); docPropIdentifyDataTable.Columns.Add("TimeValue"); docPropIdentifyDataTable.Columns.Add("TimeUnit"); docPropIdentifyDataTable.Columns.Add("ExceptionValue"); foreach (var item in model.DocPropIdentityModel) { DataRow objDataRow = docPropIdentifyDataTable.NewRow(); objDataRow[0] = item.DestroyPolicyDtlID; objDataRow[1] = item.PropIdentityID; objDataRow[2] = item.TimeValue; objDataRow[3] = item.TimeUnit; objDataRow[4] = item.ExceptionValue; docPropIdentifyDataTable.Rows.Add(objDataRow); } using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetDocPropIdentityToDocDestroy")) { db.AddInParameter(dbCommandWrapper, "@DestroyID", SqlDbType.NVarChar, model.DestroyID ?? ""); db.AddInParameter(dbCommandWrapper, "@DestroyPolicyID", SqlDbType.NVarChar, model.DestroyPolicyID); db.AddInParameter(dbCommandWrapper, "@DestroyDate", SqlDbType.NVarChar, DateTime.Parse(model.DestroyDate, culture, System.Globalization.DateTimeStyles.AssumeLocal)); db.AddInParameter(dbCommandWrapper, "@DocumentNature", SqlDbType.NVarChar, model.DocumentNature); db.AddInParameter(dbCommandWrapper, "@PolicyApplicableTo", SqlDbType.NVarChar, model.PolicyApplicableTo); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.NVarChar, model.Status); db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, model.OwnerID); db.AddInParameter(dbCommandWrapper, "@UserID", SqlDbType.NVarChar, model.SetBy); db.AddInParameter(dbCommandWrapper, "@DocCategoryID", SqlDbType.NVarChar, model.DocCategoryID); db.AddInParameter(dbCommandWrapper, "@DocTypeID", SqlDbType.NVarChar, model.DocTypeID); db.AddInParameter(dbCommandWrapper, "@DocPropertyID", SqlDbType.NVarChar, model.DocPropertyID); db.AddInParameter(dbCommandWrapper, "@Doc_PropIdentity", SqlDbType.Structured, docPropIdentifyDataTable); 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); }