public BugEntryGump(BugEntry entry, bool access)
: base(0, 0)
{
_Entry = entry;
_Access = access;
this.Closable = true;
this.Disposable = true;
this.Dragable = true;
this.Resizable = false;
this.AddPage(0);
this.AddBackground(12, 14, 503, 568, 9200);
this.AddLabel(25, 26, 254, String.Format("Created By: {0}", entry.Submitter));
this.AddLabel(25, 46, 254, String.Format("Added on: {0}", entry.CreationTime.ToShortDateString()));
this.AddLabel(25, 66, 254, String.Format("Last updated on: {0}", entry.LastUpdatedTime.ToShortDateString()));
this.AddLabel(260, 26, 254, String.Format("Assigned To: {0}", Enum.GetName(typeof(AssignedTo), entry.AssignedTo)));
this.AddLabel(260, 46, 254, String.Format("Status: {0}", Enum.GetName(typeof(BugStatus), entry.Status)));
this.AddHtml(21, 94, 481, 174, entry.Description, (bool)true, (bool)true); //Description
this.AddHtml(21, 275, 481, 263, CreateComments(entry), (bool)true, (bool)true); //Comments
this.AddLabel(26, 550, 254, @"Add Comment:");
this.AddButton(116, 550, 4014, 4015, (int)Buttons.addBtn, GumpButtonType.Reply, 0);
if (access)
{
this.AddLabel(154, 550, 254, @"Edit Entry:");
this.AddButton(225, 550, 4014, 4015, (int)Buttons.editBtn, GumpButtonType.Reply, 0);
}
}
public static string FormatBug(BugEntry bug)
{
// If bugzilla validation is disabled, all bugs are uncertain
if (string.IsNullOrEmpty(bug.Title))
{
return(FormatUncertainBug(bug));
}
return($"* [{bug.ID}](https://bugzilla.xamarin.com/show_bug.cgi?id={bug.ID}) - {bug.Title}" + (String.IsNullOrEmpty(bug.SecondaryTitle) ? "" : $" / {bug.SecondaryTitle}"));
}
private void AddEntry(BugEntry bugEntry, int index)
{
int y = (index * 28) + 118;
this.AddHtml(29, y, 317, 26, bugEntry.Title, (bool)true, (bool)false); //Description
this.AddHtml(345, y, 101, 26, bugEntry.Submitter, (bool)true, (bool)false); //Submitter
this.AddHtml(445, y, 77, 26, Enum.GetName(typeof(BugStatus), bugEntry.Status), (bool)true, (bool)false); //Status
this.AddHtml(521, y, 101, 26, Enum.GetName(typeof(AssignedTo), bugEntry.AssignedTo), (bool)true, (bool)false); //Assigned To
this.AddHtml(621, y, 117, 26, bugEntry.LastUpdatedTime.ToShortDateString() + " " + bugEntry.LastUpdatedTime.ToShortTimeString(), (bool)true, (bool)false); //Last Updated
this.AddButton(739, y, 208, 209, ((_Page * 15) + index) + 1, GumpButtonType.Reply, 0);
}
private static int CompareDate(BugEntry one, BugEntry two)
{
if (one.CreationTime > two.CreationTime)
{
return(-1);
}
else if (one.CreationTime < two.CreationTime)
{
return(1);
}
return(0);
}
public static int Compare(BugEntry one, BugEntry two)
{
if ((int)one.Status < (int)two.Status)
{
return(-1);
}
else if ((int)one.Status > (int)two.Status)
{
return(1);
}
else
{
return(CompareDate(one, two));
}
}
public AddCommentGump(BugEntry entry)
: base(30, 20)
{
_Entry = entry;
this.Closable = true;
this.Disposable = true;
this.Dragable = true;
this.Resizable = false;
this.AddPage(0);
this.AddBackground(6, 22, 423, 171, 9200);
this.AddAlphaRegion(17, 48, 399, 114);
this.AddTextEntry(21, 52, 394, 108, 0, 0, @"");
this.AddButton(383, 166, 4014, 4015, 1, GumpButtonType.Reply, 0);
this.AddLabel(18, 26, 0, "Please fill out the box below.");
}
static void PrintBug(BugEntry bug, bool potential, SearchOptions options)
{
if (!potential)
{
Console.WriteLine(FormatBug(bug));
}
else
{
Console.WriteLine(FormatUncertainBug(bug));
}
if (options.AdditionalBugInfo)
{
BugzillaChecker checker = new BugzillaChecker(options);
checker.Setup().Wait();
string additionalInfo = checker.LookupAdditionalInfo(bug.ID).Result;
if (additionalInfo != null)
{
Console.WriteLine($"\t{additionalInfo}");
}
}
}
public static string CreateComments(BugEntry entry)
{
StringBuilder sb = new StringBuilder();
sb.Append("Comments<br>------------------------------------<br>");
if (entry.Comments == null)
{
entry.Comments = new List <CommentEntry>();
}
for (int i = 0; i < entry.Comments.Count; i++)
{
CommentEntry c = entry.Comments[i];
if (c != null)
{
sb.AppendFormat("Comment by: {0} - {1} {2}<br><br>{3}", c.Submitter,
c.Created.ToShortDateString(), c.Created.ToShortTimeString(),
c.Comment);
}
}
return(sb.ToString());
}
public static string FormatUncertainBug(BugEntry bug)
{
return($"* [{bug.ID}](https://bugzilla.xamarin.com/show_bug.cgi?id={bug.ID}) - {bug.SecondaryTitle}");
}
private void addButton_Click(object sender, System.EventArgs e)
{
if ( validateEntryInformation( ) )
{
BugEntry entry = new BugEntry( );
entry.title = titleTextBox.Text;
entry.submitter = submitterComboBox.Text;
entry.submitDate = DateTime.Now;
entry.owner = ownerComboBox.Text;
entry.product = productComboBox.Text;
entry.description = descriptionTextBox.Text;
entry.closeDate = DateTime.Parse( closeDatePicker.Text );
entry.mileStone = milestoneComboBox.Text;
entry.priority = System.Convert.ToInt32( priorityComboBox.Text, 10 );
entry.type = typeComboBox.Text;
entry.isOpen = ( openStateComboBox.Text == "OPEN" );
entry.bugID = new Guid( IDLabel.Text );
entry.history = "USER " + username + " added bug " + entry.bugID + " on " + entry.submitDate.ToString( );
if ( !addBugToDatabase( entry ) )
{
MessageBox.Show( "Could not add bug to database!", "Error adding to DB" );
}
else
{
addButton.Enabled = false;
updateButton.Enabled = true;
// Update the listing of bugs...
listBugs( );
}
}
}
public bool updateBugInDatabase( BugEntry entry )
{
// Build up the insertion query string...
string updateQuery = "UPDATE " + "BugDB" + " SET submitter='" + entry.submitter + "', submitDate='" + entry.submitDate.ToString( ) + "', owner='" + entry.owner + "', closeDate='" + entry.closeDate.ToString( ) + "', mileStone='" + entry.mileStone + "', priority='" + entry.priority.ToString( ) +
"', product='" + entry.product + "', type='" + entry.type + "', description='" + entry.description + "', history='" + entry.history + "', title='" + entry.title + "', isOpen='" + boolToBit( entry.isOpen ).ToString( ) + "' WHERE bugID='" + entry.bugID.ToString( ) + "';";
try
{
// Build up the sql command...
SqlCommand cmd = new SqlCommand( updateQuery, dbConnection );
// Perform the query to add the information to the database...
cmd.ExecuteNonQuery( );
}
catch ( Exception e )
{
MessageBox.Show( "A problem occurred during the add operation: \n\n" + e.Message, "Error adding to DB" );
return false;
}
return true;
}
public BugEntry getBugFromDatabase( Guid guid )
{
string selectQuery = "SELECT submitter, submitDate, owner, closeDate, mileStone, priority, product, type, description, history, bugID, title, isOpen FROM " + "BugDB WHERE " +
"bugID='" + guid.ToString( ) + "';";
BugEntry dbEntry = null;
SqlDataReader sr = null;
try
{
SqlCommand queryCommand = new SqlCommand( selectQuery, dbConnection );
sr = queryCommand.ExecuteReader( );
dbEntry = new BugEntry( );
while ( sr.Read( ) )
{
dbEntry.submitter = sr.GetString( 0 );
dbEntry.submitDate = sr.GetDateTime( 1 );
dbEntry.owner = sr.GetString( 2 );
dbEntry.closeDate = sr.GetDateTime( 3 );
dbEntry.mileStone = sr.GetString( 4 );
dbEntry.priority = sr.GetInt32( 5 );
dbEntry.product = sr.GetString( 6 );
dbEntry.type = sr.GetString( 7 );
dbEntry.description = sr.GetString( 8 );
dbEntry.history = sr.GetString( 9 );
dbEntry.bugID = sr.GetGuid( 10 );
dbEntry.title = sr.GetString( 11 );
dbEntry.isOpen = sr.GetBoolean( 12 );
}
}
catch
{
// Return null if failure...
dbEntry = null;
}
finally
{
sr.Close( );
}
return dbEntry;
}
public void fillInBugInformation( BugEntry entry )
{
titleTextBox.Text = entry.title;
submitterComboBox.SelectedIndex = submitterComboBox.Items.IndexOf( entry.submitter );
submitDatePicker.Text = entry.submitDate.ToString( );
ownerComboBox.SelectedIndex = ownerComboBox.Items.IndexOf( entry.owner );
productComboBox.SelectedIndex = productComboBox.Items.IndexOf( entry.product );
descriptionTextBox.Text = entry.description;
closeDatePicker.Text = entry.closeDate.ToString( );
milestoneComboBox.SelectedIndex = milestoneComboBox.Items.IndexOf( entry.mileStone );
priorityComboBox.SelectedIndex = priorityComboBox.Items.IndexOf( entry.priority.ToString( ) );
typeComboBox.SelectedIndex = typeComboBox.Items.IndexOf( entry.type );
if ( entry.isOpen )
openStateComboBox.SelectedIndex = openStateComboBox.Items.IndexOf( "OPEN" );
else
openStateComboBox.SelectedIndex = openStateComboBox.Items.IndexOf( "CLOSED" );
IDLabel.Text = entry.bugID.ToString( );
}
private void updateButton_Click(object sender, System.EventArgs e)
{
BugEntry entry = new BugEntry( );
entry.title = titleTextBox.Text;
entry.submitter = submitterComboBox.Text;
entry.submitDate = DateTime.Now;
entry.owner = ownerComboBox.Text;
entry.product = productComboBox.Text;
entry.description = descriptionTextBox.Text;
entry.closeDate = DateTime.Parse( closeDatePicker.Text );
entry.mileStone = milestoneComboBox.Text;
entry.priority = System.Convert.ToInt32( priorityComboBox.Text, 10 );
entry.type = typeComboBox.Text;
entry.isOpen = ( openStateComboBox.Text == "OPEN" );
entry.bugID = new Guid( IDLabel.Text );
entry.history = "USER " + username + " updated bug " + entry.bugID + " on " + entry.submitDate.ToString( );
// Update the entry in the database...
updateBugInDatabase( entry );
listBugs( );
}
public bool addBugToDatabase( BugEntry entry )
{
// Build up the insertion query string...
string insertQuery = "INSERT " + "BugDB" + " (submitter, submitDate, owner, closeDate, mileStone, priority, product, type, description, history, bugID, title, isOpen ) VALUES ('" +
entry.submitter + "', '" + entry.submitDate.ToString( ) + "', '" + entry.owner + "', '" + entry.closeDate + "', '" + entry.mileStone + "', '" + entry.priority.ToString( ) + "', '" + entry.product + "', '" +
entry.type + "', '" + entry.description + "', '" + entry.history + "', '" + entry.bugID.ToString( ) + "', '" + entry.title + "', '" + boolToBit( entry.isOpen ).ToString( ) + "');";
try
{
// Build up the sql command...
SqlCommand cmd = new SqlCommand( insertQuery, dbConnection );
// Perform the query to add the information to the database...
cmd.ExecuteNonQuery( );
}
catch ( Exception e )
{
MessageBox.Show( "A problem occurred during the add operation: \n\n" + e.Message, "Error adding to DB" );
return false;
}
return true;
}
public override void OnResponse(Server.Network.NetState sender, RelayInfo info)
{
Mobile m = sender.Mobile;
if (m == null)
{
return;
}
switch (info.ButtonID)
{
case 0: break; //Cancel
case 60000:
{
if (_Page < 5)
{
_Page++;
}
m.CloseGump(typeof(BugTrackerGump));
m.SendGump(new BugTrackerGump(_Entries, _Page));
break;
}
case 59999:
{
if (_Page > 0)
{
_Page--;
}
m.CloseGump(typeof(BugTrackerGump));
m.SendGump(new BugTrackerGump(_Entries, _Page));
break;
}
default: //Any Entry
{
try
{
int index = info.ButtonID - 1;
BugEntry entry = _Entries[index];
if (entry == null)
{
m.SendMessage("Entry was deleted during a world save.");
return;
}
bool access = (m.AccessLevel >= AccessLevel.Seer);
m.CloseGump(typeof(BugEntryGump));
m.SendGump(new BugEntryGump(entry, access));
}
catch
{
Console.WriteLine("Bug Tracker: Invlid index selected.");
}
break;
}
}
}
