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;
}
}