using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using EFReplaceAll.Models;
namespace EFReplaceAll.Config
{
public class DbSetInfo
{
public IQueryable<object> DbSet { set; get; }
public Type DbSetType { set; get; }
}
public class MyContext : DbContext
{
public DbSet<Product> Products { set; get; }
public DbSet<Category> Categories { set; get; }
public DbSet<User> Users { set; get; }
public MyContext()
: base("Connection1")
{
this.Database.Log = sql => Console.Write(sql);
}
public IList<DbSetInfo> GetAllDbSets()
{
return this.GetType()
.GetProperties()
.Where(p => p.PropertyType.IsGenericType &&
p.PropertyType.GetGenericTypeDefinition() == typeof(DbSet<>))
.Select(p => new DbSetInfo
{
DbSet = (IQueryable<object>)p.GetValue(this, null),
DbSetType = p.PropertyType.GetGenericArguments().First()
})
.ToList();
}
}
} using System;
namespace EFReplaceAll.Utils
{
public class ReplaceOp
{
public string ToFind { set; get; }
public string ToReplace { set; get; }
public StringComparison Comparison { set; get; }
}
} using System.Collections.Generic;
using System.Linq;
using EFReplaceAll.Config;
namespace EFReplaceAll.Utils
{
public static class UpdateDbContextContents
{
public static void ReplaceAllStringsAcrossTables(IList<ReplaceOp> replaceOps)
{
int dbSetsCount;
using (var uow = new MyContext())
{
dbSetsCount = uow.GetAllDbSets().Count;
}
for (var i = 0; i < dbSetsCount; i++)
{
using (var uow = new MyContext()) // using a new context each time to free resources quickly.
{
var dbSetResult = uow.GetAllDbSets()[i];
var stringProperties = dbSetResult.DbSetType.GetProperties()
.Where(p => p.PropertyType == typeof(string))
.ToList();
var dbSetEntities = dbSetResult.DbSet;
var haveChanges = false;
foreach (var entity in dbSetEntities)
{
foreach (var stringProperty in stringProperties)
{
var oldPropertyValue = stringProperty.GetValue(entity, null) as string;
if (string.IsNullOrWhiteSpace(oldPropertyValue))
{
continue;
}
var newPropertyValue = oldPropertyValue;
foreach (var replaceOp in replaceOps)
{
newPropertyValue = newPropertyValue.ReplaceString(replaceOp.ToFind, replaceOp.ToReplace, replaceOp.Comparison);
}
if (oldPropertyValue != newPropertyValue)
{
stringProperty.SetValue(entity, newPropertyValue, null);
haveChanges = true;
}
}
}
if (haveChanges)
{
uow.SaveChanges();
}
}
}
}
}
} using System;
using System.Text;
namespace EFReplaceAll.Utils
{
public static class StringExtensions
{
public static string ReplaceString(this string src, string oldValue, string newValue, StringComparison comparison)
{
if (string.IsNullOrWhiteSpace(src))
{
return src;
}
if (string.Compare(oldValue, newValue, comparison) == 0)
{
return src;
}
var sb = new StringBuilder();
var previousIndex = 0;
var index = src.IndexOf(oldValue, comparison);
while (index != -1)
{
sb.Append(src.Substring(previousIndex, index - previousIndex));
sb.Append(newValue);
index += oldValue.Length;
previousIndex = index;
index = src.IndexOf(oldValue, index, comparison);
}
sb.Append(src.Substring(previousIndex));
return sb.ToString();
}
}
} UpdateDbContextContents.ReplaceAllStringsAcrossTables(
new[]
{
new ReplaceOp
{
ToFind = "https://www.dntips.ir",
ToReplace = "https://www.dntips.ir",
Comparison = StringComparison.OrdinalIgnoreCase
},
new ReplaceOp
{
ToFind = "https://www.dntips.ir",
ToReplace = "https://www.dntips.ir",
Comparison = StringComparison.OrdinalIgnoreCase
}
}); 
var posts = [
{
id: '1',
title: "Getting Started with Ember.js",
body: "Bla bla bla 1."
},
{
id: '2',
title: "Routes and Templates",
body: "Bla bla bla 2."
},
{
id: '3',
title: "Controllers",
body: "Bla bla bla 3."
}
];
var comments = [
{
id: '1',
postId: '3',
text: 'Thanks!'
},
{
id: '2',
postId: '3',
text: 'Good to know that!'
},
{
id: '3',
postId: '1',
text: 'Great!'
}
]; <script src="Scripts/App/store.js" type="text/javascript"></script>
Blogger.PostsRoute = Ember.Route.extend({
controllerName: 'posts',
renderTemplare: function () {
this.render('posts');
},
model: function () {
return posts;
}
}); <script src="Scripts/Routes/posts.js" type="text/javascript"></script>
<h2>Emeber.js blog</h2>
<ul>
{{#each post in model}}
<li>{{post.title}}</li>
{{/each}}
</ul> 
Blogger.Router.map(function () {
this.resource('posts', { path: '/' });
this.resource('about');
this.resource('contact', function () {
this.resource('email');
this.resource('phone');
});
this.resource('recent-comments');
}); Blogger.RecentCommentsRoute = Ember.Route.extend({
model: function () {
return comments;
}
}); <script src="Scripts/Routes/recent-comments.js" type="text/javascript"></script>
<div class='container'>
<nav class='navbar navbar-default' role='navigation'>
<ul class='nav navbar-nav'>
<li>{{#link-to 'posts'}}Posts{{/link-to}}</li>
<li>{{#link-to 'recent-comments'}}Recent comments{{/link-to}}</li>
<li>{{#link-to 'about'}}About{{/link-to}}</li>
<li>{{#link-to 'contact'}}Contact{{/link-to}}</li>
</ul>
</nav>
{{outlet}}
</div> <h1>Recent comments</h1>
<ul>
{{#each comment in model}}
<li>{{comment.text}}</li>
{{/each}}
</ul> <script type="text/javascript"> EmberHandlebarsLoader.loadTemplates([ 'posts', 'about', 'application', 'contact', 'email', 'phone', 'recent-comments' ]); </script>
Blogger.Router.map(function () {
this.resource('posts', { path: '/' });
this.resource('about');
this.resource('contact', function () {
this.resource('email');
this.resource('phone');
});
this.resource('recent-comments');
this.resource('post', { path: 'posts/:post_id' });
}); Blogger.PostRoute = Ember.Route.extend({
model: function (params) {
return posts.findBy('id', params.post_id);
}
}); <script src="Scripts/Routes/post.js" type="text/javascript"></script>
<h1>{{title}}</h1>
<p>{{body}}</p> <script type="text/javascript"> EmberHandlebarsLoader.loadTemplates([ 'posts', 'about', 'application', 'contact', 'email', 'phone', 'recent-comments', 'post' ]); </script>
<h2>Emeber.js blog</h2>
<ul>
{{#each post in model}}
<li>{{#link-to 'post' post.id}}{{post.title}}{{/link-to}}</li>
{{/each}}
</ul> 
<h2>{{title}}</h2>
{{#if isEditing}}
<form>
<div class="form-group">
<label for="title">Title</label>
{{input value=title id="title" class="form-control"}}
</div>
<div class="form-group">
<label for="body">Body</label>
{{textarea value=body id="body" class="form-control" rows="5"}}
</div>
<button class="btn btn-primary" {{action 'save' }}>Save</button>
</form>
{{else}}
<p>{{body}}</p>
<button class="btn btn-primary" {{action 'edit' }}>Edit</button>
{{/if}} Blogger.PostController = Ember.ObjectController.extend({
isEditing: false,
actions: {
edit: function () {
this.set('isEditing', true);
},
save: function () {
this.set('isEditing', false);
}
}
}); <script src="Scripts/Controllers/post.js" type="text/javascript"></script>
<h2>Emeber.js blog</h2>
<ul>
{{#each post in model}}
<li>{{#link-to 'post' post.id}}{{post.title}}{{/link-to}}</li>
{{/each}}
</ul>
<a href="#" class="btn btn-primary" {{action 'sortByTitle'}}>Sort by title</a> Blogger.PostsController = Ember.ArrayController.extend({
sortProperties: ['id'],// مقادیر پیش فرض مرتب سازی
sortAscending: false,
actions: {
sortByTitle: function () {
this.set('sortProperties', ['title']);
this.set('sortAscending', !this.get('sortAscending'));
}
}
}); <script src="Scripts/Controllers/posts.js" type="text/javascript"></script>
<h2>Emeber.js blog</h2>
<ul>
{{#each post in arrangedContent}}
<li>{{#link-to 'post' post.id}}{{post.title}}{{/link-to}}</li>
{{/each}}
</ul>
<a href="#" class="btn btn-primary" {{action 'sortByTitle'}}>Sort by title</a> 
<h2>Ember.js blog</h2>
<ul>
{{#each}}
<li>{{#link-to 'post' id}}{{title}}{{/link-to}}</li>
{{/each}}
</ul>
<a href="#" class="btn btn-primary" {{action 'sortByTitle'}}>Sort by title</a>