private string GetDocumentType(int documentTypeId)
        {
            var result = "";

            using (var db = new MyFileItEntities())
            {
                var obj = db.DOCUMENTSTATUS.SingleOrDefault(d => d.ID == documentTypeId);
                if (obj != null)
                {
                    result = obj.NAME;
                }
            }
            return(result);
        }
        public TeamEventDTO(TEAMEVENT teamEventEF)
        {
            ID             = teamEventEF.ID;
            ORGANIZATIONID = teamEventEF.ORGANIZATIONID;

            var organizationName = "";

            using (var db = new MyFileItEntities()) {
                organizationName = db.ORGANIZATIONs.Single(o => o.ID == teamEventEF.ORGANIZATIONID).NAME;
            }

            OrganizationName = organizationName;//teamEventEF.ORGANIZATION.NAME;
            NAME             = teamEventEF.NAME;
            YEARCODE         = teamEventEF.YEARCODE;
            STARTDATE        = teamEventEF.STARTDATE;
            EXPIRESDATE      = teamEventEF.EXPIRESDATE;
            DATECREATED      = teamEventEF.DATECREATED;
            ISDELETED        = teamEventEF.ISDELETED;
        }
 public ReportHelper(MyFileItEntities db)
 {
     _db = db;
 }