internal bool Enabled(ProjectColumn column)
{
if (Ignore?.Any(i => i == column.Name) == true)
{
return(false);
}
return(Select is null || (Select.Length == 1 && Select[0] == "*") || Select.Any(i => i == column.Name));
}
static void WriteColumn(ProjectColumn column)
{
writer.WriteLine(columnIndent + column.Name + writer.NewLine);
writer.WriteLine(writer.NewLine + "---" + writer.NewLine);
Parallel.ForEach(cardsClient.GetAll(column.Id).Result, card => {
WriteCard(card);
});
writer.WriteLine();
}
private async void OnProjectCard(ProjectCardEvent.RootObject obj)
{
//https://developer.github.com/v3/activity/events/types/#projectcardevent
if (obj == null)
{
return;
}
ProjectColumn column = await _githubClient.Repository.Project.Column.Get(obj.project_card.column_id);
Issue issue = null;
string contentUrl = obj.project_card.content_url;
if (!string.IsNullOrEmpty(contentUrl))
{
int pos = contentUrl.LastIndexOf("/") + 1;
string strId = contentUrl.Substring(pos, contentUrl.Length - pos);
if (int.TryParse(strId, out int id))
{
issue = await _githubClient.Issue.Get(obj.repository.id, id);
}
}
switch (obj.action)
{
case "created":
SendEventMessage(DiscordMessageFormatter.GetOnProjectCardCreatedMessage(obj, column, issue));
break;
case "edited":
SendEventMessage(DiscordMessageFormatter.GetOnProjectCardEditedMessage(obj));
break;
case "converted":
SendEventMessage(DiscordMessageFormatter.GetOnProjectCardConvertedMessage(obj));
break;
case "moved":
SendEventMessage(DiscordMessageFormatter.GetOnProjectCardMovedMessage(obj, column, issue));
break;
case "deleted":
SendEventMessage(DiscordMessageFormatter.GetOnProjectCardDeletedMessage(obj, issue));
break;
}
}
private ResourceItem CreateResourceItem(IXLRow row)
{
var project = row.Cell(ProjectColumn.ColumnNumber()).GetString();
var file = row.Cell(FileColumn.ColumnNumber()).GetString();
var name = row.Cell(NameColumn.ColumnNumber()).GetString();
var resource = new ResourceItem
{
Key = new ResourceKey {
Project = project, File = file, Name = name
},
Values = new Dictionary <string, string>(StringComparer.InvariantCultureIgnoreCase)
};
return(resource);
}
public ProjectEventArgs(ProjectColumn column)
{
this.column = column;
}
public ProjectEventArgs(ProjectColumn column, object value)
{
this.column = column;
this.value = value;
}
public IHttpActionResult PostTable(Table tables)
{
try
{
var existingTable = checkTableName(tables.name);
var checkTableType = checkMainTable(tables.tableType, tables.tableType);
if (!existingTable)
{
string message = "Table already existed";
return(BadRequest(message));
}
else if (!checkTableType)
{
string message = "One main table for project";
return(BadRequest(message));
}
else
{
string connectionString = @"Data Source=NIBLP535;Initial Catalog=GetixAdminDb;Integrated Security=True";
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
var commandStr = "CREATE TABLE " + tables.name + "(" + " PRJ_TASK_ID" + " int identity(1,1) not null, ";
bool isFirstCol = true;
foreach (var item in tables.columns)
{
if (!isFirstCol)
{
commandStr += ",";
}
commandStr += "[" + item.columnName + "]" + item.dataType;
isFirstCol = false;
}
commandStr += ", constraint " + "[PK_" + tables.name + "]" + " primary key clustered(PRJ_TASK_ID) " + ")";
using (SqlCommand command = new SqlCommand(commandStr, con))
command.ExecuteNonQuery();
con.Close();
}
ProjectTable projectTable = new ProjectTable();
projectTable.ProjectTableName = tables.name;
projectTable.ProjectID = tables.projectId;
projectTable.TableType = tables.tableType;
projectTable.RowInsertBy = "shivappa";
projectTable.RowInsertDate = Convert.ToDateTime(DateTime.Now.ToString("hh:mm:ss tt", System.Globalization.DateTimeFormatInfo.InvariantInfo));
db.ProjectTables.Add(projectTable);
db.SaveChanges();
foreach (var column in tables.columns)
{
ProjectColumn projectColumn = new ProjectColumn();
projectColumn.CoulmnName = column.columnName;
projectColumn.Datatype = column.dataType;
projectColumn.IsDisplay = column.isDisplay;
projectColumn.ProjectId = tables.projectId;
projectColumn.ProjectTableID = projectTable.ProjectTableID;
projectColumn.RowInsertDate = Convert.ToDateTime(DateTime.Now.ToString("hh:mm:ss tt", System.Globalization.DateTimeFormatInfo.InvariantInfo));
db.ProjectColumns.Add(projectColumn);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
}
return(Ok());
}
public CardWrapper(ProjectColumn column, ProjectCard card)
{
Column = column;
Card = card;
_uri = new Uri(card.ContentUrl);
}
public static EmbedBuilder GetOnProjectCardMovedMessage(ProjectCardEvent.RootObject obj, ProjectColumn column, Issue issue)
{
var builder = new EmbedBuilder()
{
Color = Const.DISCORD_EMBED_COLOR,
Description = $"{obj.sender.login} moved a project card for {obj.repository.full_name}"
};
builder.AddField(x =>
{
x.Name = "Moved to";
x.Value = column.Name;
x.IsInline = false;
});
if (issue == null)
{
builder.AddField(x =>
{
x.Name = "Card note";
x.Value = !string.IsNullOrEmpty(obj.project_card.note) ? obj.project_card.note : "Not available";
x.IsInline = false;
});
}
else
{
builder.AddField(x =>
{
x.Name = "Issue title";
x.Value = issue.Title;
x.IsInline = false;
});
builder.AddField(x =>
{
x.Name = "Url";
x.Value = issue.HtmlUrl;
x.IsInline = false;
});
}
builder.AddField(x =>
{
x.Name = "Creation date";
x.Value = obj.project_card.created_at.ToString("MM/dd/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
x.IsInline = false;
});
return(builder);
}
public static EmbedBuilder GetOnProjectCardCreatedMessage(ProjectCardEvent.RootObject obj, ProjectColumn column, Issue issue)
{
var builder = new EmbedBuilder()
{
Color = Const.DISCORD_EMBED_COLOR,
Description = $"{obj.sender.login} created a new project card for {obj.repository.full_name} in column {column.Name}"
};
if (issue == null)
{
builder.AddField(x =>
{
x.Name = "Card note";
x.Value = !string.IsNullOrEmpty(obj.project_card.note) ? obj.project_card.note : "Not available";
x.IsInline = false;
});
}
else
{
builder.AddField(x =>
{
x.Name = "Issue title";
x.Value = issue.Title;
x.IsInline = false;
});
builder.AddField(x =>
{
x.Name = "Url";
x.Value = issue.HtmlUrl;
x.IsInline = false;
});
}
return(builder);
}
public ProjectComparer(ProjectColumn column)
{
this.whichComparison = column;
}
