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