public DataSet SelectRevisedBudgetCostsTest(IRevisedBudget revisedBudget, DBGenericEntity dbGenericEntity) { DataSet tableVerify = new DataSet(); tableVerify = dbGenericEntity.GetCustomDataSet("GetRevisedBudgetCosts", revisedBudget) as DataSet; return(tableVerify); }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IRevisedBudget) { IRevisedBudget revisedBudget = (IRevisedBudget)ent; DBStoredProcedure spGetRevisedBudgetHours = new DBStoredProcedure(); spGetRevisedBudgetHours.ProcedureName = "bgtGetRevisedBudgetHours"; spGetRevisedBudgetHours.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spGetRevisedBudgetHours.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociate)); spGetRevisedBudgetHours.AddParameter(new DBParameter("@IdAssociateViewer", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociateViewer)); spGetRevisedBudgetHours.AddParameter(new DBParameter("@IsAssociateCurrency", DbType.Boolean, ParameterDirection.Input, revisedBudget.IsAssociateCurrency)); spGetRevisedBudgetHours.AddParameter(new DBParameter("@Version", DbType.String, ParameterDirection.Input, revisedBudget.Version)); spGetRevisedBudgetHours.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, revisedBudget.IdCountry)); spGetRevisedBudgetHours.AddParameter(new DBParameter("@IdCurrencyDisplay", DbType.Int32, ParameterDirection.Input, revisedBudget.IdCurrency)); this.AddStoredProcedure("GetRevisedBudgetHours", spGetRevisedBudgetHours); DBStoredProcedure spGetRevisedBudgetCosts = new DBStoredProcedure(); spGetRevisedBudgetCosts.ProcedureName = "bgtGetRevisedBudgetCostSales"; spGetRevisedBudgetCosts.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spGetRevisedBudgetCosts.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociate)); spGetRevisedBudgetCosts.AddParameter(new DBParameter("@IdAssociateViewer", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociateViewer)); spGetRevisedBudgetCosts.AddParameter(new DBParameter("@IsAssociateCurrency", DbType.Boolean, ParameterDirection.Input, revisedBudget.IsAssociateCurrency)); spGetRevisedBudgetCosts.AddParameter(new DBParameter("@Version", DbType.String, ParameterDirection.Input, revisedBudget.Version)); spGetRevisedBudgetCosts.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, revisedBudget.IdCountry)); spGetRevisedBudgetCosts.AddParameter(new DBParameter("@IdCurrencyDisplay", DbType.Int32, ParameterDirection.Input, revisedBudget.IdCurrency)); this.AddStoredProcedure("GetRevisedBudgetCosts", spGetRevisedBudgetCosts); DBStoredProcedure spInsertRevisedBudgetMaster = new DBStoredProcedure(); spInsertRevisedBudgetMaster.ProcedureName = "bgtInsertRevisedBudget"; spInsertRevisedBudgetMaster.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spInsertRevisedBudgetMaster.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociate)); this.AddStoredProcedure("InsertRevisedBudgetMaster", spInsertRevisedBudgetMaster); DBStoredProcedure spInsertRevisedBudget = new DBStoredProcedure(); spInsertRevisedBudget.ProcedureName = "bgtInsertRevisedBudgetDetail"; spInsertRevisedBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spInsertRevisedBudget.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, revisedBudget.IdPhase)); spInsertRevisedBudget.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, revisedBudget.IdWP)); spInsertRevisedBudget.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, revisedBudget.IdCostCenter)); spInsertRevisedBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociate)); spInsertRevisedBudget.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, revisedBudget.YearMonth)); this.AddStoredProcedure("InsertObject", spInsertRevisedBudget); DBStoredProcedure spUpdateRevisedBudget = new DBStoredProcedure(); spUpdateRevisedBudget.ProcedureName = "bgtUpdateRevisedBudgetDetail"; spUpdateRevisedBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spUpdateRevisedBudget.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, revisedBudget.IdPhase)); spUpdateRevisedBudget.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, revisedBudget.IdWP)); spUpdateRevisedBudget.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, revisedBudget.IdCostCenter)); spUpdateRevisedBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociate)); spUpdateRevisedBudget.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, revisedBudget.YearMonth)); if (revisedBudget.SaveHours) { spUpdateRevisedBudget.AddParameter(new DBParameter("@HoursQty", DbType.Int32, ParameterDirection.Input, revisedBudget.NewHours)); } else { spUpdateRevisedBudget.AddParameter(new DBParameter("@SalesVal", DbType.Decimal, ParameterDirection.Input, revisedBudget.NewSales == ApplicationConstants.DECIMAL_NULL_VALUE ? (object)DBNull.Value : (object)revisedBudget.NewSales)); } this.AddStoredProcedure("UpdateObject", spUpdateRevisedBudget); DBStoredProcedure spDeleteRevisedBudget = new DBStoredProcedure(); spDeleteRevisedBudget.ProcedureName = "bgtDeleteRevisedBudgetDetail"; spDeleteRevisedBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spDeleteRevisedBudget.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, revisedBudget.IdPhase)); spDeleteRevisedBudget.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, revisedBudget.IdWP)); spDeleteRevisedBudget.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, revisedBudget.IdCostCenter)); spDeleteRevisedBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, revisedBudget.IdAssociate)); spDeleteRevisedBudget.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, revisedBudget.YearMonth)); this.AddStoredProcedure("DeleteObject", spDeleteRevisedBudget); DBStoredProcedure spCheckValidatedInitialBudget = new DBStoredProcedure(); spCheckValidatedInitialBudget.ProcedureName = "bgtRevisedBudgetCheckForValidatedInitial"; spCheckValidatedInitialBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); this.AddStoredProcedure("CheckValidatedInitialBudget", spCheckValidatedInitialBudget); DBStoredProcedure spGetRevisedVersionNo = new DBStoredProcedure(); spGetRevisedVersionNo.ProcedureName = "bgtGetRevisedVersionNo"; spGetRevisedVersionNo.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spGetRevisedVersionNo.AddParameter(new DBParameter("@Version", DbType.String, ParameterDirection.Input, revisedBudget.Version)); this.AddStoredProcedure("GetRevisedVersionNo", spGetRevisedVersionNo); DBStoredProcedure spGetRevisedVersions = new DBStoredProcedure(); spGetRevisedVersions.ProcedureName = "bgtGetRevisedVersions"; spGetRevisedVersions.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); spGetRevisedVersions.AddParameter(new DBParameter("@Version", DbType.String, ParameterDirection.Input, revisedBudget.Version)); this.AddStoredProcedure("GetRevisedVersions", spGetRevisedVersions); DBStoredProcedure spGetLastValidatedRevisedVersion = new DBStoredProcedure(); spGetLastValidatedRevisedVersion.ProcedureName = "bgtGetLastValidatedRevisedVersion"; spGetLastValidatedRevisedVersion.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); this.AddStoredProcedure("bgtGetLastValidatedRevisedVersion", spGetLastValidatedRevisedVersion); DBStoredProcedure spUnvalidateRevisedVersion = new DBStoredProcedure(); spUnvalidateRevisedVersion.ProcedureName = "bgtUnvalidateLastRevisedVersion"; spUnvalidateRevisedVersion.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); this.AddStoredProcedure("bgtUnvalidateLastRevisedVersion", spUnvalidateRevisedVersion); DBStoredProcedure spIsLastRevisedVersionOpen = new DBStoredProcedure(); spIsLastRevisedVersionOpen.ProcedureName = "bgtIsLastRevisedVersionOpen"; spIsLastRevisedVersionOpen.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, revisedBudget.IdProject)); this.AddStoredProcedure("bgtIsLastRevisedVersionOpen", spIsLastRevisedVersionOpen); } }
/// <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 DeleteRevisedBudgetTest(IRevisedBudget revisedBudget, DBGenericEntity dbGenericEntity) { int rowCount = dbGenericEntity.DeleteObject(revisedBudget); return(rowCount); }
private int InsertRevisedBudgetTest(IRevisedBudget revisedBudget, DBGenericEntity dbGenericEntity) { revisedBudget.Id = dbGenericEntity.InsertObject(revisedBudget); return(revisedBudget.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 InsertRevisedBudgetMasterTest(IRevisedBudget revisedBudget, DBGenericEntity dbGenericEntity) { int rowCount = dbGenericEntity.ExecuteCustomProcedure("InsertRevisedBudgetMaster", revisedBudget); return(rowCount); }
public void VerifyRevisedBudget() { IRevisedBudget revisedBudget = BusinessObjectInitializer.CreateRevisedBudget(); ICostCenter costCenter = BusinessObjectInitializer.CreateCostCenter(); IWorkPackage workPackage = BusinessObjectInitializer.CreateWorkPackage(); IProject project = BusinessObjectInitializer.CreateProject(); IInitialBudget initialBudget = BusinessObjectInitializer.CreateInitialBudget(); IProjectCoreTeamMember coreTeamMembers = BusinessObjectInitializer.CreateProjectCoreTeamMember(); IFollowUpInitialBudget followUpBudegt = BusinessObjectInitializer.CreateValidateBudget(); DBRevisedBudget dbRevisedBudget = new DBRevisedBudget(connManager); DBGenericEntity dbCostCenterEntity = new DBCostCenter(connManager); DBGenericEntity dbWorkPackageEntity = new DBWorkPackage(connManager); DBGenericEntity dbProjectEntity = new DBProject(connManager); DBInitialBudget dbInitialBudget = new DBInitialBudget(connManager); DBProjectCoreTeamMember dbCoreteamMember = new DBProjectCoreTeamMember(connManager); DBFollowUpInitialBudget dbFollowUpBudget = new DBFollowUpInitialBudget(connManager); IFollowUpRevisedBudget followUpRevisedBudget = BusinessObjectInitializer.ValidateFollowUpRevisedBudget(); DBFollowUpRevisedBudget dbFollowUpRevisedBudget = new DBFollowUpRevisedBudget(connManager); Random random = new Random(); revisedBudget.IdAssociate = DATestUtils.DEFAULT_ASSOCIATE; revisedBudget.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 = revisedBudget.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; revisedBudget.NewCosts = random.Next(50000, 1000000); revisedBudget.NewHours = random.Next(1, 100); revisedBudget.NewSales = random.Next(50000, 1000000); revisedBudget.NewVal = random.Next(1, 100); revisedBudget.UpdateCosts = random.Next(50000, 1000000); revisedBudget.UpdateHours = random.Next(1, 100); revisedBudget.UpdateSales = random.Next(50000, 1000000); revisedBudget.UpdateVal = random.Next(1, 100); revisedBudget.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; revisedBudget.IdCostCenter = initialBudget.IdCostCenter; newId = InsertProjectTest(project, dbProjectEntity); //Verifies that the id returned by the insert method is greater than 0 Assert.Greater(newId, 0); revisedBudget.IdProject = newId; workPackage.IdProject = revisedBudget.IdProject; initialBudget.IdProject = newId; coreTeamMembers.IdProject = newId; followUpBudegt.IdProject = newId; followUpRevisedBudget.IdProject = revisedBudget.IdProject; newId = InsertWorkPackageTest(workPackage, dbWorkPackageEntity); //Verifies that the id returned by the insert method is greater than 0 Assert.Greater(newId, 0); revisedBudget.IdWP = newId; initialBudget.IdWP = newId; initialBudget.IdAssociate = DATestUtils.DEFAULT_ASSOCIATE; initialBudget.IdPhase = revisedBudget.IdPhase; initialBudget.Sales = random.Next(50000, 1000000); initialBudget.TotalHours = random.Next(1, 100); initialBudget.ValuedHours = random.Next(1, 100); initialBudget.YearMonth = DATestUtils.DEFAULT_YEAR_MONTH; //initialBudget.IdCostCenter = random.Next(1000, 2000); 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); ValidateBudget(followUpBudegt, dbFollowUpBudget); //revisedBudget.IdCostCenter = random.Next(1000, 2000); followUpRevisedBudget.BudVersion = "N"; ValidateRevisedbudget(followUpRevisedBudget, dbFollowUpRevisedBudget); InsertRevisedBudgetMasterTest(revisedBudget, dbRevisedBudget); // InsertRevisedBudgetTest(revisedBudget, dbRevisedBudget); UpdateRevisedBudgetTest(revisedBudget, dbRevisedBudget); 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 (" + revisedBudget.IdProject.ToString() + "," + revisedBudget.IdPhase.ToString() + "," + revisedBudget.IdWP.ToString() + ")"); DataSet RevisedBudgetHoursDS = SelectRevisedBudgetHoursTest(revisedBudget, dbRevisedBudget); //Verifies that the table is not null DataTable tableVerifyPhases = RevisedBudgetHoursDS.Tables[0]; DataTable tableVerifyWorkPackages = RevisedBudgetHoursDS.Tables[1]; DataTable tableVerifyCostCenters = RevisedBudgetHoursDS.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, "CurrentHours"); DATestUtils.CheckColumn(tableVerifyPhases, 4, "UpdateHours"); DATestUtils.CheckColumn(tableVerifyPhases, 5, "NewHours"); DATestUtils.CheckColumn(tableVerifyPhases, 6, "CurrentVal"); DATestUtils.CheckColumn(tableVerifyPhases, 7, "UpdateVal"); DATestUtils.CheckColumn(tableVerifyPhases, 8, "NewVal"); //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, "CurrentHours"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 7, "UpdateHours"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 8, "NewHours"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 9, "CurrentVal"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 10, "UpdateVal"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 11, "NewVal"); //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, "CurrentHours"); DATestUtils.CheckColumn(tableVerifyCostCenters, 6, "UpdateHours"); DATestUtils.CheckColumn(tableVerifyCostCenters, 7, "NewHours"); DATestUtils.CheckColumn(tableVerifyCostCenters, 8, "CurrentVal"); DATestUtils.CheckColumn(tableVerifyCostCenters, 9, "UpdateVal"); DATestUtils.CheckColumn(tableVerifyCostCenters, 10, "NewVal"); DATestUtils.CheckColumn(tableVerifyCostCenters, 11, "IdCurrency"); DATestUtils.CheckColumn(tableVerifyCostCenters, 12, "CurrencyCode"); DataSet RevisedBudgetCostsDS = SelectRevisedBudgetCostsTest(revisedBudget, dbRevisedBudget); //Verifies that the table is not null tableVerifyPhases = RevisedBudgetCostsDS.Tables[0]; tableVerifyWorkPackages = RevisedBudgetCostsDS.Tables[1]; tableVerifyCostCenters = RevisedBudgetCostsDS.Tables[2]; //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, "CurrentCost"); DATestUtils.CheckColumn(tableVerifyPhases, 4, "UpdateCost"); DATestUtils.CheckColumn(tableVerifyPhases, 5, "NewCost"); DATestUtils.CheckColumn(tableVerifyPhases, 6, "CurrentSales"); DATestUtils.CheckColumn(tableVerifyPhases, 7, "UpdateSales"); DATestUtils.CheckColumn(tableVerifyPhases, 8, "NewSales"); //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, "CurrentCost"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 7, "UpdateCost"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 8, "NewCost"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 9, "CurrentSales"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 10, "UpdateSales"); DATestUtils.CheckColumn(tableVerifyWorkPackages, 11, "NewSales"); //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, "CurrentCost"); DATestUtils.CheckColumn(tableVerifyCostCenters, 6, "UpdateCost"); DATestUtils.CheckColumn(tableVerifyCostCenters, 7, "NewCost"); DATestUtils.CheckColumn(tableVerifyCostCenters, 8, "CurrentSales"); DATestUtils.CheckColumn(tableVerifyCostCenters, 9, "UpdateSales"); DATestUtils.CheckColumn(tableVerifyCostCenters, 10, "NewSales"); DATestUtils.CheckColumn(tableVerifyCostCenters, 11, "IdCurrency"); DATestUtils.CheckColumn(tableVerifyCostCenters, 12, "CurrencyCode"); DeleteRevisedBudgetTest(revisedBudget, dbRevisedBudget); DeleteInitialBudgetTest(initialBudget, dbInitialBudget); //int rowCount = DeleteCostCenterTest(costCenter, dbCostCenterEntity); ////Verifies that one and only one row is affected by the delete //Assert.AreEqual(1, rowCount); //int rowCount = DeleteWorkPackageTest(workPackage, dbWorkPackageEntity); // //Verifies that one and only one row is affected by the delete // Assert.AreEqual(1, rowCount); // rowCount = DeleteProjectTest(project, dbProjectEntity); // //Verifies that one and only one row is affected by the delete // Assert.AreEqual(1, rowCount); }