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