// 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));
}
