public List <Worker_Dto> WorkerLoadAllFromRemote() { log.LogEverything("Not Specified", t.GetMethodName() + " called"); var parsedData = JRaw.Parse(http.WorkerLoadAllFromRemote()); List <Worker_Dto> lst = new List <Worker_Dto>(); foreach (JToken item in parsedData) { string firstName = item["first_name"].ToString(); string lastName = item["last_name"].ToString(); string email = item["email"].ToString(); int microtingUid = int.Parse(item["id"].ToString()); DateTime? createdAt = DateTime.Parse(item["created_at"].ToString()); DateTime? updatedAt = DateTime.Parse(item["updated_at"].ToString()); Worker_Dto temp = new Worker_Dto(microtingUid, firstName, lastName, email, createdAt, updatedAt); lst.Add(temp); } return(lst); }
//public string RetractEforms() //{ // string reply = ""; // Communicator communicator = new Communicator(sqlController, log); // if (communicator == null) // return "Failed to create a communicator. Action canceled. Database maybe not configured correct"; // List<string> lstCaseMUIds = sqlController.UnitTest_FindAllActiveCases(); // foreach (string mUId in lstCaseMUIds) // { // try // { // var aCase = sqlController.CaseReadByMUId(mUId); // if (aCase != null) // { // communicator.Delete(mUId, aCase.SiteUId); // try // { // sqlController.CaseDelete(mUId); // } // catch // { // sqlController.CaseDeleteReversed(mUId); // } // } // } // catch (Exception ex) // { // reply += "EformDelete :'" + mUId + "' failed, due to:" + ex.Message + Environment.NewLine; // } // } // return reply.Trim(); //} //public string RetractEntities() //{ // string reply = ""; // Communicator communicator = new Communicator(sqlController, log); // if (communicator == null) // return "Failed to create a communicator. Action canceled. Database maybe not configured correct"; // List<string> lstEntityMUIds = sqlController.UnitTest_EntitiesFindAllActive(); // foreach (string mUId in lstEntityMUIds) // { // try // { // string type = sqlController.EntityGroupDelete(mUId); // if (type != null) // communicator.EntityGroupDelete(type, mUId); // } // catch (Exception ex) // { // reply += "EntityDelete :'" + mUId + "' failed, due to:" + ex.Message + Environment.NewLine; // } // } // return reply.Trim(); //} //public string DbClearData() //{ // try // { // RetractEforms(); // sqlController.UnitTest_TruncateTable(typeof(cases).Name); // sqlController.UnitTest_TruncateTable(typeof(case_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(check_list_sites).Name); // sqlController.UnitTest_TruncateTable(typeof(check_list_site_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(check_list_values).Name); // sqlController.UnitTest_TruncateTable(typeof(check_list_value_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(field_values).Name); // sqlController.UnitTest_TruncateTable(typeof(field_value_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(uploaded_data).Name); // sqlController.UnitTest_TruncateTable(typeof(uploaded_data_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(a_interaction_case_list_versions).Name); // sqlController.UnitTest_TruncateTable(typeof(a_interaction_case_lists).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(a_interaction_case_versions).Name); // sqlController.UnitTest_TruncateTable(typeof(a_interaction_cases).Name); // //--- // //--- // sqlController.UnitTest_TruncateTable(typeof(notifications).Name); // return ""; // } // catch (Exception ex) // { // return t.PrintException(t.GetMethodName() + " failed", ex); // } //} //public string DbClearTemplat() //{ // try // { // RetractEntities(); // sqlController.UnitTest_TruncateTable(typeof(entity_groups).Name); // sqlController.UnitTest_TruncateTable(typeof(entity_group_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(entity_items).Name); // sqlController.UnitTest_TruncateTable(typeof(entity_item_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(fields).Name); // sqlController.UnitTest_TruncateTable(typeof(field_versions).Name); // //--- // sqlController.UnitTest_TruncateTable(typeof(check_lists).Name); // sqlController.UnitTest_TruncateTable(typeof(check_list_versions).Name); // return ""; // } // catch (Exception ex) // { // return t.PrintException(t.GetMethodName() + " failed", ex); // } //} //public string DbClear() //{ // string reply = ""; // Communicator communicator = new Communicator(sqlController, log); // if (communicator == null) // return "Failed to create a communicator. Action canceled. Database maybe not configured correct"; // reply += RetractEforms() + Environment.NewLine; // reply += RetractEntities() + Environment.NewLine; // reply += DbClearData() + Environment.NewLine; // reply += DbClearTemplat() + Environment.NewLine; // return reply.TrimEnd(); //} public string DbSetup(string token) { try { sqlController = new SqlController(connectionString); if (token == null) { token = sqlController.SettingRead(Settings.token); } //if (token.ToLower() == "unittest") // return DbSetupUnitTest(); sqlController.SettingUpdate(Settings.token, token); // configure db DbSettingsReloadRemote(); //sqlController.UnitTest_TruncateTablesIfEmpty(); Communicator communicator = new Communicator(sqlController, log); #region add site's data to db if (!bool.Parse(sqlController.SettingRead(Settings.knownSitesDone))) { //sqlController.UnitTest_TruncateTable(typeof(sites).Name); foreach (var item in communicator.SiteLoadAllFromRemote()) { SiteName_Dto siteDto = sqlController.SiteRead(item.SiteUId); if (siteDto == null) { sqlController.SiteCreate(item.SiteUId, item.SiteName); } } //sqlController.UnitTest_TruncateTable(typeof(workers).Name); foreach (var item in communicator.WorkerLoadAllFromRemote()) { Worker_Dto workerDto = sqlController.WorkerRead(item.WorkerUId); if (workerDto == null) { sqlController.WorkerCreate(item.WorkerUId, item.FirstName, item.LastName, item.Email); } } //sqlController.UnitTest_TruncateTable(typeof(site_workers).Name); foreach (var item in communicator.SiteWorkerLoadAllFromRemote()) { Site_Worker_Dto siteWorkerDto = sqlController.SiteWorkerRead(item.MicrotingUId, null, null); if (siteWorkerDto == null) { try { sqlController.SiteWorkerCreate(item.MicrotingUId, item.SiteUId, item.WorkerUId); } catch { // We do catch this because right now we a descripency at the API side. } } } int customerNo = communicator.OrganizationLoadAllFromRemote(token).CustomerNo; //sqlController.UnitTest_TruncateTable(typeof(units).Name); foreach (var item in communicator.UnitLoadAllFromRemote(customerNo)) { Unit_Dto unitDto = sqlController.UnitRead(item.UnitUId); if (unitDto == null) { try { sqlController.UnitCreate(item.UnitUId, item.CustomerNo, item.OtpCode, item.SiteUId); } catch { // We do catch this because right now we a descripency at the API side. } } } sqlController.SettingUpdate(Settings.knownSitesDone, "true"); } #endregion sqlController.SettingUpdate(Settings.firstRunDone, "true"); return(""); } catch (Exception ex) { return(t.PrintException(t.GetMethodName() + " failed", ex)); } }
public string DbSetup(string token) { try { sqlController = new SqlController(connectionString); if (token == null) { token = sqlController.SettingRead(Settings.token); } sqlController.SettingUpdate(Settings.token, token); // configure db DbSettingsReloadRemote(); string comAddressApi = sqlController.SettingRead(Settings.comAddressApi); string comAddressBasic = sqlController.SettingRead(Settings.comAddressBasic); string comOrganizationId = sqlController.SettingRead(Settings.comOrganizationId); string ComAddressPdfUpload = sqlController.SettingRead(Settings.comAddressPdfUpload); string ComSpeechToText = sqlController.SettingRead(Settings.comSpeechToText); Communicator communicator = new Communicator(token, comAddressApi, comAddressBasic, comOrganizationId, ComAddressPdfUpload, log, ComSpeechToText); #region add site's data to db if (!bool.Parse(sqlController.SettingRead(Settings.knownSitesDone))) { foreach (var item in communicator.SiteLoadAllFromRemote()) { SiteName_Dto siteDto = sqlController.SiteRead(item.SiteUId); if (siteDto == null) { sqlController.SiteCreate(item.SiteUId, item.SiteName); } } foreach (var item in communicator.WorkerLoadAllFromRemote()) { Worker_Dto workerDto = sqlController.WorkerRead(item.WorkerUId); if (workerDto == null) { sqlController.WorkerCreate(item.WorkerUId, item.FirstName, item.LastName, item.Email); } } foreach (var item in communicator.SiteWorkerLoadAllFromRemote()) { Site_Worker_Dto siteWorkerDto = sqlController.SiteWorkerRead(item.MicrotingUId, null, null); if (siteWorkerDto == null) { try { sqlController.SiteWorkerCreate(item.MicrotingUId, item.SiteUId, item.WorkerUId); } catch { // We do catch this because right now we a descripency at the API side. } } } int customerNo = communicator.OrganizationLoadAllFromRemote(token).CustomerNo; foreach (var item in communicator.UnitLoadAllFromRemote(customerNo)) { Unit_Dto unitDto = sqlController.UnitRead(item.UnitUId); if (unitDto == null) { try { sqlController.UnitCreate(item.UnitUId, item.CustomerNo, item.OtpCode, item.SiteUId); } catch { // We do catch this because right now we a descripency at the API side. } } } sqlController.SettingUpdate(Settings.knownSitesDone, "true"); } #endregion sqlController.SettingUpdate(Settings.firstRunDone, "true"); return(""); } catch (Exception ex) { return(t.PrintException(t.GetMethodName("AdminTools") + " failed", ex)); } }