Beispiel #1
0
 /// <summary>
 /// Insert person to database
 /// </summary>
 /// <param name="person">Person to insert</param>
 /// <returns>count of inserted rows</returns>
 public int Insert(Person person)
 {
     Database db = new Database();
     db.Connect();
     SqlCommand command = db.CreateCommmand(SQL_INSERT);
     PrepareCommand(command, person);
     int ret = db.ExecuteNonQuery(command);
     db.Close();
     return ret;
 }
Beispiel #2
0
        static void Main(string[] args)
        {
            Person pers = new Person("Adam", "Mrkvicka", "Piešťany", 30);

            PersonTable persTable = new PersonTable();
            try
            {
                persTable.Insert(pers);
                Console.WriteLine(pers.ToString() + " úspešne vložený");
            }
            catch (Exception e)
            {
                Console.WriteLine("Chyba pri vložení");
            }
            Console.ReadLine();
        }
Beispiel #3
0
        /// <summary>
        /// Prepare sql command
        /// </summary>
        /// <param name="command">sql command</param>
        /// <param name="person">person</param>
        public void PrepareCommand(SqlCommand command, Person person)
        {
            command.Parameters.Add(new SqlParameter("@idPerson", SqlDbType.Int));
            command.Parameters["@idPerson"].Value = person.IdPerson;

            command.Parameters.Add(new SqlParameter("@firstName", SqlDbType.VarChar, person.FirstName.Length));
            command.Parameters["@firstName"].Value = person.FirstName;

            command.Parameters.Add(new SqlParameter("@lastName", SqlDbType.VarChar, person.LastName.Length));
            command.Parameters["@lastName"].Value = person.LastName;

            command.Parameters.Add(new SqlParameter("@city", SqlDbType.VarChar, person.City.Length));
            command.Parameters["@city"].Value = person.City;

            command.Parameters.Add(new SqlParameter("@age", SqlDbType.Int));
            command.Parameters["@age"].Value = person.Age;
        }