/// <summary>
/// <remarks>Ana ve alt kategorileri Linq ile alıp Menu ve MenuItem kullanır</remarks>
/// </summary>
public void LeftMenuHazirla()
{
try
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
var res = from c in p.UrunKategori
select new { Adi = c.Adi, ID = c.AnaKategoriID };
foreach (var item in res.ToList())
{
MenuItem Ana = new MenuItem();
Ana.Text = item.Adi;
Ana.NavigateUrl = @"MainPage.aspx?KatID=" + item.ID.ToString();
var res1 = from c in p.UrunKategori
join d in p.UrunAltKategori on c.AnaKategoriID equals d.AnaKategori
where c.AnaKategoriID == item.ID
select new { ID = c.AnaKategoriID, AltKatID = d.AltKategoriID, AltKatAdi = d.Adi };
foreach (var altkat in res1.ToList())
{
MenuItem Alt = new MenuItem();
Alt.Text = altkat.AltKatAdi;
Alt.NavigateUrl = @"UrunListesi.aspx?KatID=" + item.ID.ToString() + "&AltKatID=" + altkat.AltKatID.ToString();
Ana.ChildItems.Add(Alt);
}
Menu1.Items.Add(Ana);
}
}
catch (Exception)
{
throw;
}
}
protected void LinkButton_Delete_Click(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
LinkButton btn = sender as LinkButton;
string err = string.Empty;
try
{
var res = p.Sepet.First(x => x.UrunID.ToString() == btn.CommandArgument);
p.Sepet.Remove((Models.Sepet)res);
p.SaveChanges();
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
finally
{
Models.PoliklinikEntities5 _p = new Models.PoliklinikEntities5();
if (Session["s1"] != null)
{
var k = (Models.Kullanicilar)Session["s1"];
SepetList.DataSource = _p.Sepet.Where(x => x.KullaniciAdi == k.KullaniciAdi).ToList();
}
else
SepetList.DataSource = _p.Sepet.Where(x => x.KullaniciAdi == null).ToList();
SepetList.DataBind();
Response.Redirect("/Sepetim.aspx");
}
}
/// <summary>
/// <remarks>Ana ve alt kategorileri Linq ile alıp Menu ve MenuItem kullanır</remarks>
/// </summary>
public void LeftMenuHazirla()
{
try
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
var res = from c in p.UrunKategori
select new { Adi = c.Adi, ID = c.AnaKategoriID };
foreach (var item in res.ToList())
{
MenuItem Ana = new MenuItem();
Ana.Text = item.Adi;
Ana.NavigateUrl = @"MainPage.aspx?KatID=" + item.ID.ToString();
var res1 = from c in p.UrunKategori
join d in p.UrunAltKategori on c.AnaKategoriID equals d.AnaKategori
where c.AnaKategoriID == item.ID
select new { ID = c.AnaKategoriID, AltKatID = d.AltKategoriID, AltKatAdi = d.Adi };
foreach (var altkat in res1.ToList())
{
MenuItem Alt = new MenuItem();
Alt.Text = altkat.AltKatAdi;
Alt.NavigateUrl = @"UrunListesi.aspx?KatID=" + item.ID.ToString() + "&AltKatID=" + altkat.AltKatID.ToString();
Ana.ChildItems.Add(Alt);
}
Menu1.Items.Add(Ana);
}
}
catch (Exception)
{
throw;
}
}
protected void LinkButton_Delete_Click(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
LinkButton btn = sender as LinkButton;
string err = string.Empty;
try
{
var res = p.Sepet.First(x => x.UrunID.ToString() == btn.CommandArgument);
p.Sepet.Remove((Models.Sepet)res);
p.SaveChanges();
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
finally
{
Models.PoliklinikEntities5 _p = new Models.PoliklinikEntities5();
if (Session["s1"] != null)
{
var k = (Models.Kullanicilar)Session["s1"];
SepetList.DataSource = _p.Sepet.Where(x => x.KullaniciAdi == k.KullaniciAdi).ToList();
}
else
{
SepetList.DataSource = _p.Sepet.Where(x => x.KullaniciAdi == null).ToList();
}
SepetList.DataBind();
Response.Redirect("/Sepetim.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Data.DataKatmani dk = new Data.DataKatmani();
Models.PoliklinikEntities5 pContent = new Models.PoliklinikEntities5();
try
{
var kul = (Models.Kullanicilar)Session["s1"];
var res = kul == null ? (from c in pContent.Sepet where c.KullaniciAdi == null select c) : (from c in pContent.Sepet where c.KullaniciAdi == kul.KullaniciAdi select c);
int SepetSayi = res.ToList().Count;
SepetimLabel.Text = "Sepetim(" + SepetSayi.ToString() + ")";
if (!IsPostBack)
{
DataList1.DataSource = dk.UrunKatListe1(ref err);
DataList1.DataBind();
if (Menu2.Items.Count < 1)
{
MenuItem ana = new MenuItem()
{
Text = "Hesabım", NavigateUrl = ""
};
List <MenuItem> alt = new List <MenuItem>()
{
new MenuItem {
Text = "Siparişlerim", NavigateUrl = ""
},
new MenuItem {
Text = "Mesajlarım", NavigateUrl = ""
},
new MenuItem {
Text = "Puanlarım", NavigateUrl = ""
},
new MenuItem {
Text = "Hızlı Öde", NavigateUrl = ""
},
new MenuItem {
Text = "Üyelik Bilgilerim", NavigateUrl = ""
},
new MenuItem {
Text = "Adreslerim", NavigateUrl = ""
}
};
Menu2.Items.Add(ana);
for (int i = 0; i < alt.Count; i++)
{
Menu2.Items[0].ChildItems.Add(alt[i]);
}
;
}
}
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
protected void LinkButton_Update_Click(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
LinkButton btn = sender as LinkButton;
var kul = (Models.Kullanicilar)Session["s1"];
string err = string.Empty;
if (ControlID.Count > 0)
{
try
{
for (int i = 0; i < ControlID.Count; i++)
{
if (int.Parse(Request.Form[ControlID[i]]) > 0 && int.Parse(Request.Form[ControlID[i]]) < 100)
{
Models.Sepet s = new Models.Sepet();
s.UrunSiparisAdet = int.Parse(Request.Form[ControlID[i]]);
var res = kul == null?p.Sepet.First(x => x.UrunID.ToString() == btn.CommandArgument && x.KullaniciAdi == null) : p.Sepet.First(x => x.UrunID.ToString() == btn.CommandArgument && x.KullaniciAdi == kul.KullaniciAdi);
res.UrunSiparisAdet = s.UrunSiparisAdet;
int last = btn.UniqueID.LastIndexOf("ctl0");
string find = btn.UniqueID.Substring(last, 5);
if (ControlID[i].Contains(find))
{
p.SaveChanges();
}
}
}
}
catch (OverflowException ex)
{
err = ex.Message;
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
finally
{
Models.PoliklinikEntities5 _p = new Models.PoliklinikEntities5();
if (Session["s1"] != null)
{
var k = (Models.Kullanicilar)Session["s1"];
SepetList.DataSource = _p.Sepet.Where(x => x.KullaniciAdi == k.KullaniciAdi).ToList();
}
else
{
SepetList.DataSource = _p.Sepet.Where(x => x.KullaniciAdi == null).ToList();
}
SepetList.DataBind();
}
}
}
protected void LinkButton_Update_Click(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
LinkButton btn = sender as LinkButton;
var kul = (Models.Kullanicilar)Session["s1"];
string err = string.Empty;
if (ControlID.Count > 0)
{
try
{
for (int i=0;i<ControlID.Count;i++){
if (int.Parse(Request.Form[ControlID[i]])>0&&int.Parse(Request.Form[ControlID[i]])<100)
{
Models.Sepet s = new Models.Sepet();
s.UrunSiparisAdet = int.Parse(Request.Form[ControlID[i]]);
var res = kul == null ? p.Sepet.First(x => x.UrunID.ToString() == btn.CommandArgument && x.KullaniciAdi == null) : p.Sepet.First(x => x.UrunID.ToString() == btn.CommandArgument && x.KullaniciAdi == kul.KullaniciAdi);
res.UrunSiparisAdet = s.UrunSiparisAdet;
int last=btn.UniqueID.LastIndexOf("ctl0");
string find = btn.UniqueID.Substring(last, 5);
if (ControlID[i].Contains(find))
p.SaveChanges(); }
}
}
catch (OverflowException ex)
{
err = ex.Message;
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
finally
{
Models.PoliklinikEntities5 _p = new Models.PoliklinikEntities5();
if (Session["s1"]!=null)
{
var k = (Models.Kullanicilar)Session["s1"];
SepetList.DataSource = _p.Sepet.Where(x=>x.KullaniciAdi==k.KullaniciAdi).ToList();
}
else
SepetList.DataSource = _p.Sepet.Where(x=>x.KullaniciAdi==null).ToList();
SepetList.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Data.DataKatmani dk = new Data.DataKatmani();
Models.PoliklinikEntities5 pContent = new Models.PoliklinikEntities5();
try
{
var kul = (Models.Kullanicilar)Session["s1"];
var res = kul == null ? (from c in pContent.Sepet where c.KullaniciAdi==null select c) : (from c in pContent.Sepet where c.KullaniciAdi == kul.KullaniciAdi select c);
int SepetSayi = res.ToList().Count;
SepetimLabel.Text = "Sepetim(" + SepetSayi.ToString() + ")";
if (!IsPostBack)
{
DataList1.DataSource = dk.UrunKatListe1(ref err);
DataList1.DataBind();
if (Menu2.Items.Count < 1)
{
MenuItem ana = new MenuItem() { Text = "Hesabım", NavigateUrl = "" };
List<MenuItem> alt = new List<MenuItem>() {
new MenuItem{ Text = "Siparişlerim", NavigateUrl = "" },
new MenuItem{ Text = "Mesajlarım", NavigateUrl = "" },
new MenuItem{ Text = "Puanlarım", NavigateUrl = "" },
new MenuItem{ Text = "Hızlı Öde", NavigateUrl = "" },
new MenuItem{ Text = "Üyelik Bilgilerim", NavigateUrl = "" },
new MenuItem{ Text = "Adreslerim", NavigateUrl = "" }
};
Menu2.Items.Add(ana);
for (int i = 0; i < alt.Count; i++)
{
Menu2.Items[0].ChildItems.Add(alt[i]);
};
}
}
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
protected void Sehir_SelectedIndexChanged(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
try
{
Ilce.Items.Clear();
var res = p.il_ilce.Where(x => x.il == Sehir.SelectedItem.Text);
foreach (var item in res.ToList())
{
ListItem l = new ListItem();
l.Text = item.ilce;
l.Value = item.plaka.ToString();
Ilce.Items.Add(l);
}
Ilce.DataBind();
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
LeftMenuHazirla();
if (Session["s1"] != null)
{
var kul = (Models.Kullanicilar)Session["s1"];
//lblInfo1.Text = "Hoşgeldiniz " + kul.Adi + " " + kul.Soyadi;
}
#region !IsPostBack
if (!IsPostBack)
{
Models.PoliklinikEntities5 pContent = new Models.PoliklinikEntities5();
var res = from c in pContent.Sepet where c.SessionID == Session.SessionID select c;
//int SepetSayi = res.ToList().Count;
//SepetimLabel.Text = "Sepetim(" + SepetSayi.ToString() + ")";
Data.DataKatmani dk = new Data.DataKatmani();
try
{
if (Request.QueryString["KatID"] == null)
{
DataList1.DataSource = dk.UrunListe(1, ref err1);
DataList1.DataBind();
}
else
{
DataList1.DataSource = dk.UrunListe(int.Parse(Request.QueryString["KatID"]), ref err1);
DataList1.DataBind();
}
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
#endregion
}
protected void Sehir_SelectedIndexChanged(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
try
{
Ilce.Items.Clear();
var res = p.il_ilce.Where(x => x.il == Sehir.SelectedItem.Text);
foreach (var item in res.ToList())
{
ListItem l = new ListItem();
l.Text = item.ilce;
l.Value = item.plaka.ToString();
Ilce.Items.Add(l);
}
Ilce.DataBind();
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
protected void Sehir_Init(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
if (Sehir.Items.Count < 1)
{
try
{
var res = p.il_ilce.GroupBy(x => x.il).Select(grp => grp.FirstOrDefault());
foreach (var item in res.ToList())
{
ListItem l = new ListItem();
l.Text = item.il;
l.Value = item.plaka.ToString();
Sehir.Items.Add(l);
}
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
}
public static List <Data.DataKatmani.BulunanMetin> MetinAra(string Metin)
{
using (Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5())
{
List <Data.DataKatmani.BulunanMetin> sonucList = new List <Data.DataKatmani.BulunanMetin>();
var S = p.sp_MetinAra(Metin).ToList();
ContentPlaceHolder ContentHolder;
_default dd = new _default();
ListBox list;
ContentHolder = (ContentPlaceHolder)dd.Master.FindControl("ContentPlaceHolder1");
list = ContentHolder.FindControlRecursive("listboxSearch") as ListBox;
foreach (var item in S)
{
Data.DataKatmani.BulunanMetin sonuc = new Data.DataKatmani.BulunanMetin();
sonuc.UrunAdi = item.UrunAdi;
sonuc.UrunID = item.UrunID;
sonucList.Add(sonuc);
list.Items.Add(new ListItem(sonuc.UrunAdi, sonuc.UrunID.ToString()));
}
//l.DataBind();
return(sonucList);
}
}
public static List<Data.DataKatmani.BulunanMetin> MetinAra(string Metin)
{
using (Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5())
{
List<Data.DataKatmani.BulunanMetin> sonucList = new List<Data.DataKatmani.BulunanMetin>();
var S = p.sp_MetinAra(Metin).ToList();
ContentPlaceHolder ContentHolder;
_default dd=new _default();
ListBox list;
ContentHolder = (ContentPlaceHolder) dd.Master.FindControl("ContentPlaceHolder1");
list = ContentHolder.FindControlRecursive("listboxSearch") as ListBox;
foreach (var item in S)
{
Data.DataKatmani.BulunanMetin sonuc = new Data.DataKatmani.BulunanMetin();
sonuc.UrunAdi = item.UrunAdi;
sonuc.UrunID = item.UrunID;
sonucList.Add(sonuc);
list.Items.Add(new ListItem(sonuc.UrunAdi, sonuc.UrunID.ToString()));
}
//l.DataBind();
return sonucList;
}
}
protected void Sehir_Init(object sender, EventArgs e)
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
if (Sehir.Items.Count < 1)
{
try
{
var res = p.il_ilce.GroupBy(x => x.il).Select(grp => grp.FirstOrDefault());
foreach (var item in res.ToList())
{
ListItem l = new ListItem();
l.Text = item.il;
l.Value = item.plaka.ToString();
Sehir.Items.Add(l);
}
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
}
protected void btnTamamla_Click(object sender, EventArgs e)
{
//Tamamla
try
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
Models.Siparisler s_temp=new Models.Siparisler();
var kul=Session["s1"] as Models.Kullanicilar;
var resSepet = p.Sepet.Where(x => x.KullaniciAdi == kul.KullaniciAdi).ToList();
int i=0;
s_temp.SiparisNo = Guid.NewGuid();
s_temp.Kargo_Adi = KontrolKargo.Text;
s_temp.KartNo = KrediKartNo;
s_temp.KullaniciAdi = kul.KullaniciAdi;
s_temp.SiparisTarihi = DateTime.Now;
s_temp.Taksit_Adet = TaksitSayisi==0?"Peşin":TaksitSayisi.ToString();
s_temp.ToplamFiyat = GenelToplam;
s_temp.UrunID1 = (Guid)resSepet[0].UrunID;
s_temp.UrunID1_Adet = (byte)resSepet[0].UrunSiparisAdet;
s_temp.UrunID1_Adi = resSepet[0].UrunAdi;
s_temp.UrunID1_Fiyat = resSepet[0].UrunFiyat;
#region for
for(i=2;i<=resSepet.Count;i++)
{
switch (i)
{
case 2:
s_temp.UrunID2 = (Guid)resSepet[i-1].UrunID;
s_temp.UrunID2_Adet = (byte)resSepet[i-1].UrunSiparisAdet;
s_temp.UrunID2_Adi = resSepet[i-1].UrunAdi;
s_temp.UrunID2_Fiyat = resSepet[i-1].UrunFiyat;
break;
case 3:
s_temp.UrunID3 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID3_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID3_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID3_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 4:
s_temp.UrunID4 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID4_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID4_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID4_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 5:
s_temp.UrunID5 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID5_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID5_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID5_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 6:
s_temp.UrunID6 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID6_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID6_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID6_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 7:
s_temp.UrunID7 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID7_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID7_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID7_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 8:
s_temp.UrunID8 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID8_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID8_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID8_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 9:
s_temp.UrunID9 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID9_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID9_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID9_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 10:
s_temp.UrunID10 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID10_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID10_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID10_Fiyat = resSepet[i - 1].UrunFiyat;
break;
default:
break;
}
}
#endregion
p.Siparisler.Add(s_temp);
p.SaveChanges();
string script = "alert(\"Siparişiniz başarıyla kaydedildi.\")";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
catch (Exception ex)
{
err=ex.Message;
string script = "alert(\""+err+" hatası oluştu.\")";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
Response.Redirect("/default.aspx");
}
finally
{
txtAdres.Dispose();
btnAdresGuncelle.Dispose();
rKargo.Dispose();
rOdeme.Dispose();
txtKrediKartNo.Dispose();
CardOwnertmp.Dispose();
dlistAYtmp.Dispose();
dlistYILtmp.Dispose();
txtCVC2.Dispose();
lblKontrolKargo.Dispose();
lblKontrolGenelToplam.Dispose();
p.Dispose();
Response.Redirect("/default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
/*Kullanıcı girişsiz Sepet Listelenir */
if (Request.QueryString["SepetItemID"] == null)
{
goto End;
}
/*SepeteEkle çalışır */
Models.PoliklinikEntities5 pContext = new Models.PoliklinikEntities5();
Data.DataKatmani dk = new Data.DataKatmani();
string err = string.Empty;
List <Data.Sepet> _sepet = new List <Data.Sepet>();
Data.Sepet _sepetTemp = new Data.Sepet();
Models.Sepet _s = new Models.Sepet();
Guid SepetGuid = Guid.Parse(Request.QueryString["SepetItemID"].ToString());
Models.Kullanicilar kul = new Models.Kullanicilar();
#region !IsPostBack
if (!IsPostBack)
{
try
{
var res = (from c in pContext.Urunler
where c.UrunID == SepetGuid
select new { SessionID = Session.SessionID, UrunID = c.UrunID, UrunAdi = c.UrunAdi, UrunSiparisAdet = 1, UrunFiyat = c.IndirimliFiyat, ToplamFiyat = c.IndirimliFiyat * 1, UrunResmi = c.Resim1, GuncellemeTarihi = DateTime.Now });
foreach (var item in res)
{
if (Session["s1"] != null)
{
kul = (Models.Kullanicilar)Session["s1"];
_sepetTemp.KullaniciAdi = kul.KullaniciAdi;
}
_sepetTemp.SessionID = item.SessionID;
_sepetTemp.UrunID = item.UrunID;
_sepetTemp.UrunAdi = item.UrunAdi;
_sepetTemp.UrunSiparisAdet = item.UrunSiparisAdet;
_sepetTemp.UrunFiyat = item.UrunFiyat;
_sepetTemp.ToplamFiyat = item.ToplamFiyat;
_sepetTemp.UrunResmi = item.UrunResmi;
_sepetTemp.GuncellemeTarihi = item.GuncellemeTarihi;
}
dk.SepeteEkle(_sepetTemp, ref err);
_sepet = dk.SepetIcerik;
using (Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5())
{
try
{
var varmi1 = from c in p.Sepet
where c.KullaniciAdi == null && c.UrunID == SepetGuid
select c;
var varmi2 = from c in p.Sepet
where c.KullaniciAdi != null && c.KullaniciAdi == _sepetTemp.KullaniciAdi && c.UrunID == SepetGuid
select c;
if (Session["s1"] == null && varmi1.Count() < 1)
{
_s.KullaniciAdi = _sepetTemp.KullaniciAdi;
_s.SessionID = _sepetTemp.SessionID;
_s.UrunID = _sepetTemp.UrunID;
_s.UrunAdi = _sepetTemp.UrunAdi;
_s.UrunSiparisAdet = _sepetTemp.UrunSiparisAdet;
_s.UrunFiyat = _sepetTemp.UrunFiyat;
//ToplamFiyat otomatik hesaplaniyor
_s.UrunResmi = _sepetTemp.UrunResmi;
_s.GuncellemeTarihi = DateTime.Now;
p.Sepet.Add(_s);
p.SaveChanges();
SepetList.DataSource = p.Sepet.Where(x => x.KullaniciAdi == null).ToList();
SepetList.DataBind();
}
else if (Session["s1"] != null && varmi2.Count() < 1)
{
_s.KullaniciAdi = _sepetTemp.KullaniciAdi;
_s.SessionID = _sepetTemp.SessionID;
_s.UrunID = _sepetTemp.UrunID;
_s.UrunAdi = _sepetTemp.UrunAdi;
_s.UrunSiparisAdet = _sepetTemp.UrunSiparisAdet;
_s.UrunFiyat = _sepetTemp.UrunFiyat;
//ToplamFiyat otomatik hesaplaniyor
_s.UrunResmi = _sepetTemp.UrunResmi;
_s.GuncellemeTarihi = DateTime.Now;
p.Sepet.Add(_s);
p.SaveChanges();
SepetList.DataSource = p.Sepet.Where(x => x.KullaniciAdi == kul.KullaniciAdi).ToList();
SepetList.DataBind();
}
if (Session["s1"] == null && varmi1.Count() > 0)
{
SepetList.DataSource = p.Sepet.Where(x => x.KullaniciAdi == null).ToList();
SepetList.DataBind();
}
else if (Session["s1"] != null && varmi2.Count() > 0)
{
SepetList.DataSource = p.Sepet.Where(x => x.KullaniciAdi == kul.KullaniciAdi).ToList();
SepetList.DataBind();
}
}
catch (DbEntityValidationException ex)
{
foreach (var eve in ex.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
catch (Exception)
{
throw;
}
}
#endregion
goto End1;
End:
/*Kullanıcı girişsiz Sepet Listelenir */
using (Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5())
{
var k = (Models.Kullanicilar)Session["s1"];
SepetList.DataSource = Session["s1"] == null?p.Sepet.Where(x => x.KullaniciAdi == null).ToList() : p.Sepet.Where(x => x.KullaniciAdi == k.KullaniciAdi).ToList();
SepetList.DataBind();
}
End1 :;
}
protected void Page_Load(object sender, EventArgs e)
{
/*Kullanıcı girişsiz Sepet Listelenir */
if (Request.QueryString["SepetItemID"]==null)
goto End;
/*SepeteEkle çalışır */
Models.PoliklinikEntities5 pContext = new Models.PoliklinikEntities5();
Data.DataKatmani dk = new Data.DataKatmani();
string err=string.Empty;
List<Data.Sepet> _sepet = new List<Data.Sepet>();
Data.Sepet _sepetTemp = new Data.Sepet();
Models.Sepet _s = new Models.Sepet();
Guid SepetGuid = Guid.Parse(Request.QueryString["SepetItemID"].ToString());
Models.Kullanicilar kul=new Models.Kullanicilar();
#region !IsPostBack
if (!IsPostBack)
{
try
{
var res = (from c in pContext.Urunler
where c.UrunID==SepetGuid
select new { SessionID=Session.SessionID, UrunID=c.UrunID, UrunAdi = c.UrunAdi, UrunSiparisAdet = 1, UrunFiyat = c.IndirimliFiyat, ToplamFiyat=c.IndirimliFiyat*1, UrunResmi = c.Resim1, GuncellemeTarihi=DateTime.Now });
foreach (var item in res)
{
if (Session["s1"] != null)
{
kul = (Models.Kullanicilar)Session["s1"];
_sepetTemp.KullaniciAdi=kul.KullaniciAdi;
}
_sepetTemp.SessionID = item.SessionID;
_sepetTemp.UrunID = item.UrunID;
_sepetTemp.UrunAdi = item.UrunAdi;
_sepetTemp.UrunSiparisAdet = item.UrunSiparisAdet;
_sepetTemp.UrunFiyat = item.UrunFiyat;
_sepetTemp.ToplamFiyat = item.ToplamFiyat;
_sepetTemp.UrunResmi = item.UrunResmi;
_sepetTemp.GuncellemeTarihi = item.GuncellemeTarihi;
}
dk.SepeteEkle(_sepetTemp,ref err);
_sepet = dk.SepetIcerik;
using (Models.PoliklinikEntities5 p=new Models.PoliklinikEntities5())
{
try
{
var varmi1 = from c in p.Sepet
where c.KullaniciAdi == null && c.UrunID == SepetGuid
select c;
var varmi2 = from c in p.Sepet
where c.KullaniciAdi!=null && c.KullaniciAdi==_sepetTemp.KullaniciAdi && c.UrunID == SepetGuid
select c;
if (Session["s1"] == null && varmi1.Count()<1)
{
_s.KullaniciAdi = _sepetTemp.KullaniciAdi;
_s.SessionID = _sepetTemp.SessionID;
_s.UrunID = _sepetTemp.UrunID;
_s.UrunAdi = _sepetTemp.UrunAdi;
_s.UrunSiparisAdet = _sepetTemp.UrunSiparisAdet;
_s.UrunFiyat = _sepetTemp.UrunFiyat;
//ToplamFiyat otomatik hesaplaniyor
_s.UrunResmi = _sepetTemp.UrunResmi;
_s.GuncellemeTarihi = DateTime.Now;
p.Sepet.Add(_s);
p.SaveChanges();
SepetList.DataSource = p.Sepet.Where(x => x.KullaniciAdi == null).ToList();
SepetList.DataBind();
}
else if (Session["s1"] != null && varmi2.Count() < 1)
{
_s.KullaniciAdi = _sepetTemp.KullaniciAdi;
_s.SessionID = _sepetTemp.SessionID;
_s.UrunID = _sepetTemp.UrunID;
_s.UrunAdi = _sepetTemp.UrunAdi;
_s.UrunSiparisAdet = _sepetTemp.UrunSiparisAdet;
_s.UrunFiyat = _sepetTemp.UrunFiyat;
//ToplamFiyat otomatik hesaplaniyor
_s.UrunResmi = _sepetTemp.UrunResmi;
_s.GuncellemeTarihi = DateTime.Now;
p.Sepet.Add(_s);
p.SaveChanges();
SepetList.DataSource = p.Sepet.Where(x=>x.KullaniciAdi== kul.KullaniciAdi).ToList();
SepetList.DataBind();
}
if (Session["s1"] == null && varmi1.Count() >0)
{
SepetList.DataSource = p.Sepet.Where(x => x.KullaniciAdi == null).ToList();
SepetList.DataBind();
}
else if (Session["s1"] != null && varmi2.Count() >0)
{
SepetList.DataSource = p.Sepet.Where(x => x.KullaniciAdi == kul.KullaniciAdi).ToList();
SepetList.DataBind();
}
}
catch (DbEntityValidationException ex)
{
foreach (var eve in ex.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
catch (Exception)
{
throw;
}
}
#endregion
goto End1;
End:
/*Kullanıcı girişsiz Sepet Listelenir */
using (Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5())
{
var k = (Models.Kullanicilar)Session["s1"];
SepetList.DataSource = Session["s1"] == null ? p.Sepet.Where(x => x.KullaniciAdi == null).ToList() : p.Sepet.Where(x => x.KullaniciAdi == k.KullaniciAdi).ToList();
SepetList.DataBind();
}
End1:;
}
protected void Page_Load(object sender, EventArgs e)
{
LeftMenuHazirla();
if (Session["s1"] != null)
{
var kul = (Models.Kullanicilar)Session["s1"];
//lblInfo1.Text = "Hoşgeldiniz " + kul.Adi + " " + kul.Soyadi;
}
#region !IsPostBack
if (!IsPostBack)
{
Models.PoliklinikEntities5 pContent = new Models.PoliklinikEntities5();
var res = from c in pContent.Sepet where c.SessionID == Session.SessionID select c;
//int SepetSayi = res.ToList().Count;
//SepetimLabel.Text = "Sepetim(" + SepetSayi.ToString() + ")";
Data.DataKatmani dk = new Data.DataKatmani();
try
{
if (Request.QueryString["KatID"]== null)
{
DataList1.DataSource = dk.UrunListe(1, ref err1);
DataList1.DataBind();
}
else
{
DataList1.DataSource = dk.UrunListe(int.Parse(Request.QueryString["KatID"]), ref err1);
DataList1.DataBind();
}
}
catch (Exception ex)
{
err = ex.Message;
throw;
}
}
#endregion
}
protected void btnTamamla_Click(object sender, EventArgs e)
{
//Tamamla
try
{
Models.PoliklinikEntities5 p = new Models.PoliklinikEntities5();
Models.Siparisler s_temp = new Models.Siparisler();
var kul = Session["s1"] as Models.Kullanicilar;
var resSepet = p.Sepet.Where(x => x.KullaniciAdi == kul.KullaniciAdi).ToList();
int i = 0;
s_temp.SiparisNo = Guid.NewGuid();
s_temp.Kargo_Adi = KontrolKargo.Text;
s_temp.KartNo = KrediKartNo;
s_temp.KullaniciAdi = kul.KullaniciAdi;
s_temp.SiparisTarihi = DateTime.Now;
s_temp.Taksit_Adet = TaksitSayisi == 0?"Peşin":TaksitSayisi.ToString();
s_temp.ToplamFiyat = GenelToplam;
s_temp.UrunID1 = (Guid)resSepet[0].UrunID;
s_temp.UrunID1_Adet = (byte)resSepet[0].UrunSiparisAdet;
s_temp.UrunID1_Adi = resSepet[0].UrunAdi;
s_temp.UrunID1_Fiyat = resSepet[0].UrunFiyat;
#region for
for (i = 2; i <= resSepet.Count; i++)
{
switch (i)
{
case 2:
s_temp.UrunID2 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID2_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID2_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID2_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 3:
s_temp.UrunID3 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID3_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID3_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID3_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 4:
s_temp.UrunID4 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID4_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID4_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID4_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 5:
s_temp.UrunID5 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID5_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID5_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID5_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 6:
s_temp.UrunID6 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID6_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID6_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID6_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 7:
s_temp.UrunID7 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID7_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID7_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID7_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 8:
s_temp.UrunID8 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID8_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID8_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID8_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 9:
s_temp.UrunID9 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID9_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID9_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID9_Fiyat = resSepet[i - 1].UrunFiyat;
break;
case 10:
s_temp.UrunID10 = (Guid)resSepet[i - 1].UrunID;
s_temp.UrunID10_Adet = (byte)resSepet[i - 1].UrunSiparisAdet;
s_temp.UrunID10_Adi = resSepet[i - 1].UrunAdi;
s_temp.UrunID10_Fiyat = resSepet[i - 1].UrunFiyat;
break;
default:
break;
}
}
#endregion
p.Siparisler.Add(s_temp);
p.SaveChanges();
string script = "alert(\"Siparişiniz başarıyla kaydedildi.\")";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
catch (Exception ex)
{
err = ex.Message;
string script = "alert(\"" + err + " hatası oluştu.\")";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
Response.Redirect("/default.aspx");
}
finally
{
txtAdres.Dispose();
btnAdresGuncelle.Dispose();
rKargo.Dispose();
rOdeme.Dispose();
txtKrediKartNo.Dispose();
CardOwnertmp.Dispose();
dlistAYtmp.Dispose();
dlistYILtmp.Dispose();
txtCVC2.Dispose();
lblKontrolKargo.Dispose();
lblKontrolGenelToplam.Dispose();
p.Dispose();
Response.Redirect("/default.aspx");
}
}