protected void signup_btn_Click(object sender, EventArgs e) { ElectroDBEntities db = new ElectroDBEntities(); customer newCust = new customer(); newCust.f_name = f_name.Text; newCust.l_name = l_name.Text; newCust.gender = gender.SelectedItem.Text; if (cust_type.SelectedItem.Text == "Seller") { newCust.is_seller = true; } else { newCust.is_seller = false; } newCust.username = username.Text; newCust.pass = pass.Text; if (p_img.PostedFile != null) { byte[] bytes; using (BinaryReader br = new BinaryReader(p_img.PostedFile.InputStream)) { bytes = br.ReadBytes(p_img.PostedFile.ContentLength); } newCust.cust_img = bytes; db.customers.Add(newCust); db.SaveChanges(); creation_alert.Attributes.Remove("hidden"); } }
protected void Page_Load(object sender, EventArgs e) { int returnId = Convert.ToInt16(Session["userID"].ToString()); // Entity object ElectroDBEntities db = new ElectroDBEntities(); functions user_functions = new functions(); var review = from c in db.customers where c.cust_ID == returnId select c; var userss = review.FirstOrDefault(); if (userss.cust_img != null) { Image1.ImageUrl = user_functions.image_retrive(userss.cust_ID); } user_id_label.Text = userss.cust_ID.ToString(); username_label.Text = userss.username; fullName_label.Text = userss.f_name + " " + userss.l_name; DB_label.Text = userss.b_date.ToString(); email_label.Text = userss.gender; if (userss.is_seller == true) { customer_type.Text = "Seller"; } if (userss.is_seller == false) { customer_type.Text = "Buyer"; } }
public void add_product_btn_Click1(object sender, EventArgs e) { string userName = Session["userName"].ToString(); int sID = Convert.ToInt16(Session["userID"].ToString()); ElectroDBEntities db2 = new ElectroDBEntities(); product newitem = new product(); newitem.p_ID = 100; newitem.p_name = p_name.Text; newitem.p_cat = p_category.SelectedItem.Text; newitem.p_price = Convert.ToInt16(p_price.Text); newitem.seller_ID = sID; newitem.p_desc = p_desc.InnerText; newitem.is_solled = false; if (imageUploader.PostedFile != null) { byte[] bytes; using (BinaryReader br = new BinaryReader(imageUploader.PostedFile.InputStream)) { bytes = br.ReadBytes(imageUploader.PostedFile.ContentLength); } newitem.p_img = bytes; } if (newitem != null) { db2.products.Add(newitem); db2.SaveChanges(); Response.Redirect("sellerPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { ElectroDBEntities db = new ElectroDBEntities(); functions fun = new functions(); int buyerid = Convert.ToInt16(Session["userID"].ToString()); var shippings = db.shipping_card; foreach (var shipping in shippings) { if (shipping.buyer_ID == buyerid) { call_shippings(shipping.p_ID, shipping.ID); } } }
protected void username_btn_Click(object sender, EventArgs e) { LinkButton button = (LinkButton)sender; string buttonId = button.ID; string ll = button.ID; int length = ll.IndexOf("="); ElectroDBEntities db = new ElectroDBEntities(); int rating_id = Convert.ToInt16(button.ID.Substring(0, length)); var review = from c in db.customers where c.cust_ID == rating_id select c; var userss = review.FirstOrDefault(); Session["userID"] = userss.cust_ID; HttpContext.Current.Response.Redirect("customer_acc.aspx"); }
protected void deleteBtn_Click(object sender, EventArgs e, int shid) { LinkButton button = (LinkButton)sender; string buttonId = button.ID; string ll = button.ID; int length = ll.IndexOf("="); ElectroDBEntities db = new ElectroDBEntities(); int rating_id = Convert.ToInt16(button.ID.Substring(0, length)); var review = from c in db.shipping_card where c.ID == rating_id select c; var userss = review.FirstOrDefault(); db.shipping_card.Remove(userss); db.SaveChanges(); HttpContext.Current.Response.Redirect("shippingCart.aspx"); }
public string image_retrive(int userid) { var myEntity = new ElectroDBEntities(); var query = myEntity.customers.Where(p => p.cust_ID == userid) .Select(p => p.cust_img).FirstOrDefault(); if (query != null) { byte[] bytes = query; string base64String = Convert.ToBase64String(bytes, 0, bytes.Length); return("data:image/png;base64," + base64String); } else { return("item_logo.png"); } }
public string itemImage_retrive(int itemid) { var myEntity = new ElectroDBEntities(); var query = myEntity.products.Where(p => p.p_ID == itemid) .Select(p => p.p_img).FirstOrDefault(); if (query != null) { byte[] bytes = query; string base64String = Convert.ToBase64String(bytes, 0, bytes.Length); return("data:image/png;base64," + base64String); } else { return("s20.jpg"); } }
public int login(customer user) { ElectroDBEntities db = new ElectroDBEntities(); var myUser = db.customers.FirstOrDefault(u => u.username == user.username && u.pass == user.pass); var user2 = from u in db.customers where u.username == user.username select u; var user3 = user2.FirstOrDefault <customer>(); if (myUser != null && myUser.is_seller == false) //User was found { string name = user.username;; Session["name"] = name; string userName = name; Session["userName"] = userName; string full_name = user3.f_name + " " + user3.l_name; Session["full_name"] = full_name; Session["userID"] = user3.cust_ID; Session["edit_user"] = user3; return(1); } else if (myUser != null && myUser.is_seller == true) //User was not found { string name = user.username;; Session["name"] = name; string userName = name; Session["userName"] = userName; string full_name = user3.f_name + " " + user3.l_name; Session["full_name"] = full_name; Session["userID"] = user3.cust_ID; Session["edit_user"] = user3; return(2); } else { return(0); } }
protected void orderBtn_Click(object sender, EventArgs e) { Button button = (Button)sender; string buttonId = button.ID; ElectroDBEntities db = new ElectroDBEntities(); int rating_id = Convert.ToInt16(buttonId); var review = from c in db.products where c.p_ID == rating_id select c; var userss = review.FirstOrDefault(); Session["sellerID"] = userss.seller_ID; shipping_card shipping = new shipping_card(); int buyerID = Convert.ToInt16(Session["buyerID"].ToString()); int sellerID = Convert.ToInt16(Session["sellerID"].ToString()); shipping.buyer_ID = buyerID; shipping.seller_ID = sellerID; shipping.p_ID = rating_id; shipping.is_approved = false; db.shipping_card.Add(shipping); db.SaveChanges(); }
public bool search_product(HtmlGenericControl p_box, TextBox search_box) { p_box.Controls.Clear(); ElectroDBEntities db = new ElectroDBEntities(); var products = db.products; foreach (var product in products) { if ((search_box.Text != null) && (search_box.Text.Contains(product.p_name) || search_box.Text.Contains(product.p_cat))) { HtmlGenericControl colSm = new HtmlGenericControl("div"); colSm.Attributes["class"] = "col-sm-3"; HtmlGenericControl figure = new HtmlGenericControl("figure"); figure.Attributes["class"] = "card card-product"; HtmlGenericControl wrap = new HtmlGenericControl("div"); wrap.Attributes["class"] = "img-wrap"; HtmlGenericControl image = new HtmlGenericControl("img"); image.Style.Add(HtmlTextWriterStyle.Width, "70%"); image.Style.Add(HtmlTextWriterStyle.Height, "40%"); image.Attributes["src"] = itemImage_retrive(product.p_ID); HtmlGenericControl fig = new HtmlGenericControl("figcaption"); fig.Attributes["class"] = "info-wrap"; HtmlGenericControl h4 = new HtmlGenericControl("h4"); h4.Attributes["class"] = "title"; h4.InnerText = product.p_name; HtmlGenericControl h3 = new HtmlGenericControl("h3"); h3.Attributes["class"] = "title"; h3.InnerText = product.p_cat; HtmlGenericControl p = new HtmlGenericControl("p"); p.Attributes["class"] = "desc"; p.InnerText = product.p_desc; HtmlGenericControl bottomWrap = new HtmlGenericControl("div"); bottomWrap.Attributes["class"] = "bottom-wrap"; Button orderBtn = new Button(); orderBtn.ID = product.p_ID.ToString(); orderBtn.CssClass = "btn btn-info btn-sm float-right"; orderBtn.Text = "Order Now"; orderBtn.Click += delegate(object sender, EventArgs e) { orderBtn_Click(sender, e); }; LinkButton h5 = new LinkButton(); h5.ID = product.seller_ID.ToString() + "=" + product.p_ID.ToString(); h5.CssClass = "title"; h5.Text = "Posted By: " + product.customer.username; h5.Click += delegate(object sender, EventArgs e) { username_btn_Click(sender, e); }; HtmlGenericControl bottom = new HtmlGenericControl("div"); bottom.Attributes["class"] = "price-wrap h5"; bottom.InnerText = product.p_price.ToString() + "$"; wrap.Controls.Add(image); figure.Controls.Add(wrap); fig.Controls.Add(h5); fig.Controls.Add(h4); fig.Controls.Add(h3); fig.Controls.Add(p); figure.Controls.Add(fig); bottomWrap.Controls.Add(bottom); bottomWrap.Controls.Add(orderBtn); figure.Controls.Add(bottomWrap); colSm.Controls.Add(figure); p_box.Controls.Add(colSm); } } return(false); }
public void call_seller_products(HtmlGenericControl p_box) { ElectroDBEntities db = new ElectroDBEntities(); var products = db.products; foreach (var product in products) { int id = Convert.ToInt16(Session["userID"].ToString()); if (product.seller_ID == id) { HtmlGenericControl colSm = new HtmlGenericControl("div"); colSm.Attributes["class"] = "col-sm-3"; HtmlGenericControl figure = new HtmlGenericControl("figure"); figure.Attributes["class"] = "card card-product"; HtmlGenericControl wrap = new HtmlGenericControl("div"); wrap.Attributes["class"] = "img-wrap"; HtmlGenericControl image = new HtmlGenericControl("img"); image.Style.Add(HtmlTextWriterStyle.Width, "70%"); image.Style.Add(HtmlTextWriterStyle.Height, "40%"); image.Attributes["src"] = itemImage_retrive(product.p_ID); HtmlGenericControl fig = new HtmlGenericControl("figcaption"); fig.Attributes["class"] = "info-wrap"; HtmlGenericControl h4 = new HtmlGenericControl("h4"); h4.Attributes["class"] = "title"; h4.InnerText = product.p_name; HtmlGenericControl h5 = new HtmlGenericControl("h5"); h5.Attributes["class"] = "title"; h5.InnerText = "Posted By: " + product.customer.username; HtmlGenericControl h3 = new HtmlGenericControl("h3"); h3.Attributes["class"] = "title"; h3.InnerText = product.p_cat; HtmlGenericControl p = new HtmlGenericControl("p"); p.Attributes["class"] = "desc"; p.InnerText = product.p_desc; HtmlGenericControl bottomWrap = new HtmlGenericControl("div"); bottomWrap.Attributes["class"] = "bottom-wrap"; Button orderBtn = new Button(); orderBtn.ID = product.p_ID.ToString(); orderBtn.CssClass = "btn btn - sm btn - primary float-right"; orderBtn.Text = "Order Now"; HtmlGenericControl bottom = new HtmlGenericControl("div"); bottom.Attributes["class"] = "price-wrap h5"; bottom.InnerText = product.p_price.ToString() + "$"; HtmlGenericControl status = new HtmlGenericControl("div"); status.Attributes["class"] = "price-wrap h5"; if (product.is_solled == true) { status.Style.Add(HtmlTextWriterStyle.Color, "red"); status.InnerText = "Solled"; } if (product.is_solled == false) { status.Style.Add(HtmlTextWriterStyle.Color, "blue"); status.InnerText = "Available"; } wrap.Controls.Add(image); figure.Controls.Add(wrap); fig.Controls.Add(h5); fig.Controls.Add(h4); fig.Controls.Add(h3); fig.Controls.Add(p); figure.Controls.Add(fig); bottomWrap.Controls.Add(bottom); bottomWrap.Controls.Add(status); // bottomWrap.Controls.Add(orderBtn); figure.Controls.Add(bottomWrap); colSm.Controls.Add(figure); p_box.Controls.Add(colSm); } } }
public void call_shippings(int id, int shID) { ElectroDBEntities db = new ElectroDBEntities(); functions fun = new functions(); var products = db.products; foreach (var product in products) { if (product.p_ID == id) { TextBox input = new TextBox(); total_price += product.p_price; TableRow tr = new TableRow(); TableCell th = new TableCell(); HtmlGenericControl row = new HtmlGenericControl("div"); row.Attributes["class"] = "row"; HtmlGenericControl colsm2 = new HtmlGenericControl("div"); colsm2.Attributes["class"] = "col-sm-2 hidden-xs"; HtmlGenericControl img = new HtmlGenericControl("img"); img.Style.Add(HtmlTextWriterStyle.Width, "100px"); img.Style.Add(HtmlTextWriterStyle.Height, "80px"); img.Attributes["class"] = "img-responsive"; img.Attributes["src"] = fun.itemImage_retrive(product.p_ID); HtmlGenericControl colsm10 = new HtmlGenericControl("div"); colsm10.Attributes["class"] = "col-sm-10"; HtmlGenericControl h4 = new HtmlGenericControl("h4"); h4.Attributes["class"] = "nomargin"; h4.InnerText = product.p_name; HtmlGenericControl p = new HtmlGenericControl("p"); p.InnerText = product.p_desc; ////////////////////////////////////////////////////// TableCell td = new TableCell(); td.Attributes["data-th"] = "Price"; td.Text = product.p_price.ToString(); TableCell td2 = new TableCell(); td2.Attributes["data-th"] = "Quantity"; input.Attributes["class"] = "form-control text-center"; input.Text = textQ; TableCell td3 = new TableCell(); td3.Attributes["data-th"] = "Subtotal"; td3.Attributes["class"] = "text-center"; TableCell td4 = new TableCell(); td4.Attributes["class"] = "actions"; LinkButton delete = new LinkButton(); delete.CssClass = "btn btn-danger btn-sm"; delete.ID = shID.ToString() + "=sh"; delete.Click += delegate(object sender, EventArgs e) { deleteBtn_Click(sender, e, shID); }; LinkButton refresh = new LinkButton(); refresh.CssClass = "btn btn-danger btn-sm"; refresh.ID = shID.ToString() + "=sh1"; refresh.Click += delegate(object sender, EventArgs e) { refreshBtn_Click(sender, e, input, td3, td); }; HtmlGenericControl i1 = new HtmlGenericControl("i"); i1.Attributes["class"] = "fa fa-refresh"; HtmlGenericControl i2 = new HtmlGenericControl("i"); i2.Attributes["class"] = "fa fa-trash-o"; th.Attributes["data-th"] = "Product"; colsm2.Controls.Add(img); colsm10.Controls.Add(h4); colsm10.Controls.Add(p); td2.Controls.Add(input); delete.Controls.Add(i2); refresh.Controls.Add(i1); td4.Controls.Add(refresh); td4.Controls.Add(delete); row.Controls.Add(colsm2); row.Controls.Add(colsm10); tr.Controls.Add(th); tr.Controls.Add(td); tr.Controls.Add(td2); tr.Controls.Add(td3); tr.Controls.Add(td4); tr.ID = shID.ToString(); th.Controls.Add(row); table_body.Controls.Add(tr); } } }