public void VerifyProjectPhase() { Random random = new Random(); IProjectPhase projectPhase = BusinessObjectInitializer.CreateProjectPhase(); projectPhase.Name = DATestUtils.GenerateString(50, true, false); projectPhase.Code = DATestUtils.GenerateString(10, true, true); int newId = InsertProjectPhaseTest(projectPhase); Assert.Greater(newId, 0); int rowsAffected = UpdateProjectPhaseTest(projectPhase); Assert.AreEqual(1, rowsAffected); DataTable resultTable = SelectProjectPhaseTest(projectPhase).Tables[0]; //Verifies that the table contains the correct column names and order StringCollection columns = new StringCollection(); columns.AddRange(new string[] { "Id", "Code", "Name" }); DATestUtils.CheckTableStructure(resultTable, columns); int rowCount = DeleteProjectPhaseTest(projectPhase); Assert.AreEqual(1, rowCount); }
public DataSet SelectProjectPhaseTest(IProjectPhase projectPhase) { DataSet tableVerify = new DataSet(); tableVerify = dbEntity.SelectObject(projectPhase) as DataSet; return(tableVerify); }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IProjectPhase) { IProjectPhase ProjectPhase = (IProjectPhase)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertProjectPhase"; spInsert.AddParameter(new DBParameter("@Code", DbType.String, ParameterDirection.Input, ProjectPhase.Code)); spInsert.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, ProjectPhase.Name)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateProjectPhase"; spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, ProjectPhase.Id)); spUpdate.AddParameter(new DBParameter("@Code", DbType.String, ParameterDirection.Input, ProjectPhase.Code)); spUpdate.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, ProjectPhase.Name)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteProjectPhase"; spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, ProjectPhase.Id)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectProjectPhase"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, ProjectPhase.Id)); this.AddStoredProcedure("SelectObject", spSelect); } }
public int DeleteProjectPhaseTest(IProjectPhase projectPhase) { int rowCount = dbEntity.DeleteObject(projectPhase); return(rowCount); }
public int InsertProjectPhaseTest(IProjectPhase projectPhase) { projectPhase.Id = dbEntity.InsertObject(projectPhase); return(projectPhase.Id); }