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