private void cbo_branch_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbo_branch.SelectedValue.ToString() != "-1" && cbo_branch.SelectedValue.ToString() != string.Empty)
{
txt_personal_number.Text = StaffProfiles.AccountsCode("select_staff_branch_code", cbo_branch.SelectedValue.ToString()) + "-";
}
}
protected void LoadAdvances()
{
DataTable dt = StaffProfiles.Return_advance_list("select_advance_list", StaffProfiles.staff_id);
if (dt != null)
{
gdvAdvanceList.DataSource = dt;
gdvAdvanceList.Columns["st_id"].Visible = false;
gdvAdvanceList.Columns["ad_id"].Visible = false;
gdvAdvanceList.Columns["st_name"].HeaderText = "Name";
gdvAdvanceList.Columns["ad_date"].HeaderText = "Advance Date";
gdvAdvanceList.Columns["ad_amount"].HeaderText = "Advance Amount";
gdvAdvanceList.Columns["ad_paid_amount"].HeaderText = "Paid Amount";
gdvAdvanceList.Columns["ad_balance_amount"].HeaderText = "Outstanding Amount";
gdvAdvanceList.Columns["ad_fully_paid"].HeaderText = "Advance fully paid";
gdvAdvanceList.DefaultCellStyle.SelectionBackColor = Color.White;
gdvAdvanceList.DefaultCellStyle.SelectionForeColor = Color.Black;
gdvAdvanceList.RowsDefaultCellStyle.BackColor = Color.LightGray;
gdvAdvanceList.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
gdvAdvanceList.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
gdvAdvanceList.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
gdvAdvanceList.RowHeadersDefaultCellStyle.BackColor = Color.Black;
gdvAdvanceList.DefaultCellStyle.SelectionBackColor = Color.White;
gdvAdvanceList.DefaultCellStyle.SelectionForeColor = Color.Black;
}
}
protected void save_staff_payroll()
{
if (txt_record_guid.Text == string.Empty)
{
StaffProfiles.save_staff_payroll("save_staff_payroll", staff_id, SystemConst._username, Convert.ToInt32(cbo_deploy_period.SelectedValue.ToString()), cbo_payment_month.Text, txt_basic_amt.Text != string.Empty ? decimal.Parse(txt_basic_amt.Text) : 0, txt_transport_amt.Text != string.Empty ? decimal.Parse(txt_transport_amt.Text) : 0, txt_housing_amt.Text != string.Empty ? decimal.Parse(txt_housing_amt.Text) : 0, txt_leave_amt.Text != string.Empty ? decimal.Parse(txt_leave_amt.Text) : 0, txt_over_time_amt.Text != string.Empty ? decimal.Parse(txt_over_time_amt.Text) : 0, txt_special_amt.Text != string.Empty ? decimal.Parse(txt_special_amt.Text) : 0
, txt_lst_amt.Text != string.Empty ? decimal.Parse(txt_lst_amt.Text) : 0, txt_loan_amt.Text != string.Empty ? decimal.Parse(txt_loan_amt.Text) : 0, txt_advance_amt_paid.Text != string.Empty ? decimal.Parse(txt_advance_amt_paid.Text) : 0, txt_nssf_amt.Text != string.Empty ? decimal.Parse(txt_nssf_amt.Text) : 0, txt_paye_amt.Text != string.Empty ? decimal.Parse(txt_paye_amt.Text) : 0, txt_gross_amt.Text != string.Empty ? decimal.Parse(txt_gross_amt.Text) : 0, txt_total_deductions.Text != string.Empty ? decimal.Parse(txt_total_deductions.Text) : 0, txt_net_pay.Text != string.Empty ? decimal.Parse(txt_net_pay.Text) : 0, chk_pay_salary.Checked == true ? true : false, chk_pay_paye.Checked == true ? true : false
, chk_pay_nssf.Checked == true ? true : false, chk_pay_advance.Checked == true ? true : false, chk_print_bank_schedule.Checked == true ? true : false, chk_print_payroll.Checked == true ? true : false, txt_ovt_days.Text);
//update advance payment
if (txt_advance_amt_paid.Text != "0" && txt_advance_amt_paid.Text != string.Empty)
{
UpdateEmployeeAdvanceDetails(txt_record_guid.Text);
}
string message = "Payroll for " + txt_staff_name.Text + " saved successfully";
MessageBox.Show(message, "Staff Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
StaffProfiles.update_staff_payroll("update_staff_payroll", txt_record_guid.Text, SystemConst._username, Convert.ToInt32(cbo_deploy_period.SelectedValue.ToString()), cbo_payment_month.Text, txt_basic_amt.Text != string.Empty ? decimal.Parse(txt_basic_amt.Text) : 0, txt_transport_amt.Text != string.Empty ? decimal.Parse(txt_transport_amt.Text) : 0, txt_housing_amt.Text != string.Empty ? decimal.Parse(txt_housing_amt.Text) : 0, txt_leave_amt.Text != string.Empty ? decimal.Parse(txt_leave_amt.Text) : 0, txt_over_time_amt.Text != string.Empty ? decimal.Parse(txt_over_time_amt.Text) : 0, txt_special_amt.Text != string.Empty ? decimal.Parse(txt_special_amt.Text) : 0
, txt_lst_amt.Text != string.Empty ? decimal.Parse(txt_lst_amt.Text) : 0, txt_loan_amt.Text != string.Empty ? decimal.Parse(txt_loan_amt.Text) : 0, txt_advance_amt_paid.Text != string.Empty ? decimal.Parse(txt_advance_amt_paid.Text) : 0, txt_nssf_amt.Text != string.Empty ? decimal.Parse(txt_nssf_amt.Text) : 0, txt_paye_amt.Text != string.Empty ? decimal.Parse(txt_paye_amt.Text) : 0, txt_gross_amt.Text != string.Empty ? decimal.Parse(txt_gross_amt.Text) : 0, txt_total_deductions.Text != string.Empty ? decimal.Parse(txt_total_deductions.Text) : 0, txt_net_pay.Text != string.Empty ? decimal.Parse(txt_net_pay.Text) : 0, chk_pay_salary.Checked == true ? true : false, chk_pay_paye.Checked == true ? true : false
, chk_pay_nssf.Checked == true ? true : false, chk_pay_advance.Checked == true ? true : false, chk_print_bank_schedule.Checked == true ? true : false, chk_print_payroll.Checked == true ? true : false, txt_ovt_days.Text);
//update advance payment
if (txt_advance_amt_paid.Text != "0")
{
UpdateEmployeeAdvanceDetails(txt_record_guid.Text);
}
string message = "Payroll for " + txt_staff_name.Text + " updated successfully";
MessageBox.Show(message, "Staff Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected void UpdateEmployeeAdvanceDetails(string record_guid)
{
if (record_guid == string.Empty)
{
decimal advance_principle = decimal.Parse(txt_advace_amt_principle.Text);
decimal advance_current_balance = decimal.Parse(txt_advance_amt.Text);
decimal advance_amount_paid = txt_advance_amt_paid.Text != string.Empty? decimal.Parse(txt_advance_amt_paid.Text):0;
advance_amount_paid = advance_amount_paid + decimal.Parse(txt_advance_paid.Text);
decimal new_advance_balance = advance_principle - advance_amount_paid;
StaffProfiles.update_staff_advance_payment("update_staff_advance_payment", staff_id, lblloanid.Text, advance_amount_paid, new_advance_balance);
}
else
{
//MessageBox.Show(advance_paid_amt_to_be_updated.ToString());
decimal advance_principle = decimal.Parse(txt_advace_amt_principle.Text);
decimal _balance = decimal.Parse(txt_advance_amt.Text) + advance_paid_amt_to_be_updated;
decimal amount_paid = decimal.Parse(txt_advance_amt_paid.Text);
decimal new_advance_balance = _balance - amount_paid;
decimal prev_total_advance_amt_paid = decimal.Parse(txt_advance_paid.Text) - advance_paid_amt_to_be_updated;
decimal current_total_advance_amt_paid = prev_total_advance_amt_paid + decimal.Parse(txt_advance_amt_paid.Text);
StaffProfiles.update_staff_advance_payment("update_staff_advance_payment", staff_id, lblloanid.Text, current_total_advance_amt_paid, new_advance_balance);
}
}
private void gdv_staff_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (gdv_staff.Rows.Count > 0)
{
string st_id = gdv_staff.CurrentRow.Cells[0].Value.ToString();
staff_id = st_id;
select_staff_payroll(st_id, Convert.ToInt32(cbo_deploy_period_search.SelectedValue.ToString()), cbo_payment_month_search.Text);
ResetLoanDetails();
lblTotalLoansBalance.Text = StaffProfiles.select_staff_loan_balance("select_staff_loan_balance", st_id);
// select_staff_advance(st_id);
}
}
protected void LoadPaymentPeriods()
{
DataTable dt = StaffProfiles.Return_staff_list("select_accounts_payment_periods");
if (dt.Rows.Count > 0)
{
DataRow dtRow = dt.NewRow();
dtRow["payment_period_id"] = -1;
dtRow["pay_year"] = "select year";
dt.Rows.InsertAt(dtRow, 0);
this.cbo_deploy_period.DisplayMember = "pay_year";
this.cbo_deploy_period.ValueMember = "payment_period_id";
this.cbo_deploy_period.DataSource = dt;
//this.cbo_deploy_period.Enabled = false;
}
}
protected void select_staff_list_payroll_search()
{
DataTable dt = StaffProfiles.select_staff_list_payroll_search("select_staff_list_payroll_search");
if (dt.Rows.Count > 0)
{
DataRow dtRow = dt.NewRow();
dtRow["st_id"] = "-1";
dtRow["st_name"] = "select Employee";
dt.Rows.InsertAt(dtRow, 0);
cbo_staff.DisplayMember = "st_name";
cbo_staff.ValueMember = "st_id";
cbo_staff.DataSource = dt;
this.cbo_staff.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.cbo_staff.AutoCompleteSource = AutoCompleteSource.ListItems;
}
}
protected void select_staff_advance(string st_id)
{
DataTable dt = StaffProfiles.Return_staff_advance("select_staff_advance_details", st_id);
if (dt.Rows.Count > 0)
{
DataRow dtrow = dt.Rows[0];
txt_advance_amt.Text = decimal.Parse(dtrow["ad_balance_amount"].ToString()).ToString();
txt_advace_amt_principle.Text = decimal.Parse(dtrow["ad_amount"].ToString()).ToString();
txt_advance_paid.Text = decimal.Parse(dtrow["ad_paid_amount"].ToString()).ToString();
}
else
{
txt_advance_amt.Text = "0";
txt_advace_amt_principle.Text = "0";
txt_advance_paid.Text = "0";
}
}
protected void Get_staff_profiles()
{
DataTable dt = StaffProfiles.Return_staff_list("select_staff_list");
if (dt != null)
{
gdv_staff.DataSource = dt;
gdv_staff.Columns["st_id"].Visible = false;
gdv_staff.Columns["branch_id"].Visible = false;
gdv_staff.Columns["st_position"].Visible = false;
gdv_staff.Columns["bank_id"].Visible = false;
gdv_staff.Columns["bank_branch_id"].Visible = false;
gdv_staff.Columns["st_name"].HeaderText = "Name";
gdv_staff.Columns["st_number"].HeaderText = "Personal Number";
gdv_staff.Columns["st_gender"].HeaderText = "Sex";
gdv_staff.Columns["st_status"].HeaderText = "Employee Status";
gdv_staff.Columns["nss_number"].HeaderText = "NSSF Number";
gdv_staff.Columns["bank_acc_number"].HeaderText = "Bank Account Number";
gdv_staff.Columns["tin_number"].HeaderText = "Tin Number";
gdv_staff.Columns["basic_amt"].HeaderText = "Basic Amount";
gdv_staff.Columns["transport_amt"].HeaderText = "Transport Amount";
gdv_staff.Columns["housing_amt"].HeaderText = "Housing Amount";
this.gdv_staff.DefaultCellStyle.SelectionBackColor = Color.White;
this.gdv_staff.DefaultCellStyle.SelectionForeColor = Color.Black;
this.gdv_staff.RowsDefaultCellStyle.BackColor = Color.LightGray;
this.gdv_staff.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.gdv_staff.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
this.gdv_staff.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_staff.RowHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_staff.DefaultCellStyle.SelectionBackColor = Color.White;
this.gdv_staff.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in this.gdv_staff.Columns)
{
c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 13f, GraphicsUnit.Pixel);
}
this.gdv_staff.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
this.gdv_staff.EnableHeadersVisualStyles = false;
}
}
private void btn_search_Click(object sender, EventArgs e)
{
if (cbo_staff.SelectedValue.ToString() == "-1")
{
Get_staff_profiles();
}
else
{
DataTable dt = StaffProfiles.select_staff_list_search("select_staff_list_search", cbo_staff.SelectedValue.ToString());
if (dt != null)
{
gdv_staff.DataSource = dt;
gdv_staff.Columns["st_id"].Visible = false;
gdv_staff.Columns["branch_id"].Visible = false;
gdv_staff.Columns["st_position"].Visible = false;
gdv_staff.Columns["bank_id"].Visible = false;
gdv_staff.Columns["bank_branch_id"].Visible = false;
gdv_staff.Columns["st_name"].HeaderText = "Name";
gdv_staff.Columns["st_number"].HeaderText = "Personal Number";
gdv_staff.Columns["st_gender"].HeaderText = "Sex";
gdv_staff.Columns["st_status"].HeaderText = "Employee Status";
gdv_staff.Columns["nss_number"].HeaderText = "NSSF Number";
gdv_staff.Columns["bank_acc_number"].HeaderText = "Bank Account Number";
gdv_staff.Columns["tin_number"].HeaderText = "Tin Number";
gdv_staff.DefaultCellStyle.SelectionBackColor = Color.White;
gdv_staff.DefaultCellStyle.SelectionForeColor = Color.Black;
gdv_staff.RowsDefaultCellStyle.BackColor = Color.LightGray;
gdv_staff.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
gdv_staff.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
gdv_staff.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
gdv_staff.RowHeadersDefaultCellStyle.BackColor = Color.Black;
gdv_staff.DefaultCellStyle.SelectionBackColor = Color.White;
gdv_staff.DefaultCellStyle.SelectionForeColor = Color.Black;
}
}
}
protected void SavePayroll()
{
if (cbo_deploy_period.SelectedValue.ToString() == "-1" || cbo_payment_month.Text == string.Empty)
{
MessageBox.Show("Payment Year and Month cannot be empty", "Staff Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (txt_bank_code.Text == string.Empty || txt_bank_name.Text == string.Empty || txt_account_number.Text == string.Empty || txt_nssf.Text == string.Empty)
{
MessageBox.Show("Please select a staff member to save payroll", "Staff Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (txt_record_guid.Text == string.Empty && StaffProfiles.Validate_payroll("validate_payroll", staff_id, Convert.ToInt32(cbo_deploy_period.SelectedValue.ToString()), cbo_payment_month.Text) > 0)
{
MessageBox.Show("There is already payroll saved for " + txt_staff_name.Text + " for this period", "Staff Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if ((txt_gross_amt.Text == string.Empty || txt_gross_amt.Text == "0") && (txt_net_pay.Text == string.Empty || txt_net_pay.Text == "0"))
{
MessageBox.Show("Gross Pay and Net Pay cannot be empty", "Staff Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
save_staff_payroll();
}
}
protected void save()
{
if (txtamount.Text != string.Empty)
{
if (decimal.Parse(txtamount.Text) < 1)
{
MessageBox.Show("Advance Amount cannot be zero or blank!", "save", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
if (StaffProfiles.check_if_staff_has_advance("check_if_staff_has_advance", lblstaffid.Text) > 0)
{
System.Windows.Forms.DialogResult dialogResult = MessageBox.Show("There is already an outstanding advance for " + txt_staff_name.Text + ".Are you sure you want to add another advance to this staff member", "Staff Advance", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
StaffProfiles.save_staff_advance("save_staff_advance", lblstaffid.Text, dtAdvanceDate.Value.Date, Convert.ToDecimal(txtamount.Text), Convert.ToDecimal(txtamountPaid.Text), Convert.ToDecimal(txtAmountBalance.Text), txtAmountBalance.Text == "0" ? true : false);
MessageBox.Show("Success!", "save", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadAdvances();
}
if (dialogResult == System.Windows.Forms.DialogResult.No)
{
base.Visible = true;
}
}
else
{
StaffProfiles.save_staff_advance("save_staff_advance", lblstaffid.Text, dtAdvanceDate.Value.Date, Convert.ToDecimal(txtamount.Text), Convert.ToDecimal(txtamountPaid.Text), Convert.ToDecimal(txtAmountBalance.Text), txtAmountBalance.Text == "0" ? true : false);
MessageBox.Show("Success!", "save", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadAdvances();
}
}
}
else if (txtamount.Text == string.Empty)
{
MessageBox.Show("Advance Amount cannot be zero or blank!", "save", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
protected void save()
{
if (ValidateInput())
{
if (lblstaffid.Text == ".")
{
StaffProfiles.save_staff_details("save_staff_details", string.Empty, txt_personal_number.Text, cbo_branch.SelectedValue.ToString(), txt_staff_name.Text, cbo_sex.Text, cbo_status.Text, cbo_position.Text, txt_nssf.Text, txt_acc_number.Text, cbo_bank.SelectedValue.ToString(),
cbo_bank_branch.SelectedValue.ToString() != "-1" ? cbo_bank_branch.SelectedValue.ToString() : cbo_bank_branch.SelectedValue.ToString(), txt_tin_number.Text, SystemConst._username, Convert.ToDecimal(txtbasicAmt.Text), Convert.ToDecimal(txtTransportAmt.Text), Convert.ToDecimal(txtHousingAmt.Text));
MessageBox.Show("Success!", "save", MessageBoxButtons.OK, MessageBoxIcon.Information);
Get_staff_profiles();
}
else
{
StaffProfiles.save_staff_details("update_staff_details", lblstaffid.Text, txt_personal_number.Text, cbo_branch.SelectedValue.ToString(), txt_staff_name.Text, cbo_sex.Text, cbo_status.Text, cbo_position.Text, txt_nssf.Text, txt_acc_number.Text, cbo_bank.SelectedValue.ToString(),
cbo_bank_branch.SelectedValue.ToString() != "-1" ? cbo_bank_branch.SelectedValue.ToString() : cbo_bank_branch.SelectedValue.ToString(), txt_tin_number.Text, SystemConst._username, Convert.ToDecimal(txtbasicAmt.Text), Convert.ToDecimal(txtTransportAmt.Text), Convert.ToDecimal(txtHousingAmt.Text));
MessageBox.Show("Success!", "update", MessageBoxButtons.OK, MessageBoxIcon.Information);
Get_staff_profiles();
}
}
else
{
MessageBox.Show("Please fill in all required values", "MESSAGE", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
protected void select_staff_payroll(string st_id, int payment_period_id, string pay_month)
{
DataTable dt = StaffProfiles.Return_staff_payroll("select_staff_payroll_details", st_id, payment_period_id, pay_month);
if (dt.Rows.Count > 0)
{
DataRow dtrow = dt.Rows[0];
txt_record_guid.Text = dtrow["record_guid"].ToString();
txt_personal_number.Text = dtrow["st_number"].ToString();
txt_staff_name.Text = dtrow["st_name"].ToString();
txt_bank_code.Text = dtrow["bank_code"].ToString();
txt_bank_name.Text = dtrow["bank_name"].ToString();
txt_bank_branch.Text = dtrow["branch_name"].ToString();
txt_account_number.Text = dtrow["bank_acc_number"].ToString();
txt_nssf.Text = dtrow["nss_number"].ToString();
string payment_month = dtrow["payment_month"].ToString();
if (payment_month != string.Empty)
{
cbo_deploy_period.SelectedValue = Convert.ToInt32(dtrow["payment_period_id"]).ToString();
cbo_payment_month.Text = dtrow["payment_month"].ToString();
txt_basic_amt.Text = decimal.Parse(dtrow["basic_amt"].ToString()).ToString();
txt_transport_amt.Text = decimal.Parse(dtrow["transport_amt"].ToString()).ToString();
txt_housing_amt.Text = decimal.Parse(dtrow["HousingAmt"].ToString()).ToString();
txt_over_time_amt.Text = decimal.Parse(dtrow["overtime_amt"].ToString()).ToString();
txt_special_amt.Text = decimal.Parse(dtrow["special_amt"].ToString()).ToString();
txt_leave_amt.Text = decimal.Parse(dtrow["leave_amt"].ToString()).ToString();
txt_lst_amt.Text = decimal.Parse(dtrow["local_service_tax_amt"].ToString()).ToString();
txt_loan_amt.Text = decimal.Parse(dtrow["loan_amt"].ToString()).ToString();
txt_advance_amt_paid.Text = decimal.Parse(dtrow["advance_amt"].ToString()).ToString();
advance_paid_amt_to_be_updated = decimal.Parse(dtrow["advance_amt"].ToString());
txt_gross_amt.Text = decimal.Parse(dtrow["gross_pay_amt"].ToString()).ToString();
txt_paye_amt.Text = decimal.Parse(dtrow["total_paye_amt"].ToString()).ToString();
txt_nssf_amt.Text = decimal.Parse(dtrow["total_nssf_amt"].ToString()).ToString();
txt_total_deductions.Text = decimal.Parse(dtrow["total_deductions"].ToString()).ToString();
txt_net_pay.Text = decimal.Parse(dtrow["staff_net_pay_amt"].ToString()).ToString();
chk_pay_paye.Checked = Convert.ToBoolean(dtrow["pay_paye"]);
chk_pay_nssf.Checked = Convert.ToBoolean(dtrow["pay_nssf"]);
chk_pay_advance.Checked = Convert.ToBoolean(dtrow["pay_advance"]);
chk_print_bank_schedule.Checked = Convert.ToBoolean(dtrow["print_bank_schedule"]);
chk_print_payroll.Checked = Convert.ToBoolean(dtrow["print_pay_roll"]);
txt_ovt_days.Text = dtrow["over_time_days"].ToString();
}
else
{
cbo_deploy_period.SelectedValue = -1;
cbo_payment_month.Text = string.Empty;
txt_basic_amt.Clear();
txt_transport_amt.Clear();
txt_housing_amt.Clear();
txt_over_time_amt.Clear();
txt_special_amt.Clear();
txt_leave_amt.Clear();
txt_lst_amt.Clear();
txt_loan_amt.Clear();
txt_advance_amt_paid.Clear();
txt_gross_amt.Clear();
txt_paye_amt.Clear();
txt_nssf_amt.Clear();
txt_total_deductions.Clear();
txt_net_pay.Clear();
chk_pay_paye.Checked = false;
chk_pay_nssf.Checked = false;
chk_pay_advance.Checked = false;
chk_print_bank_schedule.Checked = true;
chk_print_payroll.Checked = true;
txt_ovt_days.Clear();
}
}
else
{
DataTable _dt = StaffProfiles.select_staff_details_payroll_setup("select_staff_details_payroll_setup", st_id);
if (_dt.Rows.Count > 0)
{
DataRow _dtRow = _dt.Rows[0];
txt_personal_number.Text = _dtRow["st_number"].ToString();
txt_staff_name.Text = _dtRow["st_name"].ToString();
txt_bank_code.Text = _dtRow["bank_code"].ToString();
txt_bank_name.Text = _dtRow["bank_name"].ToString();
txt_bank_branch.Text = _dtRow["branch_name"].ToString();
txt_account_number.Text = _dtRow["bank_acc_number"].ToString();
txt_nssf.Text = _dtRow["nss_number"].ToString();
// MessageBox.Show(_dtRow["basicAmt"].ToString());
txt_basic_amt.Text = decimal.Parse(_dtRow["basicAmt"].ToString()).ToString();
txt_transport_amt.Text = decimal.Parse(_dtRow["TransportAmt"].ToString()).ToString();
txt_housing_amt.Text = decimal.Parse(_dtRow["HousingAmt"].ToString()).ToString();
}
txt_record_guid.Clear();
cbo_deploy_period.SelectedValue = -1;
cbo_payment_month.Text = string.Empty;
//txt_basic_amt.Clear();
//txt_transport_amt.Clear();
//txt_housing_amt.Clear();
txt_over_time_amt.Clear();
txt_special_amt.Clear();
txt_leave_amt.Clear();
txt_lst_amt.Clear();
txt_loan_amt.Clear();
txt_advance_amt_paid.Clear();
txt_gross_amt.Clear();
txt_paye_amt.Clear();
txt_nssf_amt.Clear();
txt_total_deductions.Clear();
txt_net_pay.Clear();
chk_pay_paye.Checked = false;
chk_pay_nssf.Checked = false;
chk_pay_advance.Checked = false;
chk_print_bank_schedule.Checked = true;
chk_print_payroll.Checked = true;
txt_ovt_days.Clear();
}
}
