private void AH() { DataSet uv = SqlAC.CheckData("SELECT * FROM History WHERE Username='******'"); int l = uv.Tables[0].Rows.Count; HtmlGenericControl td; HtmlGenericControl Utr; HtmlGenericControl Btr; for (int j = 0; j < l; j++) { string id = uv.Tables[0].Rows[j]["PID"].ToString(); DataSet ak = SqlAC.CheckData("SELECT * FROM Auctions WHERE ID=" + id); int a = int.Parse(ak.Tables[0].Rows[0]["Open"].ToString()); if (a == 1) { td = new HtmlGenericControl("tr"); Utr = new HtmlGenericControl("td"); Utr.Attributes.Add("class", "mdl-data-table__cell--non-numeric"); Btr = new HtmlGenericControl("td"); Utr.InnerText = ak.Tables[0].Rows[0]["PName"].ToString(); Btr.InnerText = uv.Tables[0].Rows[j]["Bid"].ToString(); td.Controls.Add(Utr); td.Controls.Add(Btr); tbody.Controls.Add(td); } } }
protected void Page_Load(object sender, EventArgs e) { HGC = new HtmlGenericControl[5]; ak = SqlAC.CheckData("SELECT * FROM Auctions"); try{ page = int.Parse(Request.QueryString["page"]); } catch { Response.Redirect("ProductList.aspx?page=1"); } if (int.Parse(Request.QueryString["page"]) < 1) { Response.Redirect("ProductList.aspx?page=1"); } int length = ak.Tables[0].Rows.Count; if (page * 9 > 9 + length) { Response.Redirect("ProductList.aspx?page=1"); } if (length < 9) { f1(length); } else { int start = (page - 1) * 9; int end = page * 9; f2(start, end, length); AddButtons(end, length); } }
protected void Upload(object sender, EventArgs e) { if (Session["username"] != null) { string name = Session["username"].ToString(); string desc = Despription.Text; string Catagory = ddl_c.Text; string Pname = PName.Text; string price = Price.Text; DateTime time = DateTime.Now; int min = int.Parse(Min.Text); int hour = int.Parse(Hour.Text); while (min > 60) { min -= 60; hour++; } if (FileUpload1.HasFile || !(desc.Equals("")) || !(name.Equals("")) || !(price.Equals(""))) { SqlAC.udi("INSERT INTO PhotosID (F) VALUES (0)"); ak = SqlAC.CheckData("SELECT * FROM PhotosID WHERE F='0'"); string extension = Path.GetExtension(FileUpload1.PostedFile.FileName); string fileName = ak.Tables[0].Rows[0]["ID"].ToString(); FileUpload1.PostedFile.SaveAs(Server.MapPath("~/APhotos/") + fileName + extension); SqlAC.udi("UPDATE PhotosID SET PhotosID.F='1'"); SqlAC.udi("INSERT INTO PendingAuctions (PName,SUser,Price,[Min],[Hour],ImgUrl,Catagory,Description) VALUES ('" + Pname + "','" + name + "','" + price + "','" + min.ToString() + "','" + hour.ToString() + "','" + fileName + extension + "','" + Catagory + "','" + desc + "')"); Response.Redirect(Request.Url.AbsoluteUri); } } else { Response.Redirect("Home.aspx"); } }
private void ShowAuctions() { int page = int.Parse(Request.QueryString["page"]); string query = "SELECT * FROM CompletedAuctions WHERE Buser='******'";//and paid=0; DataSet ds = SqlAC.CheckData(query); int length = ds.Tables[0].Rows.Count; //add page max check if (length < 9) { for (int i = 0; i < length; i++) { CreateCard(ds.Tables[0].Rows[i]); } } else { int start = (page - 1) * 9; int end = Math.Min(page * 9, length); for (int i = start; i < end; i++) { CreateCard(ds.Tables[0].Rows[i]); } AddButtons(end, length); } }
private bool CheckID() { try { ID = int.Parse(Request.QueryString["ID"]); } catch { return(true); } if (ID < 0) { return(true); } string query = "SELECT * FROM CompletedAuctions WHERE ID='" + ID.ToString() + "'"; ak = SqlAC.CheckData(query).Tables[0].Rows[0]; string name = ak["BName"].ToString(); if (Session["username"].ToString() != name)//XXXXXXXXXXXXXXXXXXXXX { return(true); } return(false); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { DataSet ak = SqlAC.CheckData("SELECT * FROM Users WHERE Username='******'"); TB_password.Text = ak.Tables[0].Rows[0]["Password"].ToString(); TB_Conforirmpassword.Text = ak.Tables[0].Rows[0]["Password"].ToString(); TB_Email.Text = ak.Tables[0].Rows[0]["Email"].ToString(); TB_FN.Text = ak.Tables[0].Rows[0]["FName"].ToString(); TB_LN.Text = ak.Tables[0].Rows[0]["LName"].ToString(); TB_PN.Text = ak.Tables[0].Rows[0]["Phone"].ToString(); DataSet ds = SqlAC.CheckData("SELECT * FROM Cities"); TB_City.DataSource = ds.Tables[0]; TB_City.DataTextField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataValueField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataBind(); TB_City.Text = ak.Tables[0].Rows[0]["City"].ToString(); } catch (Exception) { Response.Redirect("Home.aspx"); } } }
private void UDDL() { ds = SqlAC.CheckData("SELECT * FROM Complaints WHERE Checked='0'"); DDL.DataSource = ds.Tables[0]; DDL.DataTextField = ds.Tables[0].Columns["Title"].ToString(); DDL.DataValueField = ds.Tables[0].Columns["Title"].ToString(); DDL.DataBind(); }
private void UDDL() { DataSet ds = SqlAC.CheckData("SELECT * FROM Catagories"); ddl_c.DataSource = ds.Tables[0]; ddl_c.DataTextField = ds.Tables[0].Columns["Catagory"].ToString(); ddl_c.DataValueField = ds.Tables[0].Columns["Catagory"].ToString(); ddl_c.DataBind(); }
protected void btn2_Click(object sender, EventArgs e) { s = DDL.Text; DataSet ak = SqlAC.CheckData("SELECT * FROM Complaints WHERE Title='" + s + "'"); CCC.InnerText = ak.Tables[0].Rows[0]["Description"].ToString(); Ltitle.Text = ak.Tables[0].Rows[0]["Title"].ToString(); LUser.Text = ak.Tables[0].Rows[0]["User"].ToString(); }
private void UDDL() { DataSet ds = SqlAC.CheckData("SELECT * FROM Cities"); TB_City.DataSource = ds.Tables[0]; TB_City.DataTextField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataValueField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataBind(); }
protected void Search_Click(object sender, EventArgs e) { id = SearchT.Text; ak = SqlAC.CheckData("SELECT * FROM PendingAuctions WHERE ID=" + ID); title.Text = ak.Tables[0].Rows[0]["PName"].ToString(); User.Text = ak.Tables[0].Rows[0]["SUser"].ToString(); Price.Text = ak.Tables[0].Rows[0]["Price"].ToString(); Hours.Text = ak.Tables[0].Rows[0]["Hour"].ToString(); mins.Text = ak.Tables[0].Rows[0]["Min"].ToString(); Pimg.ImageUrl = ak.Tables[0].Rows[0]["ImgUrl"].ToString(); category.Text = ak.Tables[0].Rows[0]["Catagory"].ToString(); desc.Text = ak.Tables[0].Rows[0]["Description"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { /* * if (CheckID()) * Response.Redirect("CompletedAuctions.aspx?page=1"); */ ID = 1; string query = "SELECT * FROM CompletedAuctions WHERE ID='" + ID.ToString() + "'"; ak = SqlAC.CheckData(query).Tables[0].Rows[0]; SUser.Text = ak["SUser"].ToString(); PriceTP.Text = ak["Price"].ToString(); PDesc.Text = ak["Description"].ToString(); }
protected void Btn_Login_Click(object sender, EventArgs e) { DataSet ds = SqlAC.CheckData("SELECT * FROM Users WHERE Username='******' AND Password='******'"); if (ds.Tables[0].Rows.Count > 0) { Session["login"] = true; Session["Username"] = TB_User.Text; Response.Redirect("Home.aspx"); } else { LBL_output.Text = "Wrong username or password"; } }
private int GetBalance() { string name = ""; try { name = Session["username"].ToString(); } catch { Response.Redirect("Home.aspx"); } string query = "SELECT * FROM Users WHERE Username='******'"; DataRow UserInfo = SqlAC.CheckData(query).Tables[0].Rows[0]; return(int.Parse(UserInfo["Balance"].ToString())); }
protected void Btn_Search_Click(object sender, EventArgs e) { string User = Lbl_User.Text; DataSet ak = SqlAC.CheckData("SELECT * FROM Users WHERE Username ='******'"); int a = ak.Tables[0].Rows.Count; if (a == 1) { Grv2.DataSource = ak; Grv2.DataBind(); msg.Text = ""; } else { msg.Text = "User was not found"; } }
private void CheckAuctions() { DateTime now = DateTime.Now; string query = "SELECT * FROM Auctions"; // WHERE Buser='******' DataSet ds = SqlAC.CheckData(query); //all auctions int i = ds.Tables[0].Rows.Count; int j = 0; DateTime end; while (j < i) { end = CreateEndTime(ds.Tables[0].Rows[j]); if (CheckDate(now, end) == 1) { UpdateDB(ds.Tables[0].Rows[j]); } j++; } }
protected void Btn_Search_Click(object sender, EventArgs e) { string Pname = Lbl_Auction.Text; DataSet ak = SqlAC.CheckData("SELECT * FROM Auctions WHERE ID =" + Pname); int a = ak.Tables[0].Rows.Count; if (a == 1) { Grv2.DataSource = ak; Grv2.DataBind(); msg.Text = ""; } else { msg.Text = "Auction was not found"; Grv2.DataSource = null; Grv2.DataBind(); } }
private void AH(string id) { DataSet uv = SqlAC.CheckData("SELECT * FROM History WHERE PID='" + id + "'"); int l = uv.Tables[0].Rows.Count; HtmlGenericControl td; HtmlGenericControl Utr; HtmlGenericControl Btr; for (int j = 0; j < l; j++) { td = new HtmlGenericControl("tr"); Utr = new HtmlGenericControl("td"); Utr.Attributes.Add("class", "mdl-data-table__cell--non-numeric"); Btr = new HtmlGenericControl("td"); Utr.InnerText = uv.Tables[0].Rows[j]["Username"].ToString(); Btr.InnerText = uv.Tables[0].Rows[j]["Bid"].ToString(); td.Controls.Add(Utr); td.Controls.Add(Btr); tbody.Controls.Add(td); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["login"] != null) { string user = Session["Username"].ToString(); DataSet ak = SqlAC.CheckData("SELECT * FROM Users WHERE Username ='******'"); string manager = ak.Tables[0].Rows[0]["Manager"].ToString(); if (int.Parse(manager) == 1) { ManagerSide.Visible = true; } Login.Visible = false; Register.Visible = false; Logout.Visible = true; UProfile.Visible = true; LBL_Userinfo.Text = "Hello " + Session["Username"]; SellP.Visible = true; AH.Visible = true; Link2.Text = "Sell"; Link3.Text = "Logout"; Link2.Click += new EventHandler(LinkAuctions_Click); Link3.Click += new EventHandler(Logout_Click); } else { ManagerSide.Visible = false; AH.Visible = false; Login.Visible = true; Register.Visible = true; Logout.Visible = false; UProfile.Visible = false; SellP.Visible = false; Link2.Text = "Register"; Link3.Text = "Login"; Link2.Text = "Register"; Link3.Text = "Login"; Link2.Click += new EventHandler(Register_Click); Link3.Click += new EventHandler(Login_Click); } }
protected void Page_Load(object sender, EventArgs e) { string id = Request.QueryString["id"]; ak = SqlAC.CheckData("SELECT * FROM Auctions WHERE ID=" + id); count(); price.Text = ak.Tables[0].Rows[0]["price"].ToString(); title.InnerText = ak.Tables[0].Rows[0]["PName"].ToString(); PPic.ImageUrl = "~/APhotos/" + ak.Tables[0].Rows[0]["ImgUrl"].ToString(); PPic.Width = 300; PPic.Height = 300; string seller = ak.Tables[0].Rows[0]["SUser"].ToString(); if (Session["login"] == null || (Session["Username"].Equals(seller))) { Offer.Enabled = false; Btn_Offer.Enabled = false; } AH(id); }