public ActionResult Index([Bind("searchValue,searchOld,initDateOld,initDate,finalDateOld,finalDate")] VMSearchpayment payload)
 {
     if (payload.finalDate == null)
     {
         payload.finalDate = DateTime.Now;
     }
     if (payload.initDate == null)
     {
         payload.initDate = DateTime.MinValue;
     }
     try
     {
         if (string.IsNullOrEmpty(payload.searchValue) || string.IsNullOrWhiteSpace(payload.searchValue))
         {
             return(View(_paymentService.GetPaymentsThatAreNotPaidAndNeeded(payload.initDate.Value, payload.finalDate.Value)));
         }
         else
         {
             ViewData["searchOld"]    = payload.searchValue;
             ViewData["finalDateOld"] = payload.finalDate;
             ViewData["initDateOld"]  = payload.initDateOld;
             return(View(_paymentService.GetPaymentsByNameOrRGOrCPF(payload.searchValue, payload.initDate.Value, payload.finalDate.Value)));
         }
     }
     catch (CustomHttpException ex)
     {
         TempData["_mensagem"] = new VMMessages()
         {
             Css  = "alert alert-danger",
             Text = "Um erro insperado ocorreu"
         };
     }
     catch (Exception ex)
     {
         TempData["_mensagem"] = new VMMessages()
         {
             Css  = "alert alert-danger",
             Text = "Um erro insperado ocorreu"
         };
     }
     return(View(_paymentService.GetPaymentsThatAreNotPaidAndNeeded(payload.initDate.Value, payload.finalDate.Value)));
 }
        public ActionResult Export([Bind("searchValue,searchOld,initDateOld,initDate,finalDateOld,finalDate")] VMSearchpayment payload)
        {
            if (payload.finalDateOld == null)
            {
                payload.finalDateOld = DateTime.Now;
            }
            if (payload.initDateOld == null)
            {
                payload.initDateOld = DateTime.MinValue;
            }

            List <Payment> list;

            if (string.IsNullOrEmpty(payload.searchOld) || string.IsNullOrWhiteSpace(payload.searchOld))
            {
                list = _paymentService.GetPaymentsThatAreNotPaidAndNeeded(payload.initDateOld.Value, payload.finalDateOld.Value);
            }
            else
            {
                list = _paymentService.GetPaymentsByNameOrRGOrCPF(payload.searchOld, payload.initDateOld.Value, payload.finalDateOld.Value);
            }

            DataTable dt = GetDataTable(list);

            if (dt.Rows.Count == 0)
            {
                var mMessages = new VMMessages()
                {
                    Css  = "msg-sucesso",
                    Text = "Não há itens para serem exportados!"
                };
                TempData["_mensagem"] = JsonConvert.SerializeObject(mMessages);
                return(RedirectToAction("Index"));
            }



            Excel excel = new Excel();

            return(excel.ExportData("Lista de Inadimplentes", dt));
        }
Ejemplo n.º 3
0
        public ActionResult <List <Payment> > list([FromBody] VMSearchpayment payload)
        {
            try
            {
                if (payload.finalDate == null)
                {
                    payload.finalDate = DateTime.Now;
                }
                if (payload.initDate == null)
                {
                    payload.initDate = DateTime.MinValue;
                }

                if (!ModelState.IsValid)
                {
                    return(BadRequest(ModelState.GetErrorMessages()));
                }
                if (string.IsNullOrEmpty(payload.searchValue) || string.IsNullOrWhiteSpace(payload.searchValue))
                {
                    return(_paymentService.GetPaymentsThatAreNotPaidAndNeeded(payload.initDate.Value, payload.finalDate.Value));
                }
                else
                {
                    return(_paymentService.GetPaymentsByNameOrRGOrCPF(payload.searchValue, payload.initDate.Value, payload.finalDate.Value));
                }
            }
            catch (CustomHttpException ex)
            {
                return(StatusCode(ex.StatusCode, ex.ErrorMessage));
            }
            catch (Exception ex)
            {
                // TODO: Log ex
                return(StatusCode(500, new { error = "Internal server error" }));
            }
        }