private void update_Click(object sender, EventArgs e) { if (Firstname.Text != "" && Lastname.Text != "" && Middlename.Text != "" && bday.Text != "" && Address.Text != "" && Phonenum.Text != "" && Jobposition.Text != "" && Emailadd.Text != "") { sqlcon.Close(); string query = "Update quickpctbl Set Fname ='" + Firstname.Text.Trim() + "', Mname ='" + Middlename.Text.Trim() + "', Lname ='" + Lastname.Text.Trim() + "', Birthday ='" + bday.Text.Trim() + "', Address ='" + Address.Text.Trim() + "', PhoneNumber ='" + Phonenum.Text.Trim() + "', JobPosition ='" + Jobposition.Text.Trim() + "', EmailAddress ='" + Emailadd.Text.Trim() + "' where IdNumber = '" + idnum.Text.Trim() + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon); DataTable dtbl = new DataTable(); sda.Fill(dtbl); MessageBox.Show("Successfuly Update!"); } else { MessageBox.Show("Please Input!"); } idnum.Clear(); Firstname.Clear(); Middlename.Clear(); Lastname.Clear(); bday.Text = String.Empty; Address.Clear(); Phonenum.Clear(); Jobposition.Text = String.Empty; Emailadd.Clear(); }
internal void ProfileAdd() { // Populate the excel data GlobalDefinitions.ExcelLib.PopulateInCollection(Base.ExcelPath, "ProfilePage"); GlobalDefinitions.WaitForElement(GlobalDefinitions.driver, By.XPath("(//i[@class='dropdown icon'])[2]")); //Click Profilename ProfileName.Click(); //Enter Firstname Firstname.Clear(); Firstname.SendKeys(GlobalDefinitions.ExcelLib.ReadData(2, "Firstname")); //Enter Lastname Lastname.Clear(); Lastname.SendKeys(GlobalDefinitions.ExcelLib.ReadData(2, "Lastname")); //Save profilename SaveProfileName.Click(); var fname = GlobalDefinitions.ExcelLib.ReadData(2, "Firstname"); var Lname = GlobalDefinitions.ExcelLib.ReadData(2, "Lastname"); var title = fname + " " + Lname; GlobalDefinitions.wait(40); Assert.AreEqual(Titlename.Text, title); }
internal void Account() { User.Click(); MyAcc.Click(); Namechange.Click(); ExcelLib.PopulateInCollection(Base.ExcelPath, "MyAccount"); Firstname.Clear(); Thread.Sleep(3000); Firstname.SendKeys(ExcelLib.ReadData(2, "Firstname")); Driver.wait(5); Lastname.Clear(); Lastname.SendKeys(ExcelLib.ReadData(2, "Lastname")); Submitname.Click(); ChangeRegion.Click(); //select a region from dropdown Driver.wait(5); SelectElement reg = new SelectElement(Region); string regionval = ExcelLib.ReadData(2, "Region"); reg.SelectByText(regionval); //Region.SendKeys(ExcelLib.ReadData(2, " Region")); // Global.Driver.WaitForElement(Driver.driver, By.XPath("html/body/div[8]"), 10); // Region.SendKeys(Keys.ArrowDown); //Region.SendKeys(Keys.Enter); Thread.Sleep(3000); SubmitRegion.Click(); ValidateMyAcc(); }
public StudentInfoWindow() { InitializeComponent(); Firstname.Clear(); Lastname.Clear(); Group.Clear(); BookNum.Clear(); }
private void resetlist_Click(object sender, EventArgs e) { ID_Student.Clear(); Firstname.Clear(); Lastname.Clear(); PhoneNumber.Clear(); Address.Clear(); picturestudent.Image = null; RadioMale.Checked = false; RadioFemale.Checked = false; }
private async void Delete_OnClick(object sender, RoutedEventArgs e) { var selected = ContactsList.SelectedItem as Person; if (selected != null) { AddressList.Items.Clear(); ContactsList.Items.Remove(selected); await _personManager.Delete(selected); Firstname.Clear(); Lastname.Clear(); Phone.Clear(); Address.Clear(); } }
private void ClearInput() { Firstname.Clear(); _Name.Clear(); Secondname.Clear(); comboBox1.SelectedIndex = 0; Ball.Clear(); City.Clear(); Street.Clear(); Build.Clear(); Flat.Clear(); Group.Value = 1; Course.Value = 1; radioButton1.Checked = false; radioButton2.Checked = false; label16.Text = "1"; label15.Text = "1"; }
/// <summary> /// Admin lägger till bilmekaniker /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AddMechanic_Click(object sender, RoutedEventArgs e) { if (Firstname.Text == "" || Lastname.Text == "" || DOB.SelectedDate == null) { MessageBox.Show("Fyll i alla fälten"); return; } string firstName = Firstname.Text; string lastName = Lastname.Text; DateTime dob = DOB.DisplayDate; var _mechanic = _mechanicService.AddMechanic(firstName, lastName, dob); MessageBox.Show($"Bilmekaniker {Firstname.Text} {Lastname.Text} har lagts till"); Firstname.Clear(); Lastname.Clear(); }
private void newaccount_Click(object sender, EventArgs e) { if (Firstname.Text != "" && Lastname.Text != "" && Middlename.Text != "" && bday.Text != "" && Address.Text != "" && Phonenum.Text != "" && Jobposition.Text != "" && Emailadd.Text != "") { string query = "Insert into quickpctbl VALUES('" + idnum.Text.Trim() + "','" + Firstname.Text.Trim() + "','" + Middlename.Text.Trim() + "','" + Lastname.Text.Trim() + "','" + bday.Text.Trim() + "','" + Address.Text.Trim() + "','" + Phonenum.Text.Trim() + "','" + Jobposition.Text.Trim() + "','" + Emailadd.Text.Trim() + "')"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon); DataTable dtbl = new DataTable(); sda.Fill(dtbl); MessageBox.Show("Successfuly Added!"); idnum.Clear(); Firstname.Clear(); Middlename.Clear(); Lastname.Clear(); bday.Text = String.Empty; Address.Clear(); Phonenum.Clear(); Jobposition.Text = String.Empty; Emailadd.Clear(); } else { MessageBox.Show("Please Input!"); } }
//SignUp Button private void button1_Click(object sender, EventArgs e) { try { bool x = true; TheClasses.NewClient objNewClient = new TheClasses.NewClient(); TextInfo textInfo = new CultureInfo("en-US", false).TextInfo; #region Firstname //objNewClient.NullCheck(Firstname); //Firstname.Text = Firstname.Text.ToLower(); //objNewClient.NumberCheck(Firstname); //objNewClient.UnicodeCheck(Firstname, 0); //objNewClient.FName += objNewClient.CapitalizeFirstLetter(Firstname.Text); if (objNewClient.NullCheck(Firstname.Text) == false) { Firstname.Clear(); throw new Exception("Please insert your '" + Firstname.Name + "' !"); } if (objNewClient.NumberCheck(Firstname.Text) == false) { Firstname.Clear(); throw new Exception("Please insert a correct '" + Firstname.Name + "' !"); } if (objNewClient.UnicodeCheck(Firstname.Text, 0) == false) { Firstname.Clear(); throw new Exception("Please insert a correct '" + Firstname.Name + "' !"); } objNewClient.FName += textInfo.ToTitleCase(Firstname.Text); #endregion #region Lastname //objNewClient.NullCheck(Lastname); //Lastname.Text = Lastname.Text.ToLower(); //objNewClient.NumberCheck(Lastname); //objNewClient.UnicodeCheck(Lastname, 1); if (objNewClient.NullCheck(Lastname.Text) == false) { Lastname.Clear(); throw new Exception("Please insert your '" + Lastname.Name + "' !"); } if (objNewClient.NumberCheck(Lastname.Text) == false) { Lastname.Clear(); throw new Exception("Please insert a correct '" + Lastname.Name + "' !"); } if (objNewClient.UnicodeCheck(Lastname.Text, 1) == false) { Lastname.Clear(); throw new Exception("Please insert a correct '" + Lastname.Name + "' !"); } objNewClient.LName += textInfo.ToTitleCase(Lastname.Text); #endregion #region Email //objNewClient.NullCheck(Email); //Email.Text = Email.Text.ToLower(); //objNewClient.EmailCheck(Email); if (objNewClient.NullCheck(Email.Text) == false) { Email.Clear(); throw new Exception("Please insert your '" + Email.Name + "' !"); } if (objNewClient.EmailCheck(Email.Text) == true) { Email.Clear(); throw new Exception("Please insert a correct Email! ([email protected]/@gmail.com)"); } objNewClient.Email += Email.Text; #endregion #region Phone //objNewClient.PhoneCheck(Phone); if (string.IsNullOrEmpty(Phone.Text)) { x = false; } if (x == true) { if (objNewClient.LetterCheck(Phone.Text) == false) { Phone.Clear(); throw new Exception("Please insert a correct '" + Phone.Name + "' !"); } if (objNewClient.UnicodeCheck(Phone.Text, 0) == false) { Phone.Clear(); throw new Exception("Please insert a correct '" + Phone.Name + "' !"); } } objNewClient.Phone += Phone.Text; #endregion #region Username //objNewClient.NullCheck(Username); //objNewClient.UnicodeCheck(Username, 0); if (objNewClient.NullCheck(Username.Text) == false) { Username.Clear(); throw new Exception("Please insert your '" + Username.Name + "' !"); } if (objNewClient.UnicodeCheck(Username.Text, 0) == false) { Username.Clear(); throw new Exception("Please insert a correct '" + Username.Name + "' !"); } if (Username.Text.Contains("admin")) { Username.Clear(); throw new Exception("Your Username cannot contain 'admin'!"); } objNewClient.UserName += Username.Text; #endregion #region Password //objNewClient.NullCheck(Password); //objNewClient.PasswordRule(Password); if (objNewClient.NullCheck(Password.Text) == false) { Password.Clear(); throw new Exception("Please insert your '" + Password.Name + "' !"); } if ((objNewClient.PasswordRule1(Password.Text) == true) || (objNewClient.PasswordRule2(Password.Text) == true)) { Password.Clear(); throw new Exception("Your password must contain at least 1 uupercase " + Environment.NewLine + " and 1 special character!"); } objNewClient.Password += Password.Text; #endregion if (checkBox1.Checked) { //SQL Command string _command = "INSERT INTO Customer.dbo.Customer (FirstName,LastName,Email,Phone,UserName,Password) VALUES('" + objNewClient.FName + "','" + objNewClient.LName + "','" + objNewClient.Email + "','" + objNewClient.Phone + "','" + objNewClient.UserName + "','" + objNewClient.Password + "')"; objNewClient.InsertReadUpdateData(_command); //Using EntityFramework /*using (CustomerEntities obj = new CustomerEntities()) * { * Customer NewCustomer = new Customer(); * * NewCustomer.FirstName = objNewClient.FName; * NewCustomer.LastName = objNewClient.LName; * NewCustomer.Email = objNewClient.Email; * NewCustomer.Phone = objNewClient.Phone; * NewCustomer.UserName = objNewClient.UserName; * NewCustomer.Password = objNewClient.Password; * obj.Customers.Add(NewCustomer); * obj.SaveChanges(); * }*/ MessageBox.Show("You have succesfuly created an account!"); this.Close(); originalForm.enabledisable(1); } else { Password.Clear(); throw new Exception("You didn't Agree the Terms of service!"); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }