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