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 { }
}
}
