public static Info FindByUniqueCode(string uniqueCode)
{
if (string.IsNullOrEmpty(uniqueCode))
{
return(null);
}
Info result = null;
if (m_infosCache.TryGetValue(uniqueCode, out result))
{
return(result);
}
List <Info> allInfos = GenericDbHelper.Get <Info>();
foreach (Info info in allInfos)
{
if (info.UniqueCode.Equals(uniqueCode))
{
result = info;
break;
}
}
if (result != null)
{
m_infosCache.Add(uniqueCode, result);
}
return(result);
}
private List <TaskSync> LoadAllTasksByUserId(string userId, DateTime lastSyncDate)
{
List <TaskSync> result = new List <TaskSync>();
if (string.IsNullOrEmpty(userId))
{
return(result);
}
result = GenericDbHelper.Get <TaskSync>(string.Format("LAST_MODIFY_DATE >= '{0}' and USER_ID = '{1}'",
lastSyncDate.ToString("yyyy.MM.dd hh:mm:ss"), userId));
return(result);
}
public string GetUserTasks(string json)
{
log4net.ILog log = log4net.LogManager.GetLogger(typeof(Soap));
new ConfigHelper().Load();
try
{
if (string.IsNullOrEmpty(json))
{
return(string.Empty);
}
AdminObject adminObject = JsonHelper.OnlyJsonToObject <AdminObject>(json);
if (adminObject == null)
{
return(string.Empty);
}
string userId = adminObject.UserId;
string password = adminObject.Password;
if (ServicesConstants.DELETE_PASSWORD.Equals(password) == false ||
string.IsNullOrEmpty(userId))
{
return(string.Empty);
}
List <TaskSync> tasks = GenericDbHelper.Get <TaskSync>(string.Format("USER_ID = '{0}'", userId));
SyncObject result = new SyncObject();
result.Tasks = tasks;
return(JsonHelper.ConvertToJson <SyncObject>(result));
}
catch (Exception e)
{
log.Error(e);
return(e.ToString());
}
}
public void Sync()
{
if (string.IsNullOrEmpty(Static.StaticData.Settings.Sync.Id))
{
return;
}
try
{
DateTime startSync = DateTime.Now;
DateTime lastSyncDate = Minder.Static.StaticData.Settings.Sync.LastSyncDate;
string dateSync = DBTypesConverter.ToFullDateStringByCultureInfo(lastSyncDate);
// new ErrorBox(dateSync);
List <Task> allTasks = GenericDbHelper.Get <Task>(string.Format("LAST_MODIFY_DATE >= '{0}'", dateSync));
SyncObject syncObject = new SyncObject();
syncObject.UserId = Static.StaticData.Settings.Sync.Id;
syncObject.Tasks = new List <Task>();
syncObject.LastSyncDate = lastSyncDate.ToUniversalTime();
foreach (Task task in allTasks)
{
task.UserId = Static.StaticData.Settings.Sync.Id;
syncObject.Tasks.Add(task);
// task.LastModifyDate = task.LastModifyDate.ToUniversalTime();
// task.DateRemainder = task.DateRemainder.ToUniversalTime();
}
//Paruošti taskai siuntimui
List <Task> tasksFromServer = GetSyncedTasksFromServer(syncObject);
SetLocalDate(allTasks.ToArray());
m_newTasks = tasksFromServer.Count;
m_log.DebugFormat("Tasks' count retrieved from server {0}", m_newTasks);
// using(IConnection con = new ConnectionCollector().GetConnection())
// {
foreach (Task task in tasksFromServer)
{
task.LastModifyDate = task.LastModifyDate.ToLocalTime();
task.DateRemainder = task.DateRemainder.ToLocalTime();
foreach (Task localTask in allTasks)
{
if (localTask.Equals(task))
{
m_newTasks--;
}
}
if (ExistTask(task))
{
//Negalime updatinti pagal ID, nes serveryje kitoks id.
GenericDbHelper.RunDirectSql(string.Format("DELETE FROM TASK WHERE SOURCE_ID = '{0}'", task.SourceId));
GenericDbHelper.Save(task);
m_log.DebugFormat("Updated existing task {0}", task);
}
else
{
GenericDbHelper.Save(task);
m_log.DebugFormat("Created new task {0}", task);
}
}
GenericDbHelper.Flush();
// }
if (m_newTasks > 0)
{
if (Synced != null)
{
Synced();
}
}
Minder.Static.StaticData.Settings.Sync.LastSyncDate = DateTime.Now;
TimeSpan span = DateTime.Now - startSync;
m_log.InfoFormat("Synced in {0} seconds", span.TotalSeconds);
}
catch (Exception e)
{
m_log.Error(e);
}
}
