public ForgetCardModel GetInfor(string empId, DateTime?workDate) { var list = (from l in _db.SP_FORGETCARD_GETINFOR(empId, workDate) select new ForgetCardModel() { Id = l.Id, EmpId = l.EmpId, EmpName = l.EmpName, Position = l.Posistion, JobTitle = l.JobTitle, JoinDate = l.JOINDATE, DeptFullName = l.DeptFullName, DeptId = l.DeptId ?? 0, TimeIn = l.TimeIn, TimeOut = l.TimeOut, ImageBinary = l.Img, WorkDate = l.WorkDate ?? new DateTime(), SecurityName = l.SecurityName, GateNumber = l.GateId.ToString(), GateName = l.GateName, TemporaryCard = l.TemporaryCard, Reason = l.Reason, ReasonOthers = l.ReasonOthers, ReasonName = l.ReasonName, Org = l.Organization ?? 0, OrgName = l.OrganizationName, DeptPrint = l.DeptNamePrint }).FirstOrDefault(); if (list == null) { return(null); } list.Image = Util.ScaleImage(list.ImageBinary); return(list); }