// GET: /Interface/InterfaceTransferPricingIndex public ActionResult InterfaceTransferPricingIndex() { InterfaceTransferPricingViewModel itpVM = new InterfaceTransferPricingViewModel(); return View(itpVM); }
public ActionResult ArquivoInterfaceTransferPricing(string DT_INI, string DT_FIM) { InterfaceTransferPricingViewModel itpVM = new InterfaceTransferPricingViewModel(); try { string xmlStream; List<TransferPricing> tp = _produtoAppService.InterfaceTransferPricing(Convert.ToDateTime(DT_INI), Convert.ToDateTime(DT_FIM)).ToList(); StringWriter sw = new StringWriter(); sw.WriteLine("\"COD_PRODUTO\";\"NEGOCIO\";\"MES\";\"VLR_DOLAR\";\"VLR_REAL\";\"COD_EMPRESA\""); foreach (var line in tp) { sw.WriteLine(string.Format("\"{0}\";\"{1}\";\"{2}\";\"{3}\";\"{4}\";\"{5}\"", line.COD_PRODUTO, line.NEGOCIO, line.MES.ToString("dd/MM/yy"), line.VLR_DOLAR, line.VLR_REAL, line.COD_EMPRESA)); } xmlStream = sw.ToString(); return new ExcelResult { FileName = string.Format("InterfaceTransferPricing-{0}.csv", DateTime.Now.ToString("yyyyMMdd-HHmmss")), XMLStream = xmlStream }; } catch (RetryLimitExceededException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. ModelState.AddModelError("", "Erro ao gerar arquivo. Tente novamente ou, se o problema persistir, entre em contato com o suporte."); } return View(itpVM); }