// GET: Aporte/Create
public ActionResult Create(string id)
{
int empresaId = 0;
if (Session["EmpresaId"] != null)
{
Int32.TryParse(Session["EmpresaId"].ToString(), out empresaId);
}
string socioDecrypted = MiUtil.desEncriptar(id);
int intSocioId = Convert.ToInt32(socioDecrypted);
socio socio = db.socio.Find(intSocioId);
ViewBag.idSocio = intSocioId.ToString();
ViewBag.socioNombre = socio.Nombre;
ViewBag.ConceptoAporteId = new SelectList(db.conceptoaporte.Where(c => c.Estado == true && c.EmpresaId == empresaId).OrderBy(e => e.Nombre), "ConceptoAporteId", "Nombre");
ViewBag.EmpresaId = empresaId;
// ViewBag.SocioId = new SelectList(db.socio.Where(c=>c.Estado==true).OrderBy(e=>e.Nit), "SocioId", "Nit");
aporte a = new aporte();
a.SocioId = intSocioId;
a.Fecha = DateTime.Now;
a.Estado = true;
return(View(a));
//return View();
}
// 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);
}