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