public List <string> startParticipantWithSelectedList(int list_id)
{
List <string> result = new List <string>();
//lista zawodnikow z danej listy startowej imie nazwisko email do stringa jako wynik
using (var db = new EntitiesTagTime())
{
istoredprocedures.pStartParticipantFromList(list_id);
result.Add("name sname email");
return(result);
}
}
public List <vResultList> getResultList()
{
using (var db = new EntitiesTagTime())
{
var result = db.vResultList.ToList();
if (result.Any())
{
return(result);
}
else
{
return(emptyResult());
}
}
}
public List <VStartingLists> getAllList()
{
try
{
List <VStartingLists> result = new List <VStartingLists>();
using (var db = new EntitiesTagTime())
{
result = db.VStartingLists.AsNoTracking().ToList();
return(result);
}
}
catch (Exception ex)
{
string er = ex.Message;
return(null);
}
}
public List <VStartingLists> getAllList(IParticipantStart istartList)
{
using (var db = new EntitiesTagTime())
{
var source = db.VStartingLists.AsNoTracking().ToList();
if (source.Any())
{
var result = source.Distinct().Select(x => new VStartingLists
{
list_id = x.list_id,
list_nazwa = x.list_nazwa,
dys_wartosc = x.dys_wartosc,
list_ilosc = x.list_ilosc
}).ToList();
return(result);
}
else
{
List <VStartingLists> emptyResult = new List <VStartingLists>();
emptyResult.Add(istartList.getEmptyList());
return(emptyResult);
}
}
}
