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