public UserHealthfacilitiesViewModel(UserHealthFacilities uh, HealthFacilities h) : this() { HealthFacilitiesId = h.HealthFacilitiesId; Name = h.Name; Address = h.Address; IsDefault = uh.IsDefault; Code = h.Code; }
public HealthFacilitiesViewModel(HealthFacilities obj, string connectionString) : this() { context = new MySqlContext(new MySqlConnectionFactory(connectionString)); HealthFacilitiesId = obj.HealthFacilitiesId; Name = obj.Name; Code = obj.Code; DistrictCode = obj.DistrictCode; ProvinceCode = obj.ProvinceCode; Address = obj.Address; IsActive = obj.IsActive; IsDelete = obj.IsDelete; Specialist = context.JoinQuery <HealthFacilities, HealthFacilitiesSpecialists>((d, ds) => new object[] { JoinType.InnerJoin, d.HealthFacilitiesId == ds.HealthFacilitiesId }) .Where((d, hs) => d.HealthFacilitiesId == obj.HealthFacilitiesId) .Select((d, hs) => new HealthFacilitiesSpecialistsViewModel(hs, connectionString)).ToList(); TotalDoctor = context.Query <HealthFacilitiesDoctors>().Where(o => o.HealthFacilitiesId == obj.HealthFacilitiesId).Count(); }