private void refresh() { List <Genre> listGenres = GenreDAO.getGenres(); gvGenreList.DataSource = listGenres; gvGenreList.DataBind(); }
public ActionResult Register() { try { if (Session["DevId"] != null) { TypeAppDAO tdao = new TypeAppDAO(); PegiDAO pdao = new PegiDAO(); UserDAO udao = new UserDAO(); GenreDAO gdao = new GenreDAO(); ViewBag.Class = ""; ViewBag.Type = tdao.List(); ViewBag.Pegi = pdao.List(); ViewBag.App = new Application(); ViewBag.Genres = gdao.ListId(); ViewBag.User = udao.SearchById(int.Parse(Session["Id"].ToString())); return(View()); } return(RedirectToAction("../Home/Index")); } catch { return(RedirectToAction("Index", "Home")); } }
public bool objectAlreadyExists(string name, string objectType) { if (objectType == "Interpret") { InterpretDAO iDAO = new InterpretDAO(); if (iDAO.getInterpretByName(name) == null) { return(false); } else { return(true); } } else if (objectType == "Genre") { GenreDAO gDAO = new GenreDAO(); if (gDAO.getGenreByName(name).Count == 0) { return(false); } else { return(true); } } else { MessageBox.Show("Fehler", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
protected void btInserir_Click(object sender, EventArgs e) { if (Page.IsValid) { Genre genre = new Genre() { description_genre = tbxDescri.Text }; int returncode = GenreDAO.InsertGenre(genre); if (returncode == -1) { lbMensagem.ForeColor = System.Drawing.Color.Red; lbMensagem.Text = "Adição falhada!<br />Contacte o administrador ou tente novamente..."; } else { lbMensagem.ForeColor = System.Drawing.Color.Green; lbMensagem.Text = "Adição Efetuada com sucesso!"; tbxDescri.Enabled = false; btInserir.Enabled = false; btCancelar.Text = "Voltar"; } } }
public void create() { GenreDTO gDTO = new GenreDTO(name); GenreDAO gDAO = new GenreDAO(); gDAO.insertGenre(gDTO); }
protected void gvGenreList_RowUpdating(object sender, GridViewUpdateEventArgs e) { int id_genre = Convert.ToInt32(gvGenreList.Rows[e.RowIndex].Cells[0].Text); Genre genre = new Genre { id_genre = id_genre, description_genre = e.NewValues["description_genre"].ToString() }; int ReturnCode = GenreDAO.UpdateGenre(genre); if (ReturnCode == -1) { lbMensagem.ForeColor = System.Drawing.Color.Red; lbMensagem.Text = "Edição falhada!"; gvGenreList.EditIndex = -1; refresh(); } else { lbMensagem.Text = "Edição feita com sucesso!<br />"; lbMensagem.ForeColor = System.Drawing.Color.Green; gvGenreList.EditIndex = -1; refresh(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlEditor.DataSource = PublisherDAO.getPublishers(); ddlEditor.DataValueField = "id_publisher"; ddlEditor.DataTextField = "name_publisher"; ddlEditor.DataBind(); ddlGenero.DataSource = GenreDAO.getGenres(); ddlGenero.DataValueField = "id_genre"; ddlGenero.DataTextField = "description_genre"; ddlGenero.DataBind(); int id_game = Convert.ToInt32(Request.QueryString["id_game"]); if (id_game == 0) { Response.Redirect("~/Games/GameLibraryPL/GameLibrary.aspx"); } Game game = GameDAO.GetGame(id_game); tbxValorPago.Text = game.amount_paid.ToString(); Genre genre = GenreDAO.GetGenre(game.id_genre); Publisher publisher = PublisherDAO.GetPublisher(game.id_publisher); ddlGenero.SelectedValue = genre.description_genre; ddlEditor.SelectedValue = publisher.name_publisher; tbxTitulo.Text = game.title; tbxDataCompra.Text = Convert.ToDateTime(game.purchase_date).ToString("yyyy-MM-dd"); imgCapa.ImageUrl = "../../Content/CoverImages/" + game.cover_image; } }
void LoadGenreIntoCheckedList(CheckedListBox checkedList) { List <Genre> genreList = GenreDAO.GetListGenre(); checkedList.DataSource = genreList; checkedList.DisplayMember = "Name"; }
// GET: Genre //public ActionResult Index() //{ // return View(); //} //public ActionResult Register() //{ // if (Session["ModId"] != null) // { // ViewBag.Genre = new Genre(); // return View(); // } // return RedirectToAction("../Home/Index"); //} public ActionResult Index() { try { if (Session["ModId"] != null) { GenreDAO dao = new GenreDAO(); UserDAO udao = new UserDAO(); ModeratorDAO mdao = new ModeratorDAO(); ViewBag.Mod = mdao.SearchById(int.Parse(Session["ModId"].ToString())); User u = udao.SearchById(int.Parse(Session["Id"].ToString())); ViewBag.User = u; ViewBag.Genre = new Genre(); ViewBag.Genres = dao.List(); return(View()); } else { return(RedirectToAction("../Home/Index")); } } catch { return(RedirectToAction("Index", "Home")); } }
public ActionResult ApproveApp(int id) { try { if (Session["ModId"] != null) { UserDAO udao = new UserDAO(); User u = udao.SearchById(int.Parse(Session["Id"].ToString())); ImageDAO idao = new ImageDAO(); ApplicationDAO dao = new ApplicationDAO(); TypeAppDAO tdao = new TypeAppDAO(); GenreDAO gdao = new GenreDAO(); PegiDAO pdao = new PegiDAO(); ApplicationGenreDAO agdao = new ApplicationGenreDAO(); ViewBag.Types = tdao.List(); ViewBag.Pegis = pdao.List(); ViewBag.AppGens = agdao.ListByApplication(id); ViewBag.Genres = gdao.List(); ViewBag.User = u; ViewBag.App = dao.SearchById(id); ViewBag.Img = idao.SearchAppImages(id); return(View()); } return(RedirectToAction("Index", "Home")); } catch { return(RedirectToAction("Index", "Home")); } }
public List <GenreDTO> getAllGenres() { List <GenreDTO> genres = new List <GenreDTO>(); GenreDAO gDAO = new GenreDAO(); genres = gDAO.getAllFromDb(); return(genres); }
public ActionResult Index() { if (Session["username"] == null) { return(RedirectToAction("../Login/Index")); } return(View(GenreDAO.FindAll())); }
public ActionResult Update(int Id) { if (Session["username"] == null) { return(RedirectToAction("../Login/Index")); } //retorna para a view o objeto a ser atualizado return(View("Insert", GenreDAO.FindById(Id))); }
public ActionResult Inscription() { Utilisateur utilisateur = new Utilisateur(); VilleDao villeDao = new VilleDao(); GenreDAO genreDao = new GenreDAO(); ViewModelUtilisateur u = new ViewModelUtilisateur(utilisateur, villeDao, genreDao); return(View(u)); }
public ActionResult Insert() { if (Session["username"] == null) { return(RedirectToAction("../Login/Index")); } ViewBag.Genre = GenreDAO.FindAll(); return(View(new Movie())); }
void DeleteGenre(string id) { if (GenreDAO.DeleteGenre(id)) { MessageBox.Show("Xóa thể loại thành công"); } else { MessageBox.Show("Xóa thể loại thất bại"); } }
void InsertGenre(string id, string name, string desc) { if (GenreDAO.InsertGenre(id, name, desc)) { MessageBox.Show("Thêm thể loại thành công"); } else { MessageBox.Show("Thêm thể loại thất bại"); } }
void UpdateGenre(string id, string name, string desc) { if (GenreDAO.UpdateGenre(id, name, desc)) { MessageBox.Show("Sửa thể loại thành công"); } else { MessageBox.Show("Sửa thể loại thất bại"); } }
public static GenreDAO GetGenreDAO() { if (GenreDAO == null) { GenreSqlCeDAOImpl genreDAOImpl = new GenreSqlCeDAOImpl(); genreDAOImpl.dbContext = DBContextProvider.getDBContext(); GenreDAO = genreDAOImpl; } return GenreDAO; }
private void SaveGenreCommandAction(Object paramter) { if (!String.IsNullOrEmpty(Genre.Name)) { GenreDAO.AddGenre(Genre); OnCloseDialog(new DialogEventArgs(true)); } else { OnCloseDialog(new DialogEventArgs(false)); } }
public PartialViewResult _GenreGameRightSide() { GenreDAO gdao = new GenreDAO(); ApplicationDAO appdao = new ApplicationDAO(); IList <Genre> g = gdao.GetTop10(); ViewBag.GenreSide = g; IList <Application> a = appdao.GetTop5(); ViewBag.AppsSide = a; return(PartialView()); }
public Album(string name, string releaseYear, string genre, string interpret, string coverpath) { InterpretDAO iDAO = new InterpretDAO(); GenreDAO gDAO = new GenreDAO(); this.name = name; this.releaseYear = releaseYear; this.genre = gDAO.getIdFromDb(genre); this.interpret = iDAO.getIdFromDb(interpret); this.coverpath = coverpath; AlbumDTO aDTO = new AlbumDTO(name, releaseYear, this.genre, this.interpret, coverpath); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ddlEditor.DataSource = PublisherDAO.getPublishers(); ddlEditor.DataValueField = "id_publisher"; ddlEditor.DataTextField = "name_publisher"; ddlEditor.DataBind(); ddlGenero.DataSource = GenreDAO.getGenres(); ddlGenero.DataValueField = "id_genre"; ddlGenero.DataTextField = "description_genre"; ddlGenero.DataBind(); } }
public ActionResult Insert(Movie movie) { if (Session["username"] == null) { return(RedirectToAction("../Login/Index")); } if (ModelState.IsValid) { //insere novo ou edita filme no DB MovieDAO.Insert(movie); return(View("Index", MovieDAO.FindAll())); } ViewBag.Genre = GenreDAO.FindAll(); return(View("Insert", movie)); }
public GenrePage() { InitializeComponent(); var connection = new ConnectionFactory(SqlServerConfiguration.Settings).GetConnection(typeof(SqlServerConnection)); genreDAO = new DAOFactory(connection).GetConnection(typeof(GenreDAO)) as GenreDAO; observer = new Observer(GetAll_Click); genreDAO.AddObserver(observer); Get_.Click += Get_Click; GetAll.Click += GetAll_Click; Add.Click += Add_Click; Update.Click += Update_Click; Delete.Click += Delete_Click; }
public object GetConnection(Type type) { if (type == typeof(AuthorDAO)) { return(AuthorDAO.GetInstance(connection)); } else if (type == typeof(WorkDAO)) { return(WorkDAO.GetInstance(connection)); } else if (type == typeof(GenreDAO)) { return(GenreDAO.GetInstance(connection)); } return(null); }
public DAOStorage( CompanyDAO companyDAO, FormatDAO formatDAO, GenreDAO genreDAO, PosterDAO posterDAO, QualityDAO qualityDAO, MovieDAO movieDAO, PosterImageDAO posterImageDAO ) { CompanyDAO = companyDAO; FormatDAO = formatDAO; GenreDAO = genreDAO; PosterDAO = posterDAO; QualityDAO = qualityDAO; MovieDAO = movieDAO; PosterImageDAO = posterImageDAO; }
public PartialViewResult GenreIndex() { if (Session["ModId"] != null) { GenreDAO dao = new GenreDAO(); UserDAO udao = new UserDAO(); ModeratorDAO mdao = new ModeratorDAO(); ViewBag.Mod = mdao.SearchById(int.Parse(Session["ModId"].ToString())); User u = udao.SearchById(int.Parse(Session["Id"].ToString())); ViewBag.User = u; ViewBag.Genre = new Genre(); ViewBag.Genres = dao.List(); return(PartialView()); } else { return(PartialView()); } }
public AlbumGUI(MainGUI m) { this.m = m; this.a = m.A; dt_list.Columns.Add(new DataColumn("albumid", typeof(int))); dt_list.Columns.Add(new DataColumn("title", typeof(string))); dt_list.Columns.Add(new DataColumn("price", typeof(float))); dt_list.Columns.Add(new DataColumn("albumurl", typeof(string))); dt_list.Columns.Add(new DataColumn("amount", typeof(int))); InitializeComponent(); //get Genres DataTable dt = GenreDAO.getAllGenres(); DataRow r = dt.NewRow(); r["genreid"] = -1; r["name"] = "----- ALL -----"; dt.Rows.Add(r); comboBox1.DataSource = dt; comboBox1.DisplayMember = "name"; comboBox1.ValueMember = "genreid"; comboBox1.SelectedIndex = dt.Rows.Count - 1; // get Arits DataTable dt1 = ArtistDAO.getAllArtist(); DataRow r1 = dt1.NewRow(); r1["artistid"] = -1; r1["name"] = "----- ALL -----"; dt1.Rows.Add(r1); comboBox2.DataSource = dt1; comboBox2.DisplayMember = "name"; comboBox2.ValueMember = "artistid"; comboBox2.SelectedIndex = dt1.Rows.Count - 1; loadData(); }
public ActionResult Delete(int[] Id) { if (Session["username"] == null) { return(RedirectToAction("../Login/Index")); } if (Id == null) { ModelState.AddModelError("", "Nenhum item foi selecionado para deletar"); } if (ModelState.IsValid) { GenreDAO.Delete(Id); } return(View("Index", GenreDAO.FindAll())); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id_game = Convert.ToInt32(Request.QueryString["id_game"]); if (id_game == 0) { Response.Redirect("~/Games/GameLibraryPL/GameLibrary.aspx"); } Game game = GameDAO.GetGame(id_game); lbAmountPaid.Text = game.amount_paid.ToString(); Genre genre = GenreDAO.GetGenre(game.id_genre); Publisher publisher = PublisherDAO.GetPublisher(game.id_publisher); lbGenre.Text = genre.description_genre; lbPublisher.Text = publisher.name_publisher; lbTitle.Text = game.title; lbPurchaseDate.Text = Convert.ToDateTime(game.purchase_date).ToString("dd-MM-yyyy"); imageCapa.ImageUrl = "../../Content/CoverImages/" + game.cover_image; } }
public EditBooksController() { BookDAO = BookDAOFactory.GetBookDAO(); AuthorDAO = AuthorDAOFactory.GetAuthorDAO(); GenreDAO = GenreDAOFactory.GetGenreDAO(); }
public LibraryController() { BookDAO = BookDAOFactory.GetBookDAO(); AuthorDAO = AuthorDAOFactory.GetAuthorDAO(); GenreDAO = GenreDAOFactory.GetGenreDAO(); }