private void RegisterVisitor() { string ipAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (string.IsNullOrEmpty(ipAddress)) { ipAddress = Request.ServerVariables["REMOTE_ADDR"]; } if(ipAddress.Length == 3) { ipAddress = "86.81.102.253"; } string APIKey = "37daa2782cd3c6f1df7e2b511c073b624c3d5ed0c771675985296bfb9aa96ffa"; string url = string.Format("http://api.ipinfodb.com/v3/ip-city/?key={0}&ip={1}&format=json", APIKey, ipAddress); using (WebClient client = new WebClient()) { string json = client.DownloadString(url); Location location = new JavaScriptSerializer().Deserialize<Location>(json); sql_object SqlObj = new sql_object(); SqlObj.addvisitor(location.IPAddress, location.CountryName, location.CountryCode, location.CityName, location.RegionName, location.ZipCode, location.Latitude, location.Longitude, location.TimeZone); Session["visitor"] = location.IPAddress; } }
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) { sql_object sql_obj = new sql_object(); dataReader = sql_obj.get_offer_query(); GridView1.DataSource = dataReader; GridView1.DataBind(); sql_obj.close_connection(); }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; sql_object sql_obj = new sql_object(); dataReader = sql_obj.get_offer_query(); GridView1.DataSource = dataReader; GridView1.DataBind(); sql_obj.close_connection(); }
protected void main_category_SelectedIndexChanged(object sender, EventArgs e) { int id; id = Convert.ToInt32(main_category.Text); sql_object sql_obj = new sql_object(); if (sql_obj.show(id)) CheckShow.Checked = true; else CheckShow.Checked = false; sub_Category_query(id); }
protected void main_category_Load(object sender, EventArgs e) { if (!IsPostBack) { sql_object sql_obj = new sql_object(); if (sql_obj.show(0)) CheckShow.Checked = true; else CheckShow.Checked = false; } }
protected void ButDel_Click(object sender, EventArgs e) { string check = Request["hidden_text"]; if (check == "true") { int id = Convert.ToInt32(main_category.Text); sql_object sql_obj = new sql_object(); sql_obj.MainCatDel(id); main_category_query(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { sql_object sql_obj = new sql_object(); dataReader = sql_obj.get_offer_query(); GridView1.DataSource = dataReader; GridView1.DataBind(); sql_obj.close_connection(); } }
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; sql_object sql_obj = new sql_object(); dataReader = sql_obj.get_offer_query(); GridView1.DataSource = dataReader; GridView1.DataBind(); sql_obj.close_connection(); //string test1 = GridView1.Rows[e.RowIndex].Cells[1].Text; //GridView1.EditIndex = -1; }
protected void ButEdit_Click(object sender, EventArgs e) { string check = Request["hidden_text"]; string GetValue = TextMainCat.Text; Int32 Show = (CheckShow.Checked == true ? 1 : 0); if (check == "true" && GetValue != "") { int id = Convert.ToInt32(main_category.Text); sql_object sql_obj = new sql_object(); sql_obj.MainCatUpd(id, GetValue, Show); main_category_query(); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { if (Request["id"] != null) { string id = Request["id"].ToString(); sql_object SqlObj = new sql_object(); DetailObject DetailObj = SqlObj.GetDetail(id); itemnum.Text = DetailObj.itemnum; Item.Text = DetailObj.title; Order.Text = DetailObj.itemprice.ToString(); Fieldid.Value = id; } } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { if (Request["id"] != null) { string id = Request["id"].ToString(); string OfferRound = Request["amount"].ToString(); decimal amount = Convert.ToDecimal(OfferRound); sql_object SqlObj = new sql_object(); DetailObject DetailObj = SqlObj.GetDetail(id); itemnum.Text = DetailObj.itemnum; Item.Text = DetailObj.title; Offer.Text = amount.ToString(); Fieldid.Value = id; } } }
protected void Ok_Click(object sender, EventArgs e) { if (IsPostBack) { if (Email.Text == Email1.Text) { EmailErr.Visible = false; sql_object SqlObj = new sql_object(); string Gender = Male.Checked == true ? "M" : "F"; SqlObj.AddOffer(Convert.ToInt32(Fieldid.Value), 0,Convert.ToDecimal(Order.Text), FirstName.Text, LastName.Text, Address.Text, Email.Text, Gender, "U", Note.Text); OrderEmailConform(Convert.ToInt32(Fieldid.Value), LastName.Text, Email.Text, Gender, Order.Text, Item.Text, itemnum.Text); Response.Redirect("~/Default.aspx"); } else if (Email.Text != Email1.Text) { EmailErr.Text = "Emails are not the same."; EmailErr.Visible = true; } } }
private void DetailDelete(string id) { sql_object sql_obj = new sql_object(); DetailObject Detail = sql_obj.GetDetail(id); string imgPath; imgPath = "image/" + Detail.img1; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } imgPath = "image/" + Detail.img2; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } imgPath = "image/" + Detail.img3; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } imgPath = "image/" + Detail.img4; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } imgPath = "image/" + Detail.img5; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } sql_obj.DetailDelete(Convert.ToInt32(id)); }
private void EditDetail() { string action = FieldAction.Value; int Id = Convert.ToInt32(FieldId.Value); int SubCatId = Convert.ToInt32(Fieldid1.Value); string myUniqueFileName1 = null; string myUniqueFileName2 = null; string myUniqueFileName3 = null; string myUniqueFileName4 = null; string myUniqueFileName5 = null; int imgwidth = 0; int imgheight = 0; if (flupImage1.PostedFile != null && flupImage1.PostedFile.FileName != "") { string imgName1 = flupImage1.FileName; string ext = System.IO.Path.GetExtension(imgName1); myUniqueFileName1 = string.Format(@"{0}" + ext, Guid.NewGuid()); string imgPath = "image/" + myUniqueFileName1; HttpPostedFile pf = flupImage1.PostedFile; System.Drawing.Image bm = System.Drawing.Image.FromStream(pf.InputStream); if (!img1chk.Checked) { imgwidth = Convert.ToInt32(Request["img1w"]); imgheight = Convert.ToInt32(Request["img1h"]); bm = ResizeBitmap((Bitmap)bm, imgwidth, imgheight); /// new width, height bm.Save(Server.MapPath(imgPath)); } else { flupImage1.SaveAs(Server.MapPath(imgPath)); } imgPath = "image/" + FieldImage1.Value; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } FieldImage1.Value = myUniqueFileName1; } if (flupImage2.PostedFile != null && flupImage2.PostedFile.FileName != "") { string imgName1 = flupImage2.FileName; string ext = System.IO.Path.GetExtension(imgName1); myUniqueFileName2 = string.Format(@"{0}" + ext, Guid.NewGuid()); string imgPath = "image/" + myUniqueFileName2; HttpPostedFile pf = flupImage2.PostedFile; System.Drawing.Image bm = System.Drawing.Image.FromStream(pf.InputStream); if (!img2chk.Checked) { imgwidth = Convert.ToInt32(Request["img2w"]); imgheight = Convert.ToInt32(Request["img2h"]); bm = ResizeBitmap((Bitmap)bm, imgwidth, imgheight); /// new width, height bm.Save(Server.MapPath(imgPath)); } else { flupImage2.SaveAs(Server.MapPath(imgPath)); } imgPath = "image/" + FieldImage2.Value; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } FieldImage2.Value = myUniqueFileName2; } if (flupImage3.PostedFile != null && flupImage3.PostedFile.FileName != "") { string imgName1 = flupImage3.FileName; string ext = System.IO.Path.GetExtension(imgName1); myUniqueFileName3 = string.Format(@"{0}" + ext, Guid.NewGuid()); string imgPath = "image/" + myUniqueFileName3; HttpPostedFile pf = flupImage3.PostedFile; System.Drawing.Image bm = System.Drawing.Image.FromStream(pf.InputStream); if (!img3chk.Checked) { imgwidth = Convert.ToInt32(Request["img3w"]); imgheight = Convert.ToInt32(Request["img3h"]); bm = ResizeBitmap((Bitmap)bm, imgwidth, imgheight); /// new width, height bm.Save(Server.MapPath(imgPath)); } else { flupImage3.SaveAs(Server.MapPath(imgPath)); } imgPath = "image/" + FieldImage3.Value; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } FieldImage3.Value = myUniqueFileName3; } if (flupImage4.PostedFile != null && flupImage4.PostedFile.FileName != "") { string imgName1 = flupImage4.FileName; string ext = System.IO.Path.GetExtension(imgName1); myUniqueFileName4 = string.Format(@"{0}" + ext, Guid.NewGuid()); string imgPath = "image/" + myUniqueFileName4; HttpPostedFile pf = flupImage4.PostedFile; System.Drawing.Image bm = System.Drawing.Image.FromStream(pf.InputStream); if (!img4chk.Checked) { imgwidth = Convert.ToInt32(Request["img4w"]); imgheight = Convert.ToInt32(Request["img4h"]); bm = ResizeBitmap((Bitmap)bm, imgwidth, imgheight); /// new width, height bm.Save(Server.MapPath(imgPath)); } else { flupImage4.SaveAs(Server.MapPath(imgPath)); } imgPath = "image/" + FieldImage4.Value; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } FieldImage4.Value = myUniqueFileName4; } if (flupImage5.PostedFile != null && flupImage5.PostedFile.FileName != "") { string imgName1 = flupImage5.FileName; string ext = System.IO.Path.GetExtension(imgName1); myUniqueFileName5 = string.Format(@"{0}" + ext, Guid.NewGuid()); string imgPath = "image/" + myUniqueFileName5; HttpPostedFile pf = flupImage5.PostedFile; System.Drawing.Image bm = System.Drawing.Image.FromStream(pf.InputStream); if (!img5chk.Checked) { imgwidth = Convert.ToInt32(Request["img5w"]); imgheight = Convert.ToInt32(Request["img5h"]); bm = ResizeBitmap((Bitmap)bm, imgwidth, imgheight); /// new width, height bm.Save(Server.MapPath(imgPath)); } else { flupImage5.SaveAs(Server.MapPath(imgPath)); } imgPath = "image/" + FieldImage5.Value; if (File.Exists(Server.MapPath(imgPath))) { File.Delete(Server.MapPath(imgPath)); } FieldImage5.Value = myUniqueFileName5; } int offer = 0 ; string Title = TitleText.Text; string SubTitle = SubTitleText.Text; int show = Show.Checked ? 1 : 0; string Desc1 = Desc1Text.Text; string Desc2 = Desc2Text.Text; int ScreenImage = 0; if (Scroll.Checked) ScreenImage = 1; else if (MainPage.Checked) ScreenImage = 2; else if (DetailPage.Checked) ScreenImage = 3; if (DetailOffer.Checked == true) offer = 1; else offer = 2; string price = Price.Text == "" ? "0" : Price.Text; sql_object sql_obj = new sql_object(); sql_obj.DetailUpdate(Id, SubCatId, Title, SubTitle, Desc1, Desc2, FieldImage1.Value, FieldImage2.Value, FieldImage3.Value, FieldImage4.Value, FieldImage5.Value, ScreenImage, show, offer, ItemNum.Text, Convert.ToDecimal(price)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin"] == null) Response.Redirect("./login_admin.aspx"); if (!IsPostBack) { string action = Request["action"]; FieldAction.Value = action; if (action == "add") { FieldId.Value = Request["id_subcat"]; } else { FieldId.Value = Request["id"]; Fieldid1.Value = Request["id_subcat"]; } if (action == "edit") { sql_object SqlObj = new sql_object(); DetailObject DetObj = SqlObj.GetDetail(Request["id"]); ItemNum.Text = DetObj.itemnum; Price.Text = DetObj.itemprice.ToString(); TitleText.Text = DetObj.title; SubTitleText.Text = DetObj.subtitle; Desc1Text.Text = DetObj.Desc1; Desc2Text.Text = DetObj.Desc2; switch (DetObj.ScreenImg) { case 1: Scroll.Checked = true; MainPage.Checked = false; DetailPage.Checked = false; break; case 2: MainPage.Checked = true; Scroll.Checked = false; DetailPage.Checked = false; break; default: DetailPage.Checked = true; MainPage.Checked = false; Scroll.Checked = false; break; } if (DetObj.offer == 1) DetailOffer.Checked = true; else Detailorder.Checked = true; Show.Checked = DetObj.show == 1 ? true : false; ImgPrv1.ImageUrl = "~/image/" + DetObj.img1; ImgPrv2.ImageUrl = "~/image/" + DetObj.img2; ImgPrv3.ImageUrl = "~/image/" + DetObj.img3; ImgPrv4.ImageUrl = "~/image/" + DetObj.img4; ImgPrv5.ImageUrl = "~/image/" + DetObj.img5; FieldImage1.Value = DetObj.img1; FieldImage2.Value = DetObj.img2; FieldImage3.Value = DetObj.img3; FieldImage4.Value = DetObj.img4; FieldImage5.Value = DetObj.img5; } } }
protected void sub_category_Load(object sender, EventArgs e) { if (!IsPostBack) { sql_object sql_obj = new sql_object(); if (sql_obj.SubShow(0)) SubCheck.Checked = true; else SubCheck.Checked = false; } }
private void main_category_query() { sql_object sql_obj = new sql_object(); SqlDataReader dataReader = sql_obj.get_category_query(); main_category.DataSource = dataReader; main_category.DataValueField = "id"; main_category.DataTextField = "Category"; main_category.DataBind(); sql_obj.close_connection(); }
private void sub_Category_query(int IdCategory) { int IdCatLoc = IdCategory; sql_object sql_obj = new sql_object(); if (IdCategory == 0) IdCatLoc = sql_obj.GetFirstCat(); SqlDataReader dataReader = sql_obj.get_sub_cat_query(IdCatLoc); sub_category.DataSource = dataReader; sub_category.DataValueField = "id"; sub_category.DataTextField = "Cat_sub"; sub_category.DataBind(); sql_obj.close_connection(); }
protected void sub_category_SelectedIndexChanged(object sender, EventArgs e) { int id; id = Convert.ToInt32(sub_category.Text); sql_object sql_obj = new sql_object(); if (sql_obj.SubShow(id)) SubCheck.Checked = true; else SubCheck.Checked = false; }
protected void SubAdd_Click(object sender, EventArgs e) { int id = 0 ; string check = Request["hidden_text"]; string GetValue = SubText.Text; Int32 Show = (SubCheck.Checked == true ? 1 : 0); if (check == "true" && GetValue != "") { id = Convert.ToInt32(main_category.Text); sql_object sql_obj = new sql_object(); sql_obj.SubCatAdd(id, GetValue, Show); sub_Category_query(id); } }
protected void SubDel_Click(object sender, EventArgs e) { string check = Request["hidden_text"]; int IdCatMain = Convert.ToInt32(main_category.Text); if (check == "true") { int id = Convert.ToInt32(sub_category.Text); sql_object sql_obj = new sql_object(); sql_obj.SubCatDel(id); sub_Category_query(IdCatMain); } }