protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OnlineAuctionSvc.Product product;
int ProductID = (int)Session["Product ID"];
lblProductName.Text = ProductID.ToString();
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
pxy.RetrieveProductDB(ProductID);
product = pxy.RetrieveProductDB(ProductID);
lblProductName.Text = product.productname;
lblProductDescription.Text = product.productdescription;
lblReservePrice.Text = product.reserveprice.ToString();
lblCurrentBid.Text = product.Currentbid.ToString();
lblSellerUsername.Text = product.Sellerusername;
lblAuctionEndDate.Text = product.auctionenddate.ToString();
}
}
protected void btnSubmitEdit_Click(object sender, EventArgs e)
{
string productname = txtProductName.Text;
string productdescription = txtProductDescription.Text;
decimal reserveprice = decimal.Parse(txtReservePrice.Text, NumberStyles.AllowCurrencySymbol | NumberStyles.Number);
int productID = (int)Session["ProductID"];
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
int x = pxy.ModifyProductDB(productID, productname, productdescription, reserveprice);
if (x > 0)
{
HideEditFunctions();
Customer user;
user = (Customer)Session["User"];
string username = user.username;
lblMessage.Text = "Success. You have edited that product";
DBConnect objDB = new DBConnect();
DataSet myDS = pxy.ViewMyAuctions(username);
gvMyAuctions.DataSource = myDS;
gvMyAuctions.DataBind();
}
else
{
lblMessage.Text = "Error, please try again.";
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
for (int i = 0; i < gvMyAuctions.Rows.Count; i++) //Input Validation to make sure one and only one checkbox is selected
{
CheckBox cb;
cb = (CheckBox)gvMyAuctions.Rows[i].FindControl("cbSelect");
if (cb.Checked)
{
amountchecked = amountchecked + 1;
}
}
if (amountchecked < 1)
{
lblMessage.Text = "Please Select a product to work with";
}
if (amountchecked > 1)
{
lblMessage.Text = "Please Select only one product to work with";
}
else
{
for (int i = 0; i < gvMyAuctions.Rows.Count; i++) //If all conditions are good pull the information from the one selected
{
CheckBox cb;
cb = (CheckBox)gvMyAuctions.Rows[i].FindControl("cbSelect");
if (!cb.Checked)
{
continue;
}
else
{
Customer user;
user = (Customer)Session["User"];
string username = user.username;
ShowEditFunctions();
txtProductName.Text = gvMyAuctions.Rows[i].Cells[1].Text;
txtProductDescription.Text = gvMyAuctions.Rows[i].Cells[2].Text;
txtReservePrice.Text = gvMyAuctions.Rows[i].Cells[3].Text;
string productname = txtProductName.Text;
string productdescription = txtProductDescription.Text;
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
int productID = pxy.GetProductID(productname, productdescription);
Session["ProductID"] = productID;
}
}
}
}
protected void btnSearchbyCategory_Click(object sender, EventArgs e)
{
DataSet myDS = new DataSet();
string category = ddlProductCategory.Text;
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
myDS = pxy.SearchByCategory(category);
gvProducts.DataSource = myDS;
gvProducts.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
user = (Customer)Session["User"];
string username = user.username;
DataSet myDS = pxy.GetMyBids(username);
gvBids.DataSource = myDS;
gvBids.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
DataSet myDS = pxy.UpdateForDate();
gvProducts.DataSource = myDS;
gvProducts.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet myDS = new DataSet();
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
c = (Customer)Session["User"];
string username = c.username;
myDS = pxy.ViewMyAuctions(username);
gvMyAuctions.DataSource = myDS;
gvMyAuctions.DataBind();
}
}
protected void btnSubmitBid_Click(object sender, EventArgs e)
{
HideAddFunctions();
int productID = (int)Session["Product ID"];
decimal bidamount = Convert.ToDecimal(txtAddBidPrice.Text);
Customer c = (Customer)Session["User"];
string username = c.username;
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
pxy.UpdateProductBidsDB(productID, bidamount, username);
pxy.AddBidDB(productID, bidamount, username);
lblMessage.Text = "Success, your bid has been added.";
}
protected void btnAddItem_Click(object sender, EventArgs e)
{
if (txtProductName.Text == "" || txtProductDescription.Text == "" || txtStartPrice.Text == "" || txtReservePrice.Text == "")
{
lblErrorMessage.Text = "Please write a name for the product.";
return;
}
else
{
string productname = txtProductName.Text;
string productdescription = txtProductDescription.Text;
decimal startprice = Convert.ToDecimal(txtStartPrice.Text);
decimal reserveprice = Convert.ToDecimal(txtReservePrice.Text);
string category = ddlProductCategory.SelectedValue;
string subcategory = ddlProductSubCategory.Text;
DateTime date = calTime.SelectedDate;
Customer c = (Customer)Session["User"];
string username = c.username;
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
pxy.AddNewProductDB(productname, productdescription, startprice, reserveprice, username, category, subcategory, date);
lblErrorMessage.Text = "Success. You have added an item.";
txtReservePrice.Text = "";
txtProductName.Text = "";
txtStartPrice.Text = "";
txtProductDescription.Text = "";
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
for (int i = 0; i < gvMyAuctions.Rows.Count; i++) //Input Validation to make sure one and only one checkbox is selected
{
CheckBox cb;
cb = (CheckBox)gvMyAuctions.Rows[i].FindControl("cbSelect");
if (cb.Checked)
{
amountchecked = amountchecked + 1;
}
}
if (amountchecked < 1 || amountchecked > 1)
{
lblMessage.Text = "Please Select only one restaurant to work with at a time.";
}
else
{
for (int i = 0; i < gvMyAuctions.Rows.Count; i++) //If all conditions are good pull the information from the one selected
{
CheckBox cb;
cb = (CheckBox)gvMyAuctions.Rows[i].FindControl("cbSelect");
if (!cb.Checked)
{
continue;
}
else
{
string productname = gvMyAuctions.Rows[i].Cells[1].Text;
string productdescription = gvMyAuctions.Rows[i].Cells[2].Text;
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
int productID = pxy.GetProductID(productname, productdescription);
Customer user;
user = (Customer)Session["User"];
string username = user.username;
int x = pxy.DeleteProductDB(productID);
if (x > 0)
{
lblMessage.Text = "Success. You have deleted that product";
DBConnect objDB = new DBConnect();
DataSet myDS = pxy.ViewMyAuctions(username);
gvMyAuctions.DataSource = myDS;
gvMyAuctions.DataBind();
}
else
{
lblMessage.Text = "Error. Please try again.";
}
}
}
}
}
protected void btnCreateAccount_Click(object sender, EventArgs e)
{
if (txtDesiredUsername.Text == "") //CHECKS FOR ANY BLANK FIELDS IN ACCOUNT CREATION
{
lblErrorMessage.Text = "Please make sure all fields are filled out correctly.";
return;
}
if (txtNewName.Text == "")
{
lblErrorMessage.Text = "Please make sure all fields are filled out correctly.";
return;
}
if (txtNewEmail.Text == "")
{
lblErrorMessage.Text = "Please make sure all fields are filled out correctly.";
return;
}
if (txtDesiredPassword1.Text == "")
{
lblErrorMessage.Text = "Please make sure all fields are filled out correctly.";
return;
}
if (txtDesiredPassword2.Text == "")
{
lblErrorMessage.Text = "Please make sure all fields are filled out correctly.";
return;
}
if (ddlAccountType.Text == "")
{
lblErrorMessage.Text = "Please select which account type you are making.";
return;
}
if (txtDesiredPassword1.Text != txtDesiredPassword2.Text) //Checks to make sure the two passwords match
{
lblErrorMessage.Text = "Your passwords do not match.";
return;
}
OnlineAuctionSvc.OnlineAuction pxy = new OnlineAuctionSvc.OnlineAuction();
DBConnect objDB = new DBConnect();
string desiredname = txtDesiredUsername.Text;
string sqlCheck = "SELECT * From Accounts WHERE Username = '******'";
DataSet myDS = objDB.GetDataSet(sqlCheck);
// String checking = myDS.Tables[0].Rows[0][0].ToString();
if (myDS.Tables[0].Rows.Count > 0)
{
lblErrorMessage.Text = "Username is already taken. Please select another.";
}
else //if all fields ok make a new account and redirect to homepage
{
CustomerFunctions cf = new CustomerFunctions();
string name = txtNewName.Text;
string email = txtNewEmail.Text;
string username = txtDesiredUsername.Text;
string password = txtDesiredPassword1.Text;
string accounttype = ddlAccountType.Text;
Customer newUser = new Customer(name, email, username, password, accounttype);
pxy.AddNewUserDB(username, password, name, email, accounttype);
Session["User"] = newUser;
Response.Redirect("UserHome.aspx");
}
}
