public void set_logs(String work_date, String time_logs, String status, Boolean new_logs) { int i = 0; if (update_log == false) { i = dgv_list.Rows.Add(); } else { i = dgv_list.CurrentRow.Index; } DataGridViewRow row = dgv_list.Rows[i]; row.Cells["work_date"].Value = gm.toDateString(work_date, ""); row.Cells["time_log"].Value = gm.toDateString(time_logs, "HH:mm"); row.Cells["is_new"].Value = new_logs; if (status == "I") { row.Cells["status"].Value = "IN"; } else { row.Cells["status"].Value = "OUT"; } }
private void disp_list_history() { dgv_list.Rows.Clear(); try { DataTable dt = db.QueryBySQLCode("SELECT sh.*, concat(firstname,' ',lastname) AS employee FROM rssys.hr_dtr_sum_hdr sh LEFT JOIN rssys.hr_employee e ON e.empid=sh.empid ORDER BY date_generated DESC, time_generated DESC"); if (dt.Rows.Count > 0) { for (int r = 0; dt.Rows.Count > r; r++) { int i = dgv_list.Rows.Add(); DataGridViewRow row = dgv_list.Rows[i]; row.Cells["dgvl_date"].Value = gm.toDateString(dt.Rows[r]["date_generated"].ToString(), ""); row.Cells["dgvl_time"].Value = dt.Rows[r]["time_generated"].ToString(); row.Cells["dgvl_payroll"].Value = gm.toDateString(dt.Rows[r]["date_from"].ToString(), "") + " TO " + gm.toDateString(dt.Rows[r]["date_to"].ToString(), ""); row.Cells["dgvl_userid"].Value = dt.Rows[r]["empid"].ToString(); //cbo_employee.SelectedValue = dt.Rows[r]["empid"].ToString(); row.Cells["dgvl_employee"].Value = dt.Rows[r]["employee"].ToString(); } } } catch { } }
private String compute_overtime(String empid, String datein) { String result = "00:00:00"; String query = ""; String timein = "", timeout = ""; String time_from = "", time_to = ""; TimeSpan total_late = new TimeSpan(0, 0, 0, 0, 0); DataTable ot_time = db.QueryBySQLCode("SELECT time_start FROM rssys.hr_ot_start"); DataTable sched = db.QueryBySQLCode("SELECT shift_sched_from,shift_sched_to FROM rssys.hr_employee WHERE empid = '" + empid + "'"); if (sched.Rows.Count > 0) { time_from = sched.Rows[0]["shift_sched_from"].ToString(); time_to = sched.Rows[0]["shift_sched_to"].ToString(); query = "SELECT DISTINCT e.empid,work_date,(SELECT MAX(time_log) FROM rssys.hr_tito2 st WHERE work_date=t.work_date AND status='O' AND empid=t.empid) AS timeout FROM rssys.hr_tito2 t LEFT JOIN rssys.hr_employee e ON t.empid=e.empid WHERE t.empid = '" + empid + "' AND t.work_date BETWEEN '" + gm.toDateString(datein, "") + "' AND '" + gm.toDateString(datein, "") + "' ORDER BY work_date"; String ot_time_start = ot_time.Rows[0]["time_start"].ToString(); DateTime ot_start = Convert.ToDateTime(DateTime.Now.ToString("M/d/yyyy") + " " + ot_time_start); DataTable logs = db.QueryBySQLCode(query); if (logs != null && logs.Rows.Count > 0) { for (int r = 0; r < logs.Rows.Count; r++) { timeout = logs.Rows[r]["timeout"].ToString(); DateTime datetime_out = Convert.ToDateTime(DateTime.Now.ToString("M/d/yyyy") + " " + timeout); DateTime datetime_to = Convert.ToDateTime(DateTime.Now.ToString("M/d/yyyy") + " " + time_to); int ot_ok = DateTime.Compare(ot_start, datetime_out); if (ot_ok < 0) { int res = DateTime.Compare(ot_start, datetime_out); if (res < 0) { TimeSpan diff = datetime_out.Subtract(ot_start); // MessageBox.Show("Out Time : " + datetime_to + " Time Out : " + datetime_out + " Overtime : " + diff); total_late = total_late + diff; result = total_late.ToString(); } } } } } return(result); }
private String compute_late(String empid, String date_from, String date_to) { String result = "00:00:00"; String query = ""; String timein = "", timeout = ""; String time_from = "", time_to = ""; String sat_time_from = ""; String sat_time_to = ""; TimeSpan total_late = new TimeSpan(0, 0, 0, 0, 0); DataTable sched = db.QueryBySQLCode("SELECT shift_sched_from,shift_sched_to,shift_sched_sat_from,shift_sched_sat_to FROM rssys.hr_employee WHERE empid = '" + empid + "'"); if (sched.Rows.Count > 0) { query = "SELECT DISTINCT e.empid,work_date,(SELECT MIN(time_log) FROM rssys.hr_tito2 st WHERE work_date=t.work_date AND status='I' AND empid=t.empid) AS timein, (SELECT MAX(time_log) FROM rssys.hr_tito2 st WHERE work_date=t.work_date AND status='O' AND empid=t.empid) AS timeout FROM rssys.hr_tito2 t LEFT JOIN rssys.hr_employee e ON t.empid=e.empid WHERE t.work_date BETWEEN '" + gm.toDateString(date_from, "") + "' AND '" + gm.toDateString(date_to, "") + "' AND t.empid ='" + empid + "' ORDER BY work_date"; DataTable logs = db.QueryBySQLCode(query); if (logs != null && logs.Rows.Count > 0) { for (int r = 0; r < logs.Rows.Count; r++) { timein = logs.Rows[r]["timein"].ToString(); DateTime date = Convert.ToDateTime(logs.Rows[r]["work_date"].ToString()); String day_of_week = date.DayOfWeek.ToString(); if (day_of_week == "Saturday") { time_from = sched.Rows[0]["shift_sched_sat_from"].ToString(); } else { time_from = sched.Rows[0]["shift_sched_from"].ToString(); } DateTime datetime_in = Convert.ToDateTime(DateTime.Now.ToString("M/d/yyyy") + " " + timein); DateTime datetime_from = Convert.ToDateTime(DateTime.Now.ToString("M/d/yyyy") + " " + time_from); int res = DateTime.Compare(datetime_from, datetime_in); if (res < 0) { TimeSpan diff = datetime_in.Subtract(datetime_from); total_late = total_late + diff; result = total_late.ToString(); } } } } return(result); }
private void disp_list() { try { dgv_list.Rows.Clear(); } catch (Exception) { } int i = 0; DataTable dt = db.QueryBySQLCode("SELECT * from rssys.hr_leaves WHERE COALESCE(cancel,cancel,'')<>'Y' ORDER BY d_filed DESC"); for (int r = 0; r < dt.Rows.Count; r++) { i = dgv_list.Rows.Add(); DataGridViewRow row = dgv_list.Rows[i]; row.Cells["dgvl_code"].Value = dt.Rows[r]["lvcode"].ToString(); row.Cells["dgvl_empid"].Value = dt.Rows[r]["empid"].ToString(); row.Cells["dgvl_leave_type_code"].Value = dt.Rows[r]["leave_type"].ToString(); cbo_employee.SelectedValue = row.Cells["dgvl_empid"].Value; row.Cells["dgvl_employee"].Value = cbo_employee.Text; cbo_leave.SelectedValue = row.Cells["dgvl_leave_type_code"].Value; row.Cells["dgvl_leave_type"].Value = cbo_leave.Text; row.Cells["dgvl_leave_pay"].Value = dt.Rows[r]["leave_pay"].ToString(); row.Cells["dgvl_d_filed"].Value = gm.toDateString(dt.Rows[r]["d_filed"].ToString(), ""); row.Cells["dgvl_leave_from"].Value = gm.toDateString(dt.Rows[r]["leave_from"].ToString(), ""); row.Cells["dgvl_lfrm_am"].Value = Convert.ToBoolean(dt.Rows[r]["frm_am"].ToString()) ? "✔" : ""; row.Cells["dgvl_lfrm_pm"].Value = Convert.ToBoolean(dt.Rows[r]["frm_pm"].ToString()) ? "✔" : ""; row.Cells["dgvl_leave_to"].Value = gm.toDateString(dt.Rows[r]["leave_to"].ToString(), ""); row.Cells["dgvl_lto_am"].Value = Convert.ToBoolean(dt.Rows[r]["to_am"].ToString()) ? "✔" : ""; row.Cells["dgvl_lto_pm"].Value = Convert.ToBoolean(dt.Rows[r]["to_pm"].ToString()) ? "✔" : ""; row.Cells["dgvl_amount"].Value = gm.toNormalDoubleFormat(dt.Rows[r]["leave_amount"].ToString()).ToString("0.00"); row.Cells["dgvl_no_of_days"].Value = dt.Rows[r]["no_of_days"].ToString(); //✔ i++; } }
private void disp_list() { try { dgv_list.Rows.Clear(); } catch (Exception) { } int i = 0; DataTable dt = db.QueryBySQLCode("SELECT * from rssys.hr_contri_remittance WHERE COALESCE(cancel,cancel,'')<>'Y'"); for (int r = 0; r < dt.Rows.Count; r++) { i = dgv_list.Rows.Add(); DataGridViewRow row = dgv_list.Rows[i]; row.Cells["dgvl_code"].Value = dt.Rows[r]["crcode"].ToString(); row.Cells["dgvl_month"].Value = dt.Rows[r]["month"].ToString(); row.Cells["dgvl_sbr"].Value = dt.Rows[r]["sbr"].ToString(); row.Cells["dgvl_sbr_date"].Value = gm.toDateString(dt.Rows[r]["sbr_date"].ToString(), ""); row.Cells["dgvl_pbr"].Value = dt.Rows[r]["pbr"].ToString(); row.Cells["dgvl_pbr_date"].Value = gm.toDateString(dt.Rows[r]["pbr_date"].ToString(), ""); row.Cells["dgvl_pr"].Value = dt.Rows[r]["pr"].ToString(); row.Cells["dgvl_pr_date"].Value = gm.toDateString(dt.Rows[r]["pr_date"].ToString(), ""); } }
private void bgworker_DoWork(object sender, DoWorkEventArgs e) { String query = "", empid = "", date_from = "", date_to = "", pay_code = "", table = "hr_rpt_files", filename = "", code = "", col = "", val = "", date_in = ""; DataTable pay_period = null; Double total = 0.00, ee = 0.00, er = 0.00, ec = 0.00; query = "SELECT empid, firstname, lastname,pay_rate FROM rssys.hr_employee"; cbo_employee.Invoke(new Action(() => { if (cbo_employee.SelectedIndex != -1) { empid = cbo_employee.SelectedValue.ToString(); query += " WHERE empid='" + empid + "'"; } })); query += " ORDER BY empid ASC"; DataTable employees = db.QueryBySQLCode(query); cbo_payollperiod.Invoke(new Action(() => { pay_code = cbo_payollperiod.SelectedValue.ToString(); })); pay_period = get_date(pay_code); if (pay_period.Rows.Count > 0) { date_from = gm.toDateString(pay_period.Rows[0]["date_from"].ToString(), "yyyy-MM-dd"); date_to = gm.toDateString(pay_period.Rows[0]["date_to"].ToString(), "yyyy-MM-dd"); } filename = RandomString(5) + "_" + DateTime.Now.ToString("yyyy-MM-dd"); filename += ".pdf"; //System.IO.FileStream fs = new FileStream("\\\\RIGHTAPPS\\RightApps\\Eastland\\payroll_reports\\hdmf_summary\\" + filename, FileMode.Create); System.IO.FileStream fs = new FileStream(fileloc_dtr + "\\ViewController\\RPT\\Payroll\\hdmf_summary\\" + filename, FileMode.Create); Document document = new Document(PageSize.LEGAL); PdfWriter.GetInstance(document, fs); document.Open(); BaseFont bf = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 9, iTextSharp.text.Font.NORMAL); Paragraph paragraph = new Paragraph(); paragraph.Alignment = Element.ALIGN_CENTER; paragraph.Font = FontFactory.GetFont("Arial", 12); paragraph.SetLeading(1, 1); paragraph.Add("HDMF DEDUCTIONS REPORTS SUMMARY"); Phrase line_break = new Phrase("\n"); document.Add(paragraph); document.Add(line_break); Paragraph paragraph_2 = new Paragraph(); paragraph_2.Alignment = Element.ALIGN_CENTER; paragraph_2.Font = FontFactory.GetFont("Arial", 12); paragraph_2.SetLeading(1, 1); paragraph_2.Add("For the payroll period " + date_from + " to " + date_to); Phrase line_break_2 = new Phrase("\n"); document.Add(paragraph_2); document.Add(line_break_2); PdfPTable t = new PdfPTable(1); float[] widths = new float[] { 100 }; t.WidthPercentage = 100; t.SetWidths(widths); PdfPTable dis_earnings = new PdfPTable(4); float[] _w2 = new float[] { 70, 50, 50, 50 }; dis_earnings.SetWidths(_w2); dis_earnings.AddCell(new PdfPCell(new Paragraph("Employee Name")) { Border = 2 }); dis_earnings.AddCell(new PdfPCell(new Paragraph("EmployeE Share")) { Border = 2 }); dis_earnings.AddCell(new PdfPCell(new Paragraph("EmployeR Share")) { Border = 2 }); dis_earnings.AddCell(new PdfPCell(new Paragraph("Total Contribution")) { Border = 2 }); foreach (DataRow _employees in employees.Rows) { total = 0; ee = 0; er = 0; String fname = _employees["firstname"].ToString(); String lname = _employees["lastname"].ToString(); String empno = _employees["empid"].ToString(); Double payrate = Convert.ToDouble(_employees["pay_rate"].ToString()); try { if (payrate < 5000.00) { if (payrate <= 1500.00) { ee = (1 / 100) * payrate; er = (2 / 100) * payrate; } else if (payrate > 1500.00) { ee = (2 / 100) * payrate; er = (2 / 100) * payrate; } } if (payrate >= 5000.00) { ee = 100; er = 100; } total = ee + er; dis_earnings.AddCell(new PdfPCell(new Paragraph(fname + " " + lname)) { Border = 0 }); dis_earnings.AddCell(new PdfPCell(new Paragraph(ee.ToString("0.00"))) { Border = 0 }); dis_earnings.AddCell(new PdfPCell(new Paragraph(er.ToString("0.00"))) { Border = 0 }); dis_earnings.AddCell(new PdfPCell(new Paragraph(total.ToString("0.00"))) { Border = 0 }); } catch (Exception ex) { MessageBox.Show(ex.Message); } } document.Add(dis_earnings); document.Add(t); document.Close(); code = db.get_pk("rpt_id"); col = "rpt_id,filename,date_added,rpt_type"; val = "'" + code + "','" + filename + "','" + DateTime.Now.ToShortDateString() + "','HDMF'"; if (db.InsertOnTable(table, col, val)) { db.set_pkm99("rpt_id", db.get_nextincrementlimitchar(code, 8)); //changes from 'hr_empid' MessageBox.Show("New summary reports created"); } else { MessageBox.Show("Failed on saving."); } pic_loading.Invoke(new Action(() => { pic_loading.Visible = false; btn_submit.Enabled = true; })); display_list(); }
private void bgworker_DoWork(object sender, DoWorkEventArgs e) { String query = "", dept_query = "", deptid = "", empid = "", date_from = "", date_to = "", pay_code = "", table = "hr_rpt_files", filename = "", code = "", col = "", val = "", date_in = ""; DataTable pay_period = null; Double total = 0.00, ee = 0.00, er = 0.00, ec = 0.00; query = "SELECT empid, firstname, lastname,mi,pay_rate,department FROM rssys.hr_employee"; dept_query = "SELECT deptid FROM rssys.hr_department"; cbo_employee.Invoke(new Action(() => { if (cbo_employee.SelectedIndex != -1) { empid = cbo_employee.SelectedValue.ToString(); query += " WHERE empid='" + empid + "'"; } })); cbo_department.Invoke(new Action(() => { if (cbo_department.SelectedIndex != -1) { deptid = cbo_department.SelectedValue.ToString(); dept_query += " WHERE deptid = '" + deptid + "' LIMIT 1"; } })); query += " ORDER BY empid ASC"; DataTable departments = db.QueryBySQLCode(dept_query); DataTable employees = db.QueryBySQLCode(query); cbo_payollperiod.Invoke(new Action(() => { pay_code = cbo_payollperiod.SelectedValue.ToString(); })); pay_period = get_date(pay_code); if (pay_period.Rows.Count > 0) { date_from = gm.toDateString(pay_period.Rows[0]["date_from"].ToString(), "yyyy-MM-dd"); date_to = gm.toDateString(pay_period.Rows[0]["date_to"].ToString(), "yyyy-MM-dd"); } filename = RandomString(5) + "_" + DateTime.Now.ToString("yyyy-MM-dd"); filename += ".pdf"; //System.IO.FileStream fs = new FileStream("\\\\RIGHTAPPS\\RightApps\\Eastland\\payroll_reports\\payroll_summary\\" + filename, FileMode.Create); System.IO.FileStream fs = new FileStream(fileloc_dtr + "\\ViewController\\RPT\\Payroll\\payroll_summary\\" + filename, FileMode.Create); Document document = new Document(PageSize.LEGAL.Rotate()); PdfWriter.GetInstance(document, fs); document.Open(); document.Add(new Paragraph("SUGBU REALTY, INC", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 11f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_LEFT }); document.Add(new Paragraph("PAYROLL PERIOD", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 11f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_LEFT }); document.Add(new Chunk("\n")); PdfPTable _thead = new PdfPTable(13); _thead.WidthPercentage = 100f; float[] columnWidths = { 100, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40 }; _thead.SetWidths(columnWidths); _thead.AddCell(new PdfPCell(new Paragraph("Employee", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Rate", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Basic Pay", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Late/UT", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Overtime", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Gross Pay", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Earnings", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Deductions", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("SSS", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("PHIC", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("HDMF", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("With-Tax-C", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("Net Pay", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); cbo_employee.Invoke(new Action(() => { if (cbo_employee.SelectedIndex != -1) { foreach (DataRow _emp in employees.Rows) { DataTable emp_dept = db.QueryBySQLCode("SELECT * FROM rssys.hr_department WHERE deptid='" + _emp["department"].ToString() + "' LIMIT 1"); DataTable emp_payroll = db.QueryBySQLCode("SELECT * FROM rssys.hr_emp_payroll WHERE empid = '" + _emp["empid"].ToString() + "'"); _thead.AddCell(new PdfPCell(new Paragraph(emp_dept.Rows[0]["dept_name"].ToString(), new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLDITALIC)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_LEFT }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); Double pay_rate = Convert.ToDouble(_emp["pay_rate"].ToString()); Double basic_pay = Convert.ToDouble(emp_payroll.Rows[0]["basic_pay"].ToString()); Double late_ut = Convert.ToDouble(emp_payroll.Rows[0]["late_ut"].ToString()); _thead.AddCell(new PdfPCell(new Paragraph(_emp["lastname"].ToString() + ", " + _emp["firstname"].ToString() + " " + _emp["mi"].ToString(), new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.NORMAL)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_LEFT }); _thead.AddCell(new PdfPCell(new Paragraph(pay_rate.ToString("N", new CultureInfo("en-US")), new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_RIGHT }); _thead.AddCell(new PdfPCell(new Paragraph(basic_pay.ToString("N", new CultureInfo("en-US")), new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_RIGHT }); _thead.AddCell(new PdfPCell(new Paragraph("-" + late_ut.ToString("N", new CultureInfo("en-US")), new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); _thead.AddCell(new PdfPCell(new Paragraph("", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10f, iTextSharp.text.Font.BOLD)) { Alignment = Element.ALIGN_CENTER }) { HorizontalAlignment = Element.ALIGN_CENTER }); //DataTable _emp_payroll = db.QueryBySQLCode("SELECT "); } } })); document.Add(_thead); document.Close(); code = db.get_pk("rpt_id"); col = "rpt_id,filename,date_added,rpt_type"; val = "'" + code + "','" + filename + "','" + DateTime.Now.ToShortDateString() + "','PAYROLL_SUMMARY'"; if (db.InsertOnTable(table, col, val)) { db.set_pkm99("rpt_id", db.get_nextincrementlimitchar(code, 8)); //changes from 'hr_empid' MessageBox.Show("New summary reports created"); } else { MessageBox.Show("Failed on saving."); } pic_loading.Invoke(new Action(() => { pic_loading.Visible = false; btn_submit.Enabled = true; })); display_list(); }
private void bgworker_DoWork(object sender, DoWorkEventArgs e) { String query = "", empid = "", date_from = "", date_to = "", pay_code = "", table = "hr_dtr_files", filename = "", code = "", col = "", val = "", date_in = ""; DataTable pay_period = null; query = "SELECT empid, firstname, lastname FROM rssys.hr_employee"; cbo_employee.Invoke(new Action(() => { if (cbo_employee.SelectedIndex != -1) { empid = cbo_employee.SelectedValue.ToString(); query += " WHERE empid='" + empid + "'"; } })); query += " ORDER BY empid ASC"; DataTable employees = db.QueryBySQLCode(query); cbo_payollperiod.Invoke(new Action(() => { pay_code = cbo_payollperiod.SelectedValue.ToString(); })); pay_period = get_date(pay_code); if (pay_period.Rows.Count > 0) { date_from = gm.toDateString(pay_period.Rows[0]["date_from"].ToString(), "yyyy-MM-dd"); date_to = gm.toDateString(pay_period.Rows[0]["date_to"].ToString(), "yyyy-MM-dd"); } DateTime StartDate = DateTime.Parse(date_from); DateTime EndDate = DateTime.Parse(date_to); try { filename = RandomString(5) + "_" + DateTime.Now.ToString("yyyy-MM-dd"); filename += ".pdf"; //System.IO.FileStream fs = new FileStream("\\\\RIGHTAPPS\\RightApps\\Eastland\\payroll_reports\\dtr\\" + filename, FileMode.Create); System.IO.FileStream fs = new FileStream(fileloc_dtr + "\\ViewController\\RPT\\TimeKeeping\\dtr_pdf\\" + filename, FileMode.Create); Document document = new Document(PageSize.LEGAL, 25, 25, 30, 30); PdfWriter.GetInstance(document, fs); document.Open(); if (employees.Rows.Count > 0) { for (int r = 0; r < employees.Rows.Count; r++) { Paragraph paragraph = new Paragraph(); paragraph.Alignment = Element.ALIGN_CENTER; paragraph.Font = FontFactory.GetFont("Arial", 12); paragraph.SetLeading(1, 1); paragraph.Add("DAILY TIME RECORD"); Phrase line_break = new Phrase("\n"); document.Add(paragraph); document.Add(line_break); empid = employees.Rows[r]["empid"].ToString(); Paragraph emp_name = new Paragraph(); emp_name.Alignment = Element.ALIGN_CENTER; emp_name.Font = FontFactory.GetFont("Arial", 8); emp_name.SetLeading(1, 1); emp_name.Add(employees.Rows[r]["firstname"].ToString() + " " + employees.Rows[r]["lastname"].ToString()); document.Add(emp_name); Paragraph horizontal_line = new Paragraph(); horizontal_line.Alignment = Element.ALIGN_CENTER; horizontal_line.Font = FontFactory.GetFont("Arial", 10); horizontal_line.SetLeading(1, 1); horizontal_line.Add("--------------------------------------------------------------------------------------"); document.Add(horizontal_line); Paragraph label_name = new Paragraph(); label_name.Alignment = Element.ALIGN_CENTER; label_name.SetLeading(1, 1); label_name.Font = FontFactory.GetFont("Arial", 8); label_name.Add("Name"); document.Add(label_name); Phrase line_break_1 = new Phrase("\n"); line_break_1.SetLeading(0.5f, 0.5f); document.Add(line_break_1); PdfPTable t = new PdfPTable(9); float[] widths = new float[] { 10, 20, 20, 20, 20, 20, 20, 20, 20 }; t.WidthPercentage = 100; t.SetWidths(widths); t.AddCell(new PdfPCell(new Phrase("DATE")) { Colspan = 2, Rowspan = 2, HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("AM")) { Colspan = 2, HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("PM")) { Colspan = 2, HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("UT/OT")) { Colspan = 3, HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("IN")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("OUT")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("IN")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("OUT")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("LATE")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("UT")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("OT")) { HorizontalAlignment = Element.ALIGN_CENTER }); query = "SELECT DISTINCT CONCAT(lastname,' ',firstname) AS name, t.source, e.empid, to_char(work_date, 'yyyy-MM-dd') AS work_date, (SELECT MIN(time_log) FROM rssys.hr_tito2 st WHERE work_date=t.work_date AND status='I' AND empid=t.empid) AS timein, (SELECT MAX(time_log) FROM rssys.hr_tito2 st WHERE work_date=t.work_date AND status='O' AND empid=t.empid) AS timeout FROM rssys.hr_tito2 t LEFT JOIN rssys.hr_employee e ON t.empid=e.empid WHERE e.empid = '" + empid + "' AND t.work_date BETWEEN '" + date_from + "' AND '" + date_to + "' ORDER BY work_date "; DataTable dt = db.QueryBySQLCode(query); String date_name = "", am_in = "", am_out = "", pm_in = "", pm_out = "", log_date = "", late = "", ut = "", ot_total = ""; int index = 0; foreach (DateTime day in EachDay(StartDate, EndDate)) { if (index != dt.Rows.Count) { if (day.ToShortDateString() == DateTime.Parse(dt.Rows[index]["work_date"].ToString()).ToShortDateString()) { log_date = DateTime.Parse(dt.Rows[index]["work_date"].ToString()).ToShortDateString(); am_in = dt.Rows[index]["timein"].ToString(); pm_out = dt.Rows[index]["timeout"].ToString(); index++; } } date_name = day.ToString("MMM d, yyyy ddd", CultureInfo.InvariantCulture); if (day.ToShortDateString() != log_date) { am_in = ""; pm_out = ""; } t.AddCell(new PdfPCell(new Phrase(date_name)) { Colspan = 2, HorizontalAlignment = Element.ALIGN_LEFT }); t.AddCell(new PdfPCell(new Phrase(am_in)) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase("")) { HorizontalAlignment = Element.ALIGN_CENTER }); t.AddCell(new PdfPCell(new Phrase(pm_out)) { HorizontalAlignment = Element.ALIGN_CENTER }); if (am_in != "") { late = compute_late(empid, am_in, day.ToShortDateString()); } else { late = ""; } t.AddCell(new PdfPCell(new Phrase(late)) { HorizontalAlignment = Element.ALIGN_CENTER }); if (pm_out != "") { ut = compute_undertime(empid, pm_out, day.ToShortDateString()); } else { ut = ""; } t.AddCell(new PdfPCell(new Phrase(ut)) { HorizontalAlignment = Element.ALIGN_CENTER }); if (pm_out != "") { ot_total = compute_overtime(empid, pm_out, day.ToString("yyyy-MM-dd")); } t.AddCell(new PdfPCell(new Phrase(ot_total)) { HorizontalAlignment = Element.ALIGN_CENTER }); ut = ""; late = ""; am_in = ""; pm_out = ""; ot_total = ""; } document.Add(t); document.NewPage(); } } document.Close(); code = db.get_pk("dtr_id"); col = "dtr_id,filename,date_created"; val = "'" + code + "','" + filename + "','" + DateTime.Now.ToShortDateString() + "'"; if (db.InsertOnTable(table, col, val)) { db.set_pkm99("dtr_id", db.get_nextincrementlimitchar(code, 8)); //changes from 'hr_empid' MessageBox.Show("DTR PRINTED"); } else { MessageBox.Show("Failed on saving."); } } catch (Exception ex) { MessageBox.Show("Program Error. \n Please contact the software provider. \n " + ex.Message + "at Line : " + ex.StackTrace); } //bgworker.RunWorkerAsync(); pic_loading.Invoke(new Action(() => { pic_loading.Visible = false; })); btn_submit.Invoke(new Action(() => { btn_submit.Enabled = true; })); display_list(); }
private void bgworker_DoWork(object sender, DoWorkEventArgs e) { String query = "", empid = "", date_from = "", date_to = "", pay_code = "", table = "hr_other_deductions_files", filename = "", code = "", col = "", val = "", date_in = ""; DataTable pay_period = null; query = "SELECT empid, firstname, lastname FROM rssys.hr_employee"; cbo_employee.Invoke(new Action(() => { if (cbo_employee.SelectedIndex != -1) { empid = cbo_employee.SelectedValue.ToString(); query += " WHERE empid='" + empid + "'"; } })); query += " ORDER BY empid ASC"; DataTable employees = db.QueryBySQLCode(query); cbo_payollperiod.Invoke(new Action(() => { pay_code = cbo_payollperiod.SelectedValue.ToString(); })); pay_period = get_date(pay_code); if (pay_period.Rows.Count > 0) { date_from = gm.toDateString(pay_period.Rows[0]["date_from"].ToString(), "yyyy-MM-dd"); date_to = gm.toDateString(pay_period.Rows[0]["date_to"].ToString(), "yyyy-MM-dd"); } filename = RandomString(5) + "_" + DateTime.Now.ToString("yyyy-MM-dd"); filename += ".pdf"; //System.IO.FileStream fs = new FileStream("\\\\RIGHTAPPS\\RightApps\\Eastland\\payroll_reports\\other_deductions\\" + filename, FileMode.Create); System.IO.FileStream fs = new FileStream(fileloc_dtr + "\\ViewController\\RPT\\Payroll\\other_deductions\\" + filename, FileMode.Create); Document document = new Document(PageSize.LEGAL, 25, 25, 30, 30); PdfWriter.GetInstance(document, fs); document.Open(); BaseFont bf = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 9, iTextSharp.text.Font.NORMAL); Paragraph paragraph = new Paragraph(); paragraph.Alignment = Element.ALIGN_CENTER; paragraph.Font = FontFactory.GetFont("Arial", 12); paragraph.SetLeading(1, 1); paragraph.Add("OTHER DEDUCTIONS SUMMARY"); Phrase line_break = new Phrase("\n"); document.Add(paragraph); document.Add(line_break); Paragraph paragraph_2 = new Paragraph(); paragraph_2.Alignment = Element.ALIGN_CENTER; paragraph_2.Font = FontFactory.GetFont("Arial", 12); paragraph_2.SetLeading(1, 1); paragraph_2.Add("For the payroll period " + date_from + " to " + date_to); Phrase line_break_2 = new Phrase("\n"); document.Add(paragraph_2); document.Add(line_break_2); PdfPTable t = new PdfPTable(1); float[] widths = new float[] { 100 }; t.WidthPercentage = 100; t.SetWidths(widths); PdfPTable dis_earnings = new PdfPTable(2); float[] _w2 = new float[] { 50, 50 }; dis_earnings.SetWidths(_w2); foreach (DataRow _employees in employees.Rows) { String fname = _employees["firstname"].ToString(); String lname = _employees["lastname"].ToString(); String empno = _employees["empid"].ToString(); try { DataTable has_earnings = db.QueryBySQLCode("SELECT emp_no FROM rssys.hr_deduction_entry WHERE emp_no = '" + empno + "'"); if (has_earnings != null && has_earnings.Rows.Count > 0) { dis_earnings.AddCell(new PdfPCell(new Paragraph(fname + " " + lname)) { Colspan = 2, Border = 2 }); DataTable hoe = db.QueryBySQLCode("SELECT DISTINCT(od.code) as code,od.description FROM rssys.hr_deduction_entry de LEFT JOIN rssys.hr_other_deductions od ON de.deduction_code = od.code WHERE de.emp_no = '" + empno + "'"); foreach (DataRow _hoe in hoe.Rows) { dis_earnings.AddCell(new PdfPCell(new Paragraph(_hoe["description"].ToString())) { PaddingLeft = 30f, Colspan = 2, Border = 0 }); DataTable hee = db.QueryBySQLCode("SELECT * FROM rssys.hr_deduction_entry WHERE deduction_code = '" + _hoe["code"].ToString() + "' AND payroll_period = '" + pay_code + "' AND emp_no = '" + empno + "'"); foreach (DataRow _hee in hee.Rows) { dis_earnings.AddCell(new PdfPCell(new Paragraph(_hee["amount"].ToString())) { PaddingLeft = 40f, Colspan = 2, Border = 0 }); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } document.Add(dis_earnings); document.Add(t); document.Close(); code = db.get_pk("deductions_id"); col = "deductions_id,filename,date_added"; val = "'" + code + "','" + filename + "','" + DateTime.Now.ToShortDateString() + "'"; if (db.InsertOnTable(table, col, val)) { db.set_pkm99("deductions_id", db.get_nextincrementlimitchar(code, 8)); //changes from 'hr_empid' MessageBox.Show("New Other Earnings Summary added."); } else { MessageBox.Show("Failed on saving."); } pic_loading.Invoke(new Action(() => { pic_loading.Visible = false; btn_submit.Enabled = true; })); display_list(); }
private void disp_schedule() { dgv_list.Rows.Clear(); int i = 0; try { if (cbo_employee.SelectedIndex != -1) { String empid = cbo_employee.SelectedValue.ToString(); String date_from = dtp_frm.Value.ToString("yyyy-MM-dd"); String date_to = dtp_to.Value.ToString("yyyy-MM-dd"); DataTable dt = db.QueryBySQLCode("SELECT * FROM rssys.hr_work_schedule WHERE wrk_date BETWEEN '" + date_from + "' AND '" + date_to + "' AND empid ='" + empid + "' ORDER BY wrk_date ASC"); if (dt != null) { for (int r = 0; r < dt.Rows.Count; r++) { i = dgv_list.Rows.Add(); DataGridViewRow row = dgv_list.Rows[i]; row.Cells["dgvl_code"].Value = dt.Rows[r]["code"].ToString(); row.Cells["dgvl_date"].Value = gm.toDateString(dt.Rows[r]["wrk_date"].ToString(), ""); row.Cells["dgvl_day"].Value = dt.Rows[r]["wrk_day"].ToString(); row.Cells["dgvl_dayn"].Value = dt.Rows[r]["wrk_dayn"].ToString(); row.Cells["dgvl_shift_sched"].Value = dt.Rows[r]["shift_sched"].ToString(); row.Cells["dgvl_shiftsched_code"].Value = dt.Rows[r]["shiftsched_code"].ToString(); row.Cells["dgvl_timein1"].Value = dt.Rows[r]["timein1"].ToString(); row.Cells["dgvl_timein2"].Value = dt.Rows[r]["timein2"].ToString(); row.Cells["dgvl_timeout1"].Value = dt.Rows[r]["timeout1"].ToString(); row.Cells["dgvl_timeout2"].Value = dt.Rows[r]["timeout2"].ToString(); row.Cells["dgvl_restday"].Value = dt.Rows[r]["restday"].ToString(); row.Cells["dgvl_otin"].Value = dt.Rows[r]["ot_in"].ToString(); row.Cells["dgvl_otout"].Value = dt.Rows[r]["ot_out"].ToString(); } if (dt.Rows.Count == 0) { MessageBox.Show("Empty schedule."); } } } } catch { MessageBox.Show("Please select an employee."); } /* * try { dgv_list.Rows.Clear(); } * catch (Exception) { } * * int i = 0; * String date_from = dtp_frm.Value.ToString("yyyy-MM-dd"); * String date_to = dtp_to.Value.ToString("yyyy-MM-dd"); * * String empid = cbo_employee.SelectedValue.ToString(); * * DataTable dt = db.QueryBySQLCode("SELECT to_char(work_date, 'dd/MM/yyyy') AS work_date, time_log, status, source FROM rssys.hr_tito2 WHERE work_date BETWEEN '" + date_from + "' AND '" + date_to + "' AND empid ='" + empid + "'"); * * for (int r = 0; r < dt.Rows.Count; r++) * { * i = dgv_list.Rows.Add(); * DataGridViewRow row = dgv_list.Rows[i]; * * row.Cells["work_date"].Value = dt.Rows[r]["work_date"].ToString(); * row.Cells["time_log"].Value = dt.Rows[r]["time_log"].ToString(); * * if (dt.Rows[r]["status"].ToString() == "I") * { * row.Cells["status"].Value = "IN"; * } * else * { * row.Cells["status"].Value = "OUT"; * } * * if (dt.Rows[r]["source"].ToString() == "M") * { * row.Cells["source"].Value = "Manual"; * } * i++; * }*/ }