private void CarregaComboFabricante()
{
Veiculos.Ioc.Service.Service <Ioc.Core.Data.Fabricante> service = new Ioc.Service.Service <Ioc.Core.Data.Fabricante>();
ViewBag.IdFabricante = new SelectList
(
service.BuscarTodos(),
"Id",
"Descricao"
);
}
private void CarregaComboModelo()
{
Veiculos.Ioc.Service.Service <Ioc.Core.Data.Modelo> service = new Ioc.Service.Service <Ioc.Core.Data.Modelo>();
ViewBag.IdModelo = new SelectList
(
service.BuscarTodos(),
"Id",
"Descricao"
);
}
private void FormaPagamento()
{
Veiculos.Ioc.Service.Service <Ioc.Core.Data.FormaPagamento> service = new Ioc.Service.Service <Ioc.Core.Data.FormaPagamento>();
ViewBag.IdFormaPagamento = new SelectList
(
service.BuscarTodos(),
"Id",
"Descricao",
1
);
}
public JsonResult Placa(string placa, string veiculo)
{
Veiculos.Ioc.Service.Service <Ioc.Core.Data.Compra> service = new Ioc.Service.Service <Ioc.Core.Data.Compra>();
var result = (from c in service.BuscarTodos(g => g.Veiculo.IdStatusVeiculo == 3 && (g.Veiculo.Placa.StartsWith(placa) && !g.Veiculo.Placa.Equals(veiculo)))
select new
{
Id = c.Veiculo.Id,
Veiculo = c.Veiculo.Placa + "/" + c.Veiculo.Modelo.Descricao + "/" + c.Veiculo.Modelo.Fabricante.Descricao + "/" + c.Veiculo.AnoFabricacao.ToString(),
c.Preco,
IdCompra = c.Id
}
);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult CarregarVendas(int? IdStatusVenda)
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
int pageSize = length != null ? Convert.ToInt32(length) : 0;
int skip = start != null ? Convert.ToInt32(start) : 0;
Veiculos.Ioc.Service.Service<Ioc.Core.Data.Venda> servico = new Ioc.Service.Service<Ioc.Core.Data.Venda>();
Expression<Func<Ioc.Core.Data.Venda, bool>> _where = null;
if(IdStatusVenda != null)
_where= a => a.IdStatusVenda == IdStatusVenda;
if (!string.IsNullOrEmpty(searchValue))
{
_where = a => a.IdStatusVenda == IdStatusVenda && (a.Veiculo.Placa.StartsWith(searchValue) || a.Veiculo.Modelo.Descricao.StartsWith(searchValue) || a.Veiculo.Modelo.Fabricante.Descricao.StartsWith(searchValue));
}
var result = from v in servico.BuscarTodos(_where).ToList()
select new
{
v.Id,
Data = v.Data.ToString("dd/MM/yyyy"),
v.Veiculo.Placa,
Fabricante = v.Veiculo.Modelo.Fabricante.Descricao,
Modelo = v.Veiculo.Modelo.Descricao,
Valor = v.ValorTotal,
Vendedor = v.Usuario.Nome
};
int recordsTotal = result.Count();
var data = result.OrderByDescending(o => o.Id).Skip(skip).Take(pageSize).ToList();
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
if (sortColumnDir.Equals("asc", StringComparison.OrdinalIgnoreCase))
{
if (sortColumn.Equals("Fabricante", StringComparison.OrdinalIgnoreCase))
data = data.OrderBy(f => f.Fabricante).ToList();
if (sortColumn.Equals("Data", StringComparison.OrdinalIgnoreCase))
data = data.OrderBy(f => f.Data).ToList();
if (sortColumn.Equals("Modelo", StringComparison.OrdinalIgnoreCase))
data = data.OrderBy(f => f.Modelo).ToList();
if (sortColumn.Equals("Placa", StringComparison.OrdinalIgnoreCase))
data = data.OrderBy(f => f.Placa).ToList();
if (sortColumn.Equals("Valor", StringComparison.OrdinalIgnoreCase))
data = data.OrderBy(f => f.Valor).ToList();
if (sortColumn.Equals("Vendedor", StringComparison.OrdinalIgnoreCase))
data = data.OrderBy(f => f.Vendedor).ToList();
}
else
{
if (sortColumn.Equals("Fabricante", StringComparison.OrdinalIgnoreCase))
data = data.OrderByDescending(f => f.Fabricante).ToList();
if (sortColumn.Equals("Data", StringComparison.OrdinalIgnoreCase))
data = data.OrderByDescending(f => f.Data).ToList();
if (sortColumn.Equals("Modelo", StringComparison.OrdinalIgnoreCase))
data = data.OrderByDescending(f => f.Modelo).ToList();
if (sortColumn.Equals("Placa", StringComparison.OrdinalIgnoreCase))
data = data.OrderByDescending(f => f.Placa).ToList();
if (sortColumn.Equals("Valor", StringComparison.OrdinalIgnoreCase))
data = data.OrderByDescending(f => f.Valor).ToList();
if (sortColumn.Equals("Vendedor", StringComparison.OrdinalIgnoreCase))
data = data.OrderByDescending(f => f.Vendedor).ToList();
}
}
return Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data }, JsonRequestBehavior.AllowGet);
}