public void UpdateTest()
{
using (var dbOffcontext = new AdbContext(DatabaseType.Sqlite))
using (var dbcontext = new AdbContext())
{
var gr = new GenericUpdater <Surveys, DateTime?>(sourceContext: dbcontext, destinationContext: dbOffcontext);
var max = gr.GetMax(a => a.ModifiedOn);
var c = gr.GetToUpdateData(a => a.ModifiedOn, b => b.ModifiedOn != null && b.ModifiedOn > max, false);
}
}
public void GenericMaxTest()
{
using (var dbOffcontext = new AdbContext(DatabaseType.Sqlite))
using (var dbcontext = new AdbContext())
{
var gr = new GenericUpdater <Surveys, DateTime?>(dbcontext, dbOffcontext);
var b = gr.GetMax(a => a.ModifiedOn);
Assert.AreEqual(1, 1);
}
}
public void InsertTest()
{
using (var dbOffcontext = new AdbContext(DatabaseType.Sqlite))
using (var dbcontext = new AdbContext())
{
var gr = new GenericUpdater <Surveys, DateTime?>(sourceContext: dbcontext, destinationContext: dbOffcontext);
var max = gr.GetMax(a => a.CreatedOn);
var c = gr.GetToUpdateData(a => a.CreatedOn, b => b.CreatedOn != null && b.CreatedOn > max, true);
Assert.AreEqual(c, 1);
}
}
public void GenericSelectTest()
{
using (var dbcontext = new AdbContext())
{
var gr = new GenericRepository <Rule>(dbcontext);
Rule r = new Rule {
RuleId = 1, Name = "New", Description = "inserted"
};
gr.Insert(r);
gr.Save();
var updater = new Rule {
RuleId = 9, Name = "updated", Description = "Updated"
};
gr.Update(updater);
gr.Save();
var f = gr.Get(a => a.Name == "New", d => d.OrderBy(s => s.Name), "");
Assert.AreEqual(1, 1);
}
}
public void Test()
{
using (var dbcontext = new AdbContext())
{
var gr = new GenericRepository <Rule>(dbcontext);
var m = new Rule();
m.RuleId = 1;
m.Description = "a";
m.Name = "a";
var n = new Rule();
n.RuleId = 1;
n.Description = "b";
n.Name = "b";
gr.InsertOrUpdate(n, a => a.RuleId == n.RuleId);
gr.InsertOrUpdate(m, a => a.RuleId == m.RuleId);
gr.Save();
}
}
public void TestSyncInserts()
{
using (var dbOffLinecontext = new AdbContext(DatabaseType.Sqlite))
{
var maxcreatedon = dbOffLinecontext.Surveys.Max(s => s.CreatedOn);
maxcreatedon = maxcreatedon ?? DateTime.Now.AddYears(-20);
List <Surveys> newSurveys;
using (var dbOnLinecontext = new AdbContext())
{
var surveys = from s in dbOnLinecontext.Surveys
where s.CreatedOn != null && s.CreatedOn > maxcreatedon
select s;
var a = surveys.ToList();
newSurveys = a;
}
if (newSurveys.Count > 0)
{
dbOffLinecontext.Surveys.AddRange(newSurveys);
dbOffLinecontext.SaveChanges();
}
}
}
public void TestSyncUpdates()
{
using (var dbOffLinecontext = new AdbContext(DatabaseType.Sqlite))
{
var maxModifiedDate = dbOffLinecontext.Surveys.Max(s => s.ModifiedOn);
List <Surveys> updatedData;
using (var dbOnLinecontext = new AdbContext())
{
var surveys = from s in dbOnLinecontext.Surveys
where s.ModifiedOn != null && s.ModifiedOn > maxModifiedDate
select s;
updatedData = surveys.ToList();
}
foreach (var item in updatedData)
{
dbOffLinecontext.Surveys.Attach(item);
dbOffLinecontext.Entry(item).State = EntityState.Modified;
}
var i = dbOffLinecontext.SaveChanges();
}
}
public void Genericcrudetest()
{
using (var dbcontext = new AdbContext())
{
var gr = new GenericRepository <Rule>(dbcontext);
var m = new Rule();
m.RuleId = 10;
m.Description = "test";
m.Name = "what";
gr.Insert(m);
gr.Save();
var d = gr.Get(s => s.Name == "what");
foreach (var item in d)
{
gr.Delete(item);
}
gr.Save();
Assert.AreEqual(1, 1);
}
}
