/// <summary>
/// This method is used for selecting an object from the database
/// </summary>
/// <param name="associate">This is the Associate object that holds all information that is required so that the select should be made.</param>
/// <param name="dbGenericEntity">This is the Associate Entity.</param>
/// <returns></returns>
private DataSet SelectAssociateTest(IAssociate associate)
{
DataSet tableVerify = new DataSet();
tableVerify = dbEntity.SelectObject(associate) as DataSet;
return(tableVerify);
}
protected override void InitializeObject(IGenericEntity ent)
{
if (ent is IAssociate)
{
IAssociate Associate = (IAssociate)ent;
DBStoredProcedure spInsert = new DBStoredProcedure();
spInsert.ProcedureName = "catInsertAssociate";
spInsert.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry));
spInsert.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Associate.Name));
spInsert.AddParameter(new DBParameter("@EmployeeNumber", DbType.String, ParameterDirection.Input, Associate.EmployeeNumber));
spInsert.AddParameter(new DBParameter("@InergyLogin", DbType.String, ParameterDirection.Input, Associate.InergyLogin));
spInsert.AddParameter(new DBParameter("@IsActive", DbType.Boolean, ParameterDirection.Input, Associate.IsActive));
spInsert.AddParameter(new DBParameter("@IsSubcontractor", DbType.Boolean, ParameterDirection.Input, Associate.IsSubContractor));
spInsert.AddParameter(new DBParameter("@PercentageFullTime", DbType.Int32, ParameterDirection.Input, Associate.PercentageFullTime));
DBStoredProcedure spUpdate = new DBStoredProcedure();
spUpdate.ProcedureName = "catUpdateAssociate";
spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Associate.Id));
spUpdate.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry));
spUpdate.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Associate.Name));
spUpdate.AddParameter(new DBParameter("@EmployeeNumber", DbType.String, ParameterDirection.Input, Associate.EmployeeNumber));
spUpdate.AddParameter(new DBParameter("@InergyLogin", DbType.String, ParameterDirection.Input, Associate.InergyLogin));
spUpdate.AddParameter(new DBParameter("@IsActive", DbType.Boolean, ParameterDirection.Input, Associate.IsActive));
spUpdate.AddParameter(new DBParameter("@IsSubcontractor", DbType.Boolean, ParameterDirection.Input, Associate.IsSubContractor));
spUpdate.AddParameter(new DBParameter("@PercentageFullTime", DbType.Int32, ParameterDirection.Input, Associate.PercentageFullTime));
DBStoredProcedure spDelete = new DBStoredProcedure();
spDelete.ProcedureName = "catDeleteAssociate";
spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Associate.Id));
spDelete.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry));
this.AddStoredProcedure("InsertObject", spInsert);
this.AddStoredProcedure("UpdateObject", spUpdate);
this.AddStoredProcedure("DeleteObject", spDelete);
DBStoredProcedure spSelect = new DBStoredProcedure();
spSelect.ProcedureName = "catSelectAssociate";
spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Associate.Id));
spSelect.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry));
this.AddStoredProcedure("SelectObject", spSelect);
DBStoredProcedure spSelectActiveAssociates = new DBStoredProcedure();
spSelectActiveAssociates.ProcedureName = "catSelectActiveAssociates";
spSelectActiveAssociates.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry));
this.AddStoredProcedure("SelectActiveAssociates", spSelectActiveAssociates);
DBStoredProcedure spHasCurrentData = new DBStoredProcedure();
spHasCurrentData.ProcedureName = "bgtAssociateHasCurrentData";
spHasCurrentData.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, Associate.Id));
this.AddStoredProcedure("bgtAssociateHasCurrentData", spHasCurrentData);
}
}
public bool RemoveAssociate(IAssociate associate)
{
IAssociate obsoleteAssociate = null;
if (AssociateExists(associate))
{
obsoleteAssociate = Associates.Where(a => a.AssociateID == associate.AssociateID &&
a.Name == associate.Name)
.First();
}
return(Associates.Remove(obsoleteAssociate));
}
private IAssociate GetAssociateByID(int associateID)
{
var associateMatches = _allAssociates.Where(a => a.AssociateID == associateID);
var associateExists = associateMatches.Count() > 0;
IAssociate result = null;
if (associateExists)
{
result = associateMatches.First();
}
return(result);
}
public void VerifyAssociate()
{
IAssociate associate = BusinessObjectInitializer.CreateAssociate();
Random random = new Random();
associate.IdCountry = random.Next(1, 3);
associate.Name = DATestUtils.GenerateString(50, true, false);
associate.InergyLogin = DATestUtils.GenerateString(50, true, false);
associate.EmployeeNumber = DATestUtils.GenerateString(15, true, false);
associate.IsActive = true;
associate.PercentageFullTime = random.Next(1, 100);
associate.IsSubContractor = true;
int newId = InsertAssociateTest(associate);
//Verifies that the id returned by the insert method is greater than 1
Assert.Greater(newId, 0);
int rowsAffected = UpdateAssociateTest(associate);
//Verifies that one and only one row is affected by the update
Assert.AreEqual(1, rowsAffected);
DataTable resultTable = SelectAssociateTest(associate).Tables[0];
//Verifies that the table contains the correct column names and order
StringCollection columns = new StringCollection();
columns.AddRange(new string[] { "CountryName",
"EmployeeNumber",
"Name",
"InergyLogin",
"IsActive",
"PercentageFullTime",
"IsSubContractor",
"Id",
"IdCountry" });
DATestUtils.CheckTableStructure(resultTable, columns);
int rowCount = DeleteAssociateTest(associate);
Assert.AreEqual(1, rowCount);
}
public AssociateCollection GetAllAssociates()
{
var associateEntityList = Context.Associates
.OrderBy(a => a.Name)
.ThenBy(a => a.AssociateID)
.ToList();
var associateModels = new List <IAssociate>();
foreach (var associate in associateEntityList)
{
IAssociate model = MapAssociateEntityToAssociateModel(associate);
associateModels.Add(model);
}
var result = GetOrderedAssociateCollection(associateModels.OrderBy(e => e.Name)
.ThenBy(e => e.CurrentRole.Name));
return(result);
}
public void AddAssociate(IAssociate newAssociate)
{
var associate = _associateFactory.Invoke();
associate.AssociateID = newAssociate.AssociateID;
associate.Name = newAssociate.Name;
associate.SetCurrentRole(newAssociate.CurrentRole);
associate.Tenure = newAssociate.Tenure;
foreach (var skill in newAssociate.SkillList.Skills)
{
associate.AddSkill(skill);
}
foreach (var role in newAssociate.RoleCapabilities.Roles)
{
associate.AddRoleCapability(role);
}
Associates.Add(associate);
}
/// <summary>
/// This method is used for deleting an object from the database
/// </summary>
/// <param name="associate">This is the Associate object that holds all information that is required so that the delete should be made.</param>
/// <param name="dbGenericEntity">This is the Associate Entity.</param>
/// <returns></returns>
private int DeleteAssociateTest(IAssociate associate)
{
int rowCount = dbEntity.DeleteObject(associate);
return(rowCount);
}
/// <summary>
/// This method is used for inserting an object into the database
/// </summary>
/// <param name="associate">This is the Associate object that holds all information that is required so that the insert should be made.</param>
/// <param name="dbGenericEntity">This is the Associate Entity.</param>
/// <returns></returns>
private int InsertAssociateTest(IAssociate associate)
{
associate.Id = dbEntity.InsertObject(associate);
return(associate.Id);
}
public AssociateService(IAssociate associate)
{
_associate = associate;
}
private bool AssociateExists(IAssociate associate)
{
return(Associates.Where(s => s.AssociateID == associate.AssociateID &&
s.Name == associate.Name)
.Count() > 0);
}