private void BackToMenuBtn_Click(object sender, EventArgs e) { MenuScreenForm form = new MenuScreenForm(); form.Show(); Close(); }
private void Form1_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { MenuScreenForm form = new MenuScreenForm(); form.Show(); Visible = false; } else if (e.KeyCode == Keys.Escape) { Dispose(); } }
private void InsertCarBtn_MouseClick(object sender, MouseEventArgs e) { Regex regex = new Regex(@"(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$"); bool isValid = regex.IsMatch(startDateTextBox.Text.Trim()); bool isValid2 = regex.IsMatch(startDateTextBox.Text.Trim()); DateTime dt; isValid = DateTime.TryParseExact(startDateTextBox.Text, "dd/MM/yyyy", new CultureInfo("en-GB"), System.Globalization.DateTimeStyles.None, out dt); isValid2 = DateTime.TryParseExact(endDateTextBox.Text, "dd/MM/yyyy", new CultureInfo("en-GB"), System.Globalization.DateTimeStyles.None, out dt); DateTime startData = DateTime.Parse(startDateTextBox.Text); DateTime endData = DateTime.Parse(endDateTextBox.Text); con.Open(); if (!isValid || startDateTextBox.Text == "" || !isValid2 || endDateTextBox.Text == "") { MessageBox.Show("Invalid date."); } else if (cityTextBox.Text == "") { MessageBox.Show("Introduce a city."); } else if (startData > endData) { MessageBox.Show("The start data cannot be bigger or equal than the end data."); } else { //if the model of the car does not exist in the Cars table it will give an error. SqlCommand command = con.CreateCommand(); command.CommandText = "Select * from Cars where Model = '" + carModelTextBox.Text + "'"; command.Parameters.AddWithValue("@CarModel", carModelTextBox.Text); SqlDataAdapter sda = new SqlDataAdapter(command); DataTable dataTable = new DataTable(); sda.Fill(dataTable); //if the client ID does not exist in the Customer table it will give an error. SqlCommand command2 = con.CreateCommand(); command2.CommandText = "Select * from Customers where CostumerID = '" + clientIDTextBox.Text + "'"; command2.Parameters.AddWithValue("@CostumerID", clientIDTextBox.Text); SqlDataAdapter sda2 = new SqlDataAdapter(command2); DataTable dataTable2 = new DataTable(); sda2.Fill(dataTable2); //if the location does not exist in the Customer table it will give an error. SqlCommand command3 = con.CreateCommand(); command3.CommandText = "Select * from Customers where Location = '" + cityTextBox.Text + "'"; command3.Parameters.AddWithValue("@CostumerID", clientIDTextBox.Text); SqlDataAdapter sda3 = new SqlDataAdapter(command3); DataTable dataTable3 = new DataTable(); sda3.Fill(dataTable3); if (dataTable.Rows.Count > 0 && dataTable2.Rows.Count > 0 & dataTable3.Rows.Count > 0) { SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into CarRent values('" + clientIDTextBox.Text + "' , '" + carModelTextBox.Text + "' , '" + startDateTextBox.Text + "' , '" + endDateTextBox.Text + "', '" + cityTextBox.Text + "')"; cmd.ExecuteNonQuery(); Close(); MenuScreenForm form = new MenuScreenForm(); form.Show(); } else { MessageBox.Show("The model of the car or the client ID or the location it does not exists in our database.Please check again."); } con.Close(); } }
private void UpdateCustomerBtn_MouseClick(object sender, MouseEventArgs e) { Regex regex = new Regex(@"(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$"); bool isValid = regex.IsMatch(birthDateTextBox.Text.Trim()); DateTime dt; isValid = DateTime.TryParseExact(birthDateTextBox.Text, "dd/MM/yyyy", new CultureInfo("en-GB"), System.Globalization.DateTimeStyles.None, out dt); con.Open(); if (!isValid || birthDateTextBox.Text == "") { MessageBox.Show("Invalid birth date."); } else if (clientNameTextBox.Text == "") { MessageBox.Show("Introduce a client name."); } else if (locationTextBox.Text == "") { MessageBox.Show("Introduce a location."); } else if (ZIPCodeTextBox.Text.Length < 6) { MessageBox.Show("The ZIP Code cannot be lower than 6 characters."); } else if (clientIDTextBox.Text == "") { MessageBox.Show("Introduce an ID to know what customer you want to update."); } else { SqlCommand cmd2; cmd2 = new SqlCommand("Select * FROM Customers WHERE CostumerID = '" + clientIDTextBox.Text + "'", con); SqlDataAdapter da = new SqlDataAdapter(cmd2); da.Fill(ds); int i = ds.Tables[0].Rows.Count; if (i > 0) { SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = " UPDATE Customers SET Name = '" + clientNameTextBox.Text + "' , BirthDate = '" + birthDateTextBox.Text + "' , Location = '" + locationTextBox.Text + "' Where CostumerID = '" + clientIDTextBox.Text + "'"; cmd.ExecuteNonQuery(); Close(); MenuScreenForm form = new MenuScreenForm(); form.Show(); } //if the the customer ID introduced does not exists to update,there will be an error message. else { MessageBox.Show("The customer inserted with this ID " + clientIDTextBox.Text + " does not exists."); ds.Clear(); } } con.Close(); }
private void RegisterCustomerBtn_Click(object sender, EventArgs e) { Regex regex = new Regex(@"(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$"); bool isValid = regex.IsMatch(birthDateTextBox.Text.Trim()); DateTime dt; isValid = DateTime.TryParseExact(birthDateTextBox.Text, "dd/MM/yyyy", new CultureInfo("en-GB"), System.Globalization.DateTimeStyles.None, out dt); con.Open(); if (!isValid || birthDateTextBox.Text == "") { MessageBox.Show("Invalid birth date."); } else if (clientNameTextBox.Text == "") { MessageBox.Show("Introduce a client name."); } else if (locationTextBox.Text == "") { MessageBox.Show("Introduce a location."); } else if (ZIPCodeTextBox.Text.Length < 6) { MessageBox.Show("The ZIP Code cannot be lower than 6 characters."); } /* All the way up I have validated the fields. * I cannot validate the Customer ID because it is a primary key on the field and also * it has auto increment. */ else { SqlCommand cmd2; cmd2 = new SqlCommand("Select * FROM Customers WHERE Name = '" + clientNameTextBox.Text + "'", con); SqlDataAdapter da = new SqlDataAdapter(cmd2); da.Fill(ds); int i = ds.Tables[0].Rows.Count; //if the the customer introduced already exists,there will be an error message. if (i > 0) { MessageBox.Show("The customer inserted with this name " + clientNameTextBox.Text + " already exists."); ds.Clear(); } else { SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into Customers values('" + clientNameTextBox.Text + "' , '" + birthDateTextBox.Text + "' , '" + locationTextBox.Text + "')"; cmd.ExecuteNonQuery(); Close(); MenuScreenForm form = new MenuScreenForm(); form.Show(); } } con.Close(); }