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