public double GetTotalByMonthAndYear(int month, int year)
{
double total = 0;
string SQL = "SELECT ID FROM Invoices WHERE MONTH(Date_Of_Purcharse) = @Month AND YEAR(Date_Of_Purcharse) = @Year";
SqlConnection cnn = DBUtils.GetConnection();
SqlCommand cmd = new SqlCommand(SQL, cnn);
cmd.Parameters.AddWithValue("@Month", month);
cmd.Parameters.AddWithValue("@Year", year);
try
{
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CustomerDAO cusDAO = new CustomerDAO();
InvoiceDetailsDAO invoiceDetailsDAO = new InvoiceDetailsDAO();
if (rd.HasRows)
{
while (rd.Read())
{
InvoiceDTO invoiceDTO = new InvoiceDTO
{
ID = rd.GetInt32(0)
};
total += invoiceDetailsDAO.GetTotalPriceOfInvoice(invoiceDTO.ID);
}
}
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(total);
}