protected void btnuyegirisi_Click(object sender, EventArgs e)
{
using (var ctx = new YemekSepetiDBContext())
{
var q1 = from p in ctx.Users
where p.eMail == txtemail.Text
select p;
if (q1.Any())
{
Response.Write("<script> alert('Bu E-Mail zaten kullanılıyor'); </script>");
}
else
{
var newuser = new User()
{
Ad = txtAd.Text,
Soyad = txtsoyad.Text,
eMail = txtemail.Text,
Password = txtsifre.Text,
dTarihi = DateTime.Now,
Semt = txtsemt.Text,
};
ctx.Users.Add(newuser);
ctx.SaveChanges();
Response.Write("<script> alert('Kayıt başarı ile tamamlandı.'); </script>");
Response.Redirect("Default.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login_onay"] != "OK")
{
Response.Redirect("Default.aspx");
}
int id = int.Parse(Session["id"].ToString());
YemekSepetiDBContext ctx = new YemekSepetiDBContext();
var q1 = ctx.Sepets.Where(x => x.User_Id == id).ToList();
repSepet.DataSource = q1.ToList();
repSepet.DataBind();
var qUser = ctx.Users.Where(x => x.Id == id).FirstOrDefault();
labAdSoyad.Text = " " + qUser.Ad + " " + qUser.Soyad;
var qSiparis = ctx.Siparislers.Where(x => x.User_Id == id);
repsiparis.DataSource = qSiparis.ToList();
repsiparis.DataBind();
var qFavori = ctx.Favoris.Where(x => x.User_Id == id);
repFavori.DataSource = qFavori.ToList();
repFavori.DataBind();
var qAdres = ctx.Adres.Where(x => x.User_Id == id);
repAdres.DataSource = qAdres.ToList();
repAdres.DataBind();
HttpCookie cerez = Request.Cookies["sehir"];
if (cerez != null)
{
int SehirNo = int.Parse(cerez["sNo"]);
var qYERestorant = ctx.YERestorantlars.Where(x => x.sehir_Id == SehirNo).ToList();
repYERestoranlar.DataSource = qYERestorant.ToList();
repYERestoranlar.DataBind();
}
//string sd = string.Empty;
//foreach (var item in q1)
//{
// sd += item.İsim.ToString() + " ";
// sd += item.Fiyat.ToString() + " ";
// sd += item.Detay.ToString() + " <br/> ";
//}
//Label1.Text = sd;
}
private bool IsvalidUser(string userName, string password)
{
YemekSepetiDBContext ctx = new YemekSepetiDBContext();
var q1 = from p in ctx.Users
where p.eMail == userName &&
p.Password == password
select p;
if (q1.Any())
{
var q2 = ctx.Users.Where(x => x.eMail == userName && x.Password == password).FirstOrDefault();
Session["id"] = q2.Id;
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cerez = Request.Cookies["sehir"];
if (cerez != null)
{
int SehirNo = int.Parse(cerez["sNo"]);
YemekSepetiDBContext ctx = new YemekSepetiDBContext();
var qCola = ctx.ColaKampanyas.Where(x => x.sehir_Id == SehirNo).FirstOrDefault();
if (qCola != null)
{
imagCola.ImageUrl = qCola.fotoUrl;
imagCola.PostBackUrl = qCola.baglantiUrl;
}
else
{
imagCola.ImageUrl = "imege/bulunamadi.jpg";
imagCola.PostBackUrl = "#";
}
var qVodafon = ctx.VodafonKs.Where(x => x.sehir_Id == SehirNo).FirstOrDefault();
if (qVodafon != null)
{
imagVodafon.ImageUrl = qVodafon.fotoUrl;
imagVodafon.PostBackUrl = qVodafon.baglantiUrl;
}
else
{
imagVodafon.ImageUrl = "imege/bulunamadi.jpg";
imagVodafon.PostBackUrl = "#";
}
var qYERestorant = ctx.YERestorantlars.Where(x => x.sehir_Id == SehirNo).ToList();
repYERestoranlar.DataSource = qYERestorant.ToList();
repYERestoranlar.DataBind();
}
}
