public void IEReport(cIncomeExpensesReport report) { IEReportYear = report.year; IEReportMonth = report.month; IEReportIncomeTotal = report.incomeTotal; IEReportExpensesTotal = report.expensesTotal; }
public void GetParticularIncomePaymentRecode(cIncomeExpensesReport Report) { Dt.Clear(); SqlCommand cmd = new SqlCommand("SELECT * FROM incomePayment WHERE YEAR (incomeDate) = @Year and MONTH (incomeDate) = @Month", con); // cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Year", Report.year); cmd.Parameters.AddWithValue("@Month", Report.month); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); Dt.Load(sdr); con.Close(); // Ex.ExpensesDataGrid.DataSource = Dt; }