public List <Models.Registro.RegistrosLista> pegarAtrasados(int Id, bool ehCLiente)
{
List <Models.Registro.RegistrosLista> list = new List <Models.Registro.RegistrosLista>();
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand cmd;
if (ehCLiente)
{
cmd = new SqlCommand("select registro.CdFuncionario, registro.CdCliente, registro.Cditem, usuarios.Nome, item.Titulo, item.CdBarra, registro.DtCriacao, item.Preco, registro.DtEntrega, registro.ValorPago, registro.Id, registro.Prazo from registro inner join usuarios on registro.CdCliente = usuarios.Id inner join item on registro.Cditem = item.Id where registro.CdCliente = @1 and registro.Situacao = 'ALOCADO'");
}
else
{
cmd = new SqlCommand("select registro.CdFuncionario, registro.CdCliente, registro.Cditem, usuarios.Nome, item.Titulo, item.CdBarra, registro.DtCriacao, item.Preco, registro.DtEntrega, registro.ValorPago, registro.Id, registro.Prazo from registro inner join usuarios on registro.CdCliente = usuarios.Id inner join item on registro.Cditem = item.Id where registro.CdFuncionario = @1 and registro.Situacao = 'ALOCADO' ");
}
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@1", Id);
SqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
Models.Registro.RegistrosLista rr = new Models.Registro.RegistrosLista();
rr.Id = Convert.ToInt32(r["Id"].ToString());
rr.FuncionarioId = Convert.ToInt32(r["CdFuncionario"].ToString());
rr.ClienteId = Convert.ToInt32(r["CdCliente"].ToString());
rr.FilmeId = Convert.ToInt32(r["Cditem"].ToString());
rr.Nome = r["Nome"].ToString();
rr.CdBarra = r["CdBarra"].ToString();
rr.Filme = r["Titulo"].ToString();
rr.Prazo = Convert.ToInt32(r["Prazo"].ToString());
rr.ValorPago = Convert.ToInt32(r["ValorPago"].ToString());
rr.Valor = Convert.ToInt32(r["Preco"].ToString());
rr.DtEntrega = Convert.ToDateTime(r["DtEntrega"].ToString());
rr.DtCriacao = Convert.ToDateTime(r["DtCriacao"].ToString());
rr.QtdDiasAtrasado = (rr.DtEntrega > DateTime.Now) ? 0 : (rr.DtEntrega - DateTime.Now).TotalDays;
list.Add(rr);
}
return(list);
}
public List <Models.Registro.RegistrosLista> pegarUltimosDez()
{
List <Models.Registro.RegistrosLista> list = new List <Models.Registro.RegistrosLista>();
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand cmd = new SqlCommand("select registro.CdFuncionario, registro.CdCliente, registro.Cditem, usuarios.Nome, item.Titulo, item.CdBarra, registro.DtCriacao, item.Preco, registro.DtEntrega, registro.ValorPago, registro.Id, registro.Prazo from registro inner join usuarios on registro.CdCliente = usuarios.Id inner join item on registro.Cditem = item.Id where registro.Situacao = 'ALOCADO' order by registro.id DESC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY ");
cmd.Connection = conn;
SqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
Models.Registro.RegistrosLista rr = new Models.Registro.RegistrosLista();
rr.Id = Convert.ToInt32(r["Id"].ToString());
rr.FuncionarioId = Convert.ToInt32(r["CdFuncionario"].ToString());
rr.ClienteId = Convert.ToInt32(r["CdCliente"].ToString());
rr.FilmeId = Convert.ToInt32(r["Cditem"].ToString());
rr.Nome = r["Nome"].ToString();
rr.CdBarra = r["CdBarra"].ToString();
rr.Filme = r["Titulo"].ToString();
rr.Prazo = Convert.ToInt32(r["Prazo"].ToString());
rr.ValorPago = Convert.ToInt32(r["ValorPago"].ToString());
rr.Valor = Convert.ToInt32(r["Preco"].ToString());
rr.DtEntrega = Convert.ToDateTime(r["DtEntrega"].ToString());
rr.DtCriacao = Convert.ToDateTime(r["DtCriacao"].ToString());
rr.QtdDiasAtrasado = (rr.DtEntrega > DateTime.Now) ? 0 : (rr.DtEntrega - DateTime.Now).TotalDays;
list.Add(rr);
}
return(list);
}