public static Boolean UpdateCustomerAccountData(Commons.CustomerAccountData model)
        {
            using (IndexEntities db = new IndexEntities())
            {
                db.spu_CustomerAccountData(model.IdCustomer, model.IdAccount, model.ResolutionRate, model.RegimeRate,
                                           model.ResolutionStartDate, model.ResolutionEndDate, model.FiscalPeriodStartDate, model.FiscalPeriodEndDate);
            }

            return(true);
        }
        public HttpResponseMessage UpdateCustomerAccountData(Commons.CustomerAccountData model)
        {
            HttpResponseMessage respuesta = null;

            try
            {
                Boolean result = Dal.Customer.UpdateCustomerAccountData(model);
                respuesta = Request.CreateResponse(HttpStatusCode.OK, result);
            }
            catch (Exception ex)
            {
                respuesta = Request.CreateErrorResponse(HttpStatusCode.Conflict, (ex.InnerException == null) ? ex.Message : ex.InnerException.Message);
            }
            return(respuesta);
        }
Example #3
0
        public JsonResult ListaItemData(Boolean?IsProduct)
        {
            String            response           = null;
            ClienteController customerController = new ClienteController();

            Commons.Customer            customer = customerController.GetCustomer(((Commons.Customer)Session["CUSTOMERINFO"]).Id);
            Commons.User                user     = (Commons.User)Session["USERINFO"];
            Commons.Account             cuenta   = (Commons.Account)Session["ACCOUNTINFO"];
            Commons.CustomerAccountData cadata   = customerController.GetCustomerAccountData(((Commons.Customer)Session["CUSTOMERINFO"]).Id, cuenta.Id).FirstOrDefault();

            Functionalities.Reportes.ItemReport data = new Functionalities.Reportes.ItemReport(Server.MapPath("~\\CRfiles\\ListaItem.rpt"),
                                                                                               Server.MapPath("~\\ReportFiles\\ListaItem"), user.UserName, customer.EnterpriseName, Url.Content("~\\ReportFiles\\ListaItem"));
            response = data.Generate(customer.Id, cuenta.Id, IsProduct);

            return(Json(response, JsonRequestBehavior.AllowGet));
        }
Example #4
0
        public JsonResult ListaExportacionData(DateTime StartDate, DateTime EndDate, Boolean?GetTransmited)
        {
            String            response           = null;
            ClienteController customerController = new ClienteController();

            Commons.Customer            customer = customerController.GetCustomer(((Commons.Customer)Session["CUSTOMERINFO"]).Id);
            Commons.User                user     = (Commons.User)Session["USERINFO"];
            Commons.Account             cuenta   = (Commons.Account)Session["ACCOUNTINFO"];
            Commons.CustomerAccountData cadata   = customerController.GetCustomerAccountData(((Commons.Customer)Session["CUSTOMERINFO"]).Id, cuenta.Id).FirstOrDefault();

            Functionalities.Reportes.ExportList data = new Functionalities.Reportes.ExportList(Server.MapPath("~\\CRfiles\\ListaExportacion.rpt"),
                                                                                               Server.MapPath("~\\ReportFiles\\ListaExportacion"), user.UserName, customer.EnterpriseName, Url.Content("~\\ReportFiles\\ListaExportacion"));
            response = data.Generate(customer.Id, cuenta.Id, StartDate, EndDate, GetTransmited);

            return(Json(response, JsonRequestBehavior.AllowGet));
        }
Example #5
0
        public JsonResult DeclaracionJuradaGerencialData(DateTime StartDate, DateTime EndDate, Boolean?GetTransmited, String FileHeaderList, String FileDetailList, Boolean UseFreeze)
        {
            String            response           = null;
            ClienteController customerController = new ClienteController();

            Commons.Customer            customer = customerController.GetCustomer(((Commons.Customer)Session["CUSTOMERINFO"]).Id);
            Commons.User                user     = (Commons.User)Session["USERINFO"];
            Commons.Account             cuenta   = (Commons.Account)Session["ACCOUNTINFO"];
            Commons.CustomerAccountData cadata   = customerController.GetCustomerAccountData(((Commons.Customer)Session["CUSTOMERINFO"]).Id, cuenta.Id).FirstOrDefault();

            Functionalities.Reportes.SwornDeclarationTwo data = new Functionalities.Reportes.SwornDeclarationTwo(Server.MapPath("~\\CRfiles\\DeclaracionJuradaGerencial.rpt"),
                                                                                                                 Server.MapPath("~\\ReportFiles\\DeclaracionJuradaGerencial"), user.UserName, customer.EnterpriseName, Url.Content("~\\ReportFiles\\DeclaracionJuradaGerencial"));
            response = data.Generate(customer.Id, cuenta.Id, StartDate, EndDate, null, null, GetImpExpCode(customer), customer.Nit,
                                     cadata.ResolutionRate, cadata.ResolutionStartDate, cadata.ResolutionEndDate, GetTransmited, FileHeaderList, FileDetailList, UseFreeze);

            return(Json(response, JsonRequestBehavior.AllowGet));
        }
