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();
}