/// <summary>
/// Extension method class for quality check rule viewmodel to put data on quality check domain model class.
/// </summary>
/// <param name="rule">Quality check rule view model.</param>
/// <param name="qualityCheck">Quality check model.</param>
/// <returns>Updated qualityCheck model class object.</returns>
public static QualityCheck SetValuesTo(this QCRuleViewModel rule, QualityCheck qualityCheck)
{
Check.IsNotNull<QCRuleViewModel>(rule, "qcRuleViewModel");
Check.IsNotNull<QualityCheck>(qualityCheck, "qualityCheck");
qualityCheck.QualityCheckColumnRules = new List<QualityCheckColumnRule>();
if (rule.QCRuleId == 0)
{
qualityCheck.CreatedOn = DateTime.UtcNow;
qualityCheck.CreatedBy = BaseController.UserId;
}
else
{
qualityCheck.CreatedOn = Convert.ToDateTime(rule.CreatedDate).ToUTCFromClientTime();
qualityCheck.CreatedBy = rule.CreatedBy;
qualityCheck.ModifiedOn = DateTime.UtcNow;
qualityCheck.ModifiedBy = BaseController.UserId;
}
qualityCheck.EnforceOrder = rule.IsOrderRequired;
qualityCheck.IsVisibleToAll = rule.IsVisibleToAll;
qualityCheck.Description = rule.QCRuleDescription;
qualityCheck.QualityCheckId = rule.QCRuleId;
qualityCheck.Name = rule.QCRuleName;
qualityCheck.IsActive = true;
qualityCheck.IsVisibleToAll = rule.VisibilityOption == 1 ? true : false;
foreach (var headerModel in rule.LstHeaderNames)
{
if (!string.IsNullOrEmpty(headerModel.HeaderName))
{
QualityCheckColumnRule columnRule = new QualityCheckColumnRule();
columnRule.QualityCheckColumnTypeId = headerModel.ColumnTypeId;
columnRule.ErrorMessage = headerModel.ErrorMessage;
columnRule.Description = headerModel.HeaderName;
columnRule.HeaderName = headerModel.HeaderName;
columnRule.IsRequired = true;
columnRule.IsActive = true;
columnRule.QualityCheckColumnRuleId = headerModel.QCColumnRuleId;
columnRule.QualityCheckId = qualityCheck.QualityCheckId;
columnRule.Order = headerModel.Order;
if (!string.IsNullOrEmpty(headerModel.RangeStart) || !string.IsNullOrEmpty(headerModel.RangeEnd))
{
columnRule.Range = (headerModel.RangeStart == null ? string.Empty : headerModel.RangeStart) + Utilities.Constants.RangeSeparator + (headerModel.RangeEnd == null ? string.Empty : headerModel.RangeEnd);
}
qualityCheck.QualityCheckColumnRules.Add(columnRule);
}
}
return qualityCheck;
}
/// <summary>
/// Method to to add the new quality check rule.
/// </summary>
/// <param name="qualityCheck">Quality check rule.</param>
/// <returns>Added quality check object.</returns>
public QualityCheck AddQualityCheckRule(QualityCheck qualityCheck)
{
Check.IsNotNull<QualityCheck>(qualityCheck, "newQualityCheck");
var addedQualityCheck = Context.QualityChecks.Add(qualityCheck);
foreach (var columnRule in qualityCheck.QualityCheckColumnRules)
{
Context.SetEntityState<QualityCheckColumnRule>(columnRule, EntityState.Added);
}
return addedQualityCheck;
}
/// <summary>
/// Method to add or update the existing quality check rule.
/// </summary>
/// <param name="qualityCheck">Quality check object.</param>
/// <returns>True incase of succeess.</returns>
public bool AddUpdateQualityCheck(QualityCheck qualityCheck)
{
bool updateResult = false;
if (qualityCheck.QualityCheckId > 0)
{
// Delete all the existing column rules
if (this.qualityCheckRepository.DeleteColumnRules(qualityCheck.QualityCheckId))
{
this.unitOfWork.Commit();
var updatedQualityCheck = this.qualityCheckRepository.UpdateQualityCheckRule(qualityCheck);
if (updatedQualityCheck != null && updatedQualityCheck.QualityCheckId == qualityCheck.QualityCheckId)
{
updateResult = true;
this.unitOfWork.Commit();
}
}
}
else
{
var addedQualityCheck = this.qualityCheckRepository.AddQualityCheckRule(qualityCheck);
if (addedQualityCheck != null)
{
updateResult = true;
this.unitOfWork.Commit();
}
}
return updateResult;
}
public void Initialize()
{
List<QualityCheckColumnRule> lstCol = new List<QualityCheckColumnRule>();
QualityCheckColumnRule colRule = new QualityCheckColumnRule() { Description = "Column 1 desc", ErrorMessage = "error msg", HeaderName = "Column 1", IsActive = true, IsRequired = true, Order = 1, QualityCheck = null, QualityCheckColumnRuleId = 1, QualityCheckColumnTypeId = 1, QualityCheckId = 1, Range = "" };
QualityCheckColumnRule colRule1 = new QualityCheckColumnRule() { Description = "Column 2 desc", ErrorMessage = "error msg1", HeaderName = "Column 2", IsActive = true, IsRequired = true, Order = 2, QualityCheck = null, QualityCheckColumnRuleId = 2, QualityCheckColumnTypeId = 2, QualityCheckId = 1, Range = "" };
lstCol.Add(colRule);
lstCol.Add(colRule1);
// Unit of work code
this.unitOfWork =
new StubIUnitOfWork()
{
Commit = () => { return; }
};
// User repository
this.userRepository = new StubIUserRepository()
{
GetUserbyUserIdInt32 = (userId) =>
{
List<UserRole> userRoles = new List<UserRole>();
userRoles.Add(new UserRole() { Role = null, RoleId = 1, UserId = userId, UserRoleId = 1 });
User userNew = new User() { CreatedOn = DateTime.UtcNow, EmailId = "*****@*****.**", FirstName = "First", IdentityProvider = "identity", IsActive = true, LastName = "Last", MiddleName = "midele", ModifiedOn = DateTime.UtcNow, NameIdentifier = "nameIdentifier", Organization = "Test Org", UserAttributes = null, UserId = userId, UserRoles = userRoles };
return userNew;
}
};
// file Service implementation
this.fileService = new StubIFileService()
{
GetFileByFileIdInt32 = (fileId) =>
{
File fileToAdd = new File() { Citation = "Citation 1", CreatedBy = 1, CreatedOn = DateTime.Now, Description = "Document 1", FileAttributes = null, FileColumns = null, FileId = fileId, FileQualityChecks = null, Identifier = "asdahgsdfsghadfsghad", isDeleted = false, MimeType = "Mime type 1", ModifiedBy = 1, ModifiedOn = DateTime.Now, Name = "Document One", Repository = null, RepositoryId = null, Size = 20.90, Status = "Uploaded", Title = "Document 1" };
return null;
}
};
// Quality check repository implementation
this.qcRepository = new StubIQualityCheckRepository()
{
RetrieveQualityCheckRules = () =>
{
List<QualityCheck> lstQCRule = new List<QualityCheck>();
lstQCRule.Add(new QualityCheck() { CreatedBy = 1, CreatedOn = DateTime.UtcNow, Description = "Test Rule", EnforceOrder = true, FileQualityChecks = null, IsActive = true, IsVisibleToAll = true, ModifiedBy = 1, ModifiedOn = DateTime.UtcNow, Name = "Test Rule", QualityCheckColumnRules = lstCol, QualityCheckId = 1 });
// lstQCRule.Add(new QualityCheck() { CreatedBy = 1, CreatedOn = DateTime.UtcNow, Description = "Test Rule1", EnforceOrder = true, FileQualityChecks = null, IsActive = true, IsVisibleToAll = true, ModifiedBy = 1, ModifiedOn = DateTime.UtcNow, Name = "Test Rule1", QualityCheckColumnRules = lstCol, QualityCheckId = 1 });
return lstQCRule;
},
RetrieveQCColumnTypes = () =>
{
List<QualityCheckColumnType> qcTypes = new List<QualityCheckColumnType>();
qcTypes.Add(new QualityCheckColumnType() { Description = "No check", Name = "None", QualityCheckColumnTypeId = 1 });
qcTypes.Add(new QualityCheckColumnType() { Description = "Number type", Name = "Numeric", QualityCheckColumnTypeId = 2 });
return qcTypes;
},
GetQualityCheckByIDInt32 = (qualityCheckId) =>
{
QualityCheck qc = new QualityCheck() { CreatedBy = 1, CreatedOn = DateTime.UtcNow, Description = "Get by id desc", EnforceOrder = true, FileQualityChecks = null, IsActive = true, IsVisibleToAll = true, ModifiedBy = 1, ModifiedOn = DateTime.UtcNow, Name = "Get by id Rule", QualityCheckColumnRules = lstCol, QualityCheckId = qualityCheckId };
return qc;
},
AddQualityCheckRuleQualityCheck = (qualityCheck) =>
{
qualityCheck.QualityCheckId = 2;
return qualityCheck;
},
UpdateQualityCheckRuleQualityCheck = (qualityCheck) =>
{
qualityCheck.Name = "Updated rule From rep";
return qualityCheck;
},
DeleteQualityCheckRuleInt32 = (qualityCheckId) =>
{
QualityCheck qc = new QualityCheck() { CreatedBy = 1, CreatedOn = DateTime.UtcNow, Description = "Delete", EnforceOrder = true, FileQualityChecks = null, IsActive = true, IsVisibleToAll = true, ModifiedBy = 1, ModifiedOn = DateTime.UtcNow, Name = "Delete Rule", QualityCheckColumnRules = lstCol, QualityCheckId = qualityCheckId };
return qc;
},
DeleteColumnRulesInt32 = (qualityCheckId) =>
{
return true;
},
AddFileQualityCheckFileQualityCheck = (fileQualityCheck) =>
{
fileQualityCheck.Status = true;
return fileQualityCheck;
},
GetQualityCheckByNameString = (ruleName) =>
{
QualityCheck qc = new QualityCheck() { CreatedBy = 1, CreatedOn = DateTime.UtcNow, Description = "Get by rule name", EnforceOrder = true, FileQualityChecks = null, IsActive = true, IsVisibleToAll = true, ModifiedBy = 1, ModifiedOn = DateTime.UtcNow, Name = ruleName, QualityCheckColumnRules = lstCol, QualityCheckId = 10 };
return qc;
}
};
qcService = new QCS.QCService(this.qcRepository, this.unitOfWork, this.userRepository, this.fileService, this.blobRepository);
}
public void Update_Exisitng_QC_Rule_Test()
{
QualityCheck ruleToUpdate = new QualityCheck() { CreatedBy = 1, CreatedOn = DateTime.UtcNow, Description = "Updated Rule Desc", EnforceOrder = true, FileQualityChecks = null, IsActive = true, IsVisibleToAll = true, ModifiedBy = 1, ModifiedOn = DateTime.UtcNow, Name = "Updated Rule", QualityCheckColumnRules = null, QualityCheckId = 4 };
var result = qcService.AddUpdateQualityCheck(ruleToUpdate);
Assert.AreEqual(result, true);
}
/// <summary>
/// Action method to save the rule data to the database
/// </summary>
/// <param name="ruleModel">Rule view Model</param>
/// <returns>Status of the operation as json result.</returns>
public JsonResult SaveRule(QCRuleViewModel ruleModel)
{
string message = string.Empty;
bool status = false;
if (ruleModel != null)
{
QualityCheck qcModel = new QualityCheck();
qcModel = ruleModel.SetValuesTo(qcModel);
// serlize the data file before passing to API
string qcRuleData = qcModel.SerializeObject<QualityCheck>("qcRuleModel");
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
webClientManager = new WebClientRequestManager();
// Checking for the duplicate rule name
string responseDupruleName = webClientManager.UploadValues(new RequestParams()
{
RequestURL = string.Concat(BaseController.BaseWebApiQCPath + "?ruleName=" + qcModel.Name),
RequestMode = RequestMode.POST
});
int ruleResult = jsSerializer.Deserialize<int>(responseDupruleName);
if (ruleResult == 0 || ruleModel.QCRuleId == ruleResult)
{
NameValueCollection values = new NameValueCollection();
values.Add("qcRuleModel", qcRuleData.EncodeTo64());
string responseString = webClientManager.UploadValues(new RequestParams()
{
RequestURL = string.Concat(BaseController.BaseWebApiQCPath),
RequestMode = RequestMode.POST,
Values = values
});
bool postResult = jsSerializer.Deserialize<bool>(responseString);
if (postResult)
{
status = true;
}
else
{
ViewBag.ErrorMessage = Messages.QualityCheckErrorMsg;
status = false;
message = Messages.QualityCheckErrorMsg;
}
}
else
{
status = false;
message = Messages.DuplicateRuleMsg;
}
}
else
{
status = false;
message = Messages.QualityCheckErrorMsg;
}
return Json(new { Status = status, Message = message });
}
private void AddQualityCheckRule(QualityCheck qcRule)
{
testDBContext.QualityChecks.Add(qcRule);
testDBContext.Commit();
}
private void AddDefaultData()
{
User newUser = new User()
{
NameIdentifier = "s0Me1De9Tf!Er$tRing",
FirstName = "SomeFirstName",
MiddleName = "SomeMiddleName",
LastName = "SomeLastName",
IdentityProvider = "Windows Live",
Organization = "SomeOrganization",
EmailId = "*****@*****.**",
CreatedOn = DateTime.Now,
ModifiedOn = DateTime.Now,
IsActive = true,
UserAttributes = null
};
// User with userid 1
AddUser(newUser);
//Adding Quality check column rules data
QualityCheckColumnType qcColType = new QualityCheckColumnType() { Description = "No type check", Name = "None", QualityCheckColumnTypeId = 1, QualityCheckColumnRules = null };
QualityCheckColumnType qcColType1 = new QualityCheckColumnType() { Description = "Number type", Name = "Numeric", QualityCheckColumnTypeId = 2, QualityCheckColumnRules = null };
AddQualityCheckColumnType(qcColType);
AddQualityCheckColumnType(qcColType1);
QualityCheck qcRule = new QualityCheck() { CreatedBy = 1, Description = "Test rule", CreatedOn = DateTime.UtcNow, EnforceOrder = true, FileQualityChecks = null, IsActive = true, IsVisibleToAll = true, ModifiedBy = 1, ModifiedOn = DateTime.UtcNow, Name = "Test Rule", QualityCheckId = 1, QualityCheckColumnRules = null };
AddQualityCheckRule(qcRule);
QualityCheckColumnRule colRule = new QualityCheckColumnRule() { Description = "Column 1", ErrorMessage = "Col1 is required", HeaderName = "Col1", IsActive = true, IsRequired = true, Order = 1, QualityCheckColumnRuleId = 1, QualityCheckColumnTypeId = 1, QualityCheckId = 1, Range = "" };
QualityCheckColumnRule colRule1 = new QualityCheckColumnRule() { Description = "Column 2", ErrorMessage = "Col2 is required", HeaderName = "Col2", IsActive = true, IsRequired = false, Order = 2, QualityCheckColumnRuleId = 1, QualityCheckColumnTypeId = 2, QualityCheckId = 1, Range = "1-19999" };
AddQualityCheckColumnRule(colRule);
AddQualityCheckColumnRule(colRule1);
}
public void Add_QC_Rule_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
QualityCheckColumnRule colRule = new QualityCheckColumnRule() { Description = "Column 4", ErrorMessage = "Col1 is required", HeaderName = "Col1", IsActive = true, IsRequired = true, Order = 1, QualityCheckColumnRuleId = 1, QualityCheckColumnTypeId = 1, QualityCheckId = 2, Range = "" };
QualityCheck qcRule = new QualityCheck()
{
CreatedBy = 1,
CreatedOn = DateTime.UtcNow,
Description = "Added rule",
EnforceOrder = true,
FileQualityChecks = null,
IsActive = true,
IsVisibleToAll = true,
ModifiedBy = 1,
ModifiedOn = DateTime.UtcNow,
Name = "Added rule",
QualityCheckColumnRules = new List<QualityCheckColumnRule>() { colRule },
QualityCheckId = 2
};
repository.AddQualityCheckRule(qcRule);
testDBContext.Commit();
var addedQcRule = repository.GetQualityCheckByID(2);
Assert.IsNotNull(addedQcRule);
Assert.AreEqual(addedQcRule.CreatedBy, qcRule.CreatedBy);
Assert.AreEqual(addedQcRule.Description, qcRule.Description);
Assert.AreEqual(addedQcRule.EnforceOrder, qcRule.EnforceOrder);
Assert.AreEqual(addedQcRule.IsActive, qcRule.IsActive);
Assert.AreEqual(addedQcRule.IsVisibleToAll, qcRule.IsVisibleToAll);
Assert.AreEqual(addedQcRule.ModifiedBy, qcRule.ModifiedBy);
Assert.AreEqual(addedQcRule.Name, qcRule.Name);
Assert.AreEqual(addedQcRule.QualityCheckId, qcRule.QualityCheckId);
Assert.AreEqual(addedQcRule.Name, qcRule.Name);
Assert.IsNull(addedQcRule.FileQualityChecks);
Assert.IsNotNull(addedQcRule.QualityCheckColumnRules);
var selColRule = addedQcRule.QualityCheckColumnRules.Where(rul => rul.QualityCheckId == 2).FirstOrDefault();
Assert.AreEqual(selColRule.Description, colRule.Description);
Assert.AreEqual(selColRule.ErrorMessage, colRule.ErrorMessage);
Assert.AreEqual(selColRule.HeaderName, colRule.HeaderName);
Assert.AreEqual(selColRule.IsActive, colRule.IsActive);
Assert.AreEqual(selColRule.IsRequired, colRule.IsRequired);
Assert.AreEqual(selColRule.Order, colRule.Order);
Assert.AreEqual(selColRule.QualityCheckColumnRuleId, colRule.QualityCheckColumnRuleId);
Assert.AreEqual(selColRule.QualityCheckId, colRule.QualityCheckId);
Assert.AreEqual(selColRule.Range, colRule.Range);
}
/// <summary>
/// Method to to update the existing quality check rule.
/// </summary>
/// <param name="qualityCheck">Quality check rule.</param>
/// <returns>Updated quality check object.</returns>
public QualityCheck UpdateQualityCheckRule(QualityCheck qualityCheck)
{
Check.IsNotNull<QualityCheck>(qualityCheck, "modifiedQualityCheck");
QualityCheck updatedQualityCheck = Context.QualityChecks.Attach(qualityCheck);
foreach (var columnRule in qualityCheck.QualityCheckColumnRules)
{
Context.SetEntityState<QualityCheckColumnRule>(columnRule, EntityState.Added);
}
Context.SetEntityState<QualityCheck>(updatedQualityCheck, EntityState.Modified);
return updatedQualityCheck;
}
