public RepositoriesDB()
{
_sqlManager = new SQL();
_listProjects = new ListProjects();
_listSkills = new ListSkills();
_listProjectImages = new ListProjectImages();
}
/** Methode gibt die Tabelle "ProjectImages" zurück als Liste **/
private List <ListProjectImages> getProjectsImages(long projectId)
{
List <ListProjectImages> listProjectsImages = new List <ListProjectImages>();
DataTable currentProjectImagesTable = new DataTable();
string sqlQuery = "";
try
{
sqlQuery = "GetProjectImages";
/** SQL Select Statement gibt die Tabelle "ProjectImages" zurück **/
currentProjectImagesTable = _sqlManager.ExecuteSelect(sqlQuery, new string[] { "@ProjectID" }, new object[] { projectId });
/** Tabelle wird in einer Schleife durchlaufen und ins Modell geladen
* und anschließend zur Liste "listProjectsImages" hinzugefügt **/
if (currentProjectImagesTable.Rows.Count > 0)
{
for (int i = 0; i < currentProjectImagesTable.Rows.Count; i++)
{
ListProjectImages currentProjectImage = new ListProjectImages();
currentProjectImage.Id = Convert.ToInt64(currentProjectImagesTable.Rows[i]["ID"]);
currentProjectImage.ProjectId = Convert.ToInt64(currentProjectImagesTable.Rows[i]["ProjectID"]);
currentProjectImage.Image = currentProjectImagesTable.Rows[i]["Image"].ToString();
listProjectsImages.Add(currentProjectImage);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listProjectsImages);
}
