public string DeleteUserTasks(string json) { log4net.ILog log = log4net.LogManager.GetLogger(typeof(Soap)); new ConfigHelper().Load(); try { if (string.IsNullOrEmpty(json)) { return(string.Empty); } AdminObject deleteObject = JsonHelper.OnlyJsonToObject <AdminObject>(json); if (deleteObject == null) { return(string.Empty); } string userId = deleteObject.UserId; string password = deleteObject.Password; if (ServicesConstants.DELETE_PASSWORD.Equals(password) == false || string.IsNullOrEmpty(userId)) { return(string.Empty); } GenericDbHelper.RunDirectSql(string.Format("DELETE FROM TASK WHERE USER_ID = '{0}'", userId)); return("OK"); } catch (Exception e) { log.Error(e); return(e.ToString()); } }
private void SaveTasksToDb(List <TaskSync> taskFromDb, List <TaskSync> mergedTasks, DateTime lastSyncDate) { string userId = string.Empty; if (mergedTasks.Count != 0) { userId = mergedTasks[0].UserId; } foreach (TaskSync task in mergedTasks) { string deleteQuery = string.Format("DELETE FROM TASK WHERE SOURCE_ID = '{0}' AND USER_ID = '{1}'", task.SourceId, userId); GenericDbHelper.RunDirectSql(deleteQuery); } foreach (TaskSync task in mergedTasks) { GenericDbHelper.Save(task); } GenericDbHelper.Flush(); }
public static void DeleteAll() { GenericDbHelper.RunDirectSql("DELETE FROM DB_VERSION"); }
public static void DeleteAll() { GenericDbHelper.RunDirectSql("DELETE FROM TASK"); }
public void Version4() { GenericDbHelper.RunDirectSql("UPDATE TASK set LAST_MODIFY_DATE_STRING = LAST_MODIFY_DATE, DATE_REMAINDER_STRING = DATE_REMAINDER"); }
public void Version3() { GenericDbHelper.RunDirectSql("ALTER TABLE TASK ADD LAST_MODIFY_DATE_STRING TEXT"); GenericDbHelper.RunDirectSql("ALTER TABLE TASK ADD DATE_REMAINDER_STRING TEXT"); }
public void Version2() { GenericDbHelper.RunDirectSql("ALTER TABLE TASK ADD LAST_MODIFY_DATE TEXT"); GenericDbHelper.RunDirectSql("ALTER TABLE TASK ADD IS_DELETED TEXT"); }
public void Version() { GenericDbHelper.RunDirectSql("CREATE TABLE DB_VERSION (ID INTEGER PRIMARY KEY, VERSION_NR INTEGER NOT NULL, " + "DATE_VERSION TEXT, COMMENT TEXT)"); }
public void Version() { GenericDbHelper.RunDirectSql("CREATE TABLE TROL_TEST (ID INTEGER PRIMARY KEY, VERSION_NR INTEGER NOT NULL, " + "COMMENT VARCHAR(255))"); GenericDbHelper.RunDirectSql("INSERT INTO TROL_TEST (VERSION_NR, COMMENT) VALUES (5, \"Komentaras\")"); }
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); } }