private void checkSSIDPassword() { Excel.Application exApp = Globals.ThisAddIn.Application as Excel.Application; Excel.Workbook wb = exApp.ActiveWorkbook as Excel.Workbook; Channel ch = new Channel(); if (!TokenStore.checkTokenInStore()) { LoginForm frm = new LoginForm(); frm.Show(); } else { ch.setAuthToken(TokenStore.getTokenFromStore()); } if (ch.checkSpreadSheetID(wb) == "0") { string id = ch.getSpreadSheetID(wb.Name.ToString()); spreadSheetID = Convert.ToInt32(id); //write to wb property when a new ID is obtained Microsoft.Office.Core.DocumentProperties properties; properties = (Office.DocumentProperties)wb.CustomDocumentProperties; properties.Add("Excalibur ID", false, Microsoft.Office.Core.MsoDocProperties.msoPropertyTypeString, id); } else { string id = ch.checkSpreadSheetID(wb); spreadSheetID = Convert.ToInt32(id); } }
private void InitializePubComboBox() { Channel ch = new Channel(); string token = TokenStore.getTokenFromStore(); ch.setAuthToken(token); JArray d = ch.getAllBroadcastsChannels(); //Need User ID to send into filterPermittedChannels JArray datafeed = ch.filterChannelsInBroadcast(d); if (datafeed.ToString() != "[]") { foreach (dynamic data in datafeed) { foreach (dynamic c in data.channels) { pubComboBox.Items.Add(c.id.ToString() + "-" + c.description.ToString()); } } } else { pubComboBox.Items.Add("No data in the channel"); pubComboBox.SelectedIndex = 0; } }
public PubForm() { ch = new Channel(); InitializeComponent(); checkSSIDPassword(); InitializePermittedBroadcastsComboBox(); }
public void GetAllChannelsTest() { using (ShimsContext.Create()) { var responseStream = new FileStream("Fixtures/v1.channels.index.response", FileMode.Open); var responseShim = new ShimHttpWebResponse() { GetResponseStream = () => responseStream }; String actualMethod = ""; var requestShim = new ShimHttpWebRequest() { MethodSetString = (method) => { actualMethod = method; }, GetResponse = () => responseShim }; String actualURL = ""; ShimWebRequest.CreateString = (url) => { actualURL = url; return requestShim; }; Channel ch = new Channel(); JArray json = ch.getAllBroadcastsChannels(); StringAssert.AreEqualIgnoringCase("GET", actualMethod); StringAssert.AreEqualIgnoringCase("http://panoply-staging.herokuapp.com/api/channels.json", actualURL); Assert.AreEqual(2, json.Count); } }
public SubForm() { ch = new Channel(); currentValue = ""; currentFormula = ""; InitializeComponent(); InitializeBroadCastComboBox(); }
public void onRefreshButton(Office.IRibbonControl control) { Excel.Application exApp = Globals.ThisAddIn.Application as Excel.Application; Excel.Workbook wb = exApp.ActiveWorkbook as Excel.Workbook; Channel ch = new Channel(); ch.setAuthToken(TokenStore.getTokenFromStore()); string txt = ch.channelsRefresh(wb); MessageBox.Show(txt, "Refresh"); }
static void Main(string[] args) { Channel ch = new Channel(); string token = ch.getToken("*****@*****.**", "password"); ch.setAuthToken(token); string response = ch.getAllBroadcastsChannels().ToString(); //string token = ch.getToken("*****@*****.**", "password"); //Console.Write("Token from Website: " + token + "\n"); //at.setToken(token); //at.createCookieInContainer(); //string txt = at.readTokenFromCookie(); //Console.Write("Cookie Token: " + txt + "\n"); Console.Write(response); Console.Read(); }
private void loginButton_Click(object sender, EventArgs e) { Channel ch = new Channel(); string username = usernameBox.Text.ToString(); string password = passwordBox.Text.ToString(); string token = ch.getToken(username, password); if (token == "404"|token == "401") { loginErrorLabel.Visible = true; } else { loginErrorLabel.Visible = false; TokenStore.addTokenToStore(token); MessageBox.Show(TokenStore.getTokenFromStore(), "Token Obtained and Stored"); LoginForm.ActiveForm.Close(); } }
private void button1_Click(object sender, EventArgs e) { Excel.Application exApp = Globals.ThisAddIn.Application as Excel.Application; Excel.Workbook wb = exApp.ActiveWorkbook as Excel.Workbook; Excel.Worksheet ws = exApp.ActiveSheet as Excel.Worksheet; Excel.Range rng = (Excel.Range)exApp.ActiveCell; Channel ch = new Channel(); string returnID; string token; int broadcastID; string[] array = broadcastComboBox.SelectedItem.ToString().Split(new string[] { "-" }, StringSplitOptions.None); broadcastID = Convert.ToInt16(array[0]); //get token and send token together with publication request token = TokenStore.getTokenFromStore(); ch.setAuthToken(token); returnID = ch.publishChannel(feedNametextBox.Text.ToString(), rng.Value.ToString(), spreadSheetID, broadcastID); rng.Name = "PUB_" + returnID; MessageBox.Show("Published as Channel ID:" + returnID, "Response from Server"); //Add indicator to show publication status Excel.Shape aShape; aShape = ws.Shapes.AddShape(Microsoft.Office.Core.MsoAutoShapeType.msoShapeCross, rng.Left, rng.Top, 3, 3); aShape.Name = "Pub"; aShape.Fill.Visible = Microsoft.Office.Core.MsoTriState.msoTrue; aShape.Fill.Solid(); aShape.Line.Visible = Microsoft.Office.Core.MsoTriState.msoFalse; aShape.Fill.ForeColor.RGB = Color.FromArgb(200, 200, 90).ToArgb(); aShape.Placement = Excel.XlPlacement.xlMove; PubForm.ActiveForm.Close(); }
private void updateChannelDescription(object sender, EventArgs e) { Channel ch = new Channel(); this.readSelectedChannel(); descriptionTextBox.Text = ch.getChannelDesc(channelSelected.ToString()); }
private void rePubButton_Click(object sender, EventArgs e) { string responseFromServer; Excel.Application exApp = Globals.ThisAddIn.Application as Excel.Application; Excel.Workbook wb = exApp.ActiveWorkbook as Excel.Workbook; Excel.Worksheet ws = exApp.ActiveSheet as Excel.Worksheet; Excel.Range rng = (Excel.Range)exApp.ActiveCell; Channel ch = new Channel(); this.readSelectedChannel(); ch.setAuthToken(TokenStore.getTokenFromStore()); string to_replace = ""; if (forceCheckBox.Checked) { to_replace = "true"; } else { to_replace = "false"; } responseFromServer = ch.rePublishChannel(channelSelected, descriptionTextBox.Text, rng.Value.ToString(), spreadSheetID, to_replace); MessageBox.Show(responseFromServer.ToString()); if (responseFromServer == "409") { MessageBox.Show(@"This workbook is not the original publisher. Please check 'OverWrite' and retry if you want to overwrite data in the channel", "Cannot Overwrite"); } else if (responseFromServer == "401") { MessageBox.Show(@"You are not authorized to publish into the channel", "Unauthorized"); } else { rng.Name = "PUB_" + channelSelected.ToString(); //Add indicator to show publication status Excel.Shape aShape; aShape = ws.Shapes.AddShape(Microsoft.Office.Core.MsoAutoShapeType.msoShapeCross, rng.Left, rng.Top, 3, 3); aShape.Name = "Pub"; aShape.Fill.Visible = Microsoft.Office.Core.MsoTriState.msoTrue; aShape.Fill.Solid(); aShape.Line.Visible = Microsoft.Office.Core.MsoTriState.msoFalse; aShape.Fill.ForeColor.RGB = Color.FromArgb(200, 200, 90).ToArgb(); aShape.Placement = Excel.XlPlacement.xlMove; RePubForm.ActiveForm.Close(); } }
private void refreshAll(Office.CommandBarButton cmdBarbutton, ref bool cancel) { Excel.Application exApp = Globals.ThisAddIn.Application as Excel.Application; Excel.Workbook wb = exApp.ActiveWorkbook as Excel.Workbook; Channel ch = new Channel(); string txt; txt = ch.channelsRefresh(wb); MessageBox.Show(txt, "Refresh"); }
public void onRegButton(Office.IRibbonControl control) { Excel.Application exApp = Globals.ThisAddIn.Application as Excel.Application; Excel.Workbook wb = exApp.ActiveWorkbook as Excel.Workbook ; string filename = wb.Name.ToString(); Microsoft.Office.Core.DocumentProperties properties; properties = (Office.DocumentProperties)wb.CustomDocumentProperties; Channel ch = new Channel(); ch.setAuthToken(TokenStore.getTokenFromStore()); if (ch.checkSpreadSheetID(wb) == "0") { string fileID = ch.getSpreadSheetID(filename); MessageBox.Show(fileID, "File ID"); properties.Add("Excalibur ID", false, Microsoft.Office.Core.MsoDocProperties.msoPropertyTypeString, fileID); } else { MessageBox.Show("ID Exists - Excalibur ID: " + ch.checkSpreadSheetID(wb), "File Already Registered"); } }