Beispiel #1
0
        protected void createCustomer_Click1(object sender, EventArgs e)
        {
            using (ChallengeLINQDataContext Data = new ChallengeLINQDataContext())
            {
                string cusName       = custNameText.Text;
                string cusGender     = custGenderText.Text;
                string PaymentMethod = custPaymentText.Text;
                string course        = custCourseName.SelectedItem.Text;
                string hostel        = custHostelName.SelectedItem.Text;

                CustomerClass theCustomer = new CustomerClass(cusName, cusGender, course, hostel, PaymentMethod);

                List <string> customerDetails = new List <string>(theCustomer.addToList());

                foreach (string measurement in customerDetails)
                {
                    summaryList.Items.Add(measurement);
                }

                CustomerTable TableCustomer = new CustomerTable(); //This enters the formdata into the database, specifically the CustomerTable
                TableCustomer.customerName   = cusName;
                TableCustomer.customerGender = cusGender;
                TableCustomer.paymentMethod  = PaymentMethod;
                TableCustomer.courseName     = course;
                TableCustomer.hostelName     = hostel;

                Data.CustomerTables.InsertOnSubmit(TableCustomer);
                Data.SubmitChanges();
            }
        }
Beispiel #2
0
        protected void Button1_Click1(object sender, EventArgs e)
        {
            using (ChallengeLINQDataContext data = new ChallengeLINQDataContext())
            {
                string user = userBox.Text;
                string pass = passBox.Text;

                try
                {
                    var theUser = data.StaffTables.Single(StaffTable => StaffTable.username == user);   //using the == function to make sure it's an exact match
                    var thePass = data.StaffTables.Single(StaffTable => StaffTable.password == pass);

                    // string successMessage = "Welcome! " + theUser.name;             //using "" to have text appear before the staffName
                    // logInMessage.Text = successMessage;
                    Server.Transfer("Customer.aspx"); //This code would take you straight to the Customer screen on a successful Log In
                }

                catch
                {
                    string errorMessage = "Something's not quite right! Please try again."; //Error message if the information entered doesn't match the staff table exactly
                    logInMessage.Text = errorMessage;
                }
            }
        }