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);
}
