Sqlstr = "select sum(sal_det_amt) as unpaidleaveamt from salary_details where comp_id = "+strCompanyid+ " and sal_isdeduct = 1 and sal_det_desc LIKE 'Unpaid Leave%' and sal_id IN "+ "(select sal_id from salary_master where comp_id = "+strCompanyid +" and sal_year = " + lngPreviousYear + " and emp_code = '" + Txt_Employee.Text + "')"; strUnpaidLeaveAmt = cfs.get_data(Sqlstr); if(strUnpaidLeaveAmt.Trim() !=string.Empty && cfs.IsNumeric(strUnpaidLeaveAmt)) { dblTempUnpaidLeaveAmt = cfs.IsNumber(strUnpaidLeaveAmt); } if( dblTotalSalary > 0 ) { // TxtAmounts(0).Text = dblTotalSalary - dblTempUnpaidLeaveAmt; } strBonus = string.Empty; strBonusDate = string.Empty;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)