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);
//}
}
