public List <tbl_DeptLeaveRequest> GetLeaveDetailsForChange(int objLeaverequestId) { try { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> objList = new List <tbl_DeptLeaveRequest>(); DataSet ds = obj.GetEmpDetails(ConstantStoredProcedure.SP_BCL_GETLEAVEFORCHNAGE_DEPT, objLeaverequestId); DataTable dt = ds.Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var objtblLeaveRequest = new tbl_DeptLeaveRequest(); objtblLeaveRequest.LeaveRequestId = Convert.ToString(dt.Rows[i]["LEAVEREQUESTID"]); objtblLeaveRequest.LeaveId = Convert.ToInt32(dt.Rows[i]["LEAVEID"]); objtblLeaveRequest.LeaveCategory = Convert.ToString(dt.Rows[i]["LEAVECATEGORY"]); objtblLeaveRequest.FromDate = Convert.ToDateTime(dt.Rows[i]["FROMDATE"]).ToString("dd/MM/yyyy"); objtblLeaveRequest.ToDate = Convert.ToDateTime(dt.Rows[i]["TODATE"]).ToString("dd/MM/yyyy"); objtblLeaveRequest.LeaveShift = Convert.ToString(dt.Rows[i]["LEAVESHIFT"]); objtblLeaveRequest.ApproverId = Convert.ToString(dt.Rows[i]["APPROVERID"]); objtblLeaveRequest.ApproverName = Convert.ToString(dt.Rows[i]["APPROVERNAME"]); objtblLeaveRequest.AbsenceCEHour = Convert.ToDouble(dt.Rows[i]["ABSENCEHOUR"]); objtblLeaveRequest.Remarks = Convert.ToString(dt.Rows[i]["REMARKS"]); objtblLeaveRequest.EmployeeID = Convert.ToString(dt.Rows[i]["EMPLOYEEID"]); objtblLeaveRequest.PA = Convert.ToString(dt.Rows[i]["PA"]); objtblLeaveRequest.PSA = Convert.ToString(dt.Rows[i]["PSA"]); objtblLeaveRequest.EmployeeName = Convert.ToString(dt.Rows[i]["EMPLOYEENAME"]); objList.Add(objtblLeaveRequest); } } } return(objList); } catch (Exception ex) { throw ex; } }