private void ContinueButton_Click(object sender, EventArgs e) { string URL = SiteText.Text; if (URL.Length > 8 && URL.Substring(0, 7) != "http://" && URL.Substring(0, 8) != "https://") { URL = "http://" + URL; } NetworkManager nm = new NetworkManager(UsernameText.Text, PasswordText.Text, URL); string user = ""; try { user = nm.SendGetUsersRequest(1, 0); } catch (UriFormatException ex) { MessageBox.Show("The URL " + SiteText.Text + " is invalid. Change it and try again", "URL Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } catch (WebException ex) { if (ex.Status == WebExceptionStatus.ProtocolError) { var response = ex.Response as HttpWebResponse; if (response != null) { if ((int)response.StatusCode == 401) { MessageBox.Show("Account info was rejected, change the info and try again.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Could not complete request, error was " + (int)response.StatusCode + ".", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Something terrible has happened.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return; } IOfficeHelper.Instance.getAllDatabaseFieldsFromJson(user); var excelSelectForm = new ExcelSelectForm(); excelSelectForm.Location = this.Location; excelSelectForm.Size = this.Size; excelSelectForm.Show(); this.Hide(); }
static void Main(string[] args) { bool windows = true; if (windows) { SiteSelectForm initialScreen = new SiteSelectForm(); //TestForm initialScreen = new TestForm(); Application.EnableVisualStyles(); Application.Run(initialScreen); } else { string file = @"C:\Users\Ryan\Documents\Code\ExcelToIOffice\test.xlsx"; ExcelManager em = ExcelManager.Instance; em.openFile(file); em.SetActiveSheet(1); em.setIgnoreFirstRow(true); ExcelUserModel um = new ExcelUserModel(); um.addField("firstName", "a"); um.addField("lastName", "c"); um.addField("email", "d"); um.addField("username", "g"); JSONBuilder jb = new JSONBuilder(em, um); NetworkManager nm = new NetworkManager("training", "FMsite12", "https://clemson.ricohtrac.com"); /*string json; * * while ((json = jb.getNextUserJson() ) != "NO MORE ROWS"){ * System.Console.WriteLine("Pretending to send this to the network!"); * //nm.SendAddUserRequest("", json); * }*/ /*string userJson = nm.SendGetUserRequest("62570"); * IOfficeUser user = JsonConvert.DeserializeObject<IOfficeUser>(usersJson); * System.Console.WriteLine(user.lastName); * IOfficeUser.UT.field[] fields = user.userType.fields; * foreach(IOfficeUser.UT.field field in fields) * { * System.Console.WriteLine(field.id + ": " + field.name); * }*/ Console.WriteLine("about to start network"); Console.WriteLine("network done, about to get ids into array"); List <int> ids = new List <int>(0); int startAt = 0; int increment = 50; string allUsersJSON = nm.SendGetUsersRequest(increment, startAt); do { IOfficeTools.addIdsFromJSON(ids, allUsersJSON); startAt += increment; allUsersJSON = nm.SendGetUsersRequest(increment, startAt); Console.WriteLine("size is now " + ids.Count()); } while (allUsersJSON != "[]"); Console.WriteLine("ids are in array, lets sort"); ids.Sort(); Console.WriteLine("ids are done sorting, lets print"); foreach (int id in ids) { Console.WriteLine("id: " + id); } Console.Read(); } }