public ActionResult ChangeCustomer(Int32 IdCustomer)
{
Commons.User user = (Commons.User)Session["USERINFO"];
Commons.Account AccountInfo = (Commons.Account)Session["ACCOUNTINFO"];
IRestResponse WSR = Task.Run(() => apiClient.getJArray("Cliente/ListarAsignados", "UserName="******"&IdAccount=" + AccountInfo.Id)).Result;
if (WSR.StatusCode == HttpStatusCode.OK)
{
List <Customer> customers = JArray.Parse(WSR.Content).ToObject <List <Customer> >();
Customer item = customers.FirstOrDefault(x => x.Id == IdCustomer);
if (item != null)
{
Session.Remove("CUSTOMERINFO");
Session["CUSTOMERINFO"] = item;
Session.Remove("IDFILEHEADER");
TempData.Clear();
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public static Boolean Add(Commons.Account model)
{
using (IndexEntities db = new IndexEntities())
{
db.spi_Account(model.Name, model.Description, model.RegisterUser);
}
return(true);
}
public static Boolean Delete(Commons.Account model)
{
using (IndexEntities db = new IndexEntities())
{
db.spd_Account(model.Id);
}
return(true);
}
public JsonResult DetalleExportacionData(DateTime StartDate, DateTime EndDate, Boolean?GetTransmited, String FileHeaderList, String FileDetailList)
{
String response = null;
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"];
Functionalities.Reportes.ExportationDetail data = new Functionalities.Reportes.ExportationDetail(Server.MapPath("~\\CRfiles\\DetalleExportacion.rpt"),
Server.MapPath("~\\ReportFiles\\DetalleExportacion"), user.UserName, customer.EnterpriseName, Url.Content("~\\ReportFiles\\DetalleExportacion"));
response = data.Generate(customer.Id, cuenta.Id, StartDate, EndDate, GetTransmited, FileHeaderList, FileDetailList);
return(Json(response, JsonRequestBehavior.AllowGet));
}
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.Account model)
{
HttpResponseMessage respuesta = null;
try
{
Boolean result = Dal.Account.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 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));
}
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));
}
public ActionResult ReadByAssignment([DataSourceRequest] DataSourceRequest request)
{
Commons.Account AccountInfo = (Commons.Account)Session["ACCOUNTINFO"];
Commons.User user = (Commons.User)Session["USERINFO"];
IRestResponse WSR = Task.Run(() => apiClient.getJArray("Cliente/ListarAsignados", "UserName="******"&IdAccount=" + AccountInfo.Id)).Result;
if (WSR.StatusCode == HttpStatusCode.OK)
{
return(Json(JArray.Parse(WSR.Content).ToObject <List <Customer> >().ToList().ToDataSourceResult(request)));
}
else
{
return(Json(new DataSourceResult {
Errors = JObject.Parse(WSR.Content).ToObject <Error>().Message.ToString()
}));
}
}
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"
}));
}
}
