public static Boolean Delete(Commons.Customer model)
{
using (IndexEntities db = new IndexEntities())
{
db.spd_Customer(model.Id);
}
return(true);
}
public static Boolean Add(Commons.Customer model)
{
using (IndexEntities db = new IndexEntities())
{
db.spi_Customer(model.EnterpriseName, model.Nit, model.LegalRepresentative, model.PersonCode, model.ImporterCode, model.ExporterCode,
model.BondEndDate, model.Observations, model.RegisterUser);
}
return(true);
}
public ActionResult Index()
{
if (Session["CUSTOMERINFO"] != null && Session["ACCOUNTINFO"] != null)
{
DashboardController dashboard = new DashboardController();
Commons.Customer customer = (Session["CUSTOMERINFO"] == null) ? null : (Commons.Customer)Session["CUSTOMERINFO"];
Commons.Account cuenta = (Session["ACCOUNTINFO"] == null) ? null : (Commons.Account)Session["ACCOUNTINFO"];
ViewBag.Customer = dashboard.GetCustomer(customer.Id);
ViewBag.Expired = dashboard.GetExpired(customer.Id, cuenta.Id);
ViewBag.Transmited = dashboard.GetTransmited(customer.Id, cuenta.Id);
}
return(View());
}
public HttpResponseMessage Delete(Commons.Customer model)
{
HttpResponseMessage respuesta = null;
try
{
Boolean result = Dal.Customer.Delete(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);
}
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));
}
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));
}
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));
}
private String GetImpExpCode(Commons.Customer model)
{
String result = null;
if (!String.IsNullOrEmpty(model.ExporterCode) && !String.IsNullOrWhiteSpace(model.ExporterCode))
{
result = model.ExporterCode;
}
else if (!String.IsNullOrEmpty(model.ImporterCode) && !String.IsNullOrWhiteSpace(model.ImporterCode))
{
result = model.ImporterCode;
}
else
{
result = model.PersonCode;
}
return(result);
}
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"
}));
}
}
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"
}));
}
}
public ActionResult getCombo(Int32?IdCurrency)
{
Commons.Customer CustomerInfo = (Commons.Customer)Session["CUSTOMERINFO"];
if (CustomerInfo != null)
{
IRestResponse WSR = Task.Run(() => apiClient.getJArray("Moneda/Listar", "IdCurrency=null&IdCountry=" + IdCurrency)).Result;
if (WSR.StatusCode == HttpStatusCode.OK)
{
return(Json(JArray.Parse(WSR.Content).ToObject <List <Currency> >().Select(x => new { Id = x.Id, Name = x.Name }).ToList(), JsonRequestBehavior.AllowGet));
}
else
{
return(null);
}
}
else
{
return(Json(new DataSourceResult {
Errors = "No cuenta con clientes asignados"
}));
}
}
