public List <ModeloNegocio.Director> getAllDirector(int registroAMostrar, int registroAEmpezar, int tipoUsuario)
{
List <ModeloNegocio.Director> lista = new List <ModeloNegocio.Director>();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "[otaku_bcp].PA_LISTA_USERS";
Cmd.Parameters.Add("@RegistrosAMostrar", SqlDbType.Int).Value = registroAMostrar;
Cmd.Parameters.Add("@RegistrosAEmpezar", SqlDbType.Int).Value = registroAEmpezar;
Cmd.Parameters.Add("@tipoUser", SqlDbType.Int).Value = tipoUsuario;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
ModeloNegocio.Director users = new ModeloNegocio.Director();
users.School_id = Convert.ToInt32(Dtr["id"]);
users.Codigo = Dtr["codigo"].ToString();
users.FullName = Dtr["name"].ToString();
//users.Type = Dtr["type"].ToString();
users.Email = Dtr["email"].ToString();
if (DBNull.Value.Equals(Dtr["created_at"]))
{
users.FechaCreado = DateTime.Now;
}
else
{
users.FechaCreado = DateTime.Parse(Dtr["created_at"].ToString());
}
ModeloNegocio.TypeUser typeUser = new ModeloNegocio.TypeUser();
typeUser.Id = Convert.ToInt16(Dtr["type_user_id"]);
typeUser.Name = Dtr["tipoUser"].ToString();
users.typeUser = typeUser;
lista.Add(users);
}
Conn.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return(lista);
}
public List<ModeloNegocio.Director> getAllDirector(int registroAMostrar, int registroAEmpezar, int tipoUsuario)
{
List<ModeloNegocio.Director> lista = new List<ModeloNegocio.Director>();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "[otaku_bcp].PA_LISTA_USERS";
Cmd.Parameters.Add("@RegistrosAMostrar", SqlDbType.Int).Value = registroAMostrar;
Cmd.Parameters.Add("@RegistrosAEmpezar", SqlDbType.Int).Value = registroAEmpezar;
Cmd.Parameters.Add("@tipoUser", SqlDbType.Int).Value = tipoUsuario;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
ModeloNegocio.Director users = new ModeloNegocio.Director();
users.School_id = Convert.ToInt32(Dtr["id"]);
users.Codigo = Dtr["codigo"].ToString();
users.FullName = Dtr["name"].ToString();
//users.Type = Dtr["type"].ToString();
users.Email = Dtr["email"].ToString();
if (DBNull.Value.Equals(Dtr["created_at"]))
{
users.FechaCreado = DateTime.Now;
}
else
{
users.FechaCreado = DateTime.Parse(Dtr["created_at"].ToString());
}
ModeloNegocio.TypeUser typeUser = new ModeloNegocio.TypeUser();
typeUser.Id = Convert.ToInt16(Dtr["type_user_id"]);
typeUser.Name = Dtr["tipoUser"].ToString();
users.typeUser = typeUser;
lista.Add(users);
}
Conn.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return lista;
}
public ModeloNegocio.Director getDirectorId(int director_id)
{
Cmd = new SqlCommand();
Cmd.Connection = Conn;
ModeloNegocio.Director director = new ModeloNegocio.Director();
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "[otaku_bcp].PA_LISTA_USER_ID";
Cmd.Parameters.Add("@user_id", SqlDbType.Int).Value = director_id;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
director.id = Convert.ToInt32(Dtr["id"]);
director.FullName = Dtr["name"].ToString();
director.Codigo = Dtr["codigo"].ToString();
director.Email = Dtr["email"].ToString();
director.Telefono = Dtr["telefono"].ToString();
director.Password = Dtr["password"].ToString();
//users.Type = Dtr["type"].ToString();
if (DBNull.Value.Equals(Dtr["created_at"]))
{
director.FechaCreado = DateTime.Now;
}
else
{
director.FechaCreado = DateTime.Parse(Dtr["created_at"].ToString());
}
if (DBNull.Value.Equals(Dtr["updated_at"]))
{
director.FechaActualizado = DateTime.Now;
}
else
{
director.FechaActualizado = DateTime.Parse(Dtr["updated_at"].ToString());
}
ModeloNegocio.TypeUser typeUser = new ModeloNegocio.TypeUser();
typeUser.Id = Convert.ToInt16(Dtr["id_type"]);
typeUser.Name = Dtr["name_type_user"].ToString();
director.typeUser = typeUser;
//lista.Add(users);
}
Conn.Close();
return director;
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
return director;
}
}
public ModeloNegocio.Director getDirectorId(int director_id)
{
Cmd = new SqlCommand();
Cmd.Connection = Conn;
ModeloNegocio.Director director = new ModeloNegocio.Director();
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "[otaku_bcp].PA_LISTA_USER_ID";
Cmd.Parameters.Add("@user_id", SqlDbType.Int).Value = director_id;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
director.id = Convert.ToInt32(Dtr["id"]);
director.FullName = Dtr["name"].ToString();
director.Codigo = Dtr["codigo"].ToString();
director.Email = Dtr["email"].ToString();
director.Telefono = Dtr["telefono"].ToString();
director.Password = Dtr["password"].ToString();
//users.Type = Dtr["type"].ToString();
if (DBNull.Value.Equals(Dtr["created_at"]))
{
director.FechaCreado = DateTime.Now;
}
else
{
director.FechaCreado = DateTime.Parse(Dtr["created_at"].ToString());
}
if (DBNull.Value.Equals(Dtr["updated_at"]))
{
director.FechaActualizado = DateTime.Now;
}
else
{
director.FechaActualizado = DateTime.Parse(Dtr["updated_at"].ToString());
}
ModeloNegocio.TypeUser typeUser = new ModeloNegocio.TypeUser();
typeUser.Id = Convert.ToInt16(Dtr["id_type"]);
typeUser.Name = Dtr["name_type_user"].ToString();
director.typeUser = typeUser;
//lista.Add(users);
}
Conn.Close();
return(director);
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
return(director);
}
}
/// <summary>
/// getContentId Metodo obtiene un Contenido según su ID
/// </summary>
/// <param name="id">Id del Contenido </param>
/// <returns>Retorna un List ModeloNegocio.Content</returns>
public ModeloNegocio.Content getContentId(int id)
{
try
{
ModeloNegocio.Content content = new ModeloNegocio.Content();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "PA_GET_CONTENT_ID";
Cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
//Lista.Add(new EntidadNegocio.UsuarioEN(Convert.ToInt32(Dtr["idusuario"]), Dtr["nombre"].ToString(), Dtr["usuario"].ToString(), Dtr["password"].ToString(), Convert.ToInt32(Dtr["permiso"])));
content.Id = Convert.ToInt32(Dtr["id"]);
content.Title = Convert.ToString(Dtr["title"]);
content.ContentNote = Convert.ToString(Dtr["content"]);
if (DBNull.Value.Equals(Dtr["image"]))
{
content.Image = null;
}
else
{
content.Image = Dtr["image"].ToString();
}
if (DBNull.Value.Equals(Dtr["created_at"]))
{
content.Created_at = DateTime.Now;
}
else
{
content.Created_at = Convert.ToDateTime(Dtr["created_at"]);
}
if (DBNull.Value.Equals(Dtr["updated_at"]))
{
content.Updated_at = DateTime.Now;
}
else
{
content.Updated_at = Convert.ToDateTime(Dtr["updated_at"]);
}
ModeloNegocio.User user = new ModeloNegocio.User();
user.id = Convert.ToInt32(Dtr["iduser"]);
user.FullName = Convert.ToString(Dtr["user_name"]);
content.User = user;
ModeloNegocio.TypeContent typeContent = new ModeloNegocio.TypeContent();
typeContent.Id = Convert.ToInt32(Dtr["idtype"]);
typeContent.Name = Convert.ToString(Dtr["type_content_name"]);
content.typeContent = typeContent;
AccesoDatos.Comment comment = new AccesoDatos.Comment();
List <ModeloNegocio.Comment> lista = new List <ModeloNegocio.Comment>();
lista = comment.getAllCommentContentId(Convert.ToInt32(Dtr["id"]));
content.Comment = lista;
ModeloNegocio.TypeUser typeUser = new ModeloNegocio.TypeUser();
typeUser.Id = Convert.ToInt32(Dtr["idtype"]);
typeUser.Name = Convert.ToString(Dtr["type_content_name"]);
}
Cmd.Parameters.Clear();
Dtr.Close();
Conn.Close();
return(content);
}
catch (Exception ex)
{
throw new Exception("Error en Acceso a Datos: LoginUsuario.", ex);
}
}
/// <summary>
/// getContentId Metodo obtiene un Contenido según su ID
/// </summary>
/// <param name="id">Id del Contenido </param>
/// <returns>Retorna un List ModeloNegocio.Content</returns>
public ModeloNegocio.Content getContentId(int id)
{
try
{
ModeloNegocio.Content content = new ModeloNegocio.Content();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "PA_GET_CONTENT_ID";
Cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
//Lista.Add(new EntidadNegocio.UsuarioEN(Convert.ToInt32(Dtr["idusuario"]), Dtr["nombre"].ToString(), Dtr["usuario"].ToString(), Dtr["password"].ToString(), Convert.ToInt32(Dtr["permiso"])));
content.Id = Convert.ToInt32(Dtr["id"]);
content.Title = Convert.ToString(Dtr["title"]);
content.ContentNote = Convert.ToString(Dtr["content"]);
if (DBNull.Value.Equals(Dtr["image"]))
{
content.Image = null;
} else
{
content.Image = Dtr["image"].ToString() ;
}
if (DBNull.Value.Equals(Dtr["created_at"]))
{
content.Created_at = DateTime.Now;
}
else
{
content.Created_at = Convert.ToDateTime(Dtr["created_at"]);
}
if (DBNull.Value.Equals(Dtr["updated_at"]))
{
content.Updated_at = DateTime.Now;
}
else
{
content.Updated_at = Convert.ToDateTime(Dtr["updated_at"]);
}
ModeloNegocio.User user = new ModeloNegocio.User();
user.id = Convert.ToInt32(Dtr["iduser"]);
user.FullName = Convert.ToString(Dtr["user_name"]);
content.User=user;
ModeloNegocio.TypeContent typeContent = new ModeloNegocio.TypeContent();
typeContent.Id = Convert.ToInt32(Dtr["idtype"]);
typeContent.Name = Convert.ToString(Dtr["type_content_name"]);
content.typeContent=typeContent;
AccesoDatos.Comment comment = new AccesoDatos.Comment();
List<ModeloNegocio.Comment> lista = new List<ModeloNegocio.Comment>();
lista=comment.getAllCommentContentId(Convert.ToInt32(Dtr["id"]));
content.Comment = lista;
ModeloNegocio.TypeUser typeUser = new ModeloNegocio.TypeUser();
typeUser.Id = Convert.ToInt32(Dtr["idtype"]);
typeUser.Name = Convert.ToString(Dtr["type_content_name"]);
}
Cmd.Parameters.Clear();
Dtr.Close();
Conn.Close();
return content;
}
catch (Exception ex)
{
throw new Exception("Error en Acceso a Datos: LoginUsuario.", ex);
}
}
