private void backToMeetingsToolStripMenuItem_Click(object sender, EventArgs e) { this.Hide(); meetings f2 = new meetings(); f2.Closed += (s, args) => this.Close(); f2.Show(); }
private void button2_Click(object sender, EventArgs e) { this.Hide(); meetings f2 = new meetings(); f2.Closed += (s, args) => this.Close(); f2.Show(); }
private void button1_Click(object sender, EventArgs e) { string time; if (int.Parse(dateTimePicker2.Value.Minute.ToString()) < 10) { time = dateTimePicker2.Value.Hour.ToString() + ":0" + dateTimePicker2.Value.Minute.ToString(); } else { time = dateTimePicker2.Value.Hour.ToString() + ":" + dateTimePicker2.Value.Minute.ToString(); } string date = dateTimePicker1.Value.Day.ToString() + "/" + dateTimePicker1.Value.Month.ToString() + "/" + dateTimePicker1.Value.Year.ToString(); string connectionstring = "Data Source=localhost;Initial Catalog=StorageDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection con = new SqlConnection(connectionstring); con.Open(); string sql = "INSERT INTO Meetings(Id,Date,time,Customer) VALUES(@Id,@date,@time,@Customer)"; SqlCommand com = new SqlCommand(sql, con); com.Parameters.AddWithValue("@Customer", textBox1.Text); com.Parameters.AddWithValue("@date", date); com.Parameters.AddWithValue("@time", time); com.Parameters.AddWithValue("@Id", count() + 1); com.ExecuteNonQuery(); con.Close(); MessageBox.Show("Meeting Saved"); this.Hide(); meetings f2 = new meetings(); f2.Closed += (s, args) => this.Close(); f2.Show(); }