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