Example #1
0
        public void AddCat(Cat cat, string changes)
        {
            var conn = new SqlConnection(GetConnectionString());
            var sql = "INSERT INTO " + _table + " VALUES('" + cat.GetBreed().Trim() + "','" + cat.GetCountry().Trim() + "','" + cat.GetOrigin().Trim() + "','" + cat.GetBodyType().Trim() + "','" + cat.GetCoat().Trim() + "','" + cat.GetPattern().Trim() + "','" + cat.GetImage().Trim() + "','" + cat.GetInfo().Trim();

            if (_admin)
            {
                sql += "','" + changes;
            }
            sql += "')";

            try
            {
                conn.Open();
                var cmd = new SqlCommand(sql, conn);

                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                var msg = "AddCat Sql Error: ";
                msg += ex.Message;
                throw new Exception(msg);
            }
            finally
            {
                conn.Close();
            }
        }
Example #2
0
 public Boolean AddCat(Cat cat, string changes)
 {
     var catBl = new CatBL(_admin);
     if (!_admin && catBl.IsCatExist(cat.GetBreed().Trim()))
     {
         return false;
     }
     _catDal.AddCat(cat, changes);
     return true;
 }