public List <SelectListItem> ufillPeriodo()
{
var tmpResult = new List <SelectListItem>();
using (var tmpContext = new LoanReq_FeriaDigitalEntities())
{
var ListObj = tmpContext.Periods.ToList();
if (ListObj != null && ListObj.Count > 0)
{
var tmpList = ListObj.Select(c => new SelectListItem()
{
Text = c.Description,
Value = c.PeriodId.ToString(),
}).ToList();
if (tmpList != null && tmpList.Count > 0)
{
tmpResult.AddRange(tmpList);
}
}
}
return(tmpResult);
}
public List <SelectListItem> ufillTasaConfig(int ano)
{
var tmpResult = new List <SelectListItem>();
if (ano > 0)
{
using (var tmpContext = new LoanReq_FeriaDigitalEntities())
{
var ListObj = tmpContext.TasasConfigs.Where(w => w.FromVehicleYear <= ano && w.UntilVehicleYear >= ano).ToList();
if (ListObj != null && ListObj.Count > 0)
{
var tmpList = ListObj.Select(c => new SelectListItem()
{
Text = c.Description,
Value = c.idTasasConfig.ToString(),
}).ToList();
if (tmpList != null && tmpList.Count > 0)
{
tmpResult.AddRange(tmpList);
}
}
}
}
return(tmpResult);
}
public List <SelectListItem> ufillModeloVehiculo(long id)
{
var tmpResult = new List <SelectListItem>();
if (id > 0)
{
using (var tmpContext = new LoanReq_FeriaDigitalEntities())
{
var ListObj = tmpContext.TGEN_MODELO.Where(w => w.MARCA == id).ToList();
if (ListObj != null && ListObj.Count > 0)
{
var tmpList = ListObj.Select(c => new SelectListItem()
{
Text = c.DESCRIPTION,
Value = c.idTGEN_MODELO.ToString(),
}).ToList();
if (tmpList != null && tmpList.Count > 0)
{
tmpResult.AddRange(tmpList);
}
}
}
}
return(tmpResult);
}
public List <SelectListItem> ufillCondicion()
{
var tmpResult = new List <SelectListItem>();
using (var tmpContext = new LoanReq_FeriaDigitalEntities())
{
var ListObj = tmpContext.TGEN_CONDICION.ToList();
if (ListObj != null && ListObj.Count > 0)
{
var tmpList = ListObj.Select(c => new SelectListItem()
{
Text = c.DESCRIPTION,
Value = c.idTGEN_CONDICION.ToString(),
}).ToList();
if (tmpList != null && tmpList.Count > 0)
{
tmpResult.AddRange(tmpList);
}
}
}
return(tmpResult);
}
public List <SelectListItem> ufillTipoVehiculo()
{
var tmpResult = new List <SelectListItem>();
using (var tmpContext = new LoanReq_FeriaDigitalEntities())
{
var ListObj = tmpContext.TGEN_DESCTABLA7.ToList();
if (ListObj != null && ListObj.Count > 0)
{
var tmpList = ListObj.Select(c => new SelectListItem()
{
Text = c.DES_DESCRIPCION,
Value = c.DES_CODIGO.ToString(),
}).ToList();
if (tmpList != null && tmpList.Count > 0)
{
tmpResult.AddRange(tmpList);
}
}
}
return(tmpResult);
}
