public void Search() { if (!Roles.IsStandard(Presenter.GetStateManager().UserSession.SessionEntity.Roles)) { Form.Log(Messages.NotAuthorizedMsg); return; } var isRevised = Form.IsTransactionRevised; var startDate = Form.TransactionStartDate; var endDate = Form.TransactionEndtDate; var transactionType = Form.SelectedTransactionType; var transactions = SaleTransactionDbService.FindByDateTypeAndRevisionStatus(startDate, endDate, transactionType, isRevised); GridViewManager.ClearRows(); transactions.ForEach(GridViewManager.InsertTransaction); var totalSum = transactions.Sum(tr => tr.RevenueAmount); Form.Log($"Показани са {transactions.Count} транзакции. Обща сума: {totalSum:F2}."); }
//DISPLAY MANAGER TABLE public void ShowManager() { sqlstring = "select * from Managers"; try { conn.Open(); cmd = new SqlCommand(sqlstring, conn); rdr = cmd.ExecuteReader(); GridViewManager.DataSource = rdr; GridViewManager.DataBind(); } catch (Exception ex) { LabelMess.Text = ex.Message; } finally { conn.Close(); } }