public void LoadDed(string no) { // create and execute query t = new DataTable(); t.Columns.Add("id"); t.Columns.Add("No"); t.Columns.Add("Category"); t.Columns.Add("Details"); t.Columns.Add("Amount"); t.Columns.Add("Paid"); t.Columns.Add(new DataColumn("Delete", typeof(Image))); Image delete = new Bitmap(Properties.Resources.Server_Delete_16); deductionDictionary.Clear(); string Q = "SELECT * FROM deduction WHERE no = '" + no + "'"; foreach (Deduction c in Deduction.List(Q)) { try { t.Rows.Add(new object[] { c.Id, c.No, c.Category, c.Details, c.Amount, c.Paid, delete }); deductionDictionary.Add(c.Id, c.Amount); } catch (Exception m) { MessageBox.Show("" + m.Message); Helper.Exceptions(m.Message, "Viewing deductions on slip {each Pay list }" + c.No); } } dtSlip.DataSource = t; dtSlip.AllowUserToAddRows = false; dtSlip.Columns["id"].Visible = false; deduction = deductionDictionary.Sum(o => o.Value); totalDeductionTxt.Text = deduction.ToString("N0"); totalPayTxt.Text = (cost - deduction).ToString("N0"); }
public void LoadData() { // create and execute query t = new DataTable(); t.Columns.Add(new DataColumn("Select", typeof(bool))); t.Columns.Add("ID"); t.Columns.Add("uriUs"); t.Columns.Add(new DataColumn("ImgUs", typeof(Bitmap))); t.Columns.Add("userID"); t.Columns.Add("No"); t.Columns.Add("Employee"); t.Columns.Add("Category"); t.Columns.Add("Details"); t.Columns.Add("Amount"); t.Columns.Add("Paid"); t.Columns.Add("Sync"); t.Columns.Add("Created"); t.Columns.Add(new DataColumn("View", typeof(Image))); t.Columns.Add(new DataColumn("Delete", typeof(Image))); Image view = new Bitmap(Properties.Resources.Note_Memo_16); Image delete = new Bitmap(Properties.Resources.Server_Delete_16); Bitmap b2 = new Bitmap(50, 50); using (Graphics g = Graphics.FromImage(b2)) { g.DrawString("Loading...", this.Font, new SolidBrush(Color.Black), 0f, 0f); } string Q = "SELECT * FROM deduction"; foreach (Deduction c in Deduction.List(Q)) { string user = ""; string imageUs = ""; try { user = Users.Select(c.UserID).Name; } catch { } try { imageUs = Users.Select(c.UserID).Image; } catch { } try { t.Rows.Add(new object[] { "false", c.Id, imageUs as string, b2, c.UserID, c.No, user, c.Category, c.Details, c.Amount, c.Paid, c.Sync, c.Created, view, delete }); } catch (Exception m) { MessageBox.Show("" + m.Message); Helper.Exceptions(m.Message, "Viewing customer {each schedule list }" + user); } } dtGrid.DataSource = t; ThreadPool.QueueUserWorkItem(delegate { foreach (DataRow row in t.Rows) { try { Image img = Helper.Base64ToImage(row["uriUs"].ToString().Replace('"', ' ').Trim()); System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(img); Bitmap bps = new Bitmap(bmp, 50, 50); Image dstImage = Helper.CropToCircle(bps, Color.White); row["ImgUs"] = dstImage; } catch { } } }); dtGrid.AllowUserToAddRows = false; dtGrid.Columns["ID"].Visible = false; dtGrid.Columns["userID"].Visible = false; dtGrid.Columns["uriUs"].Visible = false; }