public List <tbl_DeptLeaveRequest> GetBalanceForSingleEmp(string employeeid, string leaveid) { try { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> listObj = new List <tbl_DeptLeaveRequest>(); DataSet dt = obj.GetBalanceByEmpIdDept(ConstantStoredProcedure.SP_BCLDB_sp_GetLeaveBalance, employeeid, leaveid); DataTable Dt1 = dt.Tables[0]; if (Dt1.Rows.Count > 0) { int balanceLeave = Convert.ToInt32(Dt1.Rows[0][0]); foreach (var item in Dt1.Rows) { var getBalance = new tbl_DeptLeaveRequest(); getBalance.BalanceLeave = balanceLeave; listObj.Add(getBalance); } } return(listObj); } catch (Exception ex) { throw ex; } }