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