Exemplo n.º 1
0
        static void AddEnter(int passID, DateTime time, string typeofentering)
        {
            string connectionString =
                @"Data Source=(LocalDB)\MSSQLLocalDB;
            AttachDbFilename=|DataDirectory|\AppData\Propyska.mdf;
            Integrated Security=True";

            Passes passes = Check.GetUser(passID);

            if (passes.PassID != 0)
            {
                using (SqlConnection con = new SqlConnection(connectionString))
                {
                    con.Open();

                    using (SqlCommand command = new SqlCommand(
                               "INSERT INTO [dbo].[Entering] ([PassID], [TypeofEntering], [Time]) VALUES (@PassID, @typeofentering, @time)", con))
                    {
                        command.Parameters.Add(new SqlParameter("passId", passID));
                        command.Parameters.Add(new SqlParameter("typeofentering", typeofentering));
                        command.Parameters.Add(new SqlParameter("time", time));

                        command.ExecuteNonQuery();
                    }

                    con.Close();
                }
            }

            else
            {
                MessageBox.Show("Введен неверный ID");
            }
        }
Exemplo n.º 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            int      passID         = int.Parse(comboBox1.Text);
            DateTime time           = DateTime.Now;
            string   typeofentering = "Выход";

            AddEnter(passID, time, typeofentering);

            Passes passes = Check.GetUser(passID);

            if (passes.PassID != 0)
            {
                this.Close();
            }
        }