protected void btnShow_Click(object sender, EventArgs e) { using (ClubDBEntities club = new ClubDBEntities()) { date = Convert.ToDateTime(tbDate.Text, cul); depID = Convert.ToInt32(ddlDep.SelectedValue); if (ddlDep.SelectedIndex == 0) { // var result = club.getMovReport(date); var result = club.getMovReportWithCash(date); gvIncome.DataSource = result; sum = result.Sum(o => Convert.ToDecimal(o.Paid)); } else { var result = club.getMovReport(date, depID); gvIncome.DataSource = result; sum = result.Sum(o => Convert.ToDecimal(o.Paid)); } gvIncome.DataBind(); pnlData.Visible = true; } }