//Hide edit functions and save user details to db
protected void EditConfirm_Click(object sender, EventArgs e)
{
//hide edit functions
txtAccfName.Visible = false;
lblAccfName.Visible = true;
txtAcclName.Visible = false;
lblAcclName.Visible = true;
txtAccAddress.Visible = false;
lblAccAddress.Visible = true;
txtAccPhoneNumber.Visible = false;
lblAccPhoneNumber.Visible = true;
EditDetailsbtn.Visible = true;
EditConfirmbtn.Visible = false;
//update database details
GETSET objuseraccount = new GETSET();
objuseraccount.FirstNameGetSet = txtAccfName.Text;
objuseraccount.LastNameGetSet = txtAcclName.Text;
objuseraccount.StreetAddressGetSet = txtAccAddress.Text;
objuseraccount.PhoneNumberGetSet = txtAccPhoneNumber.Text;
objuseraccount.EmailAddressGetSet = (string)(Session["id"]);
BL2 changeUserDetails = new BL2();
changeUserDetails.UserRegistration(objuseraccount);
Response.Redirect("Account.aspx");
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
string Output = string.Empty;
//Once new item details are filled in a client side verified add verified data to database
if (Page.IsValid)
{
GETSET objuserBusinesslayer = new GETSET();
//get data from user layer
objuserBusinesslayer.ProductNameGetSet = txtbxproductname.Text;
objuserBusinesslayer.CategoryGetSet = ddlcategory.Text;
objuserBusinesslayer.ModelGetSet = txtbxmodel.Text;
objuserBusinesslayer.ManufacturerGetSet = txtbxmanufacturer.Text;
objuserBusinesslayer.PriceGetSet = Convert.ToInt32(txtbxprice.Text);
objuserBusinesslayer.StockcountGetSet = Convert.ToInt32(txtbxstock.Text);
objuserBusinesslayer.DescriptionGetSet = txtbxdescription.Text;
objuserBusinesslayer.ReleaseDateGetSet = DateTime.Now;
//save data to database
BL2 objuserBl2 = new BL2();
Output = objuserBl2.InsertNewProduct(objuserBusinesslayer);
lblconfirmation.Visible = true;
//reset data for new item entry
txtbxproductname.Text = "";
ddlcategory.SelectedIndex = 0;
txtbxmodel.Text = "";
txtbxmanufacturer.Text = "";
txtbxprice.Text = "";
txtbxstock.Text = "";
txtbxdescription.Text = "";
}
}
//Button event takes the users email and password and compares it to current session registration//
protected void BtnLogin_Click(object sender, EventArgs e)
{
//login to site redirection and validation test
if (Page.IsValid)
{
//taking user input details and comapairing it with the data stored in database
string Output = string.Empty;
GETSET objuserBusinesslayer = new GETSET();
objuserBusinesslayer.EmailAddressGetSet = txtemailaddress.Text;
objuserBusinesslayer.PasswordGetSet = passwordLogin.Text;
BL2 objuserBl2 = new BL2();
Output = objuserBl2.CheckAccountDetails(objuserBusinesslayer);
//returned strings are checked for customer or admin to redirect specific logins and set session variables
if (string.Compare(Output, "correctc") == 0)
{
Session["id"] = txtemailaddress.Text;
Response.Redirect("~/User_Layer/Account.aspx");
}
if (string.Compare(Output, "correcta") == 0)
{
Session["idAdmin"] = txtemailaddress.Text;
Response.Redirect("~/User_Layer/AdminMain.aspx");
}
else
{
lblError.Text = "Incorrect Email or Password";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
BL2 UserAcc = new BL2();
DataSet UserAccounts = UserAcc.Useraccountget();
if (UserAccounts.Tables.Count > 0)
{
GridView1.DataSource = UserAccounts;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Display items on default page displaying newest 25 items
BL2 Items = new BL2();
DataSet Productds = Items.View();
if (Productds.Tables.Count > 0)
{
ListView1.DataSource = Productds;
ListView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string cat = (string)Session["ProductCat"];
breadcrumref.Text = cat;
BL2 blah = new BL2();
DataSet Productds = blah.View2(cat);
if (Productds.Tables.Count > 0)
{
ListView1.DataSource = Productds;
ListView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Retrieve admin user details
GETSET objuseraccount = new GETSET();
objuseraccount.EmailAddressGetSet = (string)(Session["idAdmin"]);
BL2 details = new BL2();
details.AdminDetails(objuseraccount);
//Display User Details
lblAccName.Text = objuseraccount.FirstNameGetSet + " " + objuseraccount.LastNameGetSet;
lblAccEmail.Text = objuseraccount.EmailAddressGetSet;
}
//user account details on page load
protected void Page_Load(object sender, EventArgs e)
{
//load user account details
GETSET objuseraccount = new GETSET();
objuseraccount.EmailAddressGetSet = (string)(Session["id"]);
BL2 getUserDetails = new BL2();
getUserDetails.UserDetails(objuseraccount);
//Display user account details
lblAccfName.Text = objuseraccount.FirstNameGetSet;
lblAcclName.Text = objuseraccount.LastNameGetSet;
lblAccAddress.Text = objuseraccount.StreetAddressGetSet;
lblAccPhoneNumber.Text = objuseraccount.PhoneNumberGetSet;
lblAccEmail.Text = objuseraccount.EmailAddressGetSet;
lblAccName2.Text = objuseraccount.FirstNameGetSet + " " + objuseraccount.LastNameGetSet;
}
//on product page load read data and fill out template to display data
protected void Page_Load(object sender, EventArgs e)
{
//obtain product details
GETSET productdetails = new GETSET();
productdetails.IDGetSet = (string)Session["productdetails"];
BL2 getProduct = new BL2();
getProduct.ProductDetails(productdetails);
string category = productdetails.CategoryGetSet;
//apply product details to user layer display
lblProductName.Text = productdetails.ProductNameGetSet;
lblPrice.Text = Convert.ToString(productdetails.PriceGetSet);
int stock = productdetails.StockcountGetSet;
lblStock2.Text = Convert.ToString(productdetails.StockcountGetSet);
lblDescription.Text = productdetails.DescriptionGetSet;
lblManufacturer.Text = productdetails.ManufacturerGetSet;
lblModel.Text = productdetails.ModelGetSet;
lblReleaseDate.Text = productdetails.ReleaseDateGetSet.ToString();
//test if stock is avaliable and display avaliable or unavaliable and grey out button
if (stock > 0)
{
lblStock.Text = "In Stock";
}
else
{
lblStock.Text = "Out of Stock";
AddToCartBtn.Enabled = false;
}
//set bread crumb title for the items category
catref.Text = " " + category + " -> ";
breadcrumref.Text = lblProductName.Text;
//set visibility of edit item detials
if ((string)Session["idAdmin"] != null)
{
btnEditPage.Visible = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
GETSET SetNewDetails = new GETSET();
SetNewDetails.IDGetSet = (string)Session["productdetails"];
SetNewDetails.ProductNameGetSet = txtbxProductName.Text;
SetNewDetails.PriceGetSet = Convert.ToInt32(txtbxPrice.Text);
SetNewDetails.StockcountGetSet = Convert.ToInt32(txtbxStock.Text);
SetNewDetails.DescriptionGetSet = txtbxDescription.Text;
SetNewDetails.ManufacturerGetSet = txtbxManufacturer.Text;
SetNewDetails.ModelGetSet = txtbxModel.Text;
SetNewDetails.ReleaseDateGetSet = Convert.ToDateTime(txtbxReleaseDate.Text);
BL2 objectPass = new BL2();
objectPass.UpdateProductDetails(SetNewDetails);
btnEditPage.Visible = true;
btnSave.Visible = true;
lblProductName.Visible = true;
lblPrice.Visible = true;
lblDescription.Visible = true;
lblManufacturer.Visible = true;
lblModel.Visible = true;
lblReleaseDate.Visible = true;
txtbxProductName.Visible = false;
txtbxPrice.Visible = false;
txtbxStock.Visible = false;
txtbxDescription.Visible = false;
txtbxManufacturer.Visible = false;
txtbxModel.Visible = false;
txtbxReleaseDate.Visible = false;
btnSave.Visible = false;
Response.Redirect("ProductDetail.aspx");
}
protected void BtnRegister_Click(object sender, EventArgs e)
{
string Output = string.Empty;
if (Page.IsValid)
{
GETSET objuserBusinesslayer = new GETSET();
objuserBusinesslayer.FirstNameGetSet = txtbxfirstname.Text;
objuserBusinesslayer.LastNameGetSet = txtbxlastname.Text;
objuserBusinesslayer.FirstNameGetSet = txtbxfirstname.Text;
objuserBusinesslayer.LastNameGetSet = txtbxlastname.Text;
objuserBusinesslayer.SuburbsGetSet = txtbxsuburb.Text;
objuserBusinesslayer.StateGetSet = ddlstate.Text;
objuserBusinesslayer.PostcodeGetSet = txtbxpostcode.Text;
objuserBusinesslayer.PhoneNumberGetSet = txtbxphonenumber.Text;
objuserBusinesslayer.EmailAddressGetSet = txtbxemail.Text;
objuserBusinesslayer.PasswordGetSet = txtbxpassword.Text;
BL2 objuserBl2 = new BL2();
Output = objuserBl2.InsertUserDetails(objuserBusinesslayer);
Session["id"] = txtbxemail.Text;
Response.Redirect("Account.aspx");
}
}
// Start is called before the first frame update
void Start()
{
string conn = "URI=file:" + Application.dataPath + "/plugins/insector.db";
IDbConnection dbconn;
dbconn = (IDbConnection) new SqliteConnection(conn);
dbconn.Open();
IDbCommand dbcmd = dbconn.CreateCommand();
string sqlQuery = "select QUIZ_1_PASS, PLAYER_LEVEL from PLAYER WHERE PLAYER_ID = '" + playerName + "'; ";
dbcmd.CommandText = sqlQuery;
IDataReader reader = dbcmd.ExecuteReader();
while (reader.Read())
{
quiz1Passed = (reader.GetInt32(0));
levelAchieved = (reader.GetInt32(1));
}
Debug.Log("About player" + quiz1Passed + levelAchieved);
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbconn.Close();
dbconn = null;
//Aqui va el cambio de galones
Debug.Log(quiz1Passed);
if (quiz1Passed == 1)
{
ColorBlock colorBL1 = BL1.GetComponent <Button>().colors;
colorBL1.normalColor = new Color32(145, 145, 27, 221);
BL1.GetComponent <Button>().colors = colorBL1;
ColorBlock colorBL2 = BL2.GetComponent <Button>().colors;
colorBL2.normalColor = new Color32(145, 145, 145, 0);
BL2.GetComponent <Button>().colors = colorBL2;
ColorBlock colorBL3 = BL3.GetComponent <Button>().colors;
colorBL3.normalColor = new Color32(145, 145, 145, 0);
BL3.GetComponent <Button>().colors = colorBL3;
ColorBlock colorBL4 = BL4.GetComponent <Button>().colors;
colorBL4.normalColor = new Color32(145, 145, 145, 0);
BL4.GetComponent <Button>().colors = colorBL4;
}
if (quiz1Passed == 1 && levelAchieved == 1)
{
ColorBlock colorBL1 = BL1.GetComponent <Button>().colors;
colorBL1.normalColor = new Color32(145, 145, 145, 0);
BL1.GetComponent <Button>().colors = colorBL1;
ColorBlock colorBL2 = BL2.GetComponent <Button>().colors;
colorBL2.normalColor = new Color32(145, 145, 27, 221);
BL2.GetComponent <Button>().colors = colorBL2;
ColorBlock colorBL3 = BL3.GetComponent <Button>().colors;
colorBL3.normalColor = new Color32(145, 145, 145, 0);
BL3.GetComponent <Button>().colors = colorBL3;
ColorBlock colorBL4 = BL4.GetComponent <Button>().colors;
colorBL4.normalColor = new Color32(145, 145, 145, 0);
BL4.GetComponent <Button>().colors = colorBL4;
}
if (quiz1Passed == 1 && levelAchieved == 2)
{
ColorBlock colorBL1 = BL1.GetComponent <Button>().colors;
colorBL1.normalColor = new Color32(145, 145, 145, 0);
BL1.GetComponent <Button>().colors = colorBL1;
ColorBlock colorBL2 = BL2.GetComponent <Button>().colors;
colorBL2.normalColor = new Color32(145, 145, 145, 0);
BL2.GetComponent <Button>().colors = colorBL2;
ColorBlock colorBL3 = BL3.GetComponent <Button>().colors;
colorBL3.normalColor = new Color32(145, 145, 27, 221);
BL3.GetComponent <Button>().colors = colorBL3;
ColorBlock colorBL4 = BL4.GetComponent <Button>().colors;
colorBL4.normalColor = new Color32(145, 145, 145, 0);
BL4.GetComponent <Button>().colors = colorBL4;
}
if (quiz1Passed == 1 && levelAchieved == 3)
{
ColorBlock colorBL1 = BL1.GetComponent <Button>().colors;
colorBL1.normalColor = new Color32(145, 145, 145, 0);
BL1.GetComponent <Button>().colors = colorBL1;
ColorBlock colorBL2 = BL2.GetComponent <Button>().colors;
colorBL2.normalColor = new Color32(145, 145, 145, 0);
BL2.GetComponent <Button>().colors = colorBL2;
ColorBlock colorBL3 = BL3.GetComponent <Button>().colors;
colorBL3.normalColor = new Color32(145, 145, 145, 0);
BL3.GetComponent <Button>().colors = colorBL3;
ColorBlock colorBL4 = BL4.GetComponent <Button>().colors;
colorBL4.normalColor = new Color32(145, 145, 27, 221);
BL4.GetComponent <Button>().colors = colorBL4;
}
}