public async Task <int> SaveScreenShotToSql(ScreenShot screenShot) { int result = 0; if (screenShot == null) { return(result); } try { if (sqliteService == null) { sqliteService = new SQLiteService <ScreenShotSQL>(sqlitePlatform, await fileSystemService.GetPath(configuration.SqlDatabaseName)); } } catch (Exception exp) { sqliteService = null; } if (sqliteService != null) { try { result = await sqliteService.Insert(converter.ConvertToScreenShotSQL(screenShot)); } catch (Exception ex) { throw ex; } } return(await TaskHelper.Complete(result)); }
public async void TestSQLiteService(){ SQLiteService sqliteService = new SQLiteService (new SQLitePlatformWin32(), await GetPath("VTSTest")); VacationInfoDTO person = new VacationInfoDTO { Date="", ImageSRC="test", Id=12, Status="qwe", VacationType = "asd" }; await sqliteService.Insert<VacationInfoDTO> (person); var personTest =await sqliteService.Get<VacationInfoDTO>(person.Id.ToString()); Assert.AreNotEqual (person, personTest,"Message Insert or Get error"); person.ImageSRC="https://ru.wikipedia.org/wiki"; await sqliteService.Update<VacationInfoDTO> (person); personTest =await sqliteService.Get<VacationInfoDTO>(person.Id.ToString()); Assert.IsTrue(person.ImageSRC == personTest.ImageSRC,"Message Update or Get error"); await sqliteService.Delete<VacationInfoDTO>(person.Id.ToString()); personTest =await sqliteService.Get<VacationInfoDTO>(person.Id.ToString()); Assert.IsNull (personTest,"Message Delete error"); }
public async Task <int> SavePowerTimeToSql(PowerPC powerpc) { int result = 0; if (powerpc == null) { return(result); } try { if (sqliteService == null) { sqliteService = new SQLiteService <PowerPCSQL>(sqlitePlatform, await fileSystemService.GetPath(configuration.SqlDatabaseName)); } } catch (Exception exp) { result = -1; sqliteService = null; } if (sqliteService != null) { try { //only for new guid insert new records, for old GUID only update timeOff List <PowerPCSQL> oldpowerpc = await sqliteService.GetWhere <PowerPCSQL>(x => x.GUID.Equals(powerpc.GUID) && x.IsActive); if (oldpowerpc != null && oldpowerpc.Count != 0) { foreach (var ppc in oldpowerpc) { ppc.dateTimeOffPC = ConverterHelper.ConvertDateTimeToMillisec(powerpc.dateTimeOffPC).ToString(); ppc.IsSynchronized = false; result = await sqliteService.Update(ppc); } } else { result = await sqliteService.Insert(converter.ConvertToPowerPCSQL(powerpc)); } } catch (Exception ex) { result = -1; var err = ex.Message; throw ex; } } return(result); }
/// <summary> /// json转sql /// </summary> /// <param name="f"></param> /// <param name="json"></param> static private void Json2Sqlite(string f, string json) { // var table = Path.GetFileName(f).Replace(Path.GetExtension(f), ""); var classname = "Game.Data." + table; var jsonObj = JsonMapper.ToObject(json); var assPath = IPath.Combine(BApplication.ProjectRoot, "Library/ScriptAssemblies/Assembly-CSharp.dll"); var ass = Assembly.LoadFile(assPath); // var t = ass.GetType(classname); // EditorUtility.DisplayProgressBar("Excel2Sqlite", string.Format("生成:{0} 记录条目:{1}", classname, jsonObj.Count), 0); if (t == null) { Debug.LogError(classname + "类不存在,请检查!"); return; } else { Debug.Log("导出:" + classname); } //数据库创建表 //sql.DB.Delete<>() sql.CreateDB(t); EditorUtility.ClearProgressBar(); // for (int i = 0; i < jsonObj.Count; i++) { var j = jsonObj[i]; var jo = JsonMapper.ToObject(t, j.ToJson()); try { sql.Insert(jo); } catch { Debug.LogError("导出数据有错,跳过! 错误位置:" + classname + ":" + i + "-" + jsonObj.Count); } } EditorUtility.DisplayProgressBar("Excel2Sqlite", string.Format("生成:{0} 记录条目:{1}", classname, jsonObj.Count), 1); }
public async Task<List<VTSModel>> GetVTSList () { ModelConverter converter = new ModelConverter (); List<VacationInfoModel> listVacationInfoModel; try { RestService restService = new RestService ("/api/Vacations", Server); listVacationInfoModel = await restService.Get<VacationInfoModel> (); } catch (AggregateException e) { //ErrorMessage = e.InnerExceptions [0].Data ["message"].ToString (); listVacationInfoModel = null; } SQLiteService sqliteService; try { sqliteService = new SQLiteService (_sqlitePlatform, await _fileSystem.GetPath ("VTS")); } catch { sqliteService = null; } List<VTSModel> VTSViewModelList = new List<VTSModel> (); VTSModel newItem; listVacationInfoModel = new VacationInfoMockModel ().Vacations; if (listVacationInfoModel != null) { foreach (VacationInfoModel info in listVacationInfoModel) { newItem = converter.ConvertToVTSModel (info); VTSViewModelList.Add (newItem); if (sqliteService != null) { await sqliteService.Insert<VacationInfoDTO> (converter.ConvertToVacationInfoDTO (newItem)); } } } else if(sqliteService != null) { List<VacationInfoDTO> vacationInfoList = await sqliteService.Get<VacationInfoDTO> (); if (vacationInfoList != null) { foreach (VacationInfoDTO info in vacationInfoList) { VTSViewModelList.Add (converter.ConvertToVTSModel (info)); } } } return VTSViewModelList; }
/// <summary> /// Save Masters to local SQLite for buffer for slow rest internet connections /// </summary> /// <param name="responce"></param> /// <returns></returns> public async Task SaveMastersToSql(IEnumerable <Master> responce) { if (responce == null) { await ClearMasterPair(); return; } try { if (sqliteService == null) { sqliteService = new SQLiteService <MasterSQL>(sqlitePlatform, await fileSystemService.GetPath(configuration.SqlDatabaseName)); } } catch (Exception exp) { sqliteService = null; } if (sqliteService != null) { try { List <MasterSQL> oldmasters = await sqliteService.Get(); if (oldmasters != null && oldmasters.Count != 0) { foreach (var master in oldmasters) { await sqliteService.Delete(master.Id.ToString()); } } foreach (var master in responce) { await sqliteService.Insert(converter.ConvertToMasterSQL(master)); } } catch (Exception ex) { var err = ex.Message; throw ex; } } }
public async Task UpdateOrCreateCodeAToSql(CodeResponce codeResponce) { if (codeResponce == null) { return; } try { if (sqliteService == null) { sqliteService = new SQLiteService <CodeResponceSQL>(sqlitePlatform, await fileSystemService.GetPath(configuration.SqlDatabaseName)); } } catch (Exception exp) { sqliteService = null; } if (sqliteService != null) { try { CodeResponceSQL currentCodeAResponce = new CodeResponceSQL { Id = 1, Code = codeResponce.Code, Hash = codeResponce.Hash, ResultCode = codeResponce.ResultCode, Date = ConverterHelper.ConvertDateTimeToMillisec(DateTime.Now).ToString() }; var codeResponcesOld = await sqliteService.Get("1"); if (codeResponcesOld != null) { await sqliteService.Update(currentCodeAResponce); } else { await sqliteService.Insert(currentCodeAResponce); } } catch (Exception ex) { var err = ex.Message; throw ex; } } }
public async Task SaveLoginModelToSQLite(string name, string password) { try { if (sqliteService == null) { sqliteService = new SQLiteService(_sqlitePlatform, await _fileSystemService.GetPath(_configuration.SqlDatabaseName)); } } catch (Exception exp) { sqliteService = null; } if (sqliteService != null) { try { LoginInfoDTO currentLoginInfo = new LoginInfoDTO(); currentLoginInfo.UserName = name; currentLoginInfo.Password = SecurytyHash.CalculateSha1Hash(password); List <LoginInfoDTO> listlogins = await sqliteService.Get <LoginInfoDTO>(); if (listlogins != null && listlogins.Count != 0) { foreach (LoginInfoDTO login in listlogins) { if (login.UserName == currentLoginInfo.UserName) { await sqliteService.Delete <LoginInfoDTO>(login.Id.ToString()); } } } await sqliteService.Insert <LoginInfoDTO>(currentLoginInfo); } catch (Exception ex) { } } }
public async Task UpdateOrCreateVacationsSql(VacationInfoModel vacation) { if (vacation == null) { return; } try { if (sqliteService == null) { sqliteService = new SQLiteService(_sqlitePlatform, await _fileSystemService.GetPath(_configuration.SqlDatabaseName)); } } catch (Exception exp) { sqliteService = null; } if (sqliteService != null) { try { var oldvacation = await sqliteService.Get <VacationInfoModelDTO>(vacation.Id.ToString()); if (oldvacation != null) { await sqliteService.Update(_converter.ConvertToVacationInfoModelDTO(vacation)); } else { await sqliteService.Insert(_converter.ConvertToVacationInfoModelDTO(vacation)); } } catch (Exception ex) { throw ex; } } }
public async Task <bool> SavePrefValue(PrefEnums key, string value) { try { if (sqliteService == null) { sqliteService = new SQLiteService <PrefSql>(sqlitePlatform, await fileSystemService.GetPath(configuration.SqlDatabaseName)); } } catch (Exception exp) { sqliteService = null; } if (sqliteService != null) { try { var oldprefSql = await sqliteService.Get(((int)key).ToString()); if (oldprefSql != null) { oldprefSql.Value = value; await sqliteService.Update(oldprefSql); } else { await sqliteService.Insert(new PrefSql { Id = (int)key, Value = value }); } return(true); } catch (Exception ex) { var err = ex.Message; throw ex; } } return(false); }
public async Task SaveVacationsToSql(List <VTSModel> listVTSModel) { try { if (sqliteService == null) { sqliteService = new SQLiteService(_sqlitePlatform, await _fileSystemService.GetPath(_configuration.SqlDatabaseName)); } } catch (Exception exp) { sqliteService = null; } if (sqliteService != null) { try { var vacationInfoList = await sqliteService.Get <VacationInfoDTO>(); if (vacationInfoList != null) { foreach (VacationInfoDTO old in vacationInfoList) { await sqliteService.Delete <VacationInfoDTO>(old.Id.ToString()); } } foreach (VTSModel info in listVTSModel) { await sqliteService.Insert(_converter.ConvertToVacationInfoDTO((info))); } } catch (Exception ex) { throw ex; } } }
public async Task SaveVacationInfo (VTSModel newItem) { ModelConverter converter = new ModelConverter (); SQLiteService sqliteService; try { sqliteService = new SQLiteService (_sqlitePlatform, await _fileSystem.GetPath ("VTS")); } catch { sqliteService = null; } VacationInfoDTO dt = converter.ConvertToVacationInfoDTO (newItem); await sqliteService.Insert<VacationInfoDTO> (dt); RestService restService = new RestService ("/api/Vacations", Server); var req = await restService.Post<VacationInfoModel> (converter.ConvertToVacationInfoModel(newItem)); }