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