/// <summary>
        /// Добавляет информацию о ремонте.
        /// </summary>
        /// <param name="infoRep"></param>
        public void Add(InfoRepair infoRep)
        {
            try
            {
                using (var conn = GetConnection())
                {
                    conn.Open();
                    using (var cmd = conn.CreateCommand())
                    {
                        cmd.CommandText = "INSERT INTO InfoRepair(Cost, Length, NameRepairs, Note, StartDate) VALUES(@Cost, @Length, @NameRepairs, @Note, @StartDate)";
                        cmd.Parameters.AddWithValue("@Cost", infoRep.Cost);
                        cmd.Parameters.AddWithValue("@Length", infoRep.Length);
                        cmd.Parameters.AddWithValue("@NameRepairs", infoRep.NameRepairs);
                        cmd.Parameters.AddWithValue("@Note", infoRep.Note);
                        cmd.Parameters.AddWithValue("@StartDate", infoRep.StartDate);

                        //object decease = customer.Note.HasValue ? (object)customer.Note.Value : DBNull.Value;
                        //cmd.Parameters.AddWithValue("@Note", decease);

                        cmd.ExecuteNonQuery();
                    }
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show(exc.Message, "Ошибка");
            }
        }
        /// <summary>
        /// Загружает информацию о ремонтах.
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        private static InfoRepair LoadInfo(SqlDataReader reader)
        {
            InfoRepair infoRepair = new InfoRepair();

            try
            {
                infoRepair.StartDate   = reader.GetDateTime(reader.GetOrdinal("StartDate"));
                infoRepair.NameRepairs = reader.GetString(reader.GetOrdinal("NameRepairs"));
                infoRepair.Note        = reader.GetString(reader.GetOrdinal("Note"));

                object decease1 = reader["Cost"];
                if (decease1 != DBNull.Value)
                {
                    infoRepair.Cost = Convert.ToInt32(decease1);
                }

                object decease = reader["Length"];
                if (decease != DBNull.Value)
                {
                    infoRepair.Length = Convert.ToInt32(decease);
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show(exc.Message, "Ошибка");
            }

            return(infoRepair);
        }
        /// <summary>
        /// Обновляет информацию о ремонте.
        /// </summary>
        /// <param name="customer"></param>
        public void Update(InfoRepair customer)
        {
            try
            {
                using (var conn = GetConnection())
                {
                    conn.Open();
                    using (var cmd = conn.CreateCommand())
                    {
                        cmd.CommandText = "UPDATE InfoRepair SET  Cost = @Cost, Length = @Length, NameRepairs=@NameRepairs, Note=@Note, StartDate=@StartDate WHERE  StartDate = @ID1";
                        cmd.Parameters.AddWithValue("@ID1", customer.StartDate);

                        //object decease = customer.Note.HasValue ? (object)customer.Note.Value : DBNull.Value;
                        //cmd.Parameters.AddWithValue("@Note", decease);

                        cmd.ExecuteNonQuery();
                    }
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show(exc.Message, "Ошибка");
            }
        }