public static void SaveGameOfficial(GameOfficial official)
{
using (DAL dal = new DAL())
{
if (!dal.IsConnected)
{
return;
}
SqlParameter[] spParam =
{
new SqlParameter("@officialID", official.officialID),
new SqlParameter("@firstName", official.firstName),
new SqlParameter("@lastName", official.lastName),
};
try
{
dal.ExecuteNonQuery("spSaveGameOfficial", spParam);
}
catch
{
return;
}
}
}
public static List <GameOfficial> GetAllGameOfficial(Tournament tournament)
{
List <GameOfficial> list = null;
using (DAL dal = new DAL())
{
if (!dal.IsConnected)
{
return(null);
}
SqlParameter[] spParam =
{
new SqlParameter("tournamentID", tournament.tournamentID)
};
var datarow = dal.ExecuteQuery("spGetAllOfficial", spParam).Tables[0];
list = new List <GameOfficial>();
foreach (var dr in datarow.AsEnumerable())
{
GameOfficial official = new GameOfficial()
{
officialID = dr.Field <int>(0),
firstName = dr.Field <string>(1),
lastName = dr.Field <string>(2),
};
list.Add(official);
}
}
return(list);
}
public static List <GameOfficial> GetOfficial(List <GameOfficial> official)
{
List <GameOfficial> list = new List <GameOfficial>();
foreach (var of in official)
{
var temp = new GameOfficial()
{
firstName = of.firstName,
lastName = of.lastName,
officialID = of.officialID,
};
list.Add(temp);
}
return(list);
}