public ClubDTO ConvertDBObjectToDTO(vwClub dbObj)
{
ClubDTO dtoObj = new ClubDTO()
{
Club_ID = dbObj.Club_ID,
Club_Name = dbObj.Club_Name,
City_ID = dbObj.City_ID,
Year_Found = dbObj.Year_Found,
City_Name = dbObj.City_Name
};
return(dtoObj);
}
public ClubDTO GetFromDB(int objectId)
{
using (UaFootball_DBDataContext db = DBManager.GetDB())
{
vwClub c = db.vwClubs.Single(cc => cc.Club_ID == objectId);
ClubDTO dtoObj = ConvertDBObjectToDTO(c);
Multimedia mLogo = (from tag in db.MultimediaTags
where tag.Club_ID == objectId && tag.Multimedia.MultimediaSubType_CD == Constants.DB.MutlimediaSubTypes.ClubLogo
select tag.Multimedia).FirstOrDefault();
if (mLogo != null)
{
dtoObj.Logo = MultimediaDTO.FromDBObject(mLogo);
dtoObj.Logo.IsUploaded = true;
}
return(dtoObj);
}
}
