private void GetDistricts() { ddlIlce.DataSource = GgDbProvider.GetDistrictList(); ddlIlce.DataTextField = "DistrictName"; ddlIlce.DataValueField = "ObjectID"; ddlIlce.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } dlUrunler.DataSource = GgDbProvider.GetProductList(); dlUrunler.DataBind(); if (dlUrunler.Items.Count == 0) { pnlUrunler.Visible = false; pnlBilgi.Visible = true; } else { pnlUrunler.Visible = true; pnlBilgi.Visible = false; } lblTopFiyat.Text = "0 TL"; lblUrunSayisi.Text = "0 Ürün"; btnSiparis.CssClass += "btn btn-default butonn disabled"; ddlFiltering.DataSource = GgDbProvider.GetCategoryList(); ddlFiltering.DataBind(); lstDistrict.DataSource = GgDbProvider.GetDistrictList(); lstDistrict.DataBind(); lstDistrict.Items.Add(new ListItem() { Text = "Seçiniz" }); List <double> toplamFiyat = new List <double>(); if (Session["ToplamFiyat"] != null) { toplamFiyat = Session["ToplamFiyat"] as List <double>; double toplam = ToplamUrunFiyatiniHesapla(toplamFiyat); lblTopFiyat.Text = toplam.ToString(); lblSayi.Text = Session["ToplamUrunSayisi"].ToString(); lblUrunSayisi.Text = Session["ToplamUrunSayisi"].ToString(); lblUrunSayisi.Text += " " + "Ürün"; lblTopFiyat.Text += " " + "TL"; btnSiparis.CssClass += "btn btn-default butonn"; } else { lblTopFiyat.Text = ""; lblSayi.Text = "0"; lblUrunSayisi.Text = "Sepetinizde ürün yok."; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } ddlCategory.DataSource = GgDbProvider.GetCategoryList(); ddlCategory.DataBind(); if (Session["Oturum"] != null) { User currentUser = Session["Oturum"] as User; int id = Convert.ToInt32(Request.QueryString["id"]); Product p = new Product(); p = GgDbProvider.Product.FirstOrDefault(i => i.ObjectID == id); if (p != default(Product)) { txtProductName.Text = p.ProductName; txtPrice.Text = p.Price.ToString(); txtQuantity.Text = p.Quantity.ToString(); ddlCategory.SelectedIndex = p.CategoryID; } } else { Session["URL"] = "gelensiparis"; Response.Redirect("Login.aspx"); } }
protected void btnLogin_Click(object sender, EventArgs e) { string usr = txtKullaniciAdi.Text; string pswd = txtPswd.Text; User result = GgDbProvider.GetUserByUsernameAndPassword(usr, pswd); if (result != default(User)) { Session["Oturum"] = result; if (Session["URL"] as string == "siparis") { Response.Redirect("UrunSiparis.aspx"); } else if (Session["URL"] as string == "siparislerim") { Response.Redirect("Siparislerim.aspx"); } else if (Session["URL"] as string == "gelensiparis") { Response.Redirect("GelenSiparis.aspx"); } else { Response.Redirect("Urunlerr.aspx"); } } else { panelDanger.Visible = true; Session["Oturum"] = null; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (Session["Oturum"] != null) { User currentUser = Session["Oturum"] as User; if (currentUser != default(User)) { rptSiparislerim.DataSource = GgDbProvider.GetOrderByCustomerId(currentUser.ObjectID); rptSiparislerim.DataBind(); if (rptSiparislerim.Items.Count == 0) { lblNoSiparis.Visible = true; } } } else { Session["URL"] = "siparislerim"; Response.Redirect("Login.aspx"); } }
protected void dlUrunler_ItemCommand(object source, DataListCommandEventArgs args) { if (args.CommandName == "btnLeaveComment") { HiddenField hfCommentedProductId = (HiddenField)args.Item.FindControl("hfCommentedProductId"); TextBox txtCommentBody = (TextBox)args.Item.FindControl("txtCommentBody"); TextBox txtCommentHeader = (TextBox)args.Item.FindControl("txtCommentHeader"); DropDownList ddlStar = (DropDownList)args.Item.FindControl("ddlStar"); string comment = txtCommentBody.Text; string header = txtCommentHeader.Text; int star = Convert.ToInt32(ddlStar.SelectedValue); if (Session["Oturum"] == null) { Response.Redirect("Login.aspx"); } else { User autUser = Session["Oturum"] as User; if (autUser == default(User)) { Response.Redirect("Login.aspx"); } else { GgDbProvider.AddComment(header, comment, autUser.ObjectID, Convert.ToInt32(hfCommentedProductId.Value), star); //pnlInfo.Visible = true; Response.Write("<script>alert('Yorumunuz başarıyla eklendi. ');</script>"); } } } }
protected void dlUrunler_ItemDataBound(object sender, DataListItemEventArgs args) { if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem) { Repeater childRepeater = (Repeater)args.Item.FindControl("rptCommentList"); HiddenField hfCommentedProductId = (HiddenField)args.Item.FindControl("hfCommentedProductId"); childRepeater.DataSource = GgDbProvider.GetCommentListForProduct(Convert.ToInt32(hfCommentedProductId.Value)).ToList(); childRepeater.DataBind(); } }
protected void rptSupplier_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "sil") { Product p = new Product(); int id = Convert.ToInt32(e.CommandArgument); p = GgDbProvider.Product.FirstOrDefault(i => i.Deleted == false && i.ObjectID == id); p.Deleted = true; GgDbProvider.SaveChanges(); } Response.Redirect("ShopLayout.aspx"); }
protected void btnGonder_Click(object sender, EventArgs e) { string ad, soyad, kullaniciAdi, sifre, eMail, adres, telefon, dukkanAd, resimYolu; ad = txtAd.Text; soyad = txtSoyad.Text; kullaniciAdi = txtKullaniciAdi.Text; sifre = txtPswd.Text; eMail = txtMail.Text; adres = txtAdres.Text; telefon = txtTelefon.Text; dukkanAd = txtDukkanAd.Text; resimYolu = null; if (rbManav.Checked == true) { try { if (fuFoto.HasFile) { HttpPostedFile upload = fuFoto.PostedFile; if (upload.ContentType.Contains("image") && upload.ContentLength < 1000000000) { Guid id = Guid.NewGuid(); resimYolu = Server.MapPath(string.Format("manavlar/{0}.jpg", id)); } else { //Çok büyük bla bla } } else { // Geçerli bir dosya yükleyin bla bla } } catch (Exception ex) { Response.Write("Hata oldu resim yüklenirken./n" + ex.InnerException); } Response.Write(resimYolu); int UserID = GgDbProvider.AddUser(ad, soyad, kullaniciAdi, sifre, eMail, 0); int DistrictID = Convert.ToInt32(ddlIlce.SelectedValue); //Bir şey seçmeyince patlar dikkat et GgDbProvider.AddSupplier(UserID, DistrictID, dukkanAd, adres, telefon, resimYolu); //Response.Write(resimYolu); } else if (rbMusteri.Checked == true) { GgDbProvider.AddUser(ad, soyad, kullaniciAdi, sifre, eMail, 1); } Temizle(); }
protected void Unnamed_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); Product p = new Product(); p = GgDbProvider.Product.FirstOrDefault(i => i.ObjectID == id); p.ProductName = txtProductName.Text.Trim(); p.Quantity = Convert.ToInt32(txtQuantity.Text.Trim()); p.Price = Convert.ToDecimal(txtQuantity.Text.Trim()); p.CategoryID = Convert.ToInt32(ddlCategory.SelectedValue); GgDbProvider.SaveChanges(); Response.Redirect("ShopLayout.aspx"); }
protected void rptSupplier_ItemDataBound(object sender, RepeaterItemEventArgs args) { if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem) { Repeater childRepeater = (Repeater)args.Item.FindControl("rptCommentList"); HiddenField hfCommentedProductId = (HiddenField)args.Item.FindControl("hfCommentedProductId"); Panel pnlInfo = (Panel)args.Item.FindControl("pnlInfo"); childRepeater.DataSource = GgDbProvider.GetCommentListForProduct(Convert.ToInt32(hfCommentedProductId.Value)).ToList(); childRepeater.DataBind(); if (childRepeater.Items.Count < 1) { pnlInfo.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } rptSupplier.DataSource = GgDbProvider.GetSupplierList(); rptSupplier.DataBind(); lstDistrict.DataSource = GgDbProvider.GetDistrictList(); lstDistrict.DataBind(); lstDistrict.Items.Add(new ListItem() { Text = "Seçiniz" }); }
protected void lbLogin_Click(object sender, EventArgs e) { string usr = txtLoginUsername.Text; string pswd = txtLoginPasswd.Text; User result = GgDbProvider.GetUserByUsernameAndPassword(usr, pswd); if (result != default(User)) { Session["Oturum"] = result; Response.Redirect("Urunlerr.aspx"); } else { panelDanger.Visible = true; Session["Oturum"] = null; } }
protected void rptComments_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Onayla") { int id = Convert.ToInt32(e.CommandArgument); Comment c = GgDbProvider.Comment.FirstOrDefault(i => i.Deleted != true && i.ObjectId == id); if (c != default(Comment)) { c.ApprovedDate = DateTime.Now; if (Session["Oturum"] != null) { User result = Session["Oturum"] as User; if (result != default(User) && result.RoleID == 1) { c.ApproverID = result.ObjectID; } else { Response.Redirect("Yetkisiz.aspx"); } } else { Response.Redirect("Login.aspx"); } c.IsApproved = true; GgDbProvider.SaveChanges(); rptComments.DataSource = GgDbProvider.Comment.Where(a => a.Deleted != true && a.IsApproved == false).OrderBy(i => i.CommentDate); rptComments.DataBind(); } } else if (e.CommandName == "Sil") { int id = Convert.ToInt32(e.CommandArgument); Comment c = GgDbProvider.Comment.FirstOrDefault(i => i.Deleted != true && i.ObjectId == id); if (c != default(Comment)) { c.Deleted = true; GgDbProvider.SaveChanges(); rptComments.DataSource = GgDbProvider.Comment.Where(a => a.Deleted != true && a.IsApproved == false).OrderBy(i => i.CommentDate); rptComments.DataBind(); } } }
protected void btnIleri_Click(object sender, EventArgs e) { string ad, soyad, kullaniciAdi, sifre, eMail; ad = txtAd.Text; soyad = txtSoyad.Text; kullaniciAdi = txtUsr.Text; sifre = txtPswd.Text; eMail = txtMail.Text; if (cbAdmin.Checked == true) { GgDbProvider.AddUser(ad, soyad, kullaniciAdi, sifre, eMail, 0); } else if (cbUser.Checked == true) { GgDbProvider.AddUser(ad, soyad, kullaniciAdi, sifre, eMail, 1); } Temizle(); }
protected void btnSearch_Click(object sender, EventArgs e) { List <Product> result = new List <Product>(); if (txtSearchProduct.Text.Trim() != "" && txtSearchSupplier.Text.Trim() != "") { result = GgDbProvider.GetProductList().Where(i => i.ProductName.ToLower().Contains(txtSearchProduct.Text.Trim().ToLower()) || i.Supplier.CompanyName.ToLower().Contains(txtSearchSupplier.Text.Trim().ToLower())).ToList(); } else if (txtSearchProduct.Text.Trim() != "" && txtSearchSupplier.Text.Trim() == "") { result = GgDbProvider.GetProductList().Where(i => i.ProductName.ToLower().Contains(txtSearchProduct.Text.Trim().ToLower())).ToList(); } else if (txtSearchProduct.Text.Trim() == "" && txtSearchSupplier.Text.Trim() != "") { result = GgDbProvider.GetProductList().Where(i => i.Supplier.CompanyName.ToLower().Contains(txtSearchSupplier.Text.Trim().ToLower())).ToList(); } else { result = GgDbProvider.GetProductList(); } List <Product> result2 = new List <Product>(); foreach (int item in lstDistrict.GetSelectedIndices()) { result2.AddRange(result.Where(i => i.Supplier.DistrictID == Convert.ToInt32(lstDistrict.Items[item].Value)).ToList()); } dlUrunler.DataSource = result2; dlUrunler.DataBind(); if (dlUrunler.Items.Count == 0) { pnlUrunler.Visible = false; pnlBilgi.Visible = true; } else { pnlUrunler.Visible = true; pnlBilgi.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (Session["Oturum"] != null) { User currentUser = Session["Oturum"] as User; if (currentUser != default(User)) { rptSupplier.DataSource = GgDbProvider.GetProductList().Where(i => i.SupplierID == currentUser.ObjectID); rptSupplier.DataBind(); } } else { Session["URL"] = "gelensiparis"; Response.Redirect("Login.aspx"); } }
protected void ddlFiltering_SelectedIndexChanged(object sender, EventArgs e) { if (ddlFiltering.SelectedValue == "Seçiniz") { dlUrunler.DataSource = GgDbProvider.GetProductList(); } else { dlUrunler.DataSource = GgDbProvider.GetProductList().Where(i => i.CategoryID == Convert.ToInt32(ddlFiltering.SelectedValue)); } dlUrunler.DataBind(); if (dlUrunler.Items.Count == 0) { pnlUrunler.Visible = false; pnlBilgi.Visible = true; } else { pnlUrunler.Visible = true; pnlBilgi.Visible = false; } }
protected void rptSiparislerim_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "iptal") { int id = Convert.ToInt32(e.CommandArgument); Order o = GgDbProvider.GetOrderByObjectId(id); if (o != default(Order)) { o.StatusId = 6; } o.LastOperationDate = DateTime.Now; } if (e.CommandName == "onay") { int id = Convert.ToInt32(e.CommandArgument); Order o = GgDbProvider.GetOrderByObjectId(id); if (o != default(Order)) { o.StatusId = 3; } o.LastOperationDate = DateTime.Now; } GgDbProvider.SaveChanges(); if (Session["Oturum"] != null) { User currentUser = Session["Oturum"] as User; if (currentUser != default(User)) { rptSiparislerim.DataSource = GgDbProvider.GetOrderByCustomerId(currentUser.ObjectID); rptSiparislerim.DataBind(); } } else { Session["URL"] = "gelensiparis"; Response.Redirect("Login.aspx"); } }
protected void btnKaydet_Click(object sender, EventArgs e) { var liste = Session["liste"] as List <Product>; int manavID = 0; if (liste != null) { foreach (var item in liste) { GgDbProvider.AddProduct(manavID, item); } // GgDbProvider.SaveChanges(); urunKayit.Visible = true; //paragrafBilgi.InnerText = "Ürünleriniz başarıyla kaydedilmiştir."; Session.Remove("liste"); } else { //paragrafBilgi.InnerText = "Listenizde ekli ürün olmadığı için hiçbir ürün eklenmedi."; urunKayit.Visible = false; Session.Remove("liste"); } }
protected void ddlSorting_SelectedIndexChanged(object sender, EventArgs e) { if (ddlSorting.SelectedValue == "artan") { dlUrunler.DataSource = GgDbProvider.GetProductList().OrderBy(i => i.Price); dlUrunler.DataBind(); } else if (ddlSorting.SelectedValue == "azalan") { dlUrunler.DataSource = GgDbProvider.GetProductList().OrderByDescending(i => i.Price); dlUrunler.DataBind(); } if (dlUrunler.Items.Count == 0) { pnlUrunler.Visible = false; pnlBilgi.Visible = true; } else { pnlUrunler.Visible = true; pnlBilgi.Visible = false; } }
protected void btnSearch_Click(object sender, EventArgs e) { List <Supplier> result = GgDbProvider.GetSupplierList(); List <Supplier> result2 = new List <Supplier>(); foreach (int item in lstDistrict.GetSelectedIndices()) { result2.AddRange(result.Where(i => i.DistrictID == Convert.ToInt32(lstDistrict.Items[item].Value)).ToList()); } rptSupplier.DataSource = result2; rptSupplier.DataBind(); if (rptSupplier.Items.Count == 0) { //pnlUrunler.Visible = false; pnlBilgi.Visible = true; } else { //pnlUrunler.Visible = true; pnlBilgi.Visible = false; } }
private void KategoriGetir() { rptKategori.DataSource = GgDbProvider.GetCategoryList(); rptKategori.DataBind(); }
protected void btnOnayla_Click(object sender, EventArgs e) { int paymentTypeId = 0; List <GgDB.Product> urunler = new List <GgDB.Product>(); urunler = Session["urunler"] as List <GgDB.Product>; GgDB.Product p = new GgDB.Product(); string fiyat; string kilo; string ad; int i = 0; string body = txtAdres.Text.Trim(); body += " adresine istenilen sipariş şu şekildedir: \n \n"; while (i < urunler.Count) { p = urunler[i]; ad = p.ProductName; fiyat = p.Price.ToString(); kilo = p.Quantity.ToString(); body += " " + ad + " ürününden "; body += kilo + " kg "; body += "(" + fiyat + " TL" + "),\n"; ++i; } body += "\nEkli Notlar: " + txtNot.Text; body += "\nOrganic Online ekibi bol kazançlar diler."; string manavMail; manavMail = p.Supplier.User.E_mail; if (rb1.Checked) { paymentTypeId = 1; } if (rb2.Checked) { paymentTypeId = 2; } else if (rb3.Checked) { paymentTypeId = 3; } else { pBilgi.Visible = true; pBilgi.InnerText = "Lütfen ödeme tipini belirtiniz."; return; } //try //{ OrderCode code = new OrderCode(); GgDbProvider.AddToOrderCode(code); GgDbProvider.SaveChanges(); User customer = Session["Oturum"] as User; if (customer == default(User)) { Response.Redirect("Login.aspx"); } foreach (Product item in urunler) { GgDbProvider.AddOrder(customer.ObjectID, item.ObjectID, 1, paymentTypeId, item.Quantity, txtAdres.Text.Trim(), txtNot.Text.Trim(), code.ObjectId); } GgDbProvider.SaveChanges(); MailMessage mail = new MailMessage("*****@*****.**", manavMail); SmtpClient client = new SmtpClient(); client.Port = 587; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.EnableSsl = true; client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "ggdb1234"); client.Host = "smtp.gmail.com"; mail.Subject = "Ürün Siparişi"; mail.Body = body; client.Send(mail); txtAdres.Text = ""; txtNot.Text = ""; Session.Remove("Urunler"); Session.Remove("urunler"); Session.Remove("ToplamFiyat"); pBilgi.Visible = true; pBilgi.InnerText = code.ObjectId + " numaralı siparişiniz başarıyla gönderilmiştir. En yakın sürede adresinize ulaşacaktır."; rptUrunler.Visible = false; txtNot.Visible = false; txtAdres.Visible = false; btnOnayla.Visible = false; pnlPaymnet.Visible = false; //} //catch //{ // Response.Write("<script>alert('Sipariş gönderilirken bir hata oldu lütfen bir daha deneyiniz.');</script>"); // UrunleriGetir(urunler); //} }