//For Report public List <tbl_LeaveHistory> GetEmployeeReport(string empid, string fromdate, string todate) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveHistory> objList = new List <tbl_LeaveHistory>(); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > lstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(lstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 20, empid.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(lstTupParameters, ConstantsVariables.P_FROMDATE, OracleDbType.NVarchar2, 20, fromdate.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(lstTupParameters, ConstantsVariables.P_TODATE, OracleDbType.NVarchar2, 20, todate.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(lstTupParameters, "P_LeaveHistory", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); DataSet ds = obj.GetEmployeeReport(ConstantStoredProcedure.SP_BCL_EMPLOYEEREPORT, lstTupParameters); DataTable dt = ds.Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var objTblLeaveHistory = new tbl_LeaveHistory(); objTblLeaveHistory.LeaveCategory = Convert.ToString(dt.Rows[i]["LEAVECATEGORY"]); objTblLeaveHistory.LeaveAppliedDate = Convert.ToDateTime(dt.Rows[i]["LEAVEAPPLIEDDATE"]).ToString("dd/MM/yyyy"); objTblLeaveHistory.FromDate = Convert.ToDateTime(dt.Rows[i]["FROMDATE"]).ToString("dd/MM/yyyy"); objTblLeaveHistory.ToDate = Convert.ToDateTime(dt.Rows[i]["TODATE"]).ToString("dd/MM/yyyy"); objTblLeaveHistory.TotalLeaves = Convert.ToDouble(dt.Rows[i]["TOTALAPPLIEDLEAVE"]); objTblLeaveHistory.ApproverName = Convert.ToString(dt.Rows[i]["APPROVERNAME"]); objTblLeaveHistory.Status = Convert.ToString(dt.Rows[i]["STATUS"]); objTblLeaveHistory.LeaveType = Convert.ToString(dt.Rows[i]["LEAVESHIFT"]); objTblLeaveHistory.Indicator = dt.Rows[i]["SAPSUCCESSFLAG"].ToString(); objTblLeaveHistory.ErrorMsg = dt.Rows[i]["ERRORMSG"].ToString(); objList.Add(objTblLeaveHistory); } } } return(objList); } catch (Exception ex) { throw ex; } }