private static void Write_DB() { Main_Form.Notify("Update and saving values in database"); int j; for (j = 1; j <= Main_Form.Male_List.Count; j++) { Sheet_Stat.Cells[j, 1] = '\'' + Main_Form.Male_List[j - 1].Name; Sheet_Stat.Cells[j, 2] = '\'' + Main_Form.Male_List[j - 1].Atalaya; Sheet_Stat.Cells[j, 3] = '\'' + Main_Form.Male_List[j - 1].Capitan; Sheet_Stat.Cells[j, 4] = '\'' + Main_Form.Male_List[j - 1].Acomodador; Sheet_Stat.Cells[j, 5] = '\'' + Main_Form.Male_List[j - 1].Lector; Sheet_Stat.Cells[j, 6] = '\'' + Main_Form.Male_List[j - 1].Pres_RP; Sheet_Stat.Cells[j, 7] = '\'' + Main_Form.Male_List[j - 1].Oracion; Sheet_Stat.Cells[j, 8] = Main_Form.Male_List[j - 1].Male_Type; } while (cellValue_stat[j, 1] != null) { Sheet_Stat.Cells[j, 1] = ""; Sheet_Stat.Cells[j, 2] = ""; Sheet_Stat.Cells[j, 3] = ""; Sheet_Stat.Cells[j, 4] = ""; Sheet_Stat.Cells[j, 5] = ""; Sheet_Stat.Cells[j, 6] = ""; Sheet_Stat.Cells[j, 7] = ""; Sheet_Stat.Cells[j, 8] = ""; j++; } DBBooks.Save(); Main_Form.Notify("Saved DB with new values"); }
public static void Persistence_Hub(Persistence_Request request) { attending_persistance = true; string req = ""; if (request.persistence_insight != null) { req = "Week: " + request.persistence_insight.Num_of_Week; Main_Form.Notify("Persistence Request for " + req); Persistence_Worker(request.persistence_insight); Main_Form.Pending_refresh_status_grids = true; } if (request.autofill) { Main_Form.Notify("Executing Autofill handler"); if (request.autofill_all) { Main_Form.Notify("Autofill for all weeks"); for (int i = 1; i <= Main_Form.number_of_weeks; i++) { Autofill_Handler(i); } } else { Main_Form.Notify("Autofill for week [" + Main_Form.current_week.ToString() + "]"); Autofill_Handler(Main_Form.current_week); } Main_Form.Pending_Week_Handler_Refresh = true; } attending_persistance = false; }
public static void Get_Songs_From_Watchtower() { try { bool song_2_found = false; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(hyperlink_WT); using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { string raw;// = reader.ReadToEnd(); //Test --Do Not Delete Comment!-- Main_Form.Notify("Connection ready for Watchtower"); while ((raw = reader.ReadLine()) != null) { if (raw.Contains(">CANCIÓN")) { if (!song_2_found) { insight_Sem_Local.Cancion_RP_2 = Find_Song_Name(Analyze_string(raw)); song_2_found = true; } else { insight_Sem_Local.Cancion_RP_3 = Find_Song_Name(Analyze_string(raw)) + " y oración final"; break; } } } Main_Form.Notify("Songs from Watchtower retrieved."); } } catch { } }
public static void Create_Overwatch_Objs() { Main_Form.Notify("Create Overwatch Objects"); Semana1.Name = "Semana 1"; Semana1.Percentaje = "0%"; Semana1.Special_VyM_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana1.Special_RP_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana2.Name = "Semana 2"; Semana2.Percentaje = "0%"; Semana2.Special_VyM_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana2.Special_RP_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana3.Name = "Semana 3"; Semana3.Percentaje = "0%"; Semana3.Special_VyM_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana3.Special_RP_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana4.Name = "Semana 4"; Semana4.Percentaje = "0%"; Semana4.Special_VyM_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana4.Special_RP_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana5.Name = "Semana 5"; Semana5.Percentaje = "0%"; Semana5.Special_VyM_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Semana5.Special_RP_Meeting_Type = Main_Form.Special_Meeting_Type.Non_status; Main_Form.Overwatch_Information_List.Add(Semana1); Main_Form.Overwatch_Information_List.Add(Semana2); Main_Form.Overwatch_Information_List.Add(Semana3); Main_Form.Overwatch_Information_List.Add(Semana4); if (Main_Form.week_five_exist) { Total_Num_weeks = 5; Main_Form.Overwatch_Information_List.Add(Semana5); } Main_Form.Pending_Overwatch_Refresh = true; }
private static void Read_DB() { /*Read Status males*/ Main_Form.Notify("Retrieve values from Status database"); Main_Form.Elders_Count = 0; Main_Form.Ministerials_Count = 0; Main_Form.Generals_Count = 0; Main_Form.Males_Count = 0; for (int i = 1; i < 100; i++) { if (cellValue_stat[i, 1] == null) { break; } else { Males aux_male = new Males { Name = cellValue_stat[i, 1].ToString(), Atalaya = cellValue_stat[i, 2].ToString(), Capitan = cellValue_stat[i, 3].ToString(), Acomodador = cellValue_stat[i, 4].ToString(), Lector = cellValue_stat[i, 5].ToString(), Pres_RP = cellValue_stat[i, 6].ToString(), Oracion = cellValue_stat[i, 7].ToString(), Male_Type = (Main_Form.Male_Type)Convert.ToInt16(cellValue_stat[i, 8].ToString()), }; switch (aux_male.Male_Type) { case Main_Form.Male_Type.Anciano: { Main_Form.Elders_Count++; break; } case Main_Form.Male_Type.Ministerial: { Main_Form.Ministerials_Count++; break; } case Main_Form.Male_Type.Publicador: { Main_Form.Generals_Count++; break; } } Main_Form.Male_List.Add(aux_male); } } Main_Form.Male_List_filled = true; Males_Rules_Handler(); Main_Form.Pending_refresh_status_grids = true; Main_Form.Males_Count = Main_Form.Elders_Count + Main_Form.Ministerials_Count + Main_Form.Generals_Count; Main_Form.Notify("Read Successfull:\nElders: " + Main_Form.Elders_Count.ToString() + "\nMinisterials: " + Main_Form.Ministerials_Count.ToString() + "\nGeneral Males: " + Main_Form.Generals_Count.ToString() + "\nMales Count: " + Main_Form.Males_Count); }
public static void Open_DB() { db_open = true; Main_Form.Notify("Opening Database file"); DBApp = new Excel.Application(); DBBooks = DBApp.Workbooks.Open(Main_Form.Path_DB, 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", true, false, 0, true, 1, 0); DBSheets = DBBooks.Worksheets; Sheet_Stat = (Excel.Worksheet)DBSheets.get_Item(1); range_stat = Sheet_Stat.get_Range("A1", "I137"); cellValue_stat = range_stat.get_Value(); }
/*-------------------- Attending request -------------------- */ private static void Access_Heaven() { Hw_inProgress = true; int max_sem = 4; if (Main_Form.week_five_exist) { max_sem = 5; } for (current_week = 1; current_week <= max_sem; current_week++) { Copy_Main_Week(); if (!insight_Sem_Local.HW_Data) { string fecha = Main_Form.meetings_days[current_week - 1, 0].ToString("yyyy/MM/dd"); string url = "https://wol.jw.org/es/wol/dt/r4/lp-s/" + fecha; month = Main_Form.meetings_days[current_week - 1, 0].ToString("MMMM"); Main_Form.Notify("Gather information from heavensward for " + month); try { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { string raw;// = reader.ReadToEnd(); //Test --Do Not Delete Comment!-- CleanUp(); //Main_Form.Notify("Connection Successfull. Reading info"); while ((raw = reader.ReadLine()) != null) { if (break_reader) { break; } String_Handler(raw); } Main_Form.Notify("Information successfully recieved from wol.jw.org for " + fecha); } } catch { Main_Form.Warn("Unable to connect to wol.jw.org at " + fecha + "\n"); } } } Return_Values_From_Heavensward(); Overwatch.OW_Request = true; Main_Form.Heavensward_request_complete = true; Main_Form.Notify("Heavensward Request Complete"); Hw_inProgress = false; Request_Heavensward = false; }
private static void Initial_Database_check() { if (File.Exists(Main_Form.Path_DB)) { Main_Form.Notify("Initial Check: Database file exist"); DB_Allowed = true; } else { Main_Form.Warn("Initial Check: Database file missing"); Main_Form.Warn("Disabling Persistence features"); DB_Allowed = false; } }
private static void Return_Values_From_Heavensward() { Main_Form.Notify("Storing info from Heavensward into Main"); Main_Form.Insight_month.Semana1.Save_Heavensward_Info(insight_Month_Local.Semana1); Main_Form.Insight_month.Semana2.Save_Heavensward_Info(insight_Month_Local.Semana2); Main_Form.Insight_month.Semana3.Save_Heavensward_Info(insight_Month_Local.Semana3); Main_Form.Insight_month.Semana4.Save_Heavensward_Info(insight_Month_Local.Semana4); if (Main_Form.week_five_exist) { Main_Form.Insight_month.Semana5.Save_Heavensward_Info(insight_Month_Local.Semana5); } }
private static void Initial_Heavensward_Check() { try { /*ToDo * Change Initialization * Get Random ID * Write in Firebase * Give 5 tries to read and compare that value * */ using (var client = new WebClient()) using (client.OpenRead("http://clients3.google.com/generate_204")) { Main_Form.Notify("Initial Check: Internet Connection: Granted!"); } } catch { Main_Form.Warn("Initial Check: Internet Connection: Denied!"); } }
public static void Overwatch_Thread_Handler() { while (true) { if (OW_Request && !Attending_OW_Request && Objects_Created) { OW_Request = false; Attending_OW_Request = true; Overwatch_Control(); } if (!Initial_Check) { Initial_Check = true; Main_Form.Notify("Initial Check: Overwatch reporting"); } if (!Objects_Created && Main_Form.UI_running) { Create_Overwatch_Objs(); Objects_Created = true; } Thread.Sleep(2000); } }
/*----------------------------------- Celestial Aeon Project -----------------------------------*/ private static void Heavensward_Oracle_Handler(HW_Oracle_Request request) { Hw_oracle_inProgress = true; string asignee = Properties.Settings.Default.Heavensward_User; bool asignee_found = false; string asig = ""; string date = ""; if (request.hw_oracle_vym != null) { List <string> VyM_Asignee = request.hw_oracle_vym.Get_Asignee_List(); if (VyM_Asignee[0] != null) { for (int i = 0; i < VyM_Asignee.Count; i++) { if (VyM_Asignee[i].Contains(asignee)) { Main_Form.Notify("Noel Belin Found in " + Assignment_VyM_List[i] + ", date " + request.hw_oracle_vym.Fecha.ToString("dddd, dd MMMM, yyyy")); asig = Assignment_VyM_List[i]; date = request.hw_oracle_vym.Fecha.ToString("dddd, dd MMMM");; asignee_found = true; } } } } else if (request.hw_oracle_rp != null) { List <string> RP_Asignee = request.hw_oracle_rp.Get_Asignee_List(); if (RP_Asignee[0] != null) { for (int i = 0; i < RP_Asignee.Count; i++) { if (RP_Asignee[i].Contains(asignee)) { Main_Form.Notify("Noel Belin Found in " + Assignment_RP_List[i] + ", date " + request.hw_oracle_rp.Fecha.ToString("dddd, dd MMMM, yyyy")); asig = Assignment_RP_List[i]; date = request.hw_oracle_rp.Fecha.ToString("dddd, dd MMMM"); asignee_found = true; } } } } else if (request.hw_oracle_ac != null) { List <string> AC_Asignee = request.hw_oracle_ac.Get_Asignee_List(); if (AC_Asignee[0] != null) { for (int i = 0; i < AC_Asignee.Count; i++) { if (AC_Asignee[i].Contains(asignee)) { string fecha; if (i < 3) { fecha = request.hw_oracle_ac.Fecha_VyM.ToString("dddd, dd MMMM, yyyy"); } else { fecha = request.hw_oracle_ac.Fecha_RP.ToString("dddd, dd MMMM, yyyy"); } Main_Form.Notify("Noel Belin Found in " + Assignment_AC_List[i] + ", date " + fecha); asig = Assignment_AC_List[i]; date = fecha; asignee_found = true; } } } } if (asignee_found) { date = date.Replace(" ", "+"); try { Main_Form.Notify("Accesing to Heavensward Oracle Network"); string url_local = "https://us-central1-agr-connected-services.cloudfunctions.net/Heavensward_Oracle"; string modifier1 = "?rw=write"; string modifier2 = "&asig=" + asig; string modifier3 = "&date=" + date; HttpWebRequest Oracle_Request = (HttpWebRequest)WebRequest.Create(url_local + modifier1 + modifier2 + modifier3); using (HttpWebResponse response = (HttpWebResponse)Oracle_Request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { string raw = reader.ReadToEnd(); Main_Form.Notify(raw); } } catch { Main_Form.Warn("Connection: Denied!"); } } HW_Oracle_Requests_List.RemoveAt(0); Hw_oracle_inProgress = false; }