public void Get_QC_Rule_By_Id_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
var qcRule = repository.GetQualityCheckByID(1);
Assert.IsNotNull(qcRule);
Assert.AreEqual(qcRule.CreatedBy, 1);
Assert.AreEqual(qcRule.Description, "Test rule");
Assert.AreEqual(qcRule.EnforceOrder, true);
Assert.AreEqual(qcRule.IsActive, true);
Assert.AreEqual(qcRule.IsVisibleToAll, true);
Assert.AreEqual(qcRule.ModifiedBy, 1);
Assert.AreEqual(qcRule.Name, "Test Rule");
Assert.AreEqual(qcRule.QualityCheckId, 1);
Assert.AreEqual(qcRule.Name, "Test Rule");
Assert.IsNull(qcRule.FileQualityChecks);
Assert.IsNotNull(qcRule.QualityCheckColumnRules);
Assert.AreEqual(qcRule.QualityCheckColumnRules.Count, 2);
var selColRule = qcRule.QualityCheckColumnRules.Where(rul => rul.QualityCheckColumnRuleId == 1).FirstOrDefault();
Assert.AreEqual(selColRule.Description, "Column 1");
Assert.AreEqual(selColRule.ErrorMessage, "Col1 is required");
Assert.AreEqual(selColRule.HeaderName, "Col1");
Assert.AreEqual(selColRule.IsActive, true);
Assert.AreEqual(selColRule.IsRequired, true);
Assert.AreEqual(selColRule.Order, 1);
Assert.AreEqual(selColRule.QualityCheckColumnRuleId, 1);
Assert.AreEqual(selColRule.QualityCheckId, 1);
Assert.AreEqual(selColRule.Range, "");
}
public void Get_Null_QC_Rule_By_Id_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
var qcRule = repository.GetQualityCheckByID(6);
Assert.IsNull(qcRule);
}
public void Get_All_Quality_Check_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
var qcRules = repository.RetrieveQualityCheckRules().ToList();
Assert.IsNotNull(qcRules);
Assert.AreEqual(qcRules.Count(), 1);
}
public void Throw_Exception_On_Add_Null_QCRule_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
repository.AddQualityCheckRule(null);
}
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);
}
public void Delete_Quality_Check_Rule_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
repository.DeleteQualityCheckRule(1);
testDBContext.Commit();
var lstRules = repository.RetrieveQualityCheckRules();
Assert.AreEqual(lstRules.Count(), 0);
}
public void Update_Existing_QC_Rule_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
var selQcRule = repository.GetQualityCheckByID(1);
selQcRule.Description = "Updated description";
selQcRule.EnforceOrder = false;
selQcRule.IsActive = false;
selQcRule.IsVisibleToAll = false;
selQcRule.Name = "Updated Name";
repository.UpdateQualityCheckRule(selQcRule);
testDBContext.Commit();
var updatedQcRule = repository.GetQualityCheckByID(1);
Assert.AreEqual(updatedQcRule.Description, "Updated description");
Assert.AreEqual(updatedQcRule.Name, "Updated Name");
Assert.IsFalse((bool)updatedQcRule.EnforceOrder);
Assert.IsFalse((bool)updatedQcRule.IsVisibleToAll);
Assert.IsFalse((bool)updatedQcRule.IsActive);
}
public void Delete_Column_Rules_For_No_column_Rules_For_QC_Rule_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
repository.DeleteColumnRules(2);
}
public void Delete_Column_Rules_QC_Rule_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
repository.DeleteColumnRules(1);
testDBContext.Commit();
var ruleList = repository.GetQualityCheckByID(1);
Assert.IsNotNull(ruleList);
Assert.AreEqual(ruleList.QualityCheckColumnRules.Count, 0);
}
public void Throw_Exception_On_Delete_Not_Available_Quality_Check_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
repository.DeleteQualityCheckRule(8);
}
public void Throw_Exception_On_Add_Null_File_Quality_Check_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
repository.AddFileQualityCheck(null);
}
public void Get_QC_Rule_By_Not_Available_Rule_Name_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
var qcRule = repository.GetQualityCheckByName("Not There");
Assert.IsNull(qcRule);
}
public void Throw_Exception_On_Get_Null_QCRule_By_Name_Test()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
repository.GetQualityCheckByName(null);
}
public void Get_All_QC_Rule_Column_Types()
{
IQualityCheckRepository repository = new QualityCheckRepository(testDBContext);
var qcColRuleTypes = repository.RetrieveQCColumnTypes();
Assert.IsNotNull(qcColRuleTypes);
Assert.AreEqual(qcColRuleTypes.Count(), 2);
}
