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