public HistoryCollection()
{
using (SqlDataReader dr = AppDAL.HistorySelectAll())
{
LoadObjectsFromReader(dr);
}
}
public Treatments(string searchText)
{
using (SqlDataReader dr = AppDAL.TreatmentSearch(searchText))
{
LoadObjectsFromReader(dr);
}
}
public Permissions(Guid userRoleGuid, Guid entityGuid)
{
using (SqlDataReader dr = AppDAL.PermssionSelect(userRoleGuid, entityGuid))
{
LoadObjectsFromReader(dr);
}
}
private bool OpenRecord(Guid userRoleGuid, Guid fieldGuid)
{
bool r = false;
using (SqlDataReader dr = AppDAL.FieldPermssionSelect(userRoleGuid, fieldGuid))
r = dr != null && dr.Read() && this.Populate(dr);
return r;
}
public FieldPermissions(UserRole userRole)
{
if (!Objectbase.IsNullOrEmpty(userRole))
{
this.mUserRole = userRole;
using (SqlDataReader dr = AppDAL.FieldPermssionSelectAllEntityByUser(userRole.ObjectGuid))
{
if (dr != null)
{
while (dr.Read())
{
FieldPermission obj = null;
if (AppShared.IsNull(dr[FieldPermission.Columns.PermisionFieldGuid]))
{
Field field = new Field();
if (field.Populate(dr))
{
obj = new FieldPermission(userRole, field);
this.Add(obj);
}
}
else
{
obj = new FieldPermission();
if (obj.Populate(dr))
this.Add(obj);
}
}
}
}
}
}
public OPDInvestigationProcedureCollection(Guid patientGuid)
{
using (SqlDataReader dr = AppDAL.OPDInvestigationProcedureSearch(patientGuid))
{
LoadObjectsFromReader(dr);
}
}
public LabInvestigationCollection(string searchText)
{
using (SqlDataReader dr = AppDAL.LabInvestigationSearch(searchText))
{
LoadObjectsFromReader(dr);
}
}
public OPDMainInvestigations(Guid InvestigationProcedureGuid)
{
using (SqlDataReader dr = AppDAL.OPDInvestigationProcedureMainInvestigationSelectAll(InvestigationProcedureGuid))
{
LoadObjectsFromReader(dr);
}
}
public Rooms()
{
using (SqlDataReader dr = AppDAL.RoomSelectAll())
{
LoadObjectsFromReader(dr);
}
}
public FieldCollection(Guid userRoleGuid)
{
using (SqlDataReader dr = AppDAL.FieldPermissionSelectByUser(userRoleGuid))
{
LoadObjectsFromReader(dr);
}
}
public PatientProcedures(Guid patientGuid)
{
using (SqlDataReader dr = AppDAL.PatientProcedureSearch(patientGuid))
{
LoadObjectsFromReader(dr);
}
}
public FieldCollection()
{
using (SqlDataReader dr = AppDAL.FieldSelectAll())
{
LoadObjectsFromReader(dr);
}
}
public HistoryCollection(Guid HistoryGuid)
{
using (SqlDataReader dr = AppDAL.HistorySelect(HistoryGuid))
{
LoadObjectsFromReader(dr);
}
}
public HistoryCollection(string searchText)
{
using (SqlDataReader dr = AppDAL.HistorySearch(searchText))
{
LoadObjectsFromReader(dr);
}
}
public MedicineSaleCollection()
{
using (SqlDataReader dr = AppDAL.MedicineSaleSelectAll())
{
LoadObjectsFromReader(dr);
}
}
public Rooms(string searchText)
{
using (SqlDataReader dr = AppDAL.RoomSearch(searchText))
{
LoadObjectsFromReader(dr);
}
}
public OPDInvestigationProcedureCollection()
{
using (SqlDataReader dr = AppDAL.OPDInvestigationProcedureSelectAll())
{
LoadObjectsFromReader(dr);
}
}
public OPDMedicines(Guid PrescriptionProcedureGuid)
{
using (SqlDataReader dr = AppDAL.OPDPrescriptionProcedureMedicineSelectAll(PrescriptionProcedureGuid))
{
LoadObjectsFromReader(dr);
}
}
//public PatientBillCollection()
//{
// using (SqlDataReader dr = AppDAL.PatientSelectAll())
// {
// LoadObjectsFromReader(dr);
// }
//}
#endregion
#region PatientCollection
public PatientBillCollection(string searchText)
{
using (SqlDataReader dr = AppDAL.PatientBillSearch(searchText))
{
LoadObjectsFromReader(dr);
}
}
public PatientMedicineSaleCollection(Guid billGuid)
{
using (SqlDataReader dr = AppDAL.PatientMedicineSaleSearchByBill(billGuid))
{
LoadObjectsFromReader(dr);
}
}
public LabInvestigationCollection(Guid LabInvestigationGuid)
{
using (SqlDataReader dr = AppDAL.LabInvestigationSelect(LabInvestigationGuid))
{
LoadObjectsFromReader(dr);
}
}
public OPDPrescriptionCollection()
{
using (SqlDataReader dr = AppDAL.OPDPrescriptionSelectAll())
{
LoadObjectsFromReader(dr);
}
}
public FieldPermissions(Guid userRoleGuid, Guid fieldGuid)
{
using (SqlDataReader dr = AppDAL.FieldPermssionSelect(userRoleGuid, fieldGuid))
{
LoadObjectsFromReader(dr);
}
}
public OPDPrescriptionCollection(Guid PatientGuid)
{
using (SqlDataReader dr = AppDAL.OPDPrescriptionSearch(PatientGuid))
{
LoadObjectsFromReader(dr);
}
}
public Treatments()
{
using (SqlDataReader dr = AppDAL.TreatmentSelectAll())
{
LoadObjectsFromReader(dr);
}
}
public OPDChiefComplains(Guid historyProcedureGuid)
{
using (SqlDataReader dr = AppDAL.OPDHistoryProcedureChiefComplainSelectAll(historyProcedureGuid))
{
LoadObjectsFromReader(dr);
}
}
public Permissions()
{
using (SqlDataReader dr = AppDAL.PermissionSelectAll())
{
LoadObjectsFromReader(dr);
}
}
public MedicineSaleCollection(string searchText)
{
using (SqlDataReader dr = AppDAL.MedicineSaleSearch(searchText))
{
LoadObjectsFromReader(dr);
}
}
public Permissions(UserRole userRole)
{
if (!Objectbase.IsNullOrEmpty(userRole))
{
this.mUserRole = userRole;
using (SqlDataReader dr = AppDAL.PermssionSelect_AllEntityByUser(userRole.ObjectGuid))
{
if (dr != null)
{
while (dr.Read())
{
Permission obj = null;
if (AppShared.IsNull(dr[Permission.Columns.PermissionEntityGuid]))
{
Entity entity = new Entity();
if (entity.Populate(dr))
{
obj = new Permission(userRole, entity);
this.Add(obj);
}
}
else
{
obj = new Permission();
if (obj.Populate(dr))
{
this.Add(obj);
}
}
}
}
}
}
}
public Procedures(string searchText)
{
using (SqlDataReader dr = AppDAL.ProcedureSearch(searchText))
{
LoadObjectsFromReader(dr);
}
}