private void btn_upd_Click(object sender, EventArgs e) { int r = 0; String code = ""; isnew = false; if (dgv_list.Rows.Count > 1) { try { r = dgv_list.CurrentRow.Index; cbo_employee.SelectedValue = dgv_list["dgvl_empno", r].Value.ToString(); code = dgv_list["dgvl_code", r].Value.ToString(); txt_code.Text = code; txt_desc.Text = dgv_list["dgvl_description", r].Value.ToString(); cbo_contraacct.SelectedValue = dgv_list["dgvl_trn_type", r].Value.ToString(); cbo_stocklocation.Text = dgv_list["dgvl_location", r].Value.ToString(); cbo_costcenter.Text = dgv_list["dgvl_ccname", r].Value.ToString(); cbo_scc.Text = dgv_list["dgvl_sub_costcenter", r].Value.ToString(); dtp_deduction.Value = gm.toDateValue(dgv_list["dgvl_deduction_date", r].Value.ToString()); dtp_trnxdt.Value = gm.toDateValue(dgv_list["dgvl_trnxdate", r].Value.ToString()); txt_amnt_loan.Text = gm.toNormalDoubleFormat(dgv_list["dgvl_loan_amount", r].Value.ToString()).ToString("0.00"); txt_deduction.Text = gm.toNormalDoubleFormat(dgv_list["dgvl_deduction_amount", r].Value.ToString()).ToString("0.00"); } catch { } //disp_itemlist(code); //total_amountdue(); goto_tbcntrl_info(); //goto_win2(); } }
private void txt_f_month_TextChanged(object sender, EventArgs e) { if (txt_f_month.Text.Length != 0) { try { double n = gm.toNormalDoubleFormat(txt_f_month.Text); if (0 < n && n <= 12) { txt_f_month.Text = n.ToString("0"); return; } } catch { } txt_f_month.Text = DateTime.Now.ToString("MM"); } }
void calculate_gross() { Double gross = gm.toNormalDoubleFormat(txt_basic_pay.Text) + gm.toNormalDoubleFormat(txt_reg_ot_b.Text) + gm.toNormalDoubleFormat(txt_dayoffot_b.Text) + gm.toNormalDoubleFormat(txt_legalhol_ot_b.Text) + gm.toNormalDoubleFormat(txt_specialhol_ot_b.Text) + gm.toNormalDoubleFormat(txt_legalhol_pay_b.Text) + gm.toNormalDoubleFormat(txt_specialhol_pay_b.Text) + gm.toNormalDoubleFormat(txt_night_diff_b.Text) + gm.toNormalDoubleFormat(txt_other_earning.Text) + gm.toNormalDoubleFormat(txt_vl_b.Text) + gm.toNormalDoubleFormat(txt_sl_b.Text) + gm.toNormalDoubleFormat(txt_pl_b.Text) + gm.toNormalDoubleFormat(txt_legalhol_pay_b.Text) + gm.toNormalDoubleFormat(txt_specialhol_pay_b.Text); lbl_total_gross.Text = gm.toAccountingFormat(gross); }
private void bg_worker_DoWork(object sender, DoWorkEventArgs e) { String table = "hr_emp_payroll", col = "", val = "", emp_pay_code = ""; String summ_code = "", empid = "", days_worked = "", absences = "", late = "", undertime = "", overtime = "", ppid = "", sss_bracket = "", philhealth_bracket = "", pagibig_bracket = ""; Double total_late = 0.00, total_under_time = 0.00, total_overtime = 0.00, leaves_amnt = 0.00, other_deduc = 0.00, other_earn = 0.00, advances_loans = 0.00, pag_ibig_a = 0.00, philhealth_cont_a = 0.00, sss_cont_a = 0.00; DataTable dtr = get_generated_dtr(), dttmp = new DataTable(); Boolean success = false; int bar = 1; if (dtr.Rows.Count > 0) { try { pbar.Invoke(new Action(() => { pbar.Maximum = dtr.Rows.Count; })); for (int r = 0; r < dtr.Rows.Count; r++) { ppid = dtr.Rows[r]["ppid"].ToString(); empid = dtr.Rows[r]["empid"].ToString(); days_worked = dtr.Rows[r]["days_worked"].ToString(); absences = dtr.Rows[r]["absences"].ToString(); late = dtr.Rows[r]["late"].ToString(); undertime = dtr.Rows[r]["undertime"].ToString(); overtime = dtr.Rows[r]["total_overtime"].ToString(); try { total_late = Convert.ToDouble(TimeSpan.Parse(late).TotalHours); } catch (Exception ex) { total_late = 0.00; } try { total_under_time = Convert.ToDouble(TimeSpan.Parse(undertime).TotalHours); } catch (Exception ex) { total_under_time = 0.00; } try { total_overtime = Convert.ToDouble(TimeSpan.Parse(overtime).TotalHours); } catch (Exception ex) { total_overtime = 0.00; } chk_oearn.Invoke(new Action(() => { if (chk_oearn.Checked) { DataTable tdt = db.QueryBySQLCode("SELECT * FROM rssys.hr_deduction_entry WHERE payroll_period='" + ppid + "' AND emp_no='" + empid + "'"); if (tdt != null) { for (int i = 0; i < tdt.Rows.Count; i++) { other_earn += gm.toNormalDoubleFormat(tdt.Rows[i]["amount"].ToString()); } } } })); chk_odeduc.Invoke(new Action(() => { if (chk_odeduc.Checked) { DataTable tdt = db.QueryBySQLCode("SELECT * FROM rssys.hr_deduction_entry WHERE payroll_period='" + ppid + "' AND emp_no='" + empid + "'"); if (tdt != null) { for (int i = 0; i < tdt.Rows.Count; i++) { other_deduc += gm.toNormalDoubleFormat(tdt.Rows[i]["amount"].ToString()); } } } })); chk_loan.Invoke(new Action(() => { if (chk_loan.Checked) { DataTable tdt = db.QueryBySQLCode("SELECT * FROM rssys.hr_loanhdr l LEFT JOIN rssys.hr_payrollpariod pp ON l.loan_transdate BETWEEN pp.date_from AND pp.date_to WHERE pp.pay_code='" + ppid + "' AND l.employee_no='" + empid + "'"); if (tdt != null) { for (int i = 0; i < tdt.Rows.Count; i++) { advances_loans += gm.toNormalDoubleFormat(tdt.Rows[i]["loan_amount"].ToString()); } } } })); chk_leave.Invoke(new Action(() => { if (chk_leave.Checked) { DataTable tdt = db.QueryBySQLCode("SELECT * from rssys.hr_leaves l LEFT JOIN rssys.hr_payrollpariod pp ON l.d_filed BETWEEN pp.date_from AND pp.date_to WHERE COALESCE(l.cancel,l.cancel,'')<>'Y' AND pp.pay_code='" + ppid + "' AND l.empid='" + empid + "'"); if (tdt != null) { for (int i = 0; i < tdt.Rows.Count; i++) { leaves_amnt += gm.toNormalDoubleFormat(tdt.Rows[i]["leave_amount"].ToString()); } } } })); emp_pay_code = db.get_pk("emp_pay_code"); col = "emp_pay_code,empid,days_worked,abcences,late,undertime,overtime,ppid,other_deduction, other_earnings, leave_amnt, advances_loans"; val = "'" + emp_pay_code + "','" + empid + "','" + days_worked + "','" + absences + "','" + total_late.ToString("0.00") + "','" + total_under_time.ToString("0.00") + "','" + total_overtime.ToString("0.00") + "','" + ppid + "','" + other_deduc + "','" + other_earn + "','" + leaves_amnt + "','" + advances_loans + "'"; dttmp = db.QueryBySQLCode("SELECT COALESCE(emp_ee,0.00) + COALESCE(emp_er,0.00) AS total, pagibig_bracket FROM rssys.hr_hdmf h JOIN rssys.hr_employee e ON (e.pagibig_bracket=h.code AND e.empid='" + empid + "')"); if (dttmp != null) { try { pag_ibig_a = gm.toNormalDoubleFormat(dttmp.Rows[0]["total"].ToString()); pagibig_bracket = dttmp.Rows[0]["pagibig_bracket"].ToString(); } catch { } } dttmp = db.QueryBySQLCode("SELECT COALESCE(empshare_sc,0.00) + COALESCE(empshare_ec,0.00) + COALESCE(s_ec,0.00) AS total, sss_bracket FROM rssys.hr_sss h JOIN rssys.hr_employee e ON (e.sss_bracket=h.code AND e.empid='" + empid + "')"); if (dttmp != null) { try { sss_cont_a = gm.toNormalDoubleFormat(dttmp.Rows[0]["total"].ToString()); sss_bracket = dttmp.Rows[0]["sss_bracket"].ToString(); } catch { } } dttmp = db.QueryBySQLCode("SELECT COALESCE(emp_ee,0.00) + COALESCE(emp_er,0.00) AS total, philhealth_bracket FROM rssys.hr_philhealth h JOIN rssys.hr_employee e ON (e.philhealth_bracket=h.code AND e.empid='" + empid + "')"); if (dttmp != null) { try { philhealth_cont_a = gm.toNormalDoubleFormat(dttmp.Rows[0]["total"].ToString()); philhealth_bracket = dttmp.Rows[0]["philhealth_bracket"].ToString(); } catch { } } col += ",regular_pay, basic_pay, vl_a, vl_b, sl_a, sl_b, pl_a, pl_b, regular_ot_a, reqular_ot_b, dayoff_ot_a, dayoff_ot_b, legal_hol_ot_a, legal_hol_ot_b, special_hol_ot_a, special_hol_ot_b, legal_hol_pay_a, legal_hol_pay_b, spl_hol_pay_a, spl_hol_pay_b,night_diff_a, night_diff_b, sss_cont_a, sss_cont_b, sss_cont_c, philhealth_cont_a, philhealth_cont_b, pag_ibig_a, pag_ibig_b, others, w_tax, late_amnt, absent_amnt, sss_bracket, philhealth_bracket, pagibig_bracket"; val += ",'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0','0', '" + sss_cont_a.ToString("0.00") + "', '0', '0', '" + philhealth_cont_a.ToString("0.00") + "', '0', '" + pag_ibig_a.ToString("0.00") + "', '0', '0', '0', '0', '0','" + sss_bracket + "','" + philhealth_bracket + "','" + pagibig_bracket + "'"; if (db.InsertOnTable(table, col, val)) { col = "isgenerated='1'"; if (db.UpdateOnTable("hr_dtr_sum_employees", col, "empid='" + empid + "' AND ppid='" + ppid + "'")) { success = true; inc_pbar(bar, dtr.Rows.Count); bar++; } db.set_pkm99("emp_pay_code", db.get_nextincrementlimitchar(emp_pay_code, 8)); } } if (success) { String period = get_payrol_period(ppid); MessageBox.Show("New payroll was generated From " + period + " ."); } } catch (Exception ex) { MessageBox.Show("Payroll cannot be generated. Something went wrong. " + ex.Message); } } else { MessageBox.Show("No generated DTR is available."); } }
private void btn_save_Click(object sender, EventArgs e) { Boolean success = false, ok = false; String notificationText = ""; z_Notification notify = new z_Notification(); String branch = GlobalClass.branch; String col = "", val = ""; String notifyadd = null, id = ""; String table = "hr_sss"; if (String.IsNullOrEmpty(txt_code.Text)) { MessageBox.Show("Please enter the required fields."); return; } String code = txt_code.Text; String bracket1 = gm.toNormalDoubleFormat(txt_bracket1.Text).ToString("0.00"); String bracket2 = gm.toNormalDoubleFormat(txt_bracket2.Text).ToString("0.00"); String s_credit = gm.toNormalDoubleFormat(txt_s_credit.Text).ToString("0.00"); String empshare_sc = gm.toNormalDoubleFormat(txt_empshare_sc.Text).ToString("0.00"); String s_ec = gm.toNormalDoubleFormat(txt_s_ec.Text).ToString("0.00"); String empshare_ec = gm.toNormalDoubleFormat(txt_empshare_ec.Text).ToString("0.00"); if (isnew) { col = "code,bracket1,bracket2,s_credit,empshare_sc,s_ec,empshare_ec"; val = "" + db.str_E(code) + ",'" + bracket1 + "','" + bracket2 + "','" + s_credit + "','" + empshare_sc + "','" + s_ec + "','" + empshare_ec + "'"; db.DeleteOnTable(table, "code=" + db.str_E(code) + " AND cancel='Y'"); if (db.InsertOnTable(table, col, val)) { success = true; } else { success = false; //db.DeleteOnTable(table, "code='" + code + "'"); MessageBox.Show("Failed on saving."); } } else { col = "bracket1='" + bracket1 + "',bracket2='" + bracket2 + "',s_credit='" + s_credit + "',empshare_sc='" + empshare_sc + "',s_ec='" + s_ec + "',empshare_ec='" + empshare_ec + "'"; if (db.UpdateOnTable(table, col, "code=" + db.str_E(code) + "")) { success = true; } else { success = false; MessageBox.Show("Failed on saving."); } } if (success) { goto_win1(); frm_clear(); disp_list(); } }
private void btn_save_Click(object sender, EventArgs e) { Boolean success = false, ok = false; String notificationText = ""; z_Notification notify = new z_Notification(); String branch = GlobalClass.branch; String col = "", val = ""; String notifyadd = null, id = ""; String table = "hr_leaves"; if (String.IsNullOrEmpty(txt_code.Text)) { MessageBox.Show("Please enter the required fields."); return; } if (cbo_employee.SelectedIndex == -1) { MessageBox.Show("Please select an employee."); cbo_employee.DroppedDown = true; return; } if (cbo_leave_pay.Text == "YES" && gm.toNormalDoubleFormat(txt_amount.Text) == 0) { MessageBox.Show("Please input leave amount."); return; } String lvcode = txt_code.Text; String no_of_days = Double.Parse(txt_no_of_days.Text).ToString(); String d_filed = dtp_filed.Value.ToString("yyyy-MM-dd"); String leave_from = dtp_lfrm.Value.ToString("yyyy-MM-dd"); String leave_to = dtp_lto.Value.ToString("yyyy-MM-dd"); String leave_amount = txt_amount.Text; String empid = (cbo_employee.SelectedValue ?? "").ToString(); String leave_pay = cbo_leave_pay.Text; String leave_type = (cbo_leave.SelectedValue ?? "").ToString(); String frm_am = Convert.ToString(chk_fam.Checked); String frm_pm = Convert.ToString(chk_fpm.Checked); String to_am = Convert.ToString(chk_tam.Checked); String to_pm = Convert.ToString(chk_tpm.Checked); // hr_leaves, lvcode, empid, d_filed, leave_from, leave_to, frm_am, frm_pm, to_am, to_pm, no_of_days, leave_pay, leave_type if (isnew) { col = "lvcode, empid, d_filed, leave_from, leave_to, frm_am, frm_pm, to_am, to_pm, no_of_days, leave_pay, leave_type, leave_amount"; val = "'" + lvcode + "', '" + empid + "', '" + d_filed + "', '" + leave_from + "', '" + leave_to + "', '" + frm_am + "', '" + frm_pm + "', '" + to_am + "', '" + to_pm + "', '" + no_of_days + "', '" + leave_pay + "', '" + leave_type + "', '" + leave_amount + "'"; db.DeleteOnTable(table, "lvcode='" + lvcode + "' AND cancel='Y'"); if (db.InsertOnTable(table, col, val)) { success = true; } else { success = false; //db.DeleteOnTable(table, "code='" + code + "'"); MessageBox.Show("Failed on saving."); } } else { col = "empid='" + empid + "', d_filed='" + d_filed + "', leave_from='" + leave_from + "', leave_to='" + leave_to + "', frm_am='" + frm_am + "', frm_pm='" + frm_pm + "', to_am='" + to_am + "', to_pm='" + to_pm + "', no_of_days='" + no_of_days + "', leave_pay='" + leave_pay + "', leave_type='" + leave_type + "', leave_amount='" + leave_amount + "'"; if (db.UpdateOnTable(table, col, "lvcode='" + lvcode + "'")) { success = true; } else { success = false; MessageBox.Show("Failed on saving."); } } if (success) { goto_win1(); frm_clear(); disp_list(); } }
private void display_emp_payroll(String pay_code, String empid, String ppid) { DataTable payroll = null; int count_dayoff = 0, dayoff = 0, days = 0; Double daily_rate = 0.00, pay_rate = 0.00, hour_rate = 0.00, minute_rate = 0.00; try { payroll = db.QueryBySQLCode("SELECT ep.*,emp.fixed_rate,emp.empid,emp.dayoff1,emp.dayoff2,emp.shift_sched_from,emp.shift_sched_to,emp.pay_rate,rt.*,CONCAT(emp.firstname, ' ',emp.lastname) as name, CONCAT(to_char(p.date_from, 'mm/dd/yyyy'),' To ',to_char(p.date_to, 'mm/dd/yyyy')) as period FROM rssys.hr_emp_payroll ep LEFT JOIN rssys.hr_employee emp ON emp.empid = ep.empid LEFT JOIN rssys.hr_payrollpariod p ON p.pay_code = ep.ppid LEFT JOIN rssys.hr_rate_type rt ON rt.ratecode = emp.rate_type WHERE emp.empid = '" + empid + "' and ep.emp_pay_code = '" + pay_code + "' ORDER BY p.date_from,p.date_to ASC "); if (payroll.Rows.Count > 0) { try { disp_legal_hol_pay(empid, ppid); txt_empname.Text = payroll.Rows[0]["name"].ToString(); txt_pay_period.Text = (payroll.Rows[0]["period"] ?? "0").ToString(); txt_pay_rate.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["pay_rate"] ?? "0.00").ToString()).ToString("0.00"); txt_rate_type.Text = (payroll.Rows[0]["description"] ?? "0.00").ToString(); txt_dayswoked.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["days_worked"] ?? "0.00").ToString()).ToString("0.00"); txt_absent.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["abcences"] ?? "0").ToString()).ToString("0.00"); if (payroll.Rows[0]["late"].ToString() == "" && payroll.Rows[0]["undertime"].ToString() == "") { txt_late_ut.Text = "0.00"; } else if (payroll.Rows[0]["late"].ToString() == "" && payroll.Rows[0]["undertime"].ToString() != "") { txt_late_ut.Text = payroll.Rows[0]["undertime"].ToString(); } else if (payroll.Rows[0]["undertime"].ToString() == "" && payroll.Rows[0]["late"].ToString() != "") { txt_late_ut.Text = payroll.Rows[0]["late"].ToString(); } else { txt_late_ut.Text = (Convert.ToDouble(payroll.Rows[0]["late"].ToString()) + Convert.ToDouble(payroll.Rows[0]["undertime"].ToString())).ToString("0.00"); } } catch (Exception ex) { } txt_vl_a.Text = (payroll.Rows[0]["vl_a"] ?? "0.00").ToString(); txt_vl_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["vl_b"] ?? "0.00").ToString()).ToString("0.00"); txt_sl_a.Text = (payroll.Rows[0]["sl_a"] ?? "0.00").ToString(); txt_sl_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["sl_b"] ?? "0.00").ToString()).ToString("0.00"); txt_pl_a.Text = (payroll.Rows[0]["pl_a"] ?? "0.00").ToString(); txt_pl_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["pl_b"] ?? "0.00").ToString()).ToString("0.00"); txt_reg_ot_a.Text = (payroll.Rows[0]["regular_ot_a"] ?? "0.00").ToString(); txt_reg_ot_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["reqular_ot_b"] ?? "0.00").ToString()).ToString("0.00"); txt_dayoffot_a.Text = (payroll.Rows[0]["dayoff_ot_a"] ?? "0.00").ToString(); txt_dayoffot_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["dayoff_ot_b"] ?? "0.00").ToString()).ToString("0.00"); txt_legalhol_ot_a.Text = (payroll.Rows[0]["legal_hol_ot_a"] ?? "0.00").ToString(); txt_legalhol_ot_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["legal_hol_ot_b"] ?? "0.00").ToString()).ToString("0.00"); txt_specialhol_ot_a.Text = (payroll.Rows[0]["special_hol_ot_a"] ?? "0.00").ToString(); txt_specialhol_ot_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["special_hol_ot_b"] ?? "0.00").ToString()).ToString("0.00"); txt_legalhol_pay_a.Text = (payroll.Rows[0]["legal_hol_pay_a"] ?? "0.00").ToString(); txt_legalhol_pay_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["legal_hol_pay_b"] ?? "0.00").ToString()).ToString("0.00"); txt_specialhol_pay_a.Text = (payroll.Rows[0]["spl_hol_pay_a"] ?? "0.00").ToString(); txt_specialhol_pay_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["spl_hol_pay_b"] ?? "0.00").ToString()).ToString("0.00"); txt_night_diff_a.Text = (payroll.Rows[0]["night_diff_a"] ?? "0.00").ToString(); txt_night_diff_b.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["night_diff_b"] ?? "0.00").ToString()).ToString("0.00"); txt_other_earning.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["other_earnings"] ?? "0.00").ToString()).ToString("0.00"); txt_sss_a.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["sss_cont_a"] ?? "0.00").ToString()).ToString("0.00"); txt_philhealth_a.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["philhealth_cont_a"] ?? "0.00").ToString()).ToString("0.00"); txt_pagibig_a.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["pag_ibig_a"] ?? "0.00").ToString()).ToString("0.00"); //txt_sss_b.Text = (payroll.Rows[0]["sss_cont_b"]??"0.00").ToString(); //txt_sss_con_c.Text = (payroll.Rows[0]["sss_cont_c"]??"0.00").ToString(); //txt_philhealth_a.Text = (payroll.Rows[0]["philhealth_cont_a"]??"0.00").ToString(); //txt_philhealth_b.Text = (payroll.Rows[0]["philhealth_cont_b"]??"0.00").ToString(); //txt_pagibig_a.Text = (payroll.Rows[0]["pag_ibig_a"]??"0.00").ToString(); //txt_pagibig_b.Text = payroll.Rows[0]["pag_ibig_b"].ToString(); txt_wtax.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["w_tax"] ?? "0.00").ToString()).ToString("0.00"); txt_other_deductions.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["other_deduction"] ?? "0.00").ToString()).ToString("0.00"); txt_others.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["others"] ?? "0.00").ToString()).ToString("0.00"); txt_advance_loans.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["advances_loans"] ?? "0.00").ToString()).ToString("0.00"); txt_leaves.Text = gm.toNormalDoubleFormat((payroll.Rows[0]["leave_amnt"] ?? "0.00").ToString()).ToString("0.00"); pay_rate = Convert.ToDouble((payroll.Rows[0]["pay_rate"] ?? "0.00").ToString()); if (payroll.Rows[0]["dayoff1"].ToString() != "-1") { count_dayoff = 1; } if (payroll.Rows[0]["dayoff2"].ToString() != "-1") { count_dayoff = 2; } if (count_dayoff == 2) { days = 261; } else if (count_dayoff == 1) { days = 312; } else { days = 365; } if (payroll.Rows[0]["ratecode"].ToString() == "M") { if (payroll.Rows[0]["fixed_rate"].ToString() == "1") { daily_rate = (pay_rate * 12) / days; //pay_rate = monthly rate pay_rate = pay_rate / 2; //pay_rate = half of the month rate txt_regpay.Text = pay_rate.ToString("0.00"); } else { try { daily_rate = (pay_rate * 12) / days; txt_regpay.Text = (Convert.ToDouble(txt_dayswoked.Text) * daily_rate).ToString("0.00"); } catch (Exception ex) { txt_regpay.Text = "0.00"; } } } else if (payroll.Rows[0]["ratecode"].ToString() == "D") { try { daily_rate = (Convert.ToDouble(txt_dayswoked.Text) * pay_rate); txt_regpay.Text = daily_rate.ToString("0.00"); } catch (Exception ex) { txt_regpay.Text = "0.00"; } } else if (payroll.Rows[0]["ratecode"].ToString() == "W") { try { int year = DateTime.Now.Year; int week_days = 0; if (DateTime.IsLeapYear(year)) { if (count_dayoff == 2) { week_days = 261; } } else { week_days = 260; } daily_rate = pay_rate; //daily_rate = (pay_rate * 12) / week_days; //previous daily rate ? txt_regpay.Text = (Convert.ToDouble(txt_dayswoked.Text) * pay_rate).ToString("0.00"); } catch (Exception ex) { txt_regpay.Text = "0.00"; } } try { hour_rate = pay_rate / 8; } catch (Exception ex) { hour_rate = 0.00; } try { minute_rate = pay_rate / 480; } catch (Exception ex) { minute_rate = 0.00; } try { // Double lat_ut = (Convert.ToDouble(txt_late_ut.Text) * 60) * minute_rate; //updated Double lat_ut = (Convert.ToDouble(txt_late_ut.Text)) * minute_rate; txt_late_ut_amt.Text = lat_ut.ToString("0.00"); } catch (Exception ex) { txt_late_ut_amt.Text = "0.00"; } try { txt_absent_amount.Text = (Convert.ToDouble(txt_absent.Text) * pay_rate).ToString("0.00"); } catch (Exception ex) { txt_absent_amount.Text = "0.00"; } try { if (payroll.Rows[0]["fixed_rate"].ToString() == "1") { Double regpay = Convert.ToDouble(txt_regpay.Text); Double absent_amt = Convert.ToDouble(txt_absent_amount.Text); Double late_amt = Convert.ToDouble(txt_late_ut_amt.Text); Double basic_pay = regpay - (absent_amt + late_amt); txt_basic_pay.Text = basic_pay.ToString("0.00"); } } catch (Exception ex) { txt_basic_pay.Text = "0.00"; } } calculate_gross(); calculate_net(); } catch { } }