public void Index(int id)
{
var cart = _databaseConnection.Get(id);
var checkout = _apiCaller.GetCheckout(cart.CheckoutId);
switch (checkout.Status)
{
case CheckoutStatus.Created:
case CheckoutStatus.ReadyToPay:
case CheckoutStatus.ProcessingPayment:
cart.Status = CartStatus.Created;
break;
case CheckoutStatus.ReadyToShip:
cart.Status = CartStatus.Paid;
break;
case CheckoutStatus.Shipped:
case CheckoutStatus.PaidToAccount:
cart.Status = CartStatus.Shipped;
break;
case CheckoutStatus.Canceled:
case CheckoutStatus.Expired:
cart.Status = CartStatus.Shipped;
break;
}
_databaseConnection.Save(cart);
}
public PhoneBook GetByName(string name, IDatabaseConnection connection)
{
var phoneBooks = connection.Get <PhoneBook>("SELECT * FROM [PhoneBook] WHERE Name = ?", name);
if (phoneBooks == null || phoneBooks.Count != 1)
{
return(null);
}
return(phoneBooks.FirstOrDefault());
}
public Entry Insert(Entry entry, IDatabaseConnection connection)
{
var phoneBook = connection.Get <PhoneBook>(entry.PhoneBookId);
if (phoneBook == null)
{
throw new Exception("Invalid PhoneBookId");
}
entry.Insert(connection);
return(entry);
}
public ActionResult Index(int id)
{
var cart = _databaseConnection.Get(id);
var checkoutId = cart.CheckoutId;
var paysonCheckout = _apiCaller.GetCheckout(checkoutId);
var model = new ConfirmationViewModel {
ShoppingCart = cart, ConfirmationSnippet = paysonCheckout.Snippet
};
return(View(model));
}
public ActionResult Index(int id)
{
var cart = _databaseConnection.Get(id);
var checkout = _apiCaller.GetCheckout(cart.CheckoutId);
var viewModel = new CheckoutViewModel()
{
ShoppingCart = cart,
CheckoutSnippet = checkout.Snippet,
ColorScheme = checkout.Gui.ColorScheme
};
return(View(viewModel));
}
public async Task <IActionResult> Index(int?ReportList, int?[] DatabaseList, string Filtro)
{
List <DatabaseGDR> databaseReport;
List <DatabaseGDR> databaseList;
List <int> permissionGroups = authentication.GetPermissionGroups(HttpContext.User.Claims);
List <Report> reportList = await reportRepository.GetList(permissionGroups);
ViewBag.ReportList = new SelectList(reportList, "Id", "Name", ReportList);
ViewBag.Filtro = Filtro;
List <ReportResult> reportResult = new List <ReportResult>();
//Somente pesquisa caso seja informado o relatório e um banco
if (ReportList != null)
{
var report = await reportRepository.Get(ReportList);
databaseList = await databaseGDRRepository.GetList(report.Id);
if (DatabaseList.Length > 0)
{
databaseReport = await databaseGDRRepository.GetList(DatabaseList);
}
else
{
databaseReport = databaseList;
}
try
{
ViewBag.DatabaseList = new MultiSelectList(databaseList, "Id", "Name", DatabaseList);
reportResult = await databaseConnection.Get(report, databaseReport, Filtro);
await log.SaveLogApplicationMessage(ControllerName, $"Relatório {report.Name} executado.");
}
catch (Exception error) {
ViewBag.Error = "Erro ao gerar relatório: " + error.ToString();
await log.SaveLogApplicationError(ControllerName, $"Erro ao executar relatório {report.Name}: {error.ToString()}");
}
}
return(View(reportResult.Take(5000)));
}
public User GetUser(Guid userId)
{
return(_databaseConnection.Get <User>(userId.ToString()));
}
public List <Address> GetAddressesForUser(Guid userId)
{
return(_databaseConnection.Get <List <Address> >(userId.ToString()));
}
public List <Entry> GetByPhoneBook(Guid phoneBookId, IDatabaseConnection connection)
{
return(connection.Get <Entry>("SELECT * FROM [Entry] WHERE PhoneBookId = ?", phoneBookId));
}
public List <Entry> Search(string searchText, Guid phoneBookId, IDatabaseConnection connection)
{
var results = connection.Get <Entry>("SELECT * FROM [Entry] WHERE PhoneBookId = ? AND Name LIKE ?", phoneBookId, $"{searchText}%");
return(results);
}
public Entry Get(Guid entryId, IDatabaseConnection connection)
{
return(connection.Get <Entry>(entryId));
}
public List <PhoneBook> GetAll(IDatabaseConnection connection)
{
return(connection.Get <PhoneBook>("SELECT * FROM [PhoneBook]"));
}
public List <PhoneBook> Search(string searchText, IDatabaseConnection connection)
{
var results = connection.Get <PhoneBook>("SELECT * FROM [PhoneBook] WHERE Name LIKE ?", $"{searchText}%");
return(results);
}
public PhoneBook Get(Guid id, IDatabaseConnection connection)
{
return(connection.Get <PhoneBook>(id));
}
