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); } }