Example #6
0
        public JsonResult ListaCongeladosData(DateTime?StartDate, DateTime?EndDate)
        {
            String            response           = null;
            ClienteController customerController = new ClienteController();

            Commons.Customer            customer = new ClienteController().GetCustomer(((Commons.Customer)Session["CUSTOMERINFO"]).Id);
            Commons.User                user     = (Commons.User)Session["USERINFO"];
            Commons.Account             cuenta   = (Commons.Account)Session["ACCOUNTINFO"];
            Commons.CustomerAccountData cadata   = customerController.GetCustomerAccountData(((Commons.Customer)Session["CUSTOMERINFO"]).Id, cuenta.Id).FirstOrDefault();

            Functionalities.Reportes.FrozenReport data = new Functionalities.Reportes.FrozenReport(Server.MapPath("~\\CRfiles\\ListaCongelados.rpt"),
                                                                                                   Server.MapPath("~\\ReportFiles\\ListaCongelados"), user.UserName, customer.EnterpriseName, Url.Content("~\\ReportFiles\\ListaCongelados"));
            response = data.Generate(customer.Id, cuenta.Id, StartDate, EndDate, null, null, GetImpExpCode(customer), customer.Nit, customer.LegalRepresentative,
                                     cadata.ResolutionRate, cadata.ResolutionStartDate, cadata.ResolutionEndDate);

            return(Json(response, JsonRequestBehavior.AllowGet));
        }
Example #7
0
        public ActionResult DescargosFiltroReadDetail([DataSourceRequest] DataSourceRequest request, Int32 IdFileHeader)
        {
            ClienteController customerController = new ClienteController();

            Commons.Customer            customer = customerController.GetCustomer(((Commons.Customer)Session["CUSTOMERINFO"]).Id);
            Commons.Account             cuenta   = (Commons.Account)Session["ACCOUNTINFO"];
            Commons.CustomerAccountData cadata   = customerController.GetCustomerAccountData(((Commons.Customer)Session["CUSTOMERINFO"]).Id, cuenta.Id).FirstOrDefault();

            if (customer != null)
            {
                IRestResponse WSR = Task.Run(() => apiClient.getJArray("Reporte/Descargo/Detalle", "IdCustomer=" + customer.Id
                                                                       + "&IdAccount=" + cuenta.Id
                                                                       + "&StartDate=" + Session["StarDate"]
                                                                       + "&EndDate=" + Session["EndDate"]
                                                                       + "&GetTransmited=" + Session["GetTransmited"]
                                                                       + "&IdFileHeader=" + IdFileHeader)).Result;
                if (WSR.StatusCode == HttpStatusCode.OK)
                {
                    return(new JsonResult()
                    {
                        Data = JArray.Parse(WSR.Content).ToObject <List <FileDetail> >().ToDataSourceResult(request),
                        ContentType = "json",
                        JsonRequestBehavior = JsonRequestBehavior.AllowGet,
                        MaxJsonLength = Int32.MaxValue
                    });
                }
                else
                {
                    return(Json(new DataSourceResult {
                        Errors = JObject.Parse(WSR.Content).ToObject <Error>().Message.ToString()
                    }));
                }
            }
            else
            {
                return(Json(new DataSourceResult {
                    Errors = "No cuenta con clientes asignados"
                }));
            }
        }
Example #8
0
        public JsonResult JsonDescargosFiltroHeader(DateTime StartDate, DateTime EndDate, Boolean?GetTransmited, String IdDocument)
        {
            ClienteController customerController = new ClienteController();

            Commons.Customer            customer = customerController.GetCustomer(((Commons.Customer)Session["CUSTOMERINFO"]).Id);
            Commons.Account             cuenta   = (Commons.Account)Session["ACCOUNTINFO"];
            Commons.CustomerAccountData cadata   = customerController.GetCustomerAccountData(((Commons.Customer)Session["CUSTOMERINFO"]).Id, cuenta.Id).FirstOrDefault();

            if (customer != null)
            {
                IRestResponse WSR = Task.Run(() => apiClient.getJArray("Reporte/Descargo/Documento", "IdCustomer=" + customer.Id
                                                                       + "&IdAccount=" + cuenta.Id
                                                                       + "&StartDate=" + StartDate.ToString("yyyy-MM-dd")
                                                                       + "&EndDate=" + EndDate.ToString("yyyy-MM-dd")
                                                                       + "&GetTransmited=" + GetTransmited
                                                                       + "&IdDocument=" + IdDocument)).Result;
                if (WSR.StatusCode == HttpStatusCode.OK)
                {
                    return(new JsonResult()
                    {
                        Data = JArray.Parse(WSR.Content).ToObject <List <FileHeader> >(),
                        ContentType = "json",
                        JsonRequestBehavior = JsonRequestBehavior.AllowGet,
                        MaxJsonLength = Int32.MaxValue
                    });
                }
                else
                {
                    return(Json(new DataSourceResult {
                        Errors = JObject.Parse(WSR.Content).ToObject <Error>().Message.ToString()
                    }));
                }
            }
            else
            {
                return(Json(new DataSourceResult {
                    Errors = "No cuenta con clientes asignados"
                }));
            }
        }