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