protected void Page_Load(object sender, EventArgs e) { if (!System.Web.HttpContext.Current.User.Identity.IsAuthenticated) { Response.Redirect("index.aspx"); } BeatsEntities db = new BeatsEntities(); GridView1.Visible = true; GridView2.Visible = false; if (Request.QueryString["mode"] == null) { var res = (from ch in db.channels select new { Name = ch.channel_name, ID = ch.channel_id, Description = ch.channel_description, Followers = ch.follow }).ToList(); GridView1.DataSource = res; GridView1.DataBind(); } if (Request.QueryString["mode"] != null) { string query = Request.QueryString["mode"]; var res = (from ch in db.channels where ch.channel_name.Contains(query) select new { Name = ch.channel_name, ID = ch.channel_id, Description = ch.channel_description, Followers = ch.follow }).ToList(); GridView2.DataSource = res; GridView2.DataBind(); GridView2.Visible = true; GridView1.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { using (BeatsEntities db = new BeatsEntities()) { if (Request.QueryString["id"] == null) { Response.Redirect("index.aspx"); } if (Request.QueryString["id"] != null) { id = Int32.Parse(Request.QueryString["id"]); var path = from pt in db.song_add join sg in db.songs on pt.song_id equals sg.song_id where pt.song_id == id select new { album = sg.album, songpath = pt.path, name = sg.track, artist = sg.artist, ratings = sg.song_rating }; foreach (var q in path) { string str = "<audio controls onended ='callme()'>"; str += "<source src='" + q.songpath + "'type='audio/mpeg'"; str += "</audio>"; Response.Write("Track Name:" + q.name + "<br>"); Response.Write("Artist Name:" + q.artist + "<br>"); Response.Write("Album Name:" + q.album + "<br>"); Response.Write("Ratings:" + q.ratings + "<br>"); Response.Write(str); //checking the rating and inserting into database } } } }
protected void Button1_Click(object sender, EventArgs e) { BeatsEntities db = new BeatsEntities(); string msg = "Please try another name"; user u2 = db.users.Where(u1 => u1.username == TextBox1.Text).FirstOrDefault(); admin ad = db.admins.Where(a => a.username == TextBox1.Text).FirstOrDefault(); if (u2 != null || ad != null) { Response.Redirect("register.aspx?res=" + msg); } user u = new user(); u.username = TextBox1.Text; u.password = TextBox2.Text; u.security_ques = TextBox4.Text; u.security_ans = TextBox5.Text; db.users.Add(u); db.SaveChanges(); Response.Redirect("index.aspx?Login=" + true); }
protected void Page_Load(object sender, EventArgs e) { BeatsEntities db = new BeatsEntities(); user usr = db.users.Where(u => u.username == System.Web.HttpContext.Current.User.Identity.Name).FirstOrDefault(); if (usr == null) { Response.Redirect("index.aspx"); } var p = from c in db.correlations where c.user1 == usr.user_id//&&c.factor>0 select new { User = c.user2, Correlation = c.factor }; var q = from c in db.correlations where c.user2 == usr.user_id //&&c.factor>0 //orderby c.factor descending select new { User = c.user1, Correlation = c.factor }; var alluserswithfactormorethanzero = p.Union(q); List <sg> ls = new List <sg>(); //getting history of loggged in user var historyloggeduser = from g in db.histories where g.user_id == usr.user_id select new { Id = g.song_id, Ratings = g.ratings }; //getting songlist,userid,ratings as given by the user,and correlation with everyuser of song i haven't heard foreach (var s in alluserswithfactormorethanzero) { var historyuser = from g in db.histories where g.user_id == s.User select new { Id = g.song_id, Ratings = g.ratings }; foreach (var hist in historyuser) { //checking if the song is heard by the logged in user var s1 = db.histories.Where(h => h.song_id == hist.Id && h.user_id == usr.user_id).FirstOrDefault(); if (s1 == null) { sg sg1 = new sg(); sg1.sgid = hist.Id; //this is songid sg1.correlid = s.Correlation; //this is correl factor sg1.usrratings = (int)hist.Ratings; ls.Add(sg1); } } double totalratings = 0; double finalratings = 0; var songidwithcount = from l in ls group l by l.sgid into songID select new { Count = songID.Count(), identity = songID.Key }; //getting list of songs with their songid List <sgg> finalsongs = new List <sgg>(); foreach (var z in songidwithcount) { totalratings = 0; var n = from l in ls where l.sgid == z.identity select new { rate = l.usrratings, fact = l.correlid }; foreach (var g in n) { totalratings = totalratings + g.rate * g.fact; } finalratings = totalratings / z.Count; if (finalratings > 0) { sgg s1 = new sgg(); s1.songid = z.identity; s1.songrate = finalratings; finalsongs.Add(s1); } } List <track> tnew = new List <track> (); foreach (var fs in finalsongs) { song ss = db.songs.Where(sn => sn.song_id == fs.songid).FirstOrDefault(); track tr = new track(); if (ss != null) { tr.SongId = fs.songid; tr.Trackname = ss.track; tr.Artist = ss.artist; tr.RecommendedRating = fs.songrate; } tnew.Add(tr); } GridView1.DataSource = tnew; GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { BeatsEntities db = new BeatsEntities(); string user1 = System.Web.HttpContext.Current.User.Identity.Name; if (Request.QueryString["rating"] != null) { int songid = Int32.Parse(Request.QueryString["songid"]); int rating = Int32.Parse(Request.QueryString["rating"]); //getting user name //to get song s of songid id so that we can update count,counttoday,and ratings of that song if (rating <= 10 && rating >= 0) { song s1 = db.songs.Where(y => y.song_id == songid).FirstOrDefault(); s1.count++; s1.counttoday++; s1.song_rating = (s1.song_rating * (s1.count - 1) + Int32.Parse(Request.QueryString["rating"])) / s1.count; db.SaveChanges(); user us = db.users.Where(s => s.username == user1).FirstOrDefault(); if (us != null) { history h = db.histories.Where(s => s.user_id == us.user_id && s.song_id == songid).FirstOrDefault(); //checking if user has previously listened the song and then updating the count only else updating the database if (h == null) { history h1 = new history(); h1.song_id = songid; h1.user_id = us.user_id; h1.count = 1; h1.ratings = Int32.Parse(Request.QueryString["rating"]); h1.time = DateTime.Now; db.histories.Add(h1); } if (h != null) { h.count = h.count + 1; h.time = DateTime.Now; h.ratings = Int32.Parse(Request.QueryString["rating"]); } db.SaveChanges(); List <double> r1 = new List <double>(); List <double> r2 = new List <double>(); int primary = 0, secondary = 0; foreach (user u in db.users) { if (u.user_id != us.user_id) { if (u.user_id > us.user_id) { secondary = u.user_id; primary = us.user_id; } if (u.user_id < us.user_id) { secondary = us.user_id; primary = u.user_id; } //getting histories var p1 = (from h1 in db.histories where h1.user_id == primary select new { Song = h1.song_id, rating = h1.ratings }).ToList(); var p2 = (from h1 in db.histories where h1.user_id == secondary select new { Song = h1.song_id, rating = h1.ratings }).ToList(); //getting rating of common songs foreach (var p in p1) { foreach (var q in p2) { if (p.Song == q.Song) { r1.Add((double)p.rating); r2.Add((double)q.rating); } } } if (!(r1.Count == 0 || r2.Count == 0)) { double correl1 = Correlation.Pearson(r1, r2); if (!(Double.IsNaN(correl1))) { r1.Clear(); r2.Clear(); correlation c = db.correlations.Where(c1 => c1.user1 == primary && c1.user2 == secondary).FirstOrDefault(); if (c == null) { correlation c2 = new correlation(); c2.user1 = primary; c2.user2 = secondary; c2.factor = (float)correl1; db.correlations.Add(c2); } if (c != null) { c.factor = (float)correl1; } } } } } db.SaveChanges(); Response.Redirect("index.aspx"); } else { Response.Redirect("index.aspx"); } } } }