public GetInsureeModel Get(string chfid) { GetInsureeModel response = new GetInsureeModel(); using (var imisContext = new ImisDB()) { response = (from I in imisContext.TblInsuree join P in imisContext.TblPhotos on I.Chfid equals P.Chfid join G in imisContext.TblGender on I.Gender equals G.Code where I.Chfid == chfid && I.ValidityTo == null && P.ValidityTo == null select new GetInsureeModel() { CHFID = I.Chfid, DOB = I.Dob, Gender = G.Gender, InsureeName = I.LastName + " " + I.OtherNames, PhotoPath = P.PhotoFolder + P.PhotoFileName }).FirstOrDefault(); } return(response); }
public GetInsureeModel Get(string chfid) { GetInsureeModel response = new GetInsureeModel(); try { using (var imisContext = new ImisDB()) { response = (from I in imisContext.TblInsuree join P in imisContext.TblPhotos on I.Chfid equals P.Chfid join G in imisContext.TblGender on I.Gender equals G.Code where I.Chfid == chfid && I.ValidityTo == null && P.ValidityTo == null select new GetInsureeModel() { CHFID = I.Chfid, DOB = I.Dob.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture), Gender = G.Gender, InsureeName = I.LastName + " " + I.OtherNames, PhotoPath = P.PhotoFolder + P.PhotoFileName }) .FirstOrDefault(); } return(response); } catch (SqlException e) { throw e; } catch (Exception e) { throw e; } }