private void regbtn_CheckedChanged(object sender, EventArgs e)
 {
     if (regbtn.Checked)
     {
         CustomerFunctions cf = new CustomerFunctions();
         DataTable         dt = new DataTable();
         dt = cf.Select();
         customerlist.DataSource = dt;
     }
 }
 private void cnamebox_TextChanged(object sender, EventArgs e)
 {
     if (regbtn.Checked)
     {
         string            cname = textbox1.Text.Trim();
         CustomerFunctions cf    = new CustomerFunctions();
         DataTable         dt    = new DataTable();
         dt = cf.Search_name(cname);
         customerlist.DataSource = dt;
     }
 }
Exemple #3
0
        public async Task CustomersTestAsync()
        {
            TestLambdaContext       context;
            APIGatewayProxyRequest  request;
            APIGatewayProxyResponse response;

            CustomerFunctions functions = new CustomerFunctions(this.DDBClient, this.TableName);


            // Add a new blog post
            Customers cust = new Customers();

            cust.Name  = "The awesome post";
            cust.Email = "Content for the awesome blog";

            request = new APIGatewayProxyRequest
            {
                Body = JsonConvert.SerializeObject(cust)
            };
            context  = new TestLambdaContext();
            response = await functions.AddCustomerAsync(request, context);

            Assert.Equal(200, response.StatusCode);

            var blogId = response.Body;

            // Confirm we can get the blog post back out
            request = new APIGatewayProxyRequest
            {
                PathParameters = new Dictionary <string, string> {
                    { CustomerFunctions.ID_QUERY_STRING_NAME, blogId }
                }
            };
            context  = new TestLambdaContext();
            response = await functions.GetCustomerAsync(request, context);

            Assert.Equal(200, response.StatusCode);

            Customers read = JsonConvert.DeserializeObject <Customers>(response.Body);


            // List the blog posts
            request = new APIGatewayProxyRequest
            {
            };
            context  = new TestLambdaContext();
            response = await functions.GetCustomersAsync(request, context);

            Assert.Equal(200, response.StatusCode);

            Customers[] blogPosts = JsonConvert.DeserializeObject <Customers[]>(response.Body);
            Assert.Single(blogPosts);



            // Delete the blog post
            request = new APIGatewayProxyRequest
            {
                PathParameters = new Dictionary <string, string> {
                    { CustomerFunctions.ID_QUERY_STRING_NAME, blogId }
                }
            };
            context  = new TestLambdaContext();
            response = await functions.RemoveCustomerAsync(request, context);

            Assert.Equal(200, response.StatusCode);

            // Make sure the post was deleted.
            request = new APIGatewayProxyRequest
            {
                PathParameters = new Dictionary <string, string> {
                    { CustomerFunctions.ID_QUERY_STRING_NAME, blogId }
                }
            };
            context  = new TestLambdaContext();
            response = await functions.GetCustomerAsync(request, context);

            Assert.Equal((int)HttpStatusCode.NotFound, response.StatusCode);
        }
        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");
            }
        }