Exemplo n.º 1
0
 private static ShowGenreRow MapObjToRow(ShowGenre item)
 {
     return new ShowGenreRow
     {
         ShowGenreId = item.ShowGenreId,
         ShowId = item.ShowId,
         GenreId = item.GenreId
     };
 }
Exemplo n.º 2
0
 internal static void DeleteEntity(ShowGenre item, SqlConnection conn)
 {
     using (SqlCommand cmd = conn.CreateCommand())
     {
         cmd.CommandType = System.Data.CommandType.Text;
         cmd.CommandText = "delete ShowGenre where ShowGenreId = @ShowGenreId";
         cmd.Parameters.AddWithValue("@ShowGenreId", item.ShowGenreId);
         cmd.ExecuteNonQuery();
     }
 }
Exemplo n.º 3
0
        internal static void InsertEntity(ShowGenre item, SqlConnection conn)
        {
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandType = System.Data.CommandType.Text;
                var sql = new StringBuilder();
                sql.Append("insert ShowGenre (ShowId, GenreId)");
                sql.Append("values (@ShowId, @GenreId);");
                sql.Append("select cast ( scope_identity() as int);");
                cmd.CommandText = sql.ToString();

                SetCommonParameters(item, cmd);
                item.ShowGenreId = (int)cmd.ExecuteScalar();
            }
        }
Exemplo n.º 4
0
        internal static void UpdateEntity(ShowGenre item, SqlConnection conn)
        {
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandType = System.Data.CommandType.Text;
                var sql = new StringBuilder();
                sql.Append("update ShowGenre set ");
                sql.Append(" ShowId = @ShowId, ");
                sql.Append(" GenreId = @GenreId ");
                sql.Append("where ShowGenreId = @ShowGenreId");
                cmd.CommandText = sql.ToString();

                SetCommonParameters(item, cmd);
                cmd.Parameters.AddWithValue("@ShowGenreId", item.ShowGenreId);

                cmd.ExecuteNonQuery();
            }
        }
Exemplo n.º 5
0
 public ShowGenre PersistChild(ShowGenre showGenre, SqlConnection conn)
 {
     if (showGenre.ShowGenreId == 0 && showGenre.IsMarkedForDeletion)
     {
         showGenre = null;
     }
     else if (showGenre.IsMarkedForDeletion)
     {
         DeleteEntity(showGenre, conn);
         showGenre = null;
     }
     else if (showGenre.ShowGenreId == 0)
     {
         InsertEntity(showGenre, conn);
         showGenre.IsDirty = false;
     }
     else if (showGenre.IsDirty)
     {
         UpdateEntity(showGenre, conn);
         showGenre.IsDirty = false;
     }
     return showGenre;
 }
Exemplo n.º 6
0
 internal static ShowGenre Persist(ShowGenre item)
 {
     if (item.ShowGenreId == 0 && item.IsMarkedForDeletion) return null;
     if (item.ShowGenreId == 0)
     {
         // Insert
         var maxId = FakeDatabase.Instance
             .ShowGenres.Max(o => o.ShowGenreId);
         item.ShowGenreId = ++maxId;
         var row = MapObjToRow(item);
         FakeDatabase.Instance.ShowGenres.Add(row);
     }
     else
     {
         var existingRow = FakeDatabase.Instance.ShowGenres
             .FirstOrDefault(o => o.ShowGenreId == item.ShowGenreId);
         if (existingRow == null)
         {
             throw new ApplicationException(
                 "Record not found, another user may have deleted it.");
         }
         else if (item.IsMarkedForDeletion)
         {
             // Delete
             FakeDatabase.Instance.ShowGenres.Remove(existingRow);
         }
         else
         {
             // Update
             existingRow.ShowId = item.ShowId;
             existingRow.GenreId = item.GenreId;
         }
     }
     // reset dirty flag because obj is now synced with db
     if (item != null) item.IsDirty = false;
     return item;
 }
Exemplo n.º 7
0
 private static ShowGenre MapRowToObj(ShowGenreRow row)
 {
     var existingItem = new ShowGenre
     {
         ShowGenreId = row.ShowGenreId,
         ShowId = row.ShowId,
         GenreId = row.GenreId
     };
     existingItem.IsDirty = false;
     return existingItem;
 }
Exemplo n.º 8
0
 private static void SetCommonParameters(ShowGenre item, SqlCommand cmd)
 {
     cmd.Parameters.AddWithValue("@ShowId", item.ShowId);
     cmd.Parameters.AddWithValue("@GenreId", item.GenreId);
 }