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