// GET: Aporte/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(id); int intRetiroId = Convert.ToInt32(idDecrypted); retiro retiro = db.retiro.Find(intRetiroId); ViewBag.idSocio = retiro.SocioId.ToString(); if (retiro == null) { return(HttpNotFound()); } return(View(retiro)); }
// GET: Aporte/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string socioDecrypted = MiUtil.desEncriptar(id); int intSocioId = Convert.ToInt32(socioDecrypted); aporte aporte = db.aporte.Find(intSocioId); ViewBag.idSocio = aporte.SocioId.ToString(); if (aporte == null) { return(HttpNotFound()); } return(View(aporte)); }
// GET: Cliente/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(id); int intId = Convert.ToInt32(idDecrypted); cliente cliente = db.cliente.Find(intId); if (cliente == null) { return(HttpNotFound()); } return(View(cliente)); }
// GET: Contacto/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id)); int intId = Convert.ToInt32(idDecrypted); contacto contacto = db.contacto.Find(intId); if (contacto == null) { return(HttpNotFound()); } return(View(contacto)); }
// GET: socio/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(id); int intId = Convert.ToInt32(idDecrypted); socio socio = db.socio.Find(intId); if (socio == null) { return(HttpNotFound()); } ViewBag.EmpresaId = new SelectList(db.empresa.Where(c => c.Estado == true).OrderBy(e => e.Nit), "EmpresaId", "Nit", socio.EmpresaId); return(View(socio)); }
// // GET: /Abono/Edit/5 public ActionResult Edit(string id, string controlador) { string idDecrypted = MiUtil.desEncriptar(id); int intId = Convert.ToInt32(idDecrypted); ViewBag.controlador = controlador; abono abono = db.abono.Find(intId); cuota cuota = db.cuota.Find(abono.CuotaId); abono.cuota = cuota; ViewBag.CuotaId = cuota.CuotaId; ViewBag.idcuota = cuota.CuotaId; ViewBag.cuotaNumero = cuota.Numero; ViewBag.CreditoId = cuota.CreditoId; // ViewBag.CuotaId = new SelectList(db.Cuotas, "CuotaId", "CuotaId", abono.CuotaId); return(View(abono)); }
// // GET: /ParamCorreo/Edit/5 public ActionResult Edit(string id) { //int empresaId = 0; //if (Session["EmpresaId"] != null) // Int32.TryParse(Session["EmpresaId"].ToString(), out empresaId); string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id)); int intId = Convert.ToInt32(idDecrypted); paramcorreo paramcorreo = db.paramcorreo.Find(intId); var e = db.empresa.Where(u => u.Estado == true); // int empresaId = Convert.ToInt32(Session["EmpresaId"]); // ViewBag.EmpresaId = new SelectList(e.Where(u => u.EmpresaId == empresaId), "EmpresaId", "Nombre", empresaId); //ViewBag.EmpresaId = new SelectList(db.Empresas, "EmpresaId", "Nombre", paramcorreo.EmpresaId); return(View(paramcorreo)); }
// GET: Cliente/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id)); int intId = Convert.ToInt32(idDecrypted); cliente cliente = db.cliente.Find(intId); if (cliente == null) { return(HttpNotFound()); } //ViewBag.EmpresaId = new SelectList(db.empresa.Where(c => c.Estado == true).OrderBy(e => e.Nit), "EmpresaId", "Nit", cliente.EmpresaId); ViewBag.CiudadId = new SelectList(db.ciudad.Where(c => c.Estado == true && c.EmpresaId == cliente.EmpresaId).OrderBy(e => e.Nombre), "CiudadId", "Nombre", cliente.CiudadId); return(View(cliente)); }
// GET: RetiroInteres/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id)); int intId = Convert.ToInt32(idDecrypted); retirointeres retirointeres = db.retirointeres.Find(intId); if (retirointeres == null) { return(HttpNotFound()); } //ViewBag.EmpresaId = new SelectList(db.empresa.Where(c=>c.Estado==true).OrderBy(e=>e.Nit), "EmpresaId", "Nit", retirointeres.EmpresaId); ViewBag.EmpresaId = retirointeres.EmpresaId; return(View(retirointeres)); }
public ActionResult Edit([Bind(Include = "AporteId,Valor,Fecha,SocioId,ConceptoAporteId,Observacion,Estado,CreadoPor,FechaCreacion,ModificadoPor,FechaModificacion")] aporte aporte, int EmpresaId) { if (ModelState.IsValid) { db.Entry(aporte).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { socioId = MiUtil.encriptar(aporte.SocioId.ToString()) })); } ViewBag.idSocio = aporte.SocioId.ToString(); ViewBag.EmpresaId = EmpresaId; //int intSocioId = Convert.ToInt32(socioDecrypted); // socio socio = db.socio.Find(intSocioId); //ViewBag.idSocio = intSocioId.ToString(); ViewBag.ConceptoAporteId = new SelectList(db.conceptoaporte.Where(c => c.Estado == true && c.EmpresaId == EmpresaId).OrderBy(e => e.Nombre), "ConceptoAporteId", "Nombre", aporte.ConceptoAporteId); ViewBag.SocioId = new SelectList(db.socio.Where(c => c.Estado == true).OrderBy(e => e.Nit), "SocioId", "Nit", aporte.SocioId); return(View(aporte)); }
public ActionResult Edit(abono abono, string controlador) { ViewBag.controlador = controlador; if (ModelState.IsValid) { db.Entry(abono).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { id = MiUtil.encriptar(abono.CuotaId.ToString()), controlador = controlador })); } cuota cuota = db.cuota.Find(abono.CuotaId); ViewBag.cuotaId = cuota.CuotaId; ViewBag.cuotaNumero = cuota.Numero; ViewBag.CreditoId = cuota.CreditoId; ViewBag.CuotaId = abono.CuotaId; ViewBag.idcuota = cuota.CuotaId; // ViewBag.CuotaId = new SelectList(db.Cuotas, "CuotaId", "CuotaId", abono.CuotaId); return(View(abono)); }
// GET: Credito/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id)); int intId = Convert.ToInt32(idDecrypted); credito credito = db.credito.Find(intId); if (credito == null) { return(HttpNotFound()); } foreach (cuota c in credito.cuota) { c.SaldoCapital = c.calcularSaldoxCapital(); c.SaldoInteres = c.calcularSaldoxInteres(); } return(View(credito)); }
// GET: Empresa/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(id); int intId = Convert.ToInt32(idDecrypted); empresa empresa = db.empresa.Find(intId); // int mesActual = DateTime.Now.Month, anioActual = DateTime.Now.Year; ViewBag.EmpMesActual = MiUtil.getMeses(empresa.EmpMesActual); if (empresa == null) { return(HttpNotFound()); } return(View(empresa)); }
public ViewResult Index(string id, string controlador, string fechaActual) { string idDecrypted = MiUtil.desEncriptar(id); int intId = Convert.ToInt32(idDecrypted); cuota cuota = db.cuota.Find(intId); ViewBag.CuotaId = intId; ViewBag.CreditoId = cuota.CreditoId; ViewBag.CreditoNro = cuota.credito.CreditoNro; ViewBag.NombreCliente = cuota.credito.cliente.Nombre; ViewBag.fechaActual = fechaActual; ViewBag.cuotaNumero = cuota.Numero; ViewBag.saldo = cuota.calcularSaldoxCapital() + cuota.calcularSaldoxInteres(); var abonos = db.abono.Include(a => a.cuota).Include(a => a.cuota.credito).Where(s => s.cuota.CreditoId == cuota.CreditoId).OrderByDescending(a => a.AbonoId); ViewBag.controlador = controlador; ViewBag.Cuota = cuota; return(View(abonos.ToList())); }
public ImpresionAbono impresionAbono(int abonoId) { ImpresionAbono ia = null; abono abono = (abono)db.abono.Find(abonoId); if (abono.Estado) { cuota cuota = (cuota)db.cuota.Find(abono.CuotaId); credito credito = (credito)db.credito.Find(cuota.CreditoId); empresa empresa = (empresa)db.empresa.Find(credito.cliente.EmpresaId); ia = new ImpresionAbono(); ia.LogoEmpresa = "~/Uploads/Logos/" + empresa.LogoUrl; ia.EmpresaId = empresa.EmpresaId; ia.EmpresaNit = empresa.Nit; ia.EmpresaNombre = empresa.Nombre; ia.ClienteNit = credito.cliente.Nit; ia.ClienteNombre = credito.cliente.Nombre; ia.EmailCliente = credito.cliente.Email; ia.CreditoId = credito.CreditoId; ia.CreditoNro = credito.CreditoNro; ia.CreditoValor = credito.Valor; ia.CreditoCantCuotas = credito.cuota.Count; ia.CuotaNro = cuota.Numero; ia.CuotaValor = cuota.AbonoCapital + cuota.AbonoInteres + MiUtil.nullTodecimal(cuota.AjusteAbonoCapital) + MiUtil.nullTodecimal(cuota.AjusteAbonoInteres); ia.AbonoId = abonoId; ia.AbonoNro = abono.AbonoNro; ia.AbonoFecha = abono.Fecha; ia.AbonoValor = abono.Valor; decimal?porcenInteres = cuota.porcentajeInteres(); decimal?porcenCapital = cuota.porcentajeCapital(); ia.AbonoInteres = ia.AbonoValor * (porcenInteres / 100); ia.AbonoCapital = ia.AbonoValor * (porcenCapital / 100); ia.CreditoSaldoInteres = credito.calcularTotalInteres() - credito.calcularAbonoInteres(abono.Fecha); ia.CreditoSaldoCapital = credito.calcularTotalCapital() - credito.calcularAbonoCapital(abono.Fecha); ia.TotalAbono = ia.AbonoCapital + ia.AbonoInteres; ia.SaldoCuota = cuota.calcularSaldoxCapital(abono.Fecha) + cuota.calcularSaldoxInteres(abono.Fecha); //ia.CuotaValor - ia.TotalAbono; } return(ia); }
// GET: AbonoCapital/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id)); int intId = Convert.ToInt32(idDecrypted); abonocapital abonocapital = db.abonocapital.Find(intId); if (abonocapital == null) { return(HttpNotFound()); } ViewBag.creditoId = MiUtil.encriptar(abonocapital.CreditoId.ToString()); //new SelectList(db.credito.Where(c=>c.Estado==true).OrderBy(e=>e.TipoCuotaId), "CreditoId", "TipoCuotaId", abonocapital.CreditoId); credito cr = db.credito.Find(abonocapital.CreditoId); ViewBag.empresaId = MiUtil.encriptar(cr.EmpresaId.ToString()); return(View(abonocapital)); }
public ActionResult Create(abono abono, string controlador, int EmpresaId, string fechaActual) { ViewBag.EmpresaId = EmpresaId; if (ModelState.IsValid) { if (abono.Paga > abono.Valor) { abono.Devolucion = abono.Paga - abono.Valor; } else { abono.Valor = abono.Paga; abono.Devolucion = 0; } consecutivo c = db.consecutivo.Find(EmpresaId); c.AbonoNro = c.AbonoNro + 1; abono.AbonoNro = c.AbonoNro; db.abono.Add(abono); db.SaveChanges(); // return RedirectToAction("EnviarCorreoFromAWS", new { abonoId = MiUtil.encriptar(abono.AbonoId.ToString()), abonoNro = abono.AbonoNro }); //return RedirectToAction("Index", controlador, new { id = MiUtil.encriptar(abono.CuotaId.ToString()), controlador = controlador, fechaActual=fechaActual }); return(RedirectToAction("Index", new { id = MiUtil.encriptar(abono.CuotaId.ToString()), controlador = controlador, fechaActual = fechaActual })); } ViewBag.CuotaId = abono.CuotaId; cuota cuota = db.cuota.Find(abono.CuotaId); abono.cuota = cuota; ViewBag.cuotaId = abono.CuotaId; ViewBag.CreditoId = cuota.CreditoId; ViewBag.CreditoNro = cuota.credito.CreditoNro; ViewBag.cuotaNumero = cuota.Numero; ViewBag.saldo = cuota.calcularSaldoxCapital() + cuota.calcularSaldoxInteres(); ViewBag.controlador = controlador; //ViewBag.CuotaId = new SelectList(db.Cuotas, "CuotaId", "CuotaId", abono.CuotaId); return(View(abono)); }
// MiUtil ut = new MiUtil(); // // GET: /EstadoEmpresa/ public ViewResult Index(string anio, string mes) { int empresaId = 0; if (Session["EmpresaId"] != null) { Int32.TryParse(Session["EmpresaId"].ToString(), out empresaId); } int mesActual = DateTime.Now.Month, anioActual = DateTime.Now.Year; if (anio != null && mes != null) { mesActual = Convert.ToInt32(mes); } ViewBag.mes = MiUtil.getMeses(mesActual); var q = @"SELECT DISTINCT year(Cuota.Fecha) AS anio FROM Cuota INNER JOIN Credito ON Cuota.CreditoId = Credito.CreditoId INNER JOIN Cliente ON Credito.ClienteId=Cliente.ClienteId WHERE (Credito.Estado = 1) and (Cliente.EmpresaId='" + empresaId.ToString() + "')"; ViewBag.anio = MiUtil.llenarCombo(db, q, anioActual.ToString()); // Empresa e=db.Empresas.First(); //ViewBag.EmpresaId = new SelectList(db.Empresas.Where(u => u.Activo == true), "EmpresaId", "Nombre",e.EmpresaId); //var em = db.empresa.Where(u => u.Estado == true); //int empresaId = Convert.ToInt32(Session["EmpresaId"]); //ViewBag.EmpresaId = new SelectList(em.Where(u => u.EmpresaId == empresaId), "EmpresaId", "Nombre", empresaId); return(Index(empresaId, anioActual.ToString(), mesActual)); // } }
public IEnumerable <Cuotas> getCuotasxCobrar(int empresaId, string fecha, int?UsuarioId) { string strfecha = ""; if (MiUtil.isDate(fecha)) { ViewBag.CurrentFilter = fecha; strfecha = MiUtil.fechaToSQL(DateTime.ParseExact(fecha, "dd/MM/yyyy", null), 0); } var q = @"SELECT cuota.CuotaId, cliente.Nit, cliente.Nombre, credito.CreditoId,credito.CreditoNro, cuota.Numero, cuota.Fecha, cuota.AbonoCapital+ IFNULL(cuota.AjusteAbonoCapital,0) as AbonoCapital, cuota.AbonoInteres+ IFNULL(cuota.AjusteAbonoInteres,0) as AbonoInteres, cuota.AbonoCapital + cuota.AbonoInteres + IFNULL(cuota.AjusteAbonoCapital,0)+ IFNULL(cuota.AjusteAbonoInteres,0) AS TotalCuota, SUM(IFNULL(abono.Valor, 0)) AS Abonos, (select count(0) from cuota where credito.CreditoId=cuota.CreditoId) as CantCuotas FROM credito INNER JOIN cuota ON credito.CreditoId = cuota.CreditoId LEFT OUTER JOIN cliente ON credito.ClienteId = cliente.ClienteId LEFT OUTER JOIN abono ON cuota.CuotaId = abono.CuotaId and abono.Estado=1"; q = q + " WHERE (credito.Estado = 1) AND (Cuota.Fecha <= '" + strfecha + "') AND (cliente.EmpresaId = {0})"; if (UsuarioId > 0) { q = q + " and credito.usuarioId='" + UsuarioId.ToString() + "'"; } q = q + " GROUP BY cuota.CuotaId, cliente.Nit, cliente.Nombre, credito.CreditoId, cuota.Numero, cuota.Fecha, "; q = q + " cuota.AbonoCapital, cuota.AbonoInteres, credito.Estado ORDER BY cliente.Nombre DESC"; var cxc = db.Database.SqlQuery <Cuotas>(q, empresaId); var final = from c in cxc where (c.Abonos < (c.AbonoCapital + c.AbonoInteres)) select c; return(final.ToList()); }
// GET: Aporte public ActionResult Index(string socioId, string campos1, string filtro1, string currentCampo, string currentFilter, string sortOrder, int?page) { ViewBag.CurrentSort = sortOrder; string socioDecrypted = MiUtil.desEncriptar(socioId); int intSocioId = Convert.ToInt32(socioDecrypted); socio socio = db.socio.Find(intSocioId); ViewBag.socioId = intSocioId.ToString(); ViewBag.socioNombre = socio.Nombre; if (filtro1 != null) { page = 1; } else { campos1 = currentCampo; filtro1 = currentFilter; } campos1 = String.IsNullOrEmpty(campos1) ? "" : campos1; ViewBag.CurrentCampo = campos1; ViewBag.CurrentFilter = filtro1; List <SelectListItem> listaFiltro = new List <SelectListItem>(); //listaFiltro.Add(new SelectListItem { Text = "AporteId", Value = "AporteId" }); //ViewBag.SortAporteId = sortOrder == "AporteId" ? "AporteId_Desc" : "AporteId"; listaFiltro.Add(new SelectListItem { Text = "Valor", Value = "Valor" }); ViewBag.SortValor = sortOrder == "Valor" ? "Valor_Desc" : "Valor"; listaFiltro.Add(new SelectListItem { Text = "Fecha", Value = "Fecha" }); ViewBag.SortFecha = sortOrder == "Fecha" ? "Fecha_Desc" : "Fecha"; // listaFiltro.Add(new SelectListItem { Text = "SocioId", Value = "SocioId" }); //ViewBag.SortSocioId = sortOrder == "SocioId" ? "SocioId_Desc" : "SocioId"; listaFiltro.Add(new SelectListItem { Text = "Concepto", Value = "c.Nombre" }); ViewBag.SortConceptoAporteId = sortOrder == "ConceptoAporteId" ? "ConceptoAporteId_Desc" : "ConceptoAporteId"; listaFiltro.Add(new SelectListItem { Text = "Observacion", Value = "Observacion" }); ViewBag.SortObservacion = sortOrder == "Observacion" ? "Observacion_Desc" : "Observacion"; listaFiltro.Add(new SelectListItem { Text = "Estado", Value = "Estado" }); ViewBag.SortEstado = sortOrder == "Estado" ? "Estado_Desc" : "Estado"; ViewBag.campos1 = listaFiltro; var q = "select * from aporte a,conceptoaporte c where a.ConceptoAporteId=c.ConceptoAporteId"; q = q + " and socioId='" + intSocioId.ToString() + "'"; List <aporte> lista; if (!String.IsNullOrEmpty(campos1) && !String.IsNullOrEmpty(filtro1)) { if (!campos1.ToUpper().Equals("ESTADO")) { q = q + " and upper(" + campos1 + ") like '%" + filtro1.Trim().ToUpper() + "%'"; } else { q = q + " and (CASE WHEN a.estado = 1 THEN 'ACTIVO' ELSE 'INACTIVO' END)= '" + filtro1.Trim().ToUpper() + "'"; } lista = db.Database.SqlQuery <aporte>(q).ToList(); foreach (aporte a in lista) { conceptoaporte ca = db.conceptoaporte.Find(a.ConceptoAporteId); a.conceptoaporte = ca; } } else { var aporte = db.aporte.Include(a => a.conceptoaporte).Include(a => a.socio).Where(s => s.SocioId == intSocioId); lista = aporte.ToList(); switch (sortOrder) { case "AporteId": lista = lista.OrderBy(s => s.AporteId).ToList(); break; case "AporteId_Desc": lista = lista.OrderByDescending(s => s.AporteId).ToList(); break; case "Valor": lista = lista.OrderBy(s => s.Valor).ToList(); break; case "Valor_Desc": lista = lista.OrderByDescending(s => s.Valor).ToList(); break; case "Fecha": lista = lista.OrderBy(s => s.Fecha).ToList(); break; case "Fecha_Desc": lista = lista.OrderByDescending(s => s.Fecha).ToList(); break; case "SocioId": lista = lista.OrderBy(s => s.SocioId).ToList(); break; case "SocioId_Desc": lista = lista.OrderByDescending(s => s.SocioId).ToList(); break; case "ConceptoAporteId": lista = lista.OrderBy(s => s.ConceptoAporteId).ToList(); break; case "ConceptoAporteId_Desc": lista = lista.OrderByDescending(s => s.ConceptoAporteId).ToList(); break; case "Observacion": lista = lista.OrderBy(s => s.Observacion).ToList(); break; case "Observacion_Desc": lista = lista.OrderByDescending(s => s.Observacion).ToList(); break; case "Estado": lista = lista.OrderBy(s => s.Estado).ToList(); break; case "Estado_Desc": lista = lista.OrderByDescending(s => s.Estado).ToList(); break; default: lista = lista.OrderByDescending(s => s.AporteId).ToList(); break; } } int pageSize = Convert.ToInt32(ConfigurationManager.AppSettings["RegistrosPorPagina"].ToString()); int pageNumber = (page ?? 1); return(View(lista.ToPagedList(pageNumber, pageSize))); //return View(lista); }
// GET: AbonoCapital public ActionResult Index(string creditoId, string campos1, string filtro1, string currentCampo, string currentFilter, string sortOrder, int?page) { string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(creditoId)); int intCreditoId = Convert.ToInt32(idDecrypted); ViewBag.CurrentSort = sortOrder; if (filtro1 != null) { page = 1; } else { campos1 = currentCampo; filtro1 = currentFilter; } campos1 = String.IsNullOrEmpty(campos1) ? "" : campos1; ViewBag.CurrentCampo = campos1; ViewBag.CurrentFilter = filtro1; List <SelectListItem> listaFiltro = new List <SelectListItem>(); listaFiltro.Add(new SelectListItem { Text = "AbonoCapitalId", Value = "AbonoCapitalId" }); ViewBag.SortAbonoCapitalId = sortOrder == "AbonoCapitalId" ? "AbonoCapitalId_Desc" : "AbonoCapitalId"; listaFiltro.Add(new SelectListItem { Text = "CreditoId", Value = "CreditoId" }); ViewBag.SortCreditoId = sortOrder == "CreditoId" ? "CreditoId_Desc" : "CreditoId"; listaFiltro.Add(new SelectListItem { Text = "Fecha", Value = "Fecha" }); ViewBag.SortFecha = sortOrder == "Fecha" ? "Fecha_Desc" : "Fecha"; listaFiltro.Add(new SelectListItem { Text = "Valor", Value = "Valor" }); ViewBag.SortValor = sortOrder == "Valor" ? "Valor_Desc" : "Valor"; listaFiltro.Add(new SelectListItem { Text = "Observacion", Value = "Observacion" }); ViewBag.SortObservacion = sortOrder == "Observacion" ? "Observacion_Desc" : "Observacion"; listaFiltro.Add(new SelectListItem { Text = "AbonoNro", Value = "AbonoNro" }); ViewBag.SortAbonoNro = sortOrder == "AbonoNro" ? "AbonoNro_Desc" : "AbonoNro"; listaFiltro.Add(new SelectListItem { Text = "FechaEnvio", Value = "FechaEnvio" }); ViewBag.SortFechaEnvio = sortOrder == "FechaEnvio" ? "FechaEnvio_Desc" : "FechaEnvio"; listaFiltro.Add(new SelectListItem { Text = "Estado", Value = "Estado" }); ViewBag.SortEstado = sortOrder == "Estado" ? "Estado_Desc" : "Estado"; ViewBag.campos1 = listaFiltro; var q = "select * from abonocapital"; List <abonocapital> lista; if (!String.IsNullOrEmpty(campos1) && !String.IsNullOrEmpty(filtro1)) { if (!campos1.ToUpper().Equals("ESTADO")) { q = q + " where upper(" + campos1 + ") like '%" + filtro1.Trim().ToUpper() + "%'"; } else { q = q + " where (CASE WHEN estado = 1 THEN 'ACTIVO' ELSE 'INACTIVO' END)= '" + filtro1.Trim().ToUpper() + "'"; } lista = db.Database.SqlQuery <abonocapital>(q).ToList(); } else { var abonocapital = db.abonocapital.Include(a => a.credito).Where(a => a.CreditoId == intCreditoId).OrderByDescending(a => a.AbonoCapitalId); lista = abonocapital.ToList(); switch (sortOrder) { case "AbonoCapitalId": lista = lista.OrderBy(s => s.AbonoCapitalId).ToList(); break; case "AbonoCapitalId_Desc": lista = lista.OrderByDescending(s => s.AbonoCapitalId).ToList(); break; case "CreditoId": lista = lista.OrderBy(s => s.CreditoId).ToList(); break; case "CreditoId_Desc": lista = lista.OrderByDescending(s => s.CreditoId).ToList(); break; case "Fecha": lista = lista.OrderBy(s => s.Fecha).ToList(); break; case "Fecha_Desc": lista = lista.OrderByDescending(s => s.Fecha).ToList(); break; case "Valor": lista = lista.OrderBy(s => s.Valor).ToList(); break; case "Valor_Desc": lista = lista.OrderByDescending(s => s.Valor).ToList(); break; case "Observacion": lista = lista.OrderBy(s => s.Observacion).ToList(); break; case "Observacion_Desc": lista = lista.OrderByDescending(s => s.Observacion).ToList(); break; case "AbonoCapitalNro": lista = lista.OrderBy(s => s.AbonoCapitalNro).ToList(); break; case "AbonoNro_Desc": lista = lista.OrderByDescending(s => s.AbonoCapitalNro).ToList(); break; case "FechaEnvio": lista = lista.OrderBy(s => s.FechaEnvio).ToList(); break; case "FechaEnvio_Desc": lista = lista.OrderByDescending(s => s.FechaEnvio).ToList(); break; case "Estado": lista = lista.OrderBy(s => s.Estado).ToList(); break; case "Estado_Desc": lista = lista.OrderByDescending(s => s.Estado).ToList(); break; } } ViewBag.creditoId = creditoId; int pageSize = Convert.ToInt32(ConfigurationManager.AppSettings["RegistrosPorPagina"].ToString()); int pageNumber = (page ?? 1); return(View(lista.ToPagedList(pageNumber, pageSize))); //return View(lista); }
public ViewResult Index(int EmpresaId, string anio, int mes) { int anioi = Convert.ToInt32(anio); if (anioi == 0) { anioi = DateTime.Now.Year; } empresa empresa = (empresa)db.empresa.Find(EmpresaId); DateTime finMes = new DateTime(anioi, mes, DateTime.DaysInMonth(anioi, mes)); EstadoEmpresa ee = new EstadoEmpresa(); ee.CapitalTotalRecaudado = 0; ee.CapitalxCobrar = 0; ee.InteresTotalRecaudado = 0; ee.InteresxCobrar = 0; ee.TotalEnCaja = 0; ee.TotalxCobrar = 0; decimal?sumaAportexperiodo = 0, sumaTotalAportes = 0, sumaCreditos = 0, sumaRecaudado = 0; foreach (retirointeres ri in empresa.retirointeres) { if (ri.Estado && ri.Fecha <= finMes) { ee.InteresTotalRecaudado = ee.InteresTotalRecaudado - ri.Valor; } } foreach (cliente c in empresa.cliente) { foreach (credito cr in c.credito) { if (cr.Estado && cr.Fecha <= finMes) { sumaCreditos = sumaCreditos + cr.Valor; ee.CapitalxCobrar = ee.CapitalxCobrar + (cr.calcularTotalCapital() - cr.calcularAbonoCapital(finMes)); ee.InteresxCobrar = ee.InteresxCobrar + (cr.calcularTotalInteres() - cr.calcularAbonoInteres(finMes)); sumaRecaudado = sumaRecaudado + cr.calcularAbonoCapital(finMes); ee.InteresTotalRecaudado = ee.InteresTotalRecaudado + cr.calcularAbonoInteres(finMes); } } } ee.esocios = new List <EstadoSocio>(); foreach (socio s in empresa.socio.OrderBy(e => e.Nombre)) { EstadoSocio es = new EstadoSocio(); es.SocioNit = s.Nit; es.Nombre = s.Nombre; DateTime iniMes = new DateTime(anioi, mes, 1); es.TotalAportes = s.calcularAportes(finMes) - s.calcularRetiros(finMes); //es.AportesxPeriodo = s.calcularAportes(iniMes.AddDays(-1)) - s.calcularRetiros(finMes); es.AportesxPeriodo = s.calcularAportes(finMes) - s.calcularRetiros(finMes); sumaAportexperiodo = sumaAportexperiodo + es.AportesxPeriodo; sumaTotalAportes = sumaTotalAportes + es.TotalAportes; ee.esocios.Add(es); } ee.CapitalTotalRecaudado = sumaTotalAportes - sumaCreditos + sumaRecaudado; if (sumaAportexperiodo != 0) { foreach (EstadoSocio es in ee.esocios) { es.UtilidadRecomendada = ee.InteresTotalRecaudado * ((es.AportesxPeriodo * 100 / sumaAportexperiodo) / 100); } } ee.TotalxCobrar = ee.CapitalxCobrar + ee.InteresxCobrar; ee.TotalEnCaja = ee.CapitalTotalRecaudado + ee.InteresTotalRecaudado; var em = db.empresa.Where(u => u.Estado == true); int empresaId = 0; if (Session["EmpresaId"] != null) { Int32.TryParse(Session["EmpresaId"].ToString(), out empresaId); } //int empresaId = Convert.ToInt32(Session["EmpresaId"]); ViewBag.EmpresaId = new SelectList(em.Where(u => u.EmpresaId == empresaId), "EmpresaId", "Nombre", empresaId); // ViewBag.EmpresaId = new SelectList(db.Empresas.Where(u => u.Activo == true), "EmpresaId", "Nombre", EmpresaId); int mesActual = DateTime.Now.Month; ViewBag.mes = MiUtil.getMeses(mesActual); var q = @"SELECT DISTINCT year(Cuota.Fecha) AS anio FROM Cuota INNER JOIN Credito ON Cuota.CreditoId = Credito.CreditoId INNER JOIN Cliente ON Credito.ClienteId= Cliente.ClienteId WHERE (Credito.Estado = 1) and (Cliente.EmpresaId='" + empresaId.ToString() + "')"; ViewBag.anio = MiUtil.llenarCombo(db, q, anioi.ToString()); return(View(ee)); }