FogBugz » TimeIntervalCommentsPlugin http://fogbugz.stackexchange.com/questions/3316
Clone URL:  
Pushed to one repository · View In Graph Contained in version_0-2-0-0, version_0-2-0-1, and tip

check length of intervals returned

Changeset 3286058dee83…

Parent d538b01283e6…

by Adam Wishneusky

Changes to 2 files · Browse files at 3286058dee83 Showing diff from parent d538b01283e6 Diff from another changeset...

Change 1 of 1 Show Entire File TimeIntervalExample/​Properties/​AssemblyInfo.cs Stacked
 
39
40
41
42
43
 
 
 
39
40
41
 
 
42
43
@@ -39,5 +39,5 @@
 // You can specify all the values or you can default the Build and Revision Numbers  // by using the '*' as shown below:  // [assembly: AssemblyVersion("1.0.*")] -[assembly: AssemblyVersion("0.1.1.5")] -[assembly: AssemblyFileVersion("0.1.1.5")] +[assembly: AssemblyVersion("0.1.2.0")] +[assembly: AssemblyFileVersion("0.1.2.0")]
Change 1 of 2 Show Changes Only TimeIntervalExample/​TimeIntervalExample.cs Stacked
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
 
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
 
 
158
159
160
161
162
163
164
165
166
 
 
 
 
167
168
169
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
 
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
 
 
 
 
 
164
165
166
167
168
169
170
 using System;  using System.Collections.Generic;  using System.Text;  using System.Web;    using FogCreek.FogBugz;  using FogCreek.FogBugz.Plugins;  using FogCreek.FogBugz.Plugins.Api;  using FogCreek.FogBugz.Database.Entity;  using FogCreek.FogBugz.Plugins.Entity;  using FogCreek.FogBugz.Plugins.Interfaces;  using FogCreek.FogBugz.UI.Dialog;    namespace TimeIntervalExample  {   public class TimeIntervalExample : Plugin, IPluginTimeIntervalJoin,   IPluginJS, IPluginDatabase, IPluginRawPageDisplay   {   public TimeIntervalExample(CPluginApi api) : base(api) { }     protected const string SPluginId = "Adam+TimeIntervalExample@fogcreek.com";   private const string CommentsTable = "TimeIntervalComment";   private const string IntervalColumn = "ixInterval";   private const string CommentColumn = "sComment";   public const int CommentColumnMaxLength = 255;   private const int PluginSchemaVer = 1;     #region IPluginTimeIntervalJoin Members     public string[] TimeIntervalJoinTables()   {   return new string[] { "TimeIntervalComment" };   }     #endregion     #region IPluginJS Members     public CJSInfo JSInfo()   {   string fullAjaxPostUrl = api.Url.PluginRawPageUrl() +   String.Format("&{0}sComment=' + sComment + '&{0}action=postTimeIntervalComment&{0}actionToken={1}",   api.PluginPrefix,   api.Security.GetActionToken("postTimeIntervalComment"));   string fullAjaxGetUrl = api.Url.PluginRawPageUrl() +   String.Format("&{0}action=getTimeIntervalComment&{0}actionToken={1}&{0}ixInterval=",   api.PluginPrefix,   api.Security.GetActionToken("postTimeIntervalComment"));     CJSInfo jsInfo = new CJSInfo();   jsInfo.rgsStaticFiles = new string[] { "js/TimeIntervalExample.js" };   jsInfo.sInlineJS = @"  function postTimeIntervalComment()  {   var sComment = $('form#TimeIntervalExamplePluginForm input[name=comment]').val();   var ixInterval = $('form#TimeIntervalExamplePluginForm input[name=]').val();   var url = '" + fullAjaxPostUrl + @"';   jQuery.get(url, myCallback);  }    function getTimeIntervalComment(ixInterval)  {   var url = '" + fullAjaxGetUrl + @"' + ixInterval;   jQuery.get(url, function() {   $('form#TimeIntervalExamplePluginForm input[name=comment]').val(data);  alert(data);  });  }";   return jsInfo;   }     #endregion     #region IPluginDatabase Members     public CTable[] DatabaseSchema()   {   var timeIntervalComments = api.Database.NewTable(api.Database.PluginTableName(CommentsTable));   timeIntervalComments.sDesc = "Assigns Comments to TimeIntervals";   timeIntervalComments.AddAutoIncrementPrimaryKey("ixTimeIntervalComment");   timeIntervalComments.AddIntColumn(IntervalColumn, true, 0);   timeIntervalComments.AddVarcharColumn(CommentColumn, CommentColumnMaxLength, false);     return new[] { timeIntervalComments };   }     public int DatabaseSchemaVersion()   {   return PluginSchemaVer;   }     public void DatabaseUpgradeAfter(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade)   {   if (ixVersionTo == 1)   {   // No action required. Don't create any data in the tables   }   }     public void DatabaseUpgradeBefore(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade)   {   if (ixVersionTo == 1)   {   // No action required. Don't create any data in the tables   }   }     #endregion     #region IPluginRawPageDisplay Members     public string RawPageDisplay()   {   if (api.Request[api.AddPluginPrefix("action")] != null &&   Convert.ToString(api.Request[api.AddPluginPrefix("action")]) == "postTimeIntervalComment")   {   // make sure the request includes a valid action token   if ((api.Request[api.AddPluginPrefix("actionToken")] == null) ||   !api.Security.ValidateActionToken(api.Request[api.AddPluginPrefix("actionToken")],   "postTimeIntervalComment"))   {   return "failure: action token invalid";   }   else   {   return PostComment();   }     }     else if (api.Request[api.AddPluginPrefix("action")] != null &&   Convert.ToString(api.Request[api.AddPluginPrefix("action")]) == "getTimeIntervalComment")   {   int ixInterval = -1; - if (api.Request[api.AddPluginPrefix("action")] != null && + if (api.Request[api.AddPluginPrefix("ixInterval")] != null &&   Int32.TryParse(Convert.ToString(api.Request[api.AddPluginPrefix("ixInterval")]), out ixInterval))   return GetComment(ixInterval);   else   return "failure: ixInterval invalid";   }   else return "failure: command not recognized";   }     public PermissionLevel RawPageVisibility()   {   return PermissionLevel.Normal;   }     #endregion     private string PostComment()   {   return "success";   }     private string GetComment(int ixInterval)   { + string sComment = "none"; +   CTimeIntervalQuery query = api.TimeInterval.NewTimeIntervalQuery();   query.AddWhere("TimeInterval.ixInterval = @ixInterval");   query.SetParamInt("@ixInterval", ixInterval);   - CTimeInterval timeInterval = query.List()[0]; - // check for null - string sComment = timeInterval.GetPluginField(SPluginId, "sComment").ToString(); - // return sComment; - return "comment goes here"; + CTimeInterval[] rgTimeIntervals = query.List(); + if (rgTimeIntervals.Length > 0) + sComment = rgTimeIntervals[0].GetPluginField(SPluginId, "sComment").ToString(); + return sComment;   }   }  }