protected List <Marka> UrunMarkalari(List <Urun> _urunler, ModalDataContext _data)
{
return((from m in _data.Markas
where (from u in _urunler
select u.MarkaID).Contains(m.MarkaID)
select m).OrderByDescending(m => m.Uruns.Count).ToList());
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UyeID"] != null)
{
int uye_id = -1;
if (Int32.TryParse(Session["UyeID"].ToString(), out uye_id))
{
ModalDataContext data = new ModalDataContext();
Uye uye = data.Uyes.FirstOrDefault(u => u.UyeID == uye_id);
if (uye != null)
{
if (!((bool)uye.UrunGirmeDuzenleme))
{
Response.Redirect("AdminPanel.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Session["UyeID"] = null; Session["KullaniciAdi"] = null; Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
public static void Begen(string urunid, string uyeid)
{
ModalDataContext data = new ModalDataContext();
try
{
int urun_id = Int32.Parse(urunid), uye_id = Int32.Parse(uyeid);
UrunPuan urunPuan = data.UrunPuans.FirstOrDefault(up => up.UyeID == uye_id && up.UrunID == urun_id);
if (urunPuan != null)
{
urunPuan.Begeni = true;
data.SubmitChanges();
}
else
{
urunPuan = new UrunPuan();
urunPuan.UrunID = urun_id;
urunPuan.UyeID = uye_id;
urunPuan.Begeni = true;
urunPuan.FiyatPuani = -1;
urunPuan.DegerPuani = -1;
urunPuan.KalitePuani = -1;
urunPuan.Yorum = "";
urunPuan.Baslik = "";
data.UrunPuans.InsertOnSubmit(urunPuan);
data.SubmitChanges();
}
}
catch
{
}
}
protected List <UrunGrubu> UrunGruplari(List <Urun> _urunler, ModalDataContext _data)
{
return((from ug in _data.UrunGrubus
where (from u in _urunler
select u.GrupID).Contains(ug.GrupID)
select ug).OrderByDescending(ug => ug.Uruns.Count).ToList());
}
private void Button_send_comment_ServerClick(object sender, EventArgs e)
{
ModalDataContext data = new ModalDataContext();
int blog_id = -1;
if (Request.QueryString["BlogId"] != null)
{
string blog_id_str = Request.QueryString["BlogId"].ToString();
if (Int32.TryParse(blog_id_str, out blog_id))
{
if (Session["UyeID"] != null)
{
string uyeid_str = Session["UyeID"].ToString();
int uyeid = -1;
if (Int32.TryParse(uyeid_str, out uyeid))
{
Uye uye = data.Uyes.FirstOrDefault(u => u.UyeID == uyeid);
if (uye != null)
{
BlogYorum by = new BlogYorum();
by.UyeID = uye.UyeID;
by.Onaylanma = false;
by.BlogID = blog_id;
by.Tarih = DateTime.Now;
by.Yorum = txtComment.Text;
data.BlogYorums.InsertOnSubmit(by);
data.SubmitChanges();
}
}
}
}
}
}
protected void btnSil_Click(object sender, EventArgs e)
{
string _id = "";
if (Request.QueryString["UrunID"] != null)
{
_id = Request.QueryString["UrunID"].ToString();
int id = -1;
if (Int32.TryParse(_id, out id))
{
ModalDataContext data = new ModalDataContext();
Urun urun = data.Uruns.FirstOrDefault(u => u.UrunID == id);
if (urun != null)
{
int faturalar = data.FaturaDetays.Where(fd => fd.UrunId == id).Count();
if (faturalar == 0)
{
data.UrunGorselis.DeleteAllOnSubmit(data.UrunGorselis.Where(ug => ug.UrunID == id));
data.UrunPuans.DeleteAllOnSubmit(data.UrunPuans.Where(up => up.UrunID == id));
data.RenkvsUruns.DeleteAllOnSubmit(data.RenkvsUruns.Where(ru => ru.UrunID == id));
data.UrunTags.DeleteAllOnSubmit(data.UrunTags.Where(ut => ut.UrunID == id));
data.BedenvsUruns.DeleteAllOnSubmit(data.BedenvsUruns.Where(bu => bu.UrunID == id));
data.OneCikanUrunlers.DeleteAllOnSubmit(data.OneCikanUrunlers.Where(ocu => ocu.UrunID == id));
data.Uruns.DeleteOnSubmit(urun);
data.SubmitChanges();
}
else
{
lblError.Text = "Faturalandırılmış bir ürünü silemezsiniz";
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UyeID"] != null)
{
int uye_id = -1;
if (Int32.TryParse(Session["UyeID"].ToString(), out uye_id))
{
ModalDataContext data = new ModalDataContext();
Uye uye = data.Uyes.FirstOrDefault(u => u.UyeID == uye_id);
if (uye != null)
{
if ((bool)uye.BlogYazmaDuzenleme)
{
if (Request.QueryString["BlogID"] != null)
{
string blog_id_str = Request.QueryString["BlogID"].ToString();
int blog_id;
if (Int32.TryParse(blog_id_str, out blog_id))
{
if (!IsPostBack)
{
if (!blogBilgileri(blog_id))
{
Response.Redirect("AdminPanel.aspx");
}
}
}
else
{
Response.Redirect("AdminPanel.aspx");
}
}
}
else
{
Response.Redirect("AdminPanel.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
public static void AdresDegistir(string uyeid, string yeniadres)
{
ModalDataContext data = new ModalDataContext();
int uye_id = -1;
if (Int32.TryParse(uyeid, out uye_id))
{
Musteri musteri = data.Musteris.FirstOrDefault(m => m.TcKimlik == data.Uyes.FirstOrDefault(u => u.UyeID == uye_id).TcKimlik);
musteri.Adres = yeniadres;
data.SubmitChanges();
}
}
protected void ddlKategoriler_SelectedIndexChanged(object sender, EventArgs e)
{
ModalDataContext data = new ModalDataContext();
string ktgr_str = ddlKategoriler.SelectedValue;
int ktgr = Convert.ToInt32(ktgr_str);
var grp = data.UrunGrubus.Where(ug => ug.KategoriID == ktgr).ToList();
ddlUrunGrubu.Items.Clear();
foreach (var g in grp)
{
ddlUrunGrubu.Items.Add(new ListItem(g.GrupAdi, g.GrupID.ToString()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
ModalDataContext data = new ModalDataContext();
string uye_id = (Session["UyeID"] == null ? null : Session["UyeID"].ToString());
if (uye_id != null) // Kayıtlı üye olarak
{
Uye kayitli_uye = data.Uyes.FirstOrDefault(u => u.UyeID.ToString() == uye_id);
string ad_soyad = kayitli_uye.AdSoyad;
string[] ad__soyad = ad_soyad.Split(' ');
string soyad = ad__soyad[ad__soyad.Length - 1];
txtLastName.Text = soyad; txtLastName.ReadOnly = true;
txtFirstName.Text = ad_soyad.Replace(" " + soyad, ""); txtFirstName.ReadOnly = true;
txtEmailBilling.Text = kayitli_uye.Mail;
txtTCKimlik.Text = kayitli_uye.TcKimlik; txtTCKimlik.ReadOnly = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int uyeid = -1;
if (Session["UyeID"] != null)
{
if (Int32.TryParse(Session["UyeID"].ToString(), out uyeid))
{
ModalDataContext data = new ModalDataContext();
Uye uye = data.Uyes.FirstOrDefault(u => u.UyeID == uyeid);
if (uye != null)
{
bool yetki = (bool)uye.UrunGirmeDuzenleme || (bool)uye.UrunSilme ||
(bool)uye.BlogYazmaDuzenleme || (bool)uye.BlogYonetme || (bool)uye.Yetkilendirme ||
(bool)uye.SiteUnsurlari || (bool)uye.FaturaIslemleri;
if (yetki)
{
sKullanici.InnerText = Session["KullaniciAdi"] != null ? Session["KullaniciAdi"].ToString() : "";
}
else
{
Response.Redirect("Default.aspx");
}
}
else
{
Session["UyeID"] = null; Session["KullaniciAdi"] = null; Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
protected string BlogYaz(Blog _blog, ModalDataContext _data)
{
string gun, ay;
gun = ((DateTime)_blog.Tarih).ToString("dd");
ay = ((DateTime)_blog.Tarih).ToString("MM");
ay = aylar_array[Convert.ToInt32(ay) - 1];
Uye yazar = _data.Uyes.FirstOrDefault(u => u.UyeID == _blog.UyeID);
string[] taglar = _blog.BlogTags.Select(bt => ("<a href = \"Blog-Details.aspx?tag=" + bt.Tag.TagID + "\" rel=\"category tag\">" + bt.Tag.TagAdi + "</a>")).ToArray();
string _taglar = String.Join(", ", taglar);
string blog_inner = "<div class=\"single-blog fix\">" +
"<div class=\"post-thumbnail\">" +
"<a href=\"Blog-Details.aspx?BlogId=" + _blog.BlogID + "\"><img src=\"" + _blog.BlogResmi + "\" alt=\"\" /></a>" +
"</div>" +
"<div class=\"postinfo-wrapper\">" +
"<div class=\"post-date\">" +
"<span class=\"day\">" + gun + "</span><span class=\"month\">" + ay + "</span>" +
"</div>" +
"<div class=\"post-info\">" +
"<h1 class=\"blog-post-title\">" +
"<a href=\"Blog-Details.aspx?BlogId=" + _blog.BlogID + "\">" + _blog.BlogAdi + "</a>" +
"</h1>" +
"<div class=\"entry-meta\">" +
"<span class=\"author vcard\"><a class=\"url fn n\" href=\"Blog.aspx?auth=" + yazar.UyeID + "\" title=\"\" rel=\"author\">" + yazar.KullaniciAdi + "</a></span> tarafından yazıldı. / " + _taglar +
"</div>" +
"<div class=\"entry-summary\">" +
"<p>" + _blog.OnBilgi + "</p>" +
"</div>" +
"<a class=\"read-button\" href=\"Blog-Details.aspx?BlogId=" + _blog.BlogID + "\"><span>Devamı</span></a>" +
"</div>" +
"</div>" +
"</div>";
return(blog_inner);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UyeID"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
int uye_id = -1;
if (Int32.TryParse(Session["UyeID"].ToString(), out uye_id))
{
ModalDataContext data = new ModalDataContext();
Uye uye = data.Uyes.FirstOrDefault(u => u.UyeID == uye_id);
Musteri musteri = data.Musteris.FirstOrDefault(m => m.TcKimlik == uye.TcKimlik);
List <Fatura> faturalar = data.Faturas.Where(f => f.Musteri.TcKimlik == musteri.TcKimlik).ToList();
string faturalar_div_inner_html = "";
foreach (Fatura f in faturalar)
{
faturalar_div_inner_html += f.Tarih != null ? ((DateTime)f.Tarih).ToString() : "";
faturalar_div_inner_html += "<br><br><table>";
foreach (FaturaDetay fd in f.FaturaDetays)
{
faturalar_div_inner_html += "<tr><td style=\"min-width:200px;\"><strong>" + fd.Urun.UrunAdi + "</strong></td>";
faturalar_div_inner_html += "<td style=\"min-width:80px;\"><span>" + fd.Miktar + " adet </span>";
faturalar_div_inner_html += "<td style=\"min-width:80px;\"><span>" + Convert.ToDouble(fd.Urun.BirimFiyat).ToString("0.00") + " ₺ </span></td>";
faturalar_div_inner_html += "<td style=\"min-width:80px;\"><span>" + Convert.ToDouble(fd.Miktar * fd.Urun.BirimFiyat).ToString("0.00") + " ₺ </span></td>";
faturalar_div_inner_html += "</tr>";
}
faturalar_div_inner_html += "</table><br>Toplam Tutar: ";
faturalar_div_inner_html += f.ToplamTutar != null?Convert.ToDouble(f.ToplamTutar).ToString("0.00") : "";
faturalar_div_inner_html += "<br><br><hr>";
}
faturalar_div.InnerHtml = faturalar_div_inner_html;
adres_div_p.InnerText = musteri.Adres;
}
}
}
protected void btnFaturaKaydet_Click(object sender, EventArgs e)
{
ModalDataContext data = new ModalDataContext();
try
{
string uye_id = (Session["UyeID"] == null ? null : Session["UyeID"].ToString());
string tc_kimlik = null;
if (uye_id != null) // Kayıtlı üye olarak
{
Uye kayitli_uye = data.Uyes.FirstOrDefault(u => u.UyeID.ToString() == uye_id);
if (kayitli_uye != null)
{
string ad_soyad = kayitli_uye.AdSoyad;
string[] ad__soyad = ad_soyad.Split(' ');
string soyad = ad__soyad[ad__soyad.Length - 1];
txtLastName.Text = soyad; txtLastName.ReadOnly = true;
txtFirstName.Text = ad_soyad.Replace(" " + soyad, ""); txtFirstName.ReadOnly = true;
txtEmailBilling.Text = kayitli_uye.Mail;
txtTCKimlik.Text = kayitli_uye.TcKimlik; txtTCKimlik.ReadOnly = true;
tc_kimlik = kayitli_uye.TcKimlik;
}
else
{
Response.Write("<script>Oturumunuzun açık olduğundan emin olun</script>");
return;
}
}
else // Misafir Olarak
{
tc_kimlik = txtTCKimlik.Text;
Musteri misafir_musteri = data.Musteris.FirstOrDefault(m => m.TcKimlik == tc_kimlik);
if (misafir_musteri != null)
{
Uye misafir_uye = data.Uyes.FirstOrDefault(u => u.TcKimlik == tc_kimlik);
if (misafir_uye == null)
{
Response.Write("<script>Misafir üye bilgisi bulunamadı</script>"); return;
}
else
{
if (!misafir_uye.KullaniciAdi.Contains("_misafir"))
{
Response.Write("<script>Girilen tc kimlik numarası kayıtlıdır</script>"); return;
}
}
}
else
{
misafir_musteri = new Musteri();
misafir_musteri.Adres = txtAddress1.Text + " " + txtAddress2.Text;
misafir_musteri.Telefon = txtTelephone.Text;
misafir_musteri.TcKimlik = tc_kimlik;
misafir_musteri.AdSoyad = txtFirstName.Text + " " + txtLastName.Text;
misafir_musteri.Kurum = txtCompany.Text;
misafir_musteri.Email = txtEmailBilling.Text;
data.Musteris.InsertOnSubmit(misafir_musteri);
Uye misafir_uye = new Uye();
misafir_uye.TcKimlik = tc_kimlik;
misafir_uye.AdSoyad = txtFirstName.Text + " " + txtLastName.Text;
misafir_uye.KullaniciAdi = "_misafir" + misafir_musteri.TcKimlik;
misafir_uye.Mail = txtEmailBilling.Text;
data.Uyes.InsertOnSubmit(misafir_uye);
}
}
DataTable sepet = new DataTable();
sepet = (DataTable)HttpContext.Current.Session["sepet"];
if (sepet != null)
{
Fatura yeniFatura = new Fatura();
yeniFatura.TcKimlik = tc_kimlik;
yeniFatura.KargoID = int.Parse(ddlKargo.SelectedValue);
yeniFatura.Tarih = DateTime.Now;
yeniFatura.OdemeSekli = "Kredi Kartı";
yeniFatura.KdvOrani = 0.08f;
data.Faturas.InsertOnSubmit(yeniFatura);
data.SubmitChanges();
for (int i = 0; i < sepet.Rows.Count; i++)
{
FaturaDetay yeniDetay = new FaturaDetay();
yeniDetay.FaturaID = yeniFatura.FaturaID;
yeniDetay.UrunId = Convert.ToInt32(sepet.Rows[i]["UrunID"]);
yeniDetay.Miktar = Convert.ToInt32(sepet.Rows[i]["Miktar"]);
data.FaturaDetays.InsertOnSubmit(yeniDetay);
}
data.SubmitChanges();
HttpContext.Current.Session["sepet"] = null;
}
else
{
Response.Write("<script>Sepetiniz boş</script>"); return;
}
}
catch
{
Response.Write("<script>Bir hata oluştu</script>"); return;
}
Response.Redirect("Checkout.aspx");
}
protected void btnGonder_Click(object sender, EventArgs e)
{
ModalDataContext data = new ModalDataContext();
try
{
bool oturum = Session["UyeID"] != null;
if (oturum)
{
string baslik = txtBaslik.Text, yorum = txtYorum.Text;
double _fiyatPuan = -1, _urunPuan = -1, _kalitePuan = -1;
if (FiyatPuan5.Checked)
{
_fiyatPuan = 5.0;
}
else if (FiyatPuan4.Checked)
{
_fiyatPuan = 4.0;
}
else if (FiyatPuan3.Checked)
{
_fiyatPuan = 3.0;
}
else if (FiyatPuan2.Checked)
{
_fiyatPuan = 2.0;
}
else if (FiyatPuan1.Checked)
{
_fiyatPuan = 1.0;
}
if (UrunPuan5.Checked)
{
_urunPuan = 5.0;
}
else if (UrunPuan4.Checked)
{
_urunPuan = 4.0;
}
else if (UrunPuan3.Checked)
{
_urunPuan = 3.0;
}
else if (UrunPuan2.Checked)
{
_urunPuan = 2.0;
}
else if (UrunPuan1.Checked)
{
_urunPuan = 1.0;
}
if (KalitePuan5.Checked)
{
_kalitePuan = 5.0;
}
else if (KalitePuan4.Checked)
{
_kalitePuan = 4.0;
}
else if (KalitePuan3.Checked)
{
_kalitePuan = 3.0;
}
else if (KalitePuan2.Checked)
{
_kalitePuan = 2.0;
}
else if (KalitePuan1.Checked)
{
_kalitePuan = 1.0;
}
int urunID = Convert.ToInt32(Request.QueryString["UrunId"]), uyeID = Convert.ToInt32(Session["UyeID"].ToString());
UrunPuan urunPuan = data.UrunPuans.FirstOrDefault(up => up.UrunID == urunID && up.UyeID == uyeID);
if (urunPuan != null)
{
urunPuan.Yorum = yorum; urunPuan.Baslik = baslik; urunPuan.Tarih = DateTime.Now;
urunPuan.FiyatPuani = _fiyatPuan; urunPuan.DegerPuani = _urunPuan; urunPuan.KalitePuani = _kalitePuan;
}
else
{
urunPuan = new UrunPuan();
urunPuan.UrunID = urunID; urunPuan.UyeID = uyeID;
urunPuan.Yorum = yorum; urunPuan.Baslik = baslik; urunPuan.Tarih = DateTime.Now;
urunPuan.FiyatPuani = _fiyatPuan; urunPuan.DegerPuani = _urunPuan; urunPuan.KalitePuani = _kalitePuan;
urunPuan.Begeni = false;
data.UrunPuans.InsertOnSubmit(urunPuan);
}
data.SubmitChanges();
}
else
{
Response.Redirect("Login.aspx");
}
}
catch (Exception)
{
Response.Redirect("NotFound404.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
search_text.ServerClick += search_text_ServerClick;
search_price.ServerClick += search_price_ServerClick;
ModalDataContext data = new ModalDataContext();
#region Filtreleme
UlFilters.InnerHtml = "";
int[] page_array = new int[9] {
1, 2, 3, 4, 5, 6, 7, 8, 9
}; int _page = 1;
string[] filters = new string[8] {
"ctgr", "grp", "clr", "mrk", "srch", "prc", "sz", "page"
};
int i = 0, c = filters.Length;
List <Urun> urunler = data.Uruns.ToList();
while (i < c)
{
try
{
string filter = filters[i];
if (Request.QueryString[filter] != null)
{
if (i == 0) // Kategori Sorgulama
{
int id = 0;
if (Int32.TryParse(Request.QueryString[filter], out id))
{
urunler = urunler.Where(u => data.UrunGrubus.Where(ug => ug.KategoriID == id).Contains(u.UrunGrubu)).ToList();
string kategori_adi = data.Kategoris.FirstOrDefault(k => k.KategoriID == id).KategoriAdi;
h2KategoriGrup.InnerText = kategori_adi;
HtmlGenericControl li = new HtmlGenericControl("li");
Button button = new Button();
button.CssClass = "btn-link";
button.Text = " Kategori: " + kategori_adi;
button.ID = "filter_ctgr";
button.Click += button_Click;
HtmlGenericControl i_ = new HtmlGenericControl("i");
i_.Attributes.Add("class", "fa fa-remove");
button.Controls.Add(i_);
li.Controls.Add(button);
UlFilters.Controls.Add(li);
}
else
{
i++; continue;
}
}
else if (i == 1) // UrunGrubu Sorgulama
{
string _ids = Request.QueryString[filter];
string[] ids = _ids.Split('+', ' ');
int _i = 0, _c = ids.Length;
List <int> idList = new List <int>();
int id = 0;
while (_i < _c)
{
if (Int32.TryParse(ids[_i], out id))
{
idList.Add(id);
}
else
{
_i++; continue;
} _i++;
}
if (idList.Count > 0)
{
urunler = (from u in urunler
where (idList.Contains((int)u.GrupID))
select u).ToList();
HtmlGenericControl li = new HtmlGenericControl("li");
Button button = new Button();
button.CssClass = "btn-link";
button.Text = " Ürün Grubu: " + string.Join("+", data.UrunGrubus.Where(ug => idList.Contains(ug.GrupID)).Select(ug => ug.GrupAdi).ToArray());
button.ID = "filter_grp";
button.Click += button_Click;
HtmlGenericControl i_ = new HtmlGenericControl("i");
i_.Attributes.Add("class", "fa fa-remove");
button.Controls.Add(i_);
li.Controls.Add(button);
UlFilters.Controls.Add(li);
}
else
{
i++; continue;
}
}
else if (i == 2) // Renk Sorgulama
{
string _ids = Request.QueryString[filter];
string[] ids = _ids.Split('+', ' ');
int _i = 0, _c = ids.Length;
List <int> idList = new List <int>();
int id = 0;
while (_i < _c)
{
if (Int32.TryParse(ids[_i], out id))
{
idList.Add(id);
}
else
{
_i++; continue;
} _i++;
}
if (idList.Count > 0)
{
urunler = (from u in urunler
where (from ru in data.RenkvsUruns
where (idList.Contains((int)ru.RenkID))
select ru.UrunID).Contains(u.UrunID)
select u).ToList();
HtmlGenericControl li = new HtmlGenericControl("li");
Button button = new Button();
button.CssClass = "btn-link";
button.Text = " Renk: " + string.Join("+", data.Renks.Where(r => idList.Contains(r.RenkID)).Select(r => r.RenkAdi).ToArray());
button.ID = "filter_clr";
button.Click += button_Click;
HtmlGenericControl i_ = new HtmlGenericControl("i");
i_.Attributes.Add("class", "fa fa-remove");
button.Controls.Add(i_);
li.Controls.Add(button);
UlFilters.Controls.Add(li);
}
else
{
i++; continue;
}
}
else if (i == 3) // Marka Sorgulama
{
string _ids = Request.QueryString[filter];
string[] ids = _ids.Split('+', ' ');
int _i = 0, _c = ids.Length;
List <int> idList = new List <int>();
int id = 0;
while (_i < _c)
{
if (Int32.TryParse(ids[_i], out id))
{
idList.Add(id);
}
else
{
_i++; continue;
} _i++;
}
if (idList.Count > 0)
{
urunler = (from u in urunler
where (idList.Contains((int)u.MarkaID))
select u).ToList();
HtmlGenericControl li = new HtmlGenericControl("li");
Button button = new Button();
button.CssClass = "btn-link";
button.Text = " Marka: " + string.Join("+", data.Markas.Where(m => idList.Contains(m.MarkaID)).Select(m => m.MarkaAdi).ToArray());
button.ID = "filter_mrk";
button.Click += button_Click;
HtmlGenericControl i_ = new HtmlGenericControl("i");
i_.Attributes.Add("class", "fa fa-remove");
button.Controls.Add(i_);
li.Controls.Add(button);
UlFilters.Controls.Add(li);
}
else
{
i++; continue;
}
}
else if (i == 4) // İsim Sorgulama
{
string text = Request.QueryString[filter];
if (text.Length > 0)
{
string[] tags = text.Split('+', ' ');
urunler = (from u in urunler
where (from tag in tags
select u.UrunAdi.ToUpper().Contains(tag.ToUpper())).Any(b => b)
select u).ToList();
List <string[]> tagList = (from t in tags
select new string[2] {
t,
data.Tags.Select(tg => tg.TagAdi.ToUpper()).Contains(t.ToUpper()) ?
data.Tags.FirstOrDefault(tg => tg.TagAdi.ToUpper() == t.ToUpper()).TagID.ToString() :
"-1"
}).ToList();
foreach (string[] tag in tagList)
{
int tag_id = -1;
Int32.TryParse(tag[1], out tag_id);
if (tag_id == -1)
{
Tag yeniTag = new Tag();
yeniTag.TagAdi = tag[0];
yeniTag.TagAramaSayisi = 0;
data.Tags.InsertOnSubmit(yeniTag);
data.SubmitChanges();
}
else
{
Tag mevcutTag = data.Tags.FirstOrDefault(tg => tg.TagID == tag_id);
mevcutTag.TagAramaSayisi += 1;
data.SubmitChanges();
}
}
HtmlGenericControl li = new HtmlGenericControl("li");
Button button = new Button();
button.CssClass = "btn-link";
button.Text = " İsim: " + string.Join("+", tags);
button.ID = "filter_srch";
button.Click += button_Click;
HtmlGenericControl i_ = new HtmlGenericControl("i");
i_.Attributes.Add("class", "fa fa-remove");
button.Controls.Add(i_);
li.Controls.Add(button);
UlFilters.Controls.Add(li);
}
else
{
i++; continue;
}
}
else if (i == 5) // Fiyat Aralığı Sorgulama
{
string values = Request.QueryString[filter];
string[] two_values = values.Split('+', ' ');
if (two_values.Length == 2)
{
decimal taban, tavan;
if (Decimal.TryParse(two_values[0], out taban) && Decimal.TryParse(two_values[1], out tavan))
{
urunler = urunler.Where(u => u.BirimFiyat <= tavan && u.BirimFiyat >= taban).ToList();
HtmlGenericControl li = new HtmlGenericControl("li");
Button button = new Button();
button.CssClass = "btn-link";
button.Text = " Fiyat: " + string.Join("-", two_values);
button.ID = "filter_prc";
button.Click += button_Click;
HtmlGenericControl i_ = new HtmlGenericControl("i");
i_.Attributes.Add("class", "fa fa-remove");
button.Controls.Add(i_);
li.Controls.Add(button);
UlFilters.Controls.Add(li);
}
}
else
{
i++; continue;
}
}
else if (i == 6) // Beden Sorgulama
{
string _ids = Request.QueryString[filter];
string[] ids = _ids.Split('+', ' ');
int _i = 0, _c = ids.Length;
List <int> idList = new List <int>();
int id = 0;
while (_i < _c)
{
if (Int32.TryParse(ids[_i], out id))
{
idList.Add(id);
}
else
{
_i++; continue;
} _i++;
}
if (idList.Count > 0)
{
urunler = (from u in urunler
where (from bu in data.BedenvsUruns
where (idList.Contains((int)bu.BedenID))
select bu.UrunID).Contains(u.UrunID)
select u).ToList();
HtmlGenericControl li = new HtmlGenericControl("li");
Button button = new Button();
button.CssClass = "btn-link";
button.Text = " Beden: " + string.Join("+", data.Bedens.Where(b => idList.Contains(b.BedenID)).Select(b => b.BedenBoyu).ToArray());
button.ID = "filter_sz";
button.Click += button_Click;
HtmlGenericControl i_ = new HtmlGenericControl("i");
i_.Attributes.Add("class", "fa fa-remove");
button.Controls.Add(i_);
li.Controls.Add(button);
UlFilters.Controls.Add(li);
}
else
{
i++; continue;
}
}
else if (i == 7)
{
_page = 1;
if (!Int32.TryParse(Request.QueryString[filter], out _page))
{
int k = 0, f = page_array.Length;
while (k < f)
{
page_array[k] += _page > 3 ? (_page - 3) : 0; k++;
}
}
else
{
i++; continue;
}
}
}
}
catch
{
i++; continue;
}
i++;
}
#endregion
#region Sıralama Sayfalama
// Sıralama
if (IsPostBack)
{
Session["Siralama"] = ddlSort.SelectedValue; Session["SayfaUrunSayisi"] = ddlNumberOfPage.SelectedValue; Session.Timeout = 40;
}
string siralama = "sortByDate";
if (Session["Siralama"] != null)
{
siralama = Session["Siralama"].ToString();
}
if (siralama == "sortByDate")
{
urunler = urunler.OrderByDescending(u => u.Tarih).ToList(); ddlSort.SelectedIndex = 0;
}
else if (siralama == "sortByName")
{
urunler = urunler.OrderBy(u => u.UrunAdi).ToList(); ddlSort.SelectedIndex = 1;
}
else if (siralama == "sortByPrice")
{
urunler = urunler.OrderBy(u => u.BirimFiyat).ToList(); ddlSort.SelectedIndex = 2;
}
else if (siralama == "sortByQuantity")
{
urunler = urunler.OrderByDescending(u => u.NetMiktar).ToList(); ddlSort.SelectedIndex = 3;
}
else if (siralama == "sortByLiked")
{
urunler = urunler.OrderByDescending(u => u.Begeniler).ToList(); ddlSort.SelectedIndex = 4;
}
else
{
urunler = urunler.OrderByDescending(u => u.Tarih).ToList();
}
// Sayfalama
int _pageCount = 12;
string sayfalama = "twelve";
if (Session["SayfaUrunSayisi"] != null)
{
sayfalama = Session["SayfaUrunSayisi"].ToString();
}
if (sayfalama == "twelve")
{
_pageCount = 12; ddlNumberOfPage.SelectedIndex = 0;
}
else if (sayfalama == "eighteen")
{
_pageCount = 18; ddlNumberOfPage.SelectedIndex = 1;
}
else if (sayfalama == "twentyfour")
{
_pageCount = 24; ddlNumberOfPage.SelectedIndex = 2;
}
int urun_count = urunler.Count;
int total_pages = (urun_count - (urun_count % _pageCount)) / _pageCount +
(urun_count % _pageCount == 0 ? 0 : 1);
urunler = urunler.Skip((_page - 1) * _pageCount).Take(_pageCount).ToList();
grid_row.InnerHtml = GridUrun(urunler, data);
list_div.InnerHtml = ListUrun(urunler, data);
if (_page != 1)
{
HtmlGenericControl li = new HtmlGenericControl("li");
LinkButton pageLink = new LinkButton();
HtmlGenericControl i_ctrl = new HtmlGenericControl("i");
i_ctrl.Attributes.Add("class", "fa fa-caret-left");
pageLink.ID = "pagePrev";
pageLink.Controls.Add(i_ctrl);
pageLink.Click += pageLink_Click;
li.Controls.Add(pageLink);
pagination_pages.Controls.Add(li);
}
i = 0; c = page_array.Length;
while (i < c)
{
int __page = page_array[i];
if (__page <= total_pages)
{
HtmlGenericControl li = new HtmlGenericControl("li");
if (__page == _page)
{
li.Attributes.Add("class", "current");
}
LinkButton pageLink = new LinkButton();
pageLink.Text = __page.ToString();
pageLink.ID = "page" + __page;
pageLink.Click += pageLink_Click;
li.Controls.Add(pageLink);
pagination_pages.Controls.Add(li);
}
i++;
}
if (_page != total_pages)
{
HtmlGenericControl li = new HtmlGenericControl("li");
LinkButton pageLink = new LinkButton();
HtmlGenericControl i_ctrl = new HtmlGenericControl("i");
i_ctrl.Attributes.Add("class", "fa fa-caret-right");
pageLink.ID = "pageNext";
pageLink.Controls.Add(i_ctrl);
pageLink.Click += pageLink_Click;
li.Controls.Add(pageLink);
pagination_pages.Controls.Add(li);
}
quickview_wrapper.InnerHtml = QuickViewUrun(urunler, data);
#endregion
#region Kategori Seçenekleri
UlKategoriGrup.InnerHtml = "";
if (Request.QueryString["ctgr"] == null)
{
h2KategoriGrup.InnerText = "Kategori";
foreach (Kategori k in data.Kategoris)
{
LinkButton btnKategori = new LinkButton();
btnKategori.Text = k.KategoriAdi;
btnKategori.Click += btnKategori_Click;
btnKategori.ID = "kategori" + k.KategoriID;
HtmlGenericControl li = new HtmlGenericControl("li");
li.Controls.Add(btnKategori);
UlKategoriGrup.Controls.Add(li);
}
}
else
{
List <UrunGrubu> gruplar = UrunGruplari(urunler, data);
foreach (UrunGrubu ug in gruplar)
{
LinkButton btnGrup = new LinkButton();
btnGrup.Text = ug.GrupAdi + " (" + ug.Uruns.Count + ")";
btnGrup.Click += btnGrup_Click;
btnGrup.ID = "grup" + ug.GrupID;
HtmlGenericControl li = new HtmlGenericControl("li");
li.Controls.Add(btnGrup);
UlKategoriGrup.Controls.Add(li);
}
}
List <Marka> markalar = UrunMarkalari(urunler, data);
foreach (Marka m in markalar)
{
LinkButton btnMarka = new LinkButton();
btnMarka.Text = m.MarkaAdi + " (" + m.Uruns.Count + ")";
btnMarka.Click += btnMarka_Click;
btnMarka.ID = "marka" + m.MarkaID;
HtmlGenericControl li = new HtmlGenericControl("li");
li.Controls.Add(btnMarka);
UlMarka.Controls.Add(li);
}
List <Renk> renkler = UrunRenkleri(urunler, data);
foreach (Renk r in renkler)
{
LinkButton btnRenk = new LinkButton();
btnRenk.Text = r.RenkAdi;
btnRenk.Click += btnRenk_Click;
btnRenk.ID = "renk" + r.RenkID;
HtmlGenericControl li = new HtmlGenericControl("li");
li.Controls.Add(btnRenk);
UlRenk.Controls.Add(li);
}
List <Beden> bedenler = UrunBedenleri(urunler, data);
foreach (Beden b in bedenler)
{
LinkButton btnBeden = new LinkButton();
btnBeden.Text = b.BedenBoyu;
btnBeden.Click += btnBeden_Click;
btnBeden.ID = "beden" + b.BedenID;
HtmlGenericControl li = new HtmlGenericControl("li");
li.Controls.Add(btnBeden);
UlBeden.Controls.Add(li);
}
#endregion
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
try
{
ModalDataContext data = new ModalDataContext();
Urun yeniUrun = new Urun();
yeniUrun.UrunAdi = txtUrunAdi.Text;
yeniUrun.Aciklama = txtAciklama.Text;
yeniUrun.BirimFiyat = Convert.ToDecimal(txtFiyat.Text);
yeniUrun.DepoyaGirenMiktar = Convert.ToInt32(txtMiktar.Text);
yeniUrun.KullanilanMiktar = 0;
yeniUrun.BitisSuresi = cldBitisTarihi.SelectedDate;
yeniUrun.Begeniler = 0; yeniUrun.GoruntulenmeSayisi = 0;
yeniUrun.MarkaID = Convert.ToInt32(ddlMarkalar.SelectedValue);
yeniUrun.GrupID = Convert.ToInt32(ddlUrunGrubu.SelectedValue);
yeniUrun.Tarih = DateTime.Now;
data.Uruns.InsertOnSubmit(yeniUrun);
data.SubmitChanges();
List <RenkvsUrun> yeniUrunRenkleri = new List <RenkvsUrun>();
int i = 0, c = blRenkler.Items.Count;
while (i < c)
{
RenkvsUrun yeniUrunRenk = new RenkvsUrun();
yeniUrunRenk.RenkID = Convert.ToInt32(blRenkler.Items[i].Value);
yeniUrunRenk.UrunID = yeniUrun.UrunID;
yeniUrunRenkleri.Add(yeniUrunRenk);
i++;
}
var recUR = (from ur in yeniUrunRenkleri
select ur);
data.RenkvsUruns.InsertAllOnSubmit(yeniUrunRenkleri);
List <BedenvsUrun> yeniUrunBedenleri = new List <BedenvsUrun>();
i = 0; c = blBedenler.Items.Count;
while (i < c)
{
BedenvsUrun yeniUrunBeden = new BedenvsUrun();
yeniUrunBeden.BedenID = Convert.ToInt32(blBedenler.Items[i].Value);
yeniUrunBeden.UrunID = yeniUrun.UrunID;
yeniUrunBedenleri.Add(yeniUrunBeden);
i++;
}
var recUB = (from ub in yeniUrunBedenleri
select ub);
data.BedenvsUruns.InsertAllOnSubmit(recUB);
DataTable dtG = new DataTable();
if (Session["YuklenenGorseller"] == null)
{
dtG = new DataTable();
dtG.Columns.Add("GorselAdres");
}
else
{
dtG = (DataTable)Session["YuklenenGorseller"];
}
List <UrunGorseli> yeniUrunGorselleri = new List <UrunGorseli>();
i = 0; c = dtG.Rows.Count;
while (i < c)
{
UrunGorseli yeniUrunGorseli = new UrunGorseli();
yeniUrunGorseli.GorselAdres = dtG.Rows[i]["GorselAdres"].ToString();
yeniUrunGorseli.UrunID = yeniUrun.UrunID;
yeniUrunGorselleri.Add(yeniUrunGorseli);
i++;
}
var recUG = (from ug in yeniUrunGorselleri
select ug);
data.UrunGorselis.InsertAllOnSubmit(recUG);
data.SubmitChanges();
Session["YuklenenGorseller"] = null;
blBedenler.Items.Clear(); blRenkler.Items.Clear();
txtAciklama.Text = ""; txtFiyat.Text = ""; txtMiktar.Text = ""; txtUrunAdi.Text = "";
}
catch
{
lblError.Text = "Bir hata oluştu";
}
}
protected List <Renk> UrunRenkleri(List <Urun> _urunler, ModalDataContext _data)
{
return(_data.Renks.Where(b => _data.RenkvsUruns.Where(bu => _urunler.Select(u => u.UrunID).Contains((int)bu.UrunID)).Select(bu => bu.RenkID).Contains(b.RenkID)).ToList());
}
protected List <Beden> UrunBedenleri(List <Urun> _urunler, ModalDataContext _data)
{
return(_data.Bedens.Where(b => _data.BedenvsUruns.Where(bu => _urunler.Select(u => u.UrunID).Contains((int)bu.UrunID)).Select(bu => bu.BedenID).Contains(b.BedenID)).ToList());
}
protected string QuickViewUrun(List <Urun> _urunler, ModalDataContext _data)
{
string ret = "";
foreach (Urun u in _urunler)
{
string gorsel = u.UrunGorselis.OrderBy(ug => ug.GorselID).FirstOrDefault().GorselAdres;
string uye_id = Session["UyeID"] == null ? "-1" : Session["UyeID"].ToString();
string _u = "<div class=\"modal fade\" id=\"productModal" + u.UrunID + "\" tabindex=\"-1\" role=\"dialog\">" +
"<div class=\"modal-dialog\" role=\"document\">" +
"<div class=\"modal-content\">" +
"<div class=\"modal-header\">" +
"<button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button>" +
"</div>" +
"<div class=\"modal-body\">" +
"<div class=\"modal-product\">" +
"<div class=\"product-images\">" +
"<div class=\"main-image images\">" +
"<div style=\"width:254px;height:360px;display:table;background-color:rgba(255,255,255,.0);\">" +
"<div style=\"text-align:center;vertical-align:middle;display:table-cell;\">" +
"<img src=\"" + gorsel + "\" alt=\"\" style=\"max-width:254px;max-height:360px;width:auto;height:auto;\" />" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"<div class=\"product-info\">" +
"<h1>" + u.UrunAdi + "</h1>" +
"<div class=\"price-box\">" +
"<p class=\"price\"><span class=\"special-price\"><span class=\"amount\">" + Convert.ToDouble(u.BirimFiyat).ToString("0.00") + " ₺ </span></span></p>" +
"</div>" +
"<a href=\"product-details.aspx?UrunId=" + u.UrunID + "\" class=\"see-all\">Ürün Detayları</a>" +
"<div class=\"quick-add-to-cart\">" +
"<form method=\"post\" class=\"cart\">" +
"<div class=\"numbers-row\">" +
"<input type=\"number\" id=\"french-hens" + u.UrunID + "\" value=\"1\" min=\"1\" max=\"12\">" +
"</div>" +
"<button class=\"single_add_to_cart_button\" type=\"submit\" onclick=\"addCart(" + u.UrunID + ", document.getElementById('french-hens" + u.UrunID + "').value); \">Sepete Ekle</button>" +
"</form>" +
"</div>" +
"<div class=\"quick-desc\">" +
u.Aciklama +
"</div>" +
"<div class=\"social-sharing\">" +
"<div class=\"widget widget_socialsharing_widget\">" +
"<h3 class=\"widget-title-modal\">Ürünü Paylaş</h3>" +
"<ul class=\"social-icons\">" +
"<li><a target=\"_blank\" title=\"Facebook\" href=\"#\" class=\"facebook social-icon\"><i class=\"fa fa-facebook\"></i></a></li>" +
"<li><a target=\"_blank\" title=\"Twitter\" href=\"#\" class=\"twitter social-icon\"><i class=\"fa fa-twitter\"></i></a></li>" +
"<li><a target=\"_blank\" title=\"Pinterest\" href=\"#\" class=\"pinterest social-icon\"><i class=\"fa fa-pinterest\"></i></a></li>" +
"<li><a target=\"_blank\" title=\"Google +\" href=\"#\" class=\"gplus social-icon\"><i class=\"fa fa-google-plus\"></i></a></li>" +
"<li><a target=\"_blank\" title=\"LinkedIn\" href=\"#\" class=\"linkedin social-icon\"><i class=\"fa fa-linkedin\"></i></a></li>" +
"</ul>" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"</div>";
ret += _u;
}
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
btn_search.ServerClick += Btn_search_ServerClick;
ModalDataContext data = new ModalDataContext();
int[] page_array = new int[9] {
1, 2, 3, 4, 5, 6, 7, 8, 9
};
int page = 1, ctgr = -1, auth = -1; string srch = ""; string month_year = "", tag = "";
var nameValues = HttpUtility.ParseQueryString(Request.QueryString.ToString());
if (nameValues.AllKeys.Contains("page"))
{
var _page = nameValues["page"]; if (Int32.TryParse(_page, out page))
{
int k = 0, f = page_array.Length; while (k < f)
{
page_array[k] += page > 3 ? (page - 3) : 0; k++;
}
}
}
if (nameValues.AllKeys.Contains("srch"))
{
srch = nameValues["srch"];
}
if (nameValues.AllKeys.Contains("arch"))
{
month_year = nameValues["arch"];
}
if (nameValues.AllKeys.Contains("ctgr"))
{
var _ctgr = nameValues["ctgr"]; Int32.TryParse(_ctgr, out ctgr);
}
if (nameValues.AllKeys.Contains("tag"))
{
tag = nameValues["tag"];
}
if (nameValues.AllKeys.Contains("auth"))
{
var _auth = nameValues["auth"]; Int32.TryParse(_auth, out auth);
}
int blog_count, total_pages, blogs_in_pages = 6;
blog_count = data.Blogs.Count();
total_pages = (blog_count - (blog_count % blogs_in_pages)) / blogs_in_pages +
(blog_count % blogs_in_pages == 0 ? 0 : 1);
List <Blog> bloglar = data.Blogs.OrderByDescending(b => b.Tarih).ToList();
if (srch != "")
{
string srch_upper = srch.ToUpper();
bloglar = (from b in bloglar
where (b.BlogAdi.ToUpper().Contains(srch_upper) || b.OnBilgi.ToUpper().Contains(srch_upper))
select b).ToList();
}
if (month_year != "")
{
var arch = month_year.Split('-');
if (arch.Length == 2)
{
int month, year;
if (Int32.TryParse(arch[0], out month) && Int32.TryParse(arch[1], out year))
{
bloglar = (from b in bloglar
where (((DateTime)b.Tarih).ToString("MM") == month.ToString() && ((DateTime)b.Tarih).ToString("yy") == year.ToString())
select b).ToList();
}
}
}
if (tag != "")
{
bloglar = (from b in bloglar
where (b.BlogTags.Select(bt => bt.Tag.TagAdi.ToUpper()).Contains(tag.ToUpper()))
select b).ToList();
}
if (auth != -1)
{
bloglar = (from b in bloglar
where (b.UyeID == auth)
select b).ToList();
}
if (ctgr != -1)
{
bloglar = (from b in bloglar
where (b.BlogGrubuID == ctgr)
select b).ToList();
}
bloglar = bloglar.Skip((page - 1) * blogs_in_pages).Take(blogs_in_pages).ToList();
string bloglar_area_div_inner = "";
foreach (Blog _b in bloglar)
{
bloglar_area_div_inner += BlogYaz(_b, data);
}
bloglar_area_div.InnerHtml = bloglar_area_div_inner;
#region Sayfa Numaraları
HtmlGenericControl _div = new HtmlGenericControl("div");
_div.Attributes.Add("class", "row");
HtmlGenericControl __div = new HtmlGenericControl("div");
__div.Attributes.Add("class", "col-md-12");
HtmlGenericControl ___div = new HtmlGenericControl("div");
___div.Attributes.Add("class", "pagination-content");
HtmlGenericControl ____div = new HtmlGenericControl("div");
____div.Attributes.Add("class", "pagination-button");
HtmlGenericControl pagination_pages = new HtmlGenericControl("ul");
pagination_pages.Attributes.Add("class", "pagination");
if (page != 1)
{
HtmlGenericControl li = new HtmlGenericControl("li");
LinkButton pageLink = new LinkButton();
HtmlGenericControl i_ctrl = new HtmlGenericControl("i");
i_ctrl.Attributes.Add("class", "fa fa-caret-left");
pageLink.ID = "pagePrev";
pageLink.Controls.Add(i_ctrl);
pageLink.Click += PageLink_Click;
li.Controls.Add(pageLink);
pagination_pages.Controls.Add(li);
}
int i = 0, c = page_array.Length;
while (i < c)
{
int __page = page_array[i];
if (__page <= total_pages)
{
HtmlGenericControl li = new HtmlGenericControl("li");
if (__page == page)
{
li.Attributes.Add("class", "current");
}
LinkButton pageLink = new LinkButton();
pageLink.Text = __page.ToString();
pageLink.ID = "page" + __page;
pageLink.Click += PageLink_Click;
li.Controls.Add(pageLink);
pagination_pages.Controls.Add(li);
}
i++;
}
if (page != total_pages)
{
HtmlGenericControl li = new HtmlGenericControl("li");
LinkButton pageLink = new LinkButton();
HtmlGenericControl i_ctrl = new HtmlGenericControl("i");
i_ctrl.Attributes.Add("class", "fa fa-caret-right");
pageLink.ID = "pageNext";
pageLink.Controls.Add(i_ctrl);
pageLink.Click += PageLink_Click;
li.Controls.Add(pageLink);
pagination_pages.Controls.Add(li);
}
____div.Controls.Add(pagination_pages);
___div.Controls.Add(____div);
__div.Controls.Add(___div);
_div.Controls.Add(__div);
bloglar_area_div.Controls.Add(_div);
#endregion
}
protected string GridUrun(List <Urun> _urunler, ModalDataContext _data)
{
string ret = "<div class=\"row\">";
foreach (Urun u in _urunler)
{
string etiket = "", class_attr = "sale-product-label";
if (u.NetMiktar != null)
{
if (u.NetMiktar > 0)
{
if (u.Tarih != null)
{
if ((DateTime.Now - (DateTime)u.Tarih).TotalDays < 7.0)
{
etiket = "Yeni"; class_attr = "new-product-label";
}
else
{
etiket = "Satışta";
}
}
else
{
etiket = "Satışta";
}
}
else
{
etiket = "Tükendi";
}
}
string gorsel = u.UrunGorselis.OrderBy(ug => ug.GorselID).FirstOrDefault().GorselAdres;
string gorsel_hover = u.UrunGorselis.OrderByDescending(ug => ug.GorselID).FirstOrDefault().GorselAdres;
string uye_id = Session["UyeID"] == null ? "-1" : Session["UyeID"].ToString();
string _u = "<div class=\"col-md-4 col-sm-4\">" +
"<div class=\"single-product-item\">" +
"<div class=\"" + class_attr + "\"><span>" + etiket + "</span></div>" +
"<div class=\"single-product clearfix\">" +
"<a href=\"product-details.aspx?UrunId=" + u.UrunID + "\">" +
"<span class=\"product-image\">" +
"<div style=\"width:262px;height:354px;display:table;background-color:rgba(255,255,255,.0);\">" +
"<div style=\"text-align:center;vertical-align:middle;display:table-cell;\">" +
"<img src=\"" + gorsel + "\" alt=\"\" style=\"max-width:262px;max-height:354px;\" />" +
"</div>" +
"</div>" +
"</span>" +
"<span class=\"product-image hover-image\">" +
"<div style=\"width:262px;height:354px;display:table;background-color:rgba(255,255,255,.0);\">" +
"<div style=\"text-align:center;vertical-align:middle;display:table-cell;\">" +
"<img src=\"" + gorsel_hover + "\" alt=\"\" style=\"max-width:262px;max-height:354px;\" />" +
"</div>" +
"</div>" +
"</span>" +
"</a>" +
"<div class=\"button-actions clearfix\">" +
"<button class=\"button add-to-cart\" type=\"button\" onclick=\" addCart(" + u.UrunID + ", 1);\" >" +
"<span><i class=\"fa fa-shopping-cart\"></i></span>" +
"</button>" +
"<ul class=\"add-to-links\">" +
"<li class=\"quickview\">" +
"<a class=\"btn-quickview modal-view\" href=\"#\" data-toggle=\"modal\" data-target=\"#productModal" + u.UrunID + "\">" +
"<i class=\"fa fa-search-plus\"></i>" +
"</a>" +
"</li>" +
"<li>" +
"<a class=\"link-wishlist\" href=\"#\" onclick=\" addFav(" + u.UrunID + ", " + uye_id + ");\" >" +
"<i class=\"fa fa-heart\"></i>" +
"</a>" +
"</li>" +
"<li>" +
"<a class=\"link-compare\" href=\"#\">" +
"<i class=\"fa fa-retweet\"></i>" +
"</a>" +
"</li>" +
"</ul>" +
"</div>" +
"</div>" +
"<h3 class=\"single-product-name\"><a href=\"product-details.aspx?UrunId=" + u.UrunID + "\">" + (u.UrunAdi.ToString().Length > 32 ? u.UrunAdi.ToString().Substring(u.UrunAdi.ToString().Length - 30, 30).Insert(0, "..") : u.UrunAdi.ToString()) + "</a></h3>" +
"<div class=\"price-box\">" +
"<p class=\"special-price\">" +
"<span class=\"price\">" + Convert.ToDouble(u.BirimFiyat).ToString("0.00") + " ₺ </span>" +
"</p>" +
"</div>" +
"</div>" +
"</div>";
ret += _u;
}
ret += "</div>";
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
ModalDataContext data = new ModalDataContext();
int blog_id = -1;
if (Request.QueryString["BlogId"] != null)
{
string blog_id_str = Request.QueryString["BlogId"].ToString();
if (Int32.TryParse(blog_id_str, out blog_id))
{
Blog blog = data.Blogs.FirstOrDefault(b => b.BlogID == blog_id);
if (blog != null)
{
try
{
img_post_thumbnail.Src = blog.BlogResmi;
span_post_day.InnerText = ((DateTime)blog.Tarih).Day.ToString();
int month_index = ((DateTime)blog.Tarih).Month - 1;
span_post_month.InnerText = aylar_array[month_index].ToString();
h1_post_title.InnerText = blog.BlogAdi;
a_post_author.InnerText = blog.Uye.KullaniciAdi;
a_post_author.HRef = "Blog.aspx?auth=" + blog.UyeID;
string[] str_tag_array = blog.BlogTags.Select(bt => "<a href=\"Blog-Details.aspx?tag=" + bt.Tag.TagID + "\" rel=\"category tag\">" + bt.Tag.TagAdi + "</a>").ToArray();
string str_tags = String.Join(", ", str_tag_array);
div_post_tags.InnerHtml = str_tags;
div_post_entry.InnerHtml = blog.OnBilgi + blog.Icerik;
int yorum_c = blog.BlogYorums.Where(by => by.Onaylanma == true).Count();
a_post_comments_count.InnerText = yorum_c == 0 ? "Henüz yorum yazılmamış" : yorum_c + " adet yorum";
a_post_author_name.InnerText = blog.Uye.KullaniciAdi;
h3_post_comments_count.InnerText = yorum_c == 0 ? "Henüz yorum yazılmamış" : yorum_c + " adet yorum";
div_comments_area.InnerHtml = blogYorumlar(blog);
if (Session["UyeID"] != null)
{
string uyeid_str = Session["UyeID"].ToString();
int uyeid = -1;
if (Int32.TryParse(uyeid_str, out uyeid))
{
Uye uye = data.Uyes.FirstOrDefault(u => u.UyeID == uyeid);
if (uye != null)
{
input_comment_name.Value = uye.KullaniciAdi;
input_comment_name.Disabled = true;
input_comment_email.Value = uye.Mail;
input_comment_email.Disabled = true;
button_send_comment.ServerClick += Button_send_comment_ServerClick;
}
else
{
div_user_comment_area.InnerText = "Yorum yazabilmek için üye olmalısınız.";
}
}
else
{
div_user_comment_area.InnerText = "Yorum yazabilmek için üye olmalısınız.";
}
}
else
{
div_user_comment_area.InnerText = "Yorum yazabilmek için üye olmalısınız.";
}
}
catch { Response.Redirect("NotFound404.aspx"); }
}
else
{
Response.Redirect("NotFound404.aspx");
}
}
else
{
Response.Redirect("NotFound404.aspx");
}
}
else
{
Response.Redirect("NotFound404.aspx");
}
}
private bool urunBilgileri(int id)
{
ModalDataContext data = new ModalDataContext();
Urun urun = data.Uruns.FirstOrDefault(u => u.UrunID == id);
if (urun == null)
{
return(false);
}
txtUrunAdi.Text = urun.UrunAdi; txtAciklama.Text = urun.Aciklama;
txtFiyat.Text = ((decimal)urun.BirimFiyat).ToString("0.00");
txtMiktar.Text = urun.DepoyaGirenMiktar.ToString();
cldBitisTarihi.SelectedDate = (DateTime)urun.BitisSuresi;
cldBitisTarihi.VisibleDate = (DateTime)urun.BitisSuresi;
ddlMarkalar.SelectedValue = urun.MarkaID.ToString();
var ktg = data.Kategoris;
ddlKategoriler.Items.Clear();
foreach (var k in ktg)
{
ddlKategoriler.Items.Add(new ListItem(k.KategoriAdi, k.KategoriID.ToString()));
}
ddlKategoriler.SelectedValue = urun.UrunGrubu.KategoriID.ToString();
var grp = data.UrunGrubus.Where(ug => ug.KategoriID == urun.UrunGrubu.KategoriID).ToList();
ddlUrunGrubu.Items.Clear();
foreach (var g in grp)
{
ddlUrunGrubu.Items.Add(new ListItem(g.GrupAdi, g.GrupID.ToString()));
}
ddlUrunGrubu.SelectedValue = urun.GrupID.ToString();
blRenkler.Items.Clear();
foreach (var r in urun.RenkvsUruns)
{
blRenkler.Items.Add(new ListItem(r.Renk.RenkAdi, r.RenkID.ToString()));
}
blBedenler.Items.Clear();
foreach (var b in urun.BedenvsUruns)
{
blBedenler.Items.Add(new ListItem(b.Beden.BedenBoyu, b.BedenID.ToString()));
}
DataTable dtG = new DataTable();
if (Session["MevcutGorseller"] == null)
{
dtG = new DataTable();
dtG.Columns.Add("GorselAdres");
}
else
{
dtG = (DataTable)Session["MevcutGorseller"];
}
dtG.Rows.Clear();
foreach (var ug in urun.UrunGorselis)
{
dtG.Rows.Add();
dtG.Rows[dtG.Rows.Count - 1]["GorselAdres"] = ug.GorselAdres;
}
Session["MevcutGorseller"] = dtG;
return(true);
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
try
{
string _id = "";
if (Request.QueryString["UrunID"] != null)
{
_id = Request.QueryString["UrunID"].ToString();
int id = -1;
if (Int32.TryParse(_id, out id))
{
ModalDataContext data = new ModalDataContext();
Urun yeniUrun = data.Uruns.FirstOrDefault(u => u.UrunID == id);
if (yeniUrun != null)
{
yeniUrun.UrunAdi = txtUrunAdi.Text;
yeniUrun.Aciklama = txtAciklama.Text;
yeniUrun.BirimFiyat = Convert.ToDecimal(txtFiyat.Text);
yeniUrun.DepoyaGirenMiktar = Convert.ToInt32(txtMiktar.Text);
yeniUrun.KullanilanMiktar = 0;
yeniUrun.BitisSuresi = cldBitisTarihi.SelectedDate;
yeniUrun.MarkaID = Convert.ToInt32(ddlMarkalar.SelectedValue);
yeniUrun.GrupID = Convert.ToInt32(ddlUrunGrubu.SelectedValue);
data.SubmitChanges();
data.RenkvsUruns.DeleteAllOnSubmit(data.RenkvsUruns.Where(ru => ru.UrunID == id));
List <RenkvsUrun> yeniUrunRenkleri = new List <RenkvsUrun>();
int i = 0, c = blRenkler.Items.Count;
while (i < c)
{
RenkvsUrun yeniUrunRenk = new RenkvsUrun();
yeniUrunRenk.RenkID = Convert.ToInt32(blRenkler.Items[i].Value);
yeniUrunRenk.UrunID = id;
yeniUrunRenkleri.Add(yeniUrunRenk);
i++;
}
var recUR = (from ur in yeniUrunRenkleri
select ur);
data.RenkvsUruns.InsertAllOnSubmit(yeniUrunRenkleri);
data.BedenvsUruns.DeleteAllOnSubmit(data.BedenvsUruns.Where(bu => bu.UrunID == id));
List <BedenvsUrun> yeniUrunBedenleri = new List <BedenvsUrun>();
i = 0; c = blBedenler.Items.Count;
while (i < c)
{
BedenvsUrun yeniUrunBeden = new BedenvsUrun();
yeniUrunBeden.BedenID = Convert.ToInt32(blBedenler.Items[i].Value);
yeniUrunBeden.UrunID = id;
yeniUrunBedenleri.Add(yeniUrunBeden);
i++;
}
var recUB = (from ub in yeniUrunBedenleri
select ub);
data.BedenvsUruns.InsertAllOnSubmit(recUB);
DataTable dtG = new DataTable();
if (Session["MevcutGorseller"] == null)
{
dtG = new DataTable();
dtG.Columns.Add("GorselAdres");
}
else
{
dtG = (DataTable)Session["MevcutGorseller"];
}
data.UrunGorselis.DeleteAllOnSubmit(data.UrunGorselis.Where(ug => ug.UrunID == id));
List <UrunGorseli> yeniUrunGorselleri = new List <UrunGorseli>();
i = 0; c = dtG.Rows.Count;
while (i < c)
{
UrunGorseli yeniUrunGorseli = new UrunGorseli();
yeniUrunGorseli.GorselAdres = dtG.Rows[i]["GorselAdres"].ToString();
yeniUrunGorseli.UrunID = yeniUrun.UrunID;
yeniUrunGorselleri.Add(yeniUrunGorseli);
i++;
}
var recUG = (from ug in yeniUrunGorselleri
select ug);
data.UrunGorselis.InsertAllOnSubmit(recUG);
data.SubmitChanges();
Response.Redirect(Request.Url.AbsolutePath + "?UrunId=" + id.ToString());
}
}
}
}
catch
{
lblError.Text = "Bir hata oluştu";
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
SqlConnection baglanti = new SqlConnection();
baglanti.ConnectionString = ConfigurationManager.ConnectionStrings["baglantimetni"].ConnectionString;
#region GoruntulemeArtirma İşlemi Kodları
SqlCommand GoruntulemeArtirmaSorgu = new SqlCommand();
GoruntulemeArtirmaSorgu.CommandText = "update Urun set GoruntulenmeSayisi+=1 where UrunID=" +
Request.QueryString["UrunID"].ToString();
GoruntulemeArtirmaSorgu.Connection = baglanti;
baglanti.Open();
GoruntulemeArtirmaSorgu.ExecuteNonQuery();
baglanti.Close();
#endregion
#region Ürün Bilgileri
string selectsorgusu = string.Format("exec sp_UrunDetayBilgileri {0}", Request.QueryString["UrunId"]);
SqlDataAdapter sorgu = new SqlDataAdapter(selectsorgusu, baglanti);
DataTable tablo = new DataTable();
sorgu.Fill(tablo);
string urun_adi = tablo.Rows[0]["UrunAdi"].ToString();
zoom1.Src = tablo.Rows[0]["GorselAdres"].ToString();
zoom1.Attributes["data-zoom-image"] = tablo.Rows[0]["GorselAdres"].ToString();
UrunBasligi.InnerText = urun_adi;
GoruntulemeSayisi.InnerText = tablo.Rows[0]["GoruntulenmeSayisi"].ToString();
BegeniSayisi.InnerText = tablo.Rows[0]["Begeniler"] == null ? "0" : tablo.Rows[0]["Begeniler"].ToString();
Stokta.InnerText = tablo.Rows[0]["NetMiktar"].ToString() != "0"?"Stokta":"Tükendi";
eskifiyat.InnerHtml = (double.Parse(tablo.Rows[0]["BirimFiyat"].ToString()) * 1.3).ToString("0.00") + "₺";
yenifiyat.InnerHtml = double.Parse(tablo.Rows[0]["BirimFiyat"].ToString()).ToString("0.00") + "₺";
aciklama.InnerText = tablo.Rows[0]["Aciklama"].ToString();
EklenmeTarihi.InnerText = Convert.ToDateTime(tablo.Rows[0]["Tarih"]).ToString("dd.MM.yyyy");
#endregion
#region Puanlama ve Yorumlar
float fiyat_puan = 0f;
float.TryParse(tablo.Rows[0]["FiyatPuani"].ToString(), out fiyat_puan);
float urun_puan = 0f;
float.TryParse(tablo.Rows[0]["DegerPuani"].ToString(), out urun_puan);
float kalite_puan = 0f;
float.TryParse(tablo.Rows[0]["KalitePuani"].ToString(), out kalite_puan);
FiyatStars.InnerHtml = PrepareStars(fiyat_puan);
FiyatPuani.InnerText = fiyat_puan > 1f ? fiyat_puan.ToString("0.0") : "-";
UrunStars.InnerHtml = PrepareStars(urun_puan);
UrunPuani.InnerText = urun_puan > 1f ? urun_puan.ToString("0.0") : "-";
KaliteStars.InnerHtml = PrepareStars(kalite_puan);
KalitePuani.InnerText = urun_puan > 1f ? kalite_puan.ToString("0.0") : "-";
Goruntuluyorsunuz.InnerText = "Şu ürünü görüntülüyorsunuz: " + urun_adi;
ModalDataContext data = new ModalDataContext();
bool oturum = Session["UyeID"] != null;
if (oturum)
{
int uyeID = Convert.ToInt32(Session["UyeID"]), urunID = Convert.ToInt32(Request.QueryString["UrunId"]);
txtKullaniciAdi.Text = data.Uyes.FirstOrDefault(u => u.UyeID == uyeID).KullaniciAdi;
UrunPuan urunPuan = data.UrunPuans.FirstOrDefault(up => up.UrunID == urunID && up.UyeID == uyeID);
if (urunPuan == null)
{
txtBaslik.Text = "";
txtYorum.Text = "";
btnGonder.Text = "Gönder";
}
else
{
double _fiyatPuan = (double)(urunPuan.FiyatPuani != null ? urunPuan.FiyatPuani : 0.0);
if (_fiyatPuan > 0.0)
{
if (_fiyatPuan == 1.0)
{
FiyatPuan1.Checked = true;
}
else if (_fiyatPuan == 2.0)
{
FiyatPuan2.Checked = true;
}
else if (_fiyatPuan == 3.0)
{
FiyatPuan3.Checked = true;
}
else if (_fiyatPuan == 4.0)
{
FiyatPuan4.Checked = true;
}
else if (_fiyatPuan == 5.0)
{
FiyatPuan5.Checked = true;
}
}
double _urunPuan = (double)(urunPuan.DegerPuani != null ? urunPuan.DegerPuani : 0.0);
if (_urunPuan > 0.0)
{
if (_urunPuan == 1.0)
{
UrunPuan1.Checked = true;
}
else if (_urunPuan == 2.0)
{
UrunPuan2.Checked = true;
}
else if (_urunPuan == 3.0)
{
UrunPuan3.Checked = true;
}
else if (_urunPuan == 4.0)
{
UrunPuan4.Checked = true;
}
else if (_urunPuan == 5.0)
{
UrunPuan5.Checked = true;
}
}
double kalitePuan = (double)(urunPuan.KalitePuani != null ? urunPuan.KalitePuani : 0.0);
if (kalitePuan > 0.0)
{
if (kalitePuan == 1.0)
{
KalitePuan1.Checked = true;
}
else if (kalitePuan == 2.0)
{
KalitePuan2.Checked = true;
}
else if (kalitePuan == 3.0)
{
KalitePuan3.Checked = true;
}
else if (kalitePuan == 4.0)
{
KalitePuan4.Checked = true;
}
else if (kalitePuan == 5.0)
{
KalitePuan5.Checked = true;
}
}
string yorum = urunPuan.Yorum, baslik = urunPuan.Baslik;
txtYorum.Text = yorum; txtBaslik.Text = baslik;
btnGonder.Text = "Güncelle";
}
}
int urun_id = Convert.ToInt32(Request.QueryString["UrunId"]);
List <string[]> yorumlar = (from up in data.UrunPuans
where up.UrunID == urun_id &&
!(up.Yorum == null && up.Baslik == null) &&
!(up.Yorum == "" && up.Baslik == "")
orderby up.Tarih descending
select new string[4]
{
(from k in data.Uyes
where k.UyeID == up.UyeID
select k.KullaniciAdi).FirstOrDefault(),
up.Tarih == null ? "-" : up.Tarih.ToString(),
up.Baslik == null ? "" : up.Baslik,
up.Yorum == null ? "" : up.Yorum
}).Take(8).ToList();
Yorumlar.InnerHtml = GetComments(yorumlar);
#endregion
#region Geçmişte Bakılan Ürünler
DataTable gecmis = new DataTable();
gecmis = (DataTable)HttpContext.Current.Session["GecmisteBakilanUrunler"];
if (gecmis == null)
{
gecmis = new DataTable();
gecmis.Columns.Add("UrunID");
gecmis.Columns.Add("UrunAdi");
gecmis.Columns.Add("GorselAdres");
gecmis.Columns.Add("BirimFiyat");
}
bool varmi = false;
int i = 0, c = gecmis.Rows.Count, indis = 0;
while (i < c)
{
varmi = gecmis.Rows[i]["UrunID"].ToString() == tablo.Rows[0]["UrunID"].ToString();
if (varmi)
{
indis = i; break;
}
i++;
}
if (varmi)
{
gecmis.Rows.RemoveAt(indis);
}
gecmis.Rows.Add(tablo.Rows[0]["UrunID"], tablo.Rows[0]["UrunAdi"], tablo.Rows[0]["GorselAdres"], tablo.Rows[0]["BirimFiyat"]);
HttpContext.Current.Session["GecmisteBakilanUrunler"] = gecmis;
#endregion
}
catch
{
Response.Redirect("NotFound404.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["KullaniciAdi"] != null)
{
sKullanici.InnerText = Session["KullaniciAdi"].ToString();
NormalPanel.Visible = false;
KullaniciPaneli.Visible = true;
}
else
{
NormalPanel.Visible = true;
KullaniciPaneli.Visible = false;
}
#region Ana Sayfa Sekmesi
nav.InnerHtml = "<li class=\"current\">" +
"<a href=\"Default.aspx\">Ana Sayfa</a>" +
"<ul class=\"sub-menu\">" +
"<li><a href=\"#\" class=\"mega-title\">Diğer Sayfalar</a></li>" +
"<li><a href=\"Contact.aspx\">İletişim</a></li>" +
"<li><a href=\"AboutUs.aspx\">Hakkımızda</a></li>" +
"<li><a href=\"Blog.aspx\">Blog</a></li>" +
"<li><a href=\"Account.aspx\">Bilgilerim</a></li>" +
"<li><a href=\"Cart.aspx\">Sepetim</a></li>" +
"<li><a href=\"Checkout.aspx\">Satın Al</a></li>" +
"<li><a href=\"Shop.aspx\">Ürün Ara</a></li>" +
"<li><a href=\"Liked.aspx\">Beğendiklerim</a></li>" +
"</ul>" +
"</li>";
#endregion
ModalDataContext data = new ModalDataContext();
List <Kategori> kategoriler = data.Kategoris.ToList();
int i = 0, c = kategoriler.Count;
string nav_inner_html = "";
while (i < c)
{
Kategori _k = kategoriler[i];
List <UrunGrubu> gruplar = data.UrunGrubus.Where(ug => ug.KategoriID == _k.KategoriID).ToList();
int j = 0, d = gruplar.Count; int d2 = d / 2;
string grup_inner_html = "<span><a href=\"#\" class=\"mega-title\">Ürünler</a>";
while (j <= d / 2)
{
UrunGrubu ug = gruplar[j];
grup_inner_html += "<a href=\"Shop.aspx?ctgr=" + _k.KategoriID + "&grp=" + ug.GrupID + "\">" + ug.GrupAdi + "</a>";
j++;
}
grup_inner_html += "</span>";
grup_inner_html += "<span><a href=\"#\" class=\"mega-title\">Ürünler</a>";
while (j < d)
{
UrunGrubu ug = gruplar[j];
grup_inner_html += "<a href=\"Shop.aspx?ctgr=" + _k.KategoriID + "&grp=" + ug.GrupID + "\">" + ug.GrupAdi + "</a>";
j++;
}
grup_inner_html += "</span>";
List <UrunGrubu> begenilenGruplar = _k.UrunGrubus.OrderByDescending(ug => ug.Uruns.Sum(u => u.Begeniler)).Take(3).ToList();
grup_inner_html += "<span><a href=\"#\" class=\"mega-title\">Beğenilenler</a>";
j = 0; d = begenilenGruplar.Count;
while (j < d)
{
UrunGrubu ug = begenilenGruplar[j];
grup_inner_html += "<a href=\"Shop.aspx?ctgr=" + _k.KategoriID + "&grp=" + ug.GrupID + "\">" + ug.GrupAdi + "</a>";
j++;
}
grup_inner_html += "</span>";
List <UrunGrubu> oneCikanGruplar = _k.UrunGrubus.OrderByDescending(ug => ug.Uruns.Sum(u => u.GoruntulenmeSayisi)).Take(3).ToList();
grup_inner_html += "<span><a href=\"#\" class=\"mega-title\">Öne Çıkanlar</a>";
j = 0; d = oneCikanGruplar.Count;
while (j < d)
{
UrunGrubu ug = oneCikanGruplar[j];
grup_inner_html += "<a href=\"Shop.aspx?ctgr=" + _k.KategoriID + "&grp=" + ug.GrupID + "\">" + ug.GrupAdi + "</a>";
j++;
}
grup_inner_html += "</span>";
nav_inner_html += "<li>" +
"<a href=\"Shop.aspx?ctgr=" + _k.KategoriID + "\">" + _k.KategoriAdi + "</a>" +
"<div class=\"megamenu\">" +
"<div class=\"megamenu-list clearfix\">" +
grup_inner_html +
"</div>" +
"</li>";
i++;
}
nav.InnerHtml += nav_inner_html;
}
protected string ListUrun(List <Urun> _urunler, ModalDataContext _data)
{
string ret = "";
foreach (Urun u in _urunler)
{
string gorsel = u.UrunGorselis.OrderBy(ug => ug.GorselID).FirstOrDefault().GorselAdres;
string uye_id = Session["UyeID"] == null ? "-1" : Session["UyeID"].ToString();
string _u = "<div class=\"row\">" +
"<div class=\"col-md-12\">" +
"<div class=\"single-product-item\">" +
"<div class=\"row\">" +
"<div class=\"col-md-3 col-sm-4\">" +
"<div class=\"single-product clearfix\">" +
"<a href=\"product-details.aspx?UrunId=" + u.UrunID + "\">" +
"<span class=\"product-image\">" +
"<div style=\"width:181px;height:245px;display:table;background-color:rgba(255,255,255,.0);\">" +
"<div style=\"text-align:center;vertical-align:middle;display:table-cell;\">" +
"<img src=\"" + gorsel + "\" alt=\"\" style=\"max-width:181px;max-height:245px;\" />" +
"</div>" +
"</div>" +
"</span>" +
"</a>" +
"</div>" +
"</div>" +
"<div class=\"col-md-9 col-sm-8\">" +
"<h2 class=\"single-product-name\"><a href=\"product-details.aspx?UrunId=" + u.UrunID + "\">" + u.UrunAdi + "</a></h2>" +
"<div class=\"description\">" +
"<p>" + u.Aciklama + " <a class=\"learn-more\" href=\"product-details.aspx?UrunId=" + u.UrunID + "\">Ürün Detayları</a></p>" +
"</div>" +
"<div class=\"price-box\">" +
"<p class=\"special-price\">" +
"<span class=\"price\">" + Convert.ToDouble(u.BirimFiyat).ToString("0.00") + " ₺ </span>" +
"</p>" +
"</div>" +
"<div class=\"button-actions clearfix\">" +
"<button class=\"button add-to-cart\" type=\"button\" onclick=\" addCart(" + u.UrunID + ", 1);\" >" +
"<span><i class=\"fa fa-shopping-cart\"></i></span>" +
"</button>" +
"<ul class=\"add-to-links\">" +
"<li>" +
"<a class=\"link-wishlist\" href=\"#\" onclick=\" addFav(" + u.UrunID + ", " + uye_id + ");\" >" +
"<i class=\"fa fa-heart\"></i>" +
"</a>" +
"</li>" +
"<li>" +
"<a class=\"link-compare\" href=\"#\">" +
"<i class=\"fa fa-retweet\"></i>" +
"</a>" +
"</li>" +
"</ul>" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"</div>";
ret += _u;
}
return(ret);
}
