public override bool SyncStart()
{
try
{
var obj = SAPBaseService.GetSAPData(_tableName, _objectFieldSet, _options);
using (var db = new SAPDbContext())
{
if (obj.Count > 0)
{
var dbset = db.Set <T>();
var exsitingInDb = dbset.ToList();
dbset.RemoveRange(exsitingInDb);
dbset.AddRange(obj);
db.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
ExceptionHandling.LogException(ex);
return(false);
}
}
public SAPDbContext Get()
{
return(_database ?? (_database = new SAPDbContextFactory().Create()));
}
public override bool SyncStart()
{
try
{
List <List <T> > tableSet = new List <List <T> >(_objectFieldSet.Count());
foreach (var fieldset in _objectFieldSet)
{
tableSet.Add(new List <T>());
}
int index = 0;
foreach (var fieldset in _objectFieldSet)
{
var obj = SAPBaseService.GetSAPData(_tableName, fieldset.Item1, _options);
var tmp = obj.ToList();
foreach (var orderby in _primaryKeys)
{
tmp = tmp.OrderBy(orderby).ToList();
}
tableSet[index] = tmp;
index++;
}
//update
int count = tableSet.First().Count;
if (tableSet.TrueForAll(x => x.Count == count))
{
//exactly equal
int originalIndex = _objectFieldSet.Select((value, i) => new { value, index = i + 1 })
.Where(pair => pair.value.Item2 == null)
.Select(pair => pair.index)
.FirstOrDefault() - 1;
for (int i = 0; i < count; i++)
{
var origin = tableSet[originalIndex][i];
for (int j = 0; j < _objectFieldSet.Count(); j++)
{
if (j == originalIndex)
{
continue;
}
var updateFunc = _objectFieldSet[j].Item2; //origin,update
updateFunc(origin, tableSet[j][i]);
}
}
//database
using (var db = new SAPDbContext())
{
var obj = tableSet[originalIndex];
if (obj.Count > 0)
{
var dbset = db.Set <T>();
var exsitingInDb = dbset.ToList();
dbset.RemoveRange(exsitingInDb);
dbset.AddRange(obj);
db.SaveChanges();
}
}
return(true);
}
else
{
return(false);
}
return(true);
}
catch (Exception ex)
{
ExceptionHandling.LogException(ex);
return(false);
}
}