//Einen Teilnehmer finden anhand der ID
public Competitor FindCompetitor(Guid CompetitorID)
{
CompetitorDL comp = new CompetitorDL();
Competitor c = comp.FindCompetitor(CompetitorID);
return(c);
}
/*Alle Teilnehmer laden, Dictionary competitors in List umwandeln, durchsuchen und
* ein Dictionary mit den passenden Teilnehmern zurueckgeben*/
public IDictionary <Guid, Competitor> LoadCompetitors(String searchTerm, String username)
{
CompetitorDL comp = new CompetitorDL();
this.competitors = comp.LoadCompetitors();
IList <Competitor>
competitorsList =
(IList <Competitor>) this.competitors
.Values; // um es mit foreach mit dem Suchbegriff durchsuchbar zu machen
IDictionary <Guid, Competitor> result = new SortedList <Guid, Competitor>();
foreach (Competitor c in competitorsList)
{
//gibt -1 zurueck wenn substring nicht gefunden
if (c.Name.IndexOf(searchTerm) != -1 || c.Surname.IndexOf(searchTerm) != -1)
{
if (c.Visibility == "global" || username == c.Username)
{
result.Add(c.CompetitorID, c);
}
}
}
return(result);
}
// Einen Teilnehmer in der Datenbank updaten
public void UpdateCompetitor(Guid compID, String name, String surname, String gender, int skilllevel,
String visibility)
{
CompetitorDL comp = new CompetitorDL();
Competitor competitor = new Competitor(name, surname, gender, skilllevel, visibility);
comp.UpdateCompetitor(compID, competitor);
}
// Einen Teilnehmer zur Datenbank hinzufuegen
public void AddCompetitor(String name, String surname, String gender, int skilllevel, String visibility,
String username)
{
CompetitorDL comp = new CompetitorDL();
Competitor competitor = new Competitor(name, surname, gender, skilllevel, visibility, username);
comp.CreateCompetitor(competitor);
}
//Alle Teilnehmer loeschen
public void DeleteAllCompetitors()
{
RankingDL rdl = new RankingDL();
rdl.DeleteAllRankings();
CompetitorDL comp = new CompetitorDL();
comp.DeleteAllCompetitors();
}
//Einen Teilnehmer loeschen anhand der ID
public void DeleteCompetitor(Guid CompetitorID)
{
RankingDL rdl = new RankingDL();
rdl.DeleteRankingPerCompetitor(CompetitorID);
CompetitorDL comp = new CompetitorDL();
comp.DeleteCompetitor(CompetitorID);
}
public void UpdateCompetitor(Guid comID, int skillChange)
{
CompetitorDL comp = new CompetitorDL();
Competitor c = FindCompetitor(comID);
int newSkilllevel = skillChange + c.SkillLevel;
c.SkillLevel = newSkilllevel;
comp.UpdateCompetitor(c.CompetitorID, c);
}
public static bool TemplateFound(string argName, int argProjId)
{
return(CompetitorDL.TemplateFound(argName, argProjId));
}
public static void DeleteCompetitorMaster(int argCompId)
{
CompetitorDL.DeleteCompetitorMaster(argCompId);
}
public static void InsertCompetitorMaster(string argDesc)
{
CompetitorDL.InsertCompetitorMaster(argDesc);
}
public static DataSet GetReport(int argCCId, int argFlatTypeId)
{
return(CompetitorDL.GetReport(argCCId, argFlatTypeId));
}
public static void TemplateAttach(int argTemId, byte[] argImageData, System.IO.FileStream fileMode, string argExt)
{
CompetitorDL.TemplateAttach(argTemId, argImageData, fileMode, argExt);
}
public static byte[] GetDocTemp(int argTempId)
{
return(CompetitorDL.GetDocTemp(argTempId));
}
public static DataTable GetFlatTypeMaster()
{
return(CompetitorDL.GetFlatTypeMaster());
}
public static DataTable GetFlatTypeReport(int argCCId)
{
return(CompetitorDL.GetFlatTypeReport(argCCId));
}
public static int InsertTempName(string argTempName, int argProjId)
{
return(CompetitorDL.InsertTempName(argTempName, argProjId));
}
public static void UpdateTemplate(int argTempId, string argTempName)
{
CompetitorDL.UpdateTemplate(argTempId, argTempName);
}
public static DataTable GetFlatType(string argFlatTypeId)
{
return(CompetitorDL.GetFlatType(argFlatTypeId));
}
public static void DeleteTempate(int argId)
{
CompetitorDL.DeleteTempate(argId);
}
public static DataTable GetFlatTypeComp(int argProjectId)
{
return(CompetitorDL.GetFlatTypeComp(argProjectId));
}
public static void RemoveTempate(int argId)
{
CompetitorDL.RemoveTempate(argId);
}
public static void InsertFlatTypeComp(DataTable dtFlatTypetrans, int argProjectId)
{
CompetitorDL.InsertFlatTypeComp(dtFlatTypetrans, argProjectId);
}
public static DataTable GetCompMaster()
{
return(CompetitorDL.GetCompMaster());
}
public static DataTable Location()
{
return(CompetitorDL.Location());
}
public static void UpdateCompetitorMaster(int argCompId, string argCompName)
{
CompetitorDL.UpdateCompetitorMaster(argCompId, argCompName);
}
public static bool CheckFlatTypeUsed(int argProjectId)
{
return(CompetitorDL.CheckFlatTypeUsed(argProjectId));
}
public static bool CheckCompMasterUsed(int argCompId)
{
return(CompetitorDL.CheckCompMasterUsed(argCompId));
}
public static DataTable GetTemplate(int argProjId)
{
return(CompetitorDL.GetTemplate(argProjId));
}
