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