private DataSet LeaveReport(int EmployeeId) { DataSet ds = new DataSet(); ds.DataSetName = "DataSourceForReport"; DataTable dt = new DataTable("EmployeeLeave"); dt.TableName = "EmployeeLeave"; dt.Columns.Add(new DataColumn("EmployeeId", typeof(string))); dt.Columns.Add(new DataColumn("EmployeeFullNName", typeof(string))); dt.Columns.Add(new DataColumn("LeaveFromDate", typeof(DateTime))); dt.Columns.Add(new DataColumn("LeaveToDate", typeof(DateTime))); dt.Columns.Add(new DataColumn("LeaveType", typeof(string))); dt.Columns.Add(new DataColumn("BalanceLeaves", typeof(decimal))); dt.Columns.Add(new DataColumn("LeavesInDays", typeof(decimal))); dt.Columns.Add(new DataColumn("Reason", typeof(string))); dt.Columns.Add(new DataColumn("TransactionType", typeof(string))); EmployeeBAL balObject = new EmployeeBAL(); IQueryable <Entities.EmployeeLeaveTransaction> entites = balObject.GetAllEmployeeLeaves(SessionHelper.SchoolId).Where(c => c.EmployeeId == EmployeeId); if (entites != null && entites.Count() > 0) { foreach (Entities.EmployeeLeaveTransaction entity in entites) { //Entities.EmployeeLeaveTransaction entity = entites.FirstOrDefault(); DataRow dr = dt.NewRow(); dr["EmployeeId"] = entity.EmployeeId; dr["EmployeeFullNName"] = entity.EmployeeFullName; dr["LeaveFromDate"] = entity.LeaveFromDate; dr["LeaveToDate"] = entity.LeaveToDate; string strLeaveType = ""; if (entity.LeaveType == 1) { strLeaveType = "Annual Leave"; } else if (entity.LeaveType == 2) { strLeaveType = "Sick Leave"; } dr["LeaveType"] = strLeaveType; dr["LeavesInDays"] = entity.LeavesInDays; dr["BalanceLeaves"] = entity.BalanceLeaves; dr["Reason"] = entity.Remark; if (entity.TransactionType == 1) { dr["TransactionType"] = "Cr"; } else { dr["TransactionType"] = "Dr"; } reportName = entity.EmployeeId + "_" + entity.EmployeeFullName.Trim(); dt.Rows.Add(dr); } } ds.Tables.Add(getSchoolDetails()); ds.Tables.Add(dt); return(ds); }