public List<EmployeeReport> EmployeeTransactionReportBydateForMonth(DateTime fromDate, DateTime toDate) { List<EmployeeReport> aTransactions = new List<EmployeeReport>(); try { this.OpenConnection(); string sqlComm = string.Format(SqlQueries.GetQuery(Query.EmployeeTransactionReportBydate), fromDate, toDate); IDataReader aReader = this.ExecuteReader(sqlComm); if (aReader != null) { while (aReader.Read()) { EmployeeReport aTransaction = new EmployeeReport(); aTransaction = ReadToTransactionforMonth(aReader); aTransactions.Add(aTransaction); } } } catch (Exception) { } return aTransactions; }
private EmployeeReport ReadToTransactionforMonth(IDataReader aReader) { EmployeeReport aTransaction = new EmployeeReport(); try { aTransaction.SalaryDate= Convert.ToDateTime(aReader["date"]); } catch (Exception) { } try { aTransaction.SalaryAmount = Convert.ToDouble(aReader["amount"]); } catch (Exception) { } try { aTransaction.EmployeeName = (aReader["employee_name"]).ToString(); } catch (Exception) { } return aTransaction; }