/// <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>
public DataSet SelectInitialBudgetTest(IInitialBudget initialBudget, DBGenericEntity dbGenericEntity)
{
DataSet tableVerify = new DataSet();
tableVerify = dbGenericEntity.SelectObject(initialBudget) as DataSet;
return(tableVerify);
}
/// <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 DeleteInitialBudgetTest(IInitialBudget initialBudget, DBGenericEntity dbGenericEntity)
{
int rowCount = dbGenericEntity.DeleteObject(initialBudget);
return(rowCount);
}
private int InsertInitialBudgetTest(IInitialBudget initialBudget, DBGenericEntity dbGenericEntity)
{
initialBudget.Id = dbGenericEntity.InsertObject(initialBudget);
return(initialBudget.Id);
}
/// <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 InsertInitialBudgetMasterTest(IInitialBudget initialBudget, DBGenericEntity dbGenericEntity)
{
int rowCount = dbGenericEntity.ExecuteCustomProcedure("InsertIntialBudgetMaster", initialBudget);
return(rowCount);
}
public void VerifyInitialBudget()
{
IInitialBudget initialBudget = BusinessObjectInitializer.CreateInitialBudget();
ICostCenter costCenter = BusinessObjectInitializer.CreateCostCenter();
IWorkPackage workPackage = BusinessObjectInitializer.CreateWorkPackage();
IProject project = BusinessObjectInitializer.CreateProject();
IProjectCoreTeamMember coreTeamMembers = BusinessObjectInitializer.CreateProjectCoreTeamMember();
DBInitialBudget dbInitialBudget = new DBInitialBudget(connManager);
DBGenericEntity dbCostCenterEntity = new DBCostCenter(connManager);
DBGenericEntity dbWorkPackageEntity = new DBWorkPackage(connManager);
DBGenericEntity dbProjectEntity = new DBProject(connManager);
DBProjectCoreTeamMember dbCoreteamMember = new DBProjectCoreTeamMember(connManager);
Random random = new Random();
initialBudget.IdAssociate = DATestUtils.DEFAULT_ASSOCIATE;
initialBudget.IdPhase = random.Next(1, 9);
costCenter.Id = random.Next(1000, 2000);
costCenter.Name = DATestUtils.GenerateString(50, true, false);
costCenter.Code = DATestUtils.GenerateString(10, true, true);
costCenter.IdDepartment = random.Next(1, 1);
costCenter.IdInergyLocation = random.Next(1, 2);
costCenter.IsActive = true;
workPackage.IdPhase = initialBudget.IdPhase;
workPackage.Code = DATestUtils.GenerateString(3, true, true);
workPackage.Name = DATestUtils.GenerateString(30, true, false);
workPackage.Rank = random.Next(1, 100);
workPackage.IsActive = true;
workPackage.StartYearMonth = random.Next(2000, 2079) * 100 + random.Next(1, 12);
workPackage.EndYearMonth = random.Next(2000, 2079) * 100 + random.Next(1, 12);
workPackage.LastUpdate = DateTime.Today;
workPackage.IdLastUserUpdate = DATestUtils.DEFAULT_ASSOCIATE;
project.Name = DATestUtils.GenerateString(50, true, false);
project.Code = DATestUtils.GenerateString(10, true, true);
project.IdProgram = random.Next(1, 2);
project.IdProjectType = random.Next(1, 2);
project.IsActive = true;
initialBudget.Sales = random.Next(50000, 1000000);
initialBudget.TotalHours = random.Next(1, 100);
initialBudget.ValuedHours = random.Next(1, 100);
initialBudget.YearMonth = DATestUtils.DEFAULT_YEAR_MONTH;
int newId = InsertCostCenterTest(costCenter, dbCostCenterEntity);
//Verifies that the id returned by the insert method is greater than 0
Assert.Greater(newId, 0);
initialBudget.IdCostCenter = newId;
newId = InsertProjectTest(project, dbProjectEntity);
//Verifies that the id returned by the insert method is greater than 0
Assert.Greater(newId, 0);
initialBudget.IdProject = newId;
workPackage.IdProject = initialBudget.IdProject;
coreTeamMembers.IdProject = initialBudget.IdProject;
newId = InsertWorkPackageTest(workPackage, dbWorkPackageEntity);
//Verifies that the id returned by the insert method is greater than 0
Assert.Greater(newId, 0);
initialBudget.IdWP = newId;
InsertInitialBudgetMasterTest(initialBudget, dbInitialBudget);
coreTeamMembers.IdAssociate = DATestUtils.DEFAULT_ASSOCIATE;
coreTeamMembers.IdFunction = DATestUtils.DEFAULT_PROJECT_FUNCTION;
//verify if have core team member
DataTable dsCoreMember = SelectProjectCoreTeamMemberTest(coreTeamMembers, dbCoreteamMember).Tables[0];
if (dsCoreMember.Rows.Count == 0)
{
int IdCoreteammember = InsertProjectCoreTeamMemberTest(coreTeamMembers, dbCoreteamMember);
}
InsertInitialBudgetTest(initialBudget, dbInitialBudget);
UpdateInitialBudgetTest(initialBudget, dbInitialBudget);
DBWPPreselection tempTable = new DBWPPreselection(connManager);
tempTable.BulkInsert("CREATE TABLE #BUDGET_PRESELECTION_TEMP (IdProject INT NOT NULL, IdPhase INT NOT NULL, IdWP INT NOT NULL)");
tempTable.BulkInsert("INSERT INTO #BUDGET_PRESELECTION_TEMP (IdProject,IdPhase,IdWP) VALUES (" + initialBudget.IdProject.ToString() + "," + initialBudget.IdPhase.ToString() + "," + initialBudget.IdWP.ToString() + ")");
DataSet InitialBudgetDS = SelectInitialBudgetTest(initialBudget, dbInitialBudget);
//Verifies that the table is not null
DataTable tableVerifyPhases = InitialBudgetDS.Tables[0];
DataTable tableVerifyWorkPackages = InitialBudgetDS.Tables[1];
DataTable tableVerifyCostCenters = InitialBudgetDS.Tables[2];
Assert.IsNotNull(tableVerifyPhases, "The table returned should not be null");
Assert.IsNotNull(tableVerifyWorkPackages, "The table returned should not be null");
Assert.IsNotNull(tableVerifyCostCenters, "The table returned should not be null");
//Verifies that the first table is not null
Assert.IsNotNull(tableVerifyPhases, "The table returned should not be null");
//Verifies that the table returns the correcty columns
DATestUtils.CheckColumn(tableVerifyPhases, 0, "IdProject");
DATestUtils.CheckColumn(tableVerifyPhases, 1, "IdPhase");
DATestUtils.CheckColumn(tableVerifyPhases, 2, "PhaseName");
DATestUtils.CheckColumn(tableVerifyPhases, 3, "TotalHours");
DATestUtils.CheckColumn(tableVerifyPhases, 4, "Averate");
DATestUtils.CheckColumn(tableVerifyPhases, 5, "ValuedHours");
DATestUtils.CheckColumn(tableVerifyPhases, 6, "OtherCosts");
DATestUtils.CheckColumn(tableVerifyPhases, 7, "Sales");
DATestUtils.CheckColumn(tableVerifyPhases, 8, "NetCosts");
//Verifies that the second table is not null
Assert.IsNotNull(tableVerifyWorkPackages, "The table returned should not be null");
//Verifies that the table returns the correcty columns
DATestUtils.CheckColumn(tableVerifyWorkPackages, 0, "IdProject");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 1, "IdPhase");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 2, "IdWP");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 3, "WPName");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 4, "StartYearMonth");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 5, "EndYearMonth");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 6, "TotalHours");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 7, "Averate");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 8, "ValuedHours");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 9, "OtherCosts");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 10, "Sales");
DATestUtils.CheckColumn(tableVerifyWorkPackages, 11, "NetCosts");
//Verifies that the third table is not null
Assert.IsNotNull(tableVerifyWorkPackages, "The table returned should not be null");
//Verifies that the table returns the correcty columns
DATestUtils.CheckColumn(tableVerifyCostCenters, 0, "IdProject");
DATestUtils.CheckColumn(tableVerifyCostCenters, 1, "IdPhase");
DATestUtils.CheckColumn(tableVerifyCostCenters, 2, "IdWP");
DATestUtils.CheckColumn(tableVerifyCostCenters, 3, "IdCostCenter");
DATestUtils.CheckColumn(tableVerifyCostCenters, 4, "CostCenterName");
DATestUtils.CheckColumn(tableVerifyCostCenters, 5, "TotalHours");
DATestUtils.CheckColumn(tableVerifyCostCenters, 6, "Averate");
DATestUtils.CheckColumn(tableVerifyCostCenters, 7, "ValuedHours");
DATestUtils.CheckColumn(tableVerifyCostCenters, 8, "OtherCosts");
DATestUtils.CheckColumn(tableVerifyCostCenters, 9, "Sales");
DATestUtils.CheckColumn(tableVerifyCostCenters, 10, "NetCosts");
DATestUtils.CheckColumn(tableVerifyCostCenters, 11, "IdCurrency");
DATestUtils.CheckColumn(tableVerifyCostCenters, 12, "CurrencyCode");
DeleteInitialBudgetTest(initialBudget, dbInitialBudget);
int rowCount = DeleteCostCenterTest(costCenter, dbCostCenterEntity);
//Verifies that one and only one row is affected by the delete
Assert.AreEqual(1, rowCount);
rowCount = DeleteWorkPackageTest(workPackage, dbWorkPackageEntity);
//Verifies that one and only one row is affected by the delete
Assert.AreEqual(1, rowCount);
//Verifies that one and only one row is affected by the delete
rowCount = DeleteProjectCoreTeamMemberTest(coreTeamMembers, dbCoreteamMember);
Assert.AreEqual(1, rowCount);
rowCount = DeleteProjectTest(project, dbProjectEntity);
//Verifies that one and only one row is affected by the delete
Assert.AreEqual(1, rowCount);
}
protected override void InitializeObject(IGenericEntity ent)
{
if (ent is IInitialBudget)
{
IInitialBudget iInitialBudget = (IInitialBudget)ent;
DBStoredProcedure spGetInitialBudget = new DBStoredProcedure();
spGetInitialBudget.ProcedureName = "bgtGetInitialBudgetEvidence";
spGetInitialBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdProject));
spGetInitialBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdAssociate));
spGetInitialBudget.AddParameter(new DBParameter("@IdAssociateViewer", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdAssociateViewer));
spGetInitialBudget.AddParameter(new DBParameter("@IsAssociateCurrency", DbType.Boolean, ParameterDirection.Input, iInitialBudget.IsAssociateCurrency));
spGetInitialBudget.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdCountry));
spGetInitialBudget.AddParameter(new DBParameter("@IdCurrencyDisplay", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdCurrency));
this.AddStoredProcedure("SelectObject", spGetInitialBudget);
DBStoredProcedure spInsertInitialBudgetMaster = new DBStoredProcedure();
spInsertInitialBudgetMaster.ProcedureName = "bgtInsertInitialBudget";
spInsertInitialBudgetMaster.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdProject));
this.AddStoredProcedure("InsertIntialBudgetMaster", spInsertInitialBudgetMaster);
DBStoredProcedure spInsertInitialBudget = new DBStoredProcedure();
spInsertInitialBudget.ProcedureName = "bgtInsertInitialBudgetDetail";
spInsertInitialBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdProject));
spInsertInitialBudget.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdPhase));
spInsertInitialBudget.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdWP));
spInsertInitialBudget.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdCostCenter));
spInsertInitialBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdAssociate));
spInsertInitialBudget.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, iInitialBudget.YearMonth));
this.AddStoredProcedure("InsertObject", spInsertInitialBudget);
DBStoredProcedure spUpdateInitialBudget = new DBStoredProcedure();
spUpdateInitialBudget.ProcedureName = "bgtUpdateInitialBudgetDetail";
spUpdateInitialBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdProject));
spUpdateInitialBudget.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdPhase));
spUpdateInitialBudget.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdWP));
spUpdateInitialBudget.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdCostCenter));
spUpdateInitialBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdAssociate));
spUpdateInitialBudget.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, iInitialBudget.YearMonth));
if (iInitialBudget.TotalHours != ApplicationConstants.INT_NULL_VALUE_FOR_VALUE_FIELDS)
{
spUpdateInitialBudget.AddParameter(new DBParameter("@HoursQty", DbType.Int32, ParameterDirection.Input, iInitialBudget.TotalHours));
}
else
{
spUpdateInitialBudget.AddParameter(new DBParameter("@HoursQty", DbType.Int32, ParameterDirection.Input, DBNull.Value));
}
if (iInitialBudget.ValuedHours != ApplicationConstants.DECIMAL_NULL_VALUE)
{
spUpdateInitialBudget.AddParameter(new DBParameter("@HoursVal", DbType.Decimal, ParameterDirection.Input, iInitialBudget.ValuedHours));
}
else
{
spUpdateInitialBudget.AddParameter(new DBParameter("@HoursVal", DbType.Decimal, ParameterDirection.Input, DBNull.Value));
}
if (iInitialBudget.Sales != ApplicationConstants.DECIMAL_NULL_VALUE)
{
spUpdateInitialBudget.AddParameter(new DBParameter("@SalesVal", DbType.Decimal, ParameterDirection.Input, iInitialBudget.Sales));
}
else
{
spUpdateInitialBudget.AddParameter(new DBParameter("@SalesVal", DbType.Decimal, ParameterDirection.Input, DBNull.Value));
}
this.AddStoredProcedure("UpdateObject", spUpdateInitialBudget);
DBStoredProcedure spDeleteInitialBudget = new DBStoredProcedure();
spDeleteInitialBudget.ProcedureName = "bgtDeleteInitialBudgetDetail";
spDeleteInitialBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdProject));
spDeleteInitialBudget.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdPhase));
spDeleteInitialBudget.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdWP));
spDeleteInitialBudget.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdCostCenter));
spDeleteInitialBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdAssociate));
spDeleteInitialBudget.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, iInitialBudget.YearMonth));
this.AddStoredProcedure("DeleteObject", spDeleteInitialBudget);
DBStoredProcedure spInitialBudgetCheck = new DBStoredProcedure();
spInitialBudgetCheck.ProcedureName = "bgtInitialBudgetEvidenceCheck";
spInitialBudgetCheck.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, iInitialBudget.IdProject));
this.AddStoredProcedure("InitialBudgetCheck", spInitialBudgetCheck);
}
}
