protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["UserName"] != null) { String usrName = Request.QueryString["UserName"].ToString(); using (eYillikEntities veri = new eYillikEntities()) { try { var kullanici = veri.sys_ProfilSayfasiGetir(usrName).FirstOrDefault(); imgAvatar.ImageUrl = kullanici.UserPicture; spKullaniciAdi.Text = kullanici.UserName + " " + kullanici.UserSurname; hypFacebook.NavigateUrl = kullanici.UserFacebook; hypLinkedin.NavigateUrl = kullanici.UserLinkedin; hypPlus.NavigateUrl = kullanici.UserGooglePlus; hypTwitter.NavigateUrl = kullanici.UserTwitter; hypGithub.NavigateUrl = kullanici.UserGithub; hypPinterest.NavigateUrl = kullanici.UserPinterest; lblKisisel.Text = kullanici.UserPersonal; lblDostlar.Text = kullanici.UserFriend; lblTavsiye.Text = kullanici.UserRecommend; lblYeniden.Text = kullanici.UserRetry; } catch { } } } else Response.Redirect("~/Student/Profile.aspx"); } }
protected void drpSirala_SelectedIndexChanged(object sender, EventArgs e) { if (drpSirala.SelectedIndex == 1) { using (eYillikEntities veri = new eYillikEntities()) { try { var album = veri.sys_AlbumResimleriniGetir(drpAlbum.SelectedItem.ToString()); rptGaleri.DataSource = album.ToList().OrderByDescending(x => x.AlbumName); rptGaleri.DataBind(); } catch (Exception) { } } } else { using (eYillikEntities veri = new eYillikEntities()) { try { var album = veri.sys_AlbumResimleriniGetir(drpAlbum.SelectedItem.ToString()); rptGaleri.DataSource = album.ToList().OrderBy(x => x.AlbumName); rptGaleri.DataBind(); } catch (Exception) { } } } }
protected void btnYorum_Click(object sender, EventArgs e) { try { String toUsr = ""; String fromUsr = ""; SqlConnection conn = new SqlConnection(@"Server=.\sqlexpress;Database=eYillik;Trusted_Connection=True;"); SqlCommand cmd1 = new SqlCommand("Select UserId from sys_Users where UserNumber = '" + Request.QueryString["UserName"].ToString() + "'", conn); SqlCommand cmd2 = new SqlCommand("Select UserId from sys_Users where UserNumber = '" + User.Identity.Name + "'", conn); conn.Open(); SqlDataReader okuyucu1 = cmd1.ExecuteReader(); if (okuyucu1.Read()) { toUsr = okuyucu1["UserId"].ToString(); } okuyucu1.Close(); SqlDataReader okuyucu2 = cmd2.ExecuteReader(); if (okuyucu2.Read()) { fromUsr = okuyucu2["UserId"].ToString(); } okuyucu2.Close(); conn.Close(); using (eYillikEntities veri = new eYillikEntities()) { sys_Remembers ani = new sys_Remembers() { ToUser = Guid.Parse(toUsr), FromUser = Guid.Parse(fromUsr), RememberContent = txtYorum.Text }; veri.sys_Remembers.Add(ani); veri.SaveChanges(); } txtYorum.Text = ""; } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { using (eYillikEntities veri = new eYillikEntities()) { try { var album = veri.sys_AlbumleriGetir().ToList(); for (int i = 0; i < album.Count; i++) { drpAlbum.Items.Add(album[i].ToString()); } var galeri = veri.sys_AlbumResimleriniGetir(drpAlbum.SelectedItem.ToString()); rptGaleri.DataSource = galeri.ToList(); rptGaleri.DataBind(); } catch (Exception) { } } }
protected void Page_Load(object sender, EventArgs e) { using (eYillikEntities veri = new eYillikEntities()) { try { var kullanici = veri.sys_ProfilSayfasiGetir(User.Identity.Name).FirstOrDefault(); imgAvatar.ImageUrl = kullanici.UserPicture; spKullaniciAdi.Text = kullanici.UserName + " " + kullanici.UserSurname; hypFacebook.NavigateUrl = kullanici.UserFacebook; hypLinkedin.NavigateUrl = kullanici.UserLinkedin; hypPlus.NavigateUrl = kullanici.UserGooglePlus; hypTwitter.NavigateUrl = kullanici.UserTwitter; hypGithub.NavigateUrl = kullanici.UserGithub; hypPinterest.NavigateUrl = kullanici.UserPinterest; lblKisisel.Text = kullanici.UserPersonal; lblDostlar.Text = kullanici.UserFriend; lblTavsiye.Text = kullanici.UserRecommend; lblYeniden.Text = kullanici.UserRetry; username.Text = User.Identity.Name; firstname.Text = kullanici.UserName; lastname.Text = kullanici.UserSurname; SqlConnection conn = new SqlConnection(@"Server=.\sqlexpress;Database=eYillik;Trusted_Connection=True;"); SqlCommand cmd1 = new SqlCommand("Select RememberContent from sys_Remembers as r inner join sys_Users as u on u.UserId = r.ToUser where u.UserNumber = '" + User.Identity.Name + "'", conn); SqlDataAdapter da = new SqlDataAdapter(cmd1); DataSet ds = new DataSet(); da.Fill(ds, "sys_Remember"); rptAni.DataSource = ds.Tables["sys_Remember"]; rptAni.DataBind(); } catch { } } }