public static void LoadData(string start, string end)
{
_roles = new List <Roles>(Roles.ListRoles());
_patients = new List <Patient>(Patient.ListPatients());
_users = new List <Users>(Users.ListUsers());
_events = new List <Events>(Events.ListEvents());
_clinics = new List <Clinics>(Clinics.ListClinic());
_branch = new List <Branch>(Branch.ListBranch());
_queues = new List <Queue>(Queue.ListQueue());
_admit = new List <Admission>(Admission.ListAdmission());
_wards = new List <Wards>(Wards.ListWards());
_departments = new List <Departments>(Departments.ListDepartment());
_procedures = new List <Procedures>(Procedures.ListProcedures());
_operations = new List <Operations>(Operations.ListOperations());
_specimens = new List <Specimens>(Specimens.ListSpecimens());
_tests = new List <Tests>(Tests.ListTests());
_disciplines = new List <Discipline>(Discipline.ListDiscipline());
_beds = new List <Beds>(Beds.ListBeds());
_categories = new List <Category>(Category.ListCategory());
_cds = new List <Cd10>(Cd10.ListCd10());
_items = new List <Item>(Item.ListItem());
_stocks = new List <Stock>(Stock.ListStock());
_dosages = new List <Dosage>(Dosage.ListDosage());
_transactors = new List <Transactor>(Transactor.ListTransactors());
// _services = new List<Services>(Services.ListServices());
// _diagnosis = new List<Diagnosis>(Diagnosis.ListDiagnosis());
_rooms = new List <Room>(Room.ListRoom());
// _vitals = new List<Vitals>(Vitals.ListVitals());
_org = new List <Organisation>(Organisation.ListOrganisation());
}
public void LoadData()
{
_transactorList = new List <Transactor>();
_transactorList = Transactor.ListTransactors();
t = new DataTable();
t.Columns.Add(new DataColumn("Select", typeof(bool)));
t.Columns.Add("id"); //1
t.Columns.Add(new DataColumn("Img", typeof(Bitmap))); //
t.Columns.Add("No"); //3
t.Columns.Add("name"); //4
t.Columns.Add("Contact"); //6
t.Columns.Add("Email"); //7
t.Columns.Add("Address"); //10
t.Columns.Add("Created"); //14
t.Columns.Add("Type"); //14
t.Columns.Add("image"); //9
t.Columns.Add("Delete"); //10
Bitmap b = new Bitmap(50, 50);
using (Graphics g = Graphics.FromImage(b))
{
g.DrawString("Loading...", this.Font, new SolidBrush(Color.Gray), 00, 00);
}
foreach (Transactor transactor in _transactorList)
{
t.Rows.Add(new object[] { false, transactor.Id, b, transactor.TransactorNo, transactor.Name, transactor.Contact, transactor.Email, transactor.Address, transactor.Created, transactor.Type, transactor.Image, "Delete" });
}
dtGrid.DataSource = t;
ThreadPool.QueueUserWorkItem(delegate
{
foreach (DataRow row in t.Rows)
{
try
{
Image img = Base64ToImage(row["image"].ToString());
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(img);
Bitmap bps = new Bitmap(bmp, 50, 50);
row["Img"] = bps;
}
catch
{
}
}
});
dtGrid.AllowUserToAddRows = false;
dtGrid.Columns[11].DefaultCellStyle.BackColor = Color.Aquamarine;
dtGrid.RowTemplate.Height = 60;
dtGrid.Columns[1].Visible = false;
dtGrid.Columns[10].Visible = false;
}
