public async Task CardListChangeDoesNothingWhenOptionDisabled()
{
try
{
var cardData = "{\"id\":\"5a72b7ab3711a44643c5ed49\",\"idList\":\"51478f6469fd3d9341001dad\"}";
var listData = "{\"id\":\"51478f6469fd3d9341001daf\",\"cards\":[{\"id\":\"5a72b7ab3711a44643c5ed50\"}]}";
MockHost.MockRest <IJsonCard>(cardData);
MockHost.MockRest <IJsonList>(listData);
var card = _factory.Card("5a72b7ab3711a44643c5ed49");
var list = _factory.List("51478f6469fd3d9341001daf");
await card.Refresh();
await list.Refresh();
list.Cards.Count().Should().Be(1);
card.List = list;
list.Cards.Count().Should().Be(1);
}
finally
{
MockHost.ResetRest();
TrelloConfiguration.EnableConsistencyProcessing = false;
TrelloConfiguration.Cache.Clear();
}
}
public async Task Issue36_CardAttachmentByUrlThrows()
{
ICard card = null;
try
{
TrelloAuthorization.Default.AppKey = TrelloIds.AppKey;
var list = _factory.List(TrelloIds.ListId);
card = await list.Cards.Add("attachment test");
await card.Attachments.Add("http://i.imgur.com/eKgKEOn.jpg", "me");
}
finally
{
card?.Delete();
}
}
private static async Task AddCard()
{
Console.WriteLine("Inside");
TrelloAuthorization.Default.AppKey = "109fe6fc4bf193d45e7730f7055440b0";
TrelloAuthorization.Default.UserToken = "d6af304d5c424d0d8862b03781c32ddd8adf2ea7aa5ff97bba45b230209cf5a1";
ITrelloFactory factory = new TrelloFactory();
var List = factory.List("5b40363293193091c1ba5014");
Console.WriteLine("Creating a Card .......");
var card = List.Cards.Add("This is A NEW Card");
Console.WriteLine("Create Finished");
await List.Refresh();
return;
}
static async System.Threading.Tasks.Task Main(string[] args)
{
string SQLPRoofDate;
ArrayList JobDetails = new ArrayList();
bool done = false;
try
{
do
{
Console.WriteLine("Enter Pace Job Number");
string jn = Console.ReadLine();
int i = 0;
JobDetails.Clear();
var connString = "Host=6.1.1.13;Username=epace_read;Password=epace;Database=epace"; // ** Connection Details ** //
//var conn1 = @"Data Source=AG00072\SQLEXPRESS; Database=TrelloJobs; Connection Timeout=30;Integrated Security=SSPI;";
using (var conn = new NpgsqlConnection(connString))
{
conn.Open();
// ** Connection string ** //
using (var cmd = new NpgsqlCommand("SELECT job.ccmasterid, job.amounttoinvoice, Customer.arcustname, job.ccdescription, job.ccscheduledshipdate, jobpart.ccact2date FROM job INNER Join customer ON job.armasterid = customer.armasterid INNER Join jobpart ON job.ccmasterid = jobpart.ccmasterid WHERE job.ccmasterid =" + jn, conn))
using (NpgsqlDataReader reader = cmd.ExecuteReader())
while (JobDetails.Count < 5)
{
while (reader.Read()) //Loop through SQL reader //
{
switch (JobDetails.Count)
{
case 0:
JobDetails.Add(reader[0]);
JobDetails.Add(reader[1]);
JobDetails.Add(reader[2]);
JobDetails.Add(reader[3]);
JobDetails.Add(reader[4]);
break;
case 5:
JobDetails.Clear();
JobDetails.Insert(0, reader[0]);
JobDetails.Insert(1, reader[1]);
JobDetails.Insert(2, reader[2]);
JobDetails.Insert(3, reader[3]);
JobDetails.Insert(4, reader[4]);
break;
}
if (reader.GetValue(5).ToString() != "")
{
JobDetails.Add(reader[5]); // Proof Date //
}
}
}
}
//using (var conn2 = new SqlConnection(conn1))
// {
// conn2.Open();
if (JobDetails.Count == 5)
{
SQLPRoofDate = "N/A";
}
else
{
SQLPRoofDate = JobDetails[5].ToString();
}
// using (var cmdd = new SqlCommand("INSERT INTO Jobs VALUES ('" + JobDetails[0] + "','" + JobDetails[2] + "','" + JobDetails[3] + "','" + SQLPRoofDate + "','To Start','" + JobDetails[4] + "')", conn2))
// using (SqlDataReader r1 = cmdd.ExecuteReader()) ;
TrelloAuthorization.Default.AppKey = "234d8eb40d3f3133b0812df057f7bdc3"; // Trello API key //
TrelloAuthorization.Default.UserToken = "0e956ba7f0000d7ca7db8504e58a3301d45102e400297f230bfbdda2acc30e1e"; // Trello UserToken //
ITrelloFactory factory = new TrelloFactory(); // Get Trello board using board ID//
var board = factory.Board("5db19603e4428377d77963b1");
await board.Refresh();
var TDList = factory.List("5db19603e4428377d77963b2");
await TDList.Refresh();
var newCard = TDList.Cards.Add(JobDetails[0].ToString().Trim() + " - " + JobDetails[2].ToString().Trim());
var Card = factory.Card(newCard.Result.Id);
Card.DueDate = (DateTime)JobDetails[4];
var desc = board.CustomFields.FirstOrDefault(f => f.Name == ":.");
var field = desc.SetValueForCard(Card, JobDetails[3].ToString());
if (JobDetails.Count == 6)
{
var ProofDate = board.CustomFields.FirstOrDefault(f => f.Name == "Proof Date");
var field1 = ProofDate.SetValueForCard(Card, (DateTime)JobDetails[5]);
}
await Card.Refresh();
await Card.Labels.Refresh();
Console.WriteLine("Type N to input another Job Number or X to Exit");
var e = Console.ReadLine();
if (e == "X")
{
done = true;
}
} while (done != true);
}
catch (IndexOutOfRangeException e)
{
Console.WriteLine(e);
}
}
async void items_ItemAddAsync(object Item)
{
bool test = false;
var cardid = "";
var LID = "";
string jnum = "";
int i = 0;
var cardindex = "";
try
{
Outlook.MailItem mail = (Outlook.MailItem)Item;
TrelloAuthorization.Default.AppKey = "234d8eb40d3f3133b0812df057f7bdc3"; // Trello API key //
TrelloAuthorization.Default.UserToken = "0e956ba7f0000d7ca7db8504e58a3301d45102e400297f230bfbdda2acc30e1e"; // Trello UserToken //
ITrelloFactory factory = new TrelloFactory(); // Get Trello board using board ID//
var board = factory.Board("5db19603e4428377d77963b1");
await board.Refresh();
var TDList = factory.List("5db19603e4428377d77963b2");
//var TList = factory.List("");
await TDList.Refresh();
var Start = mail.Subject.IndexOf("t").ToString();
jnum = mail.Subject.Substring(int.Parse(Start) + 1, 7);
string[] ListID = new string[3];
//
ListID[0] = "5db19603e4428377d77963b2"; //To Start Board ID
ListID[1] = "5db19603e4428377d77963b3"; // On Proof Board ID
ListID[2] = "5db19603e4428377d77963b4"; // Signed Off Board ID
//board = TDList.Contains("255705");
// find Card
string query = jnum;
var search = factory.Search(query, 1, SearchModelType.Cards, new IQueryable[] { board });
await search.Refresh();
var CardList = search.Cards.ToList();
foreach (var card in CardList)
{
string tName = card.Name.Substring(0, 6);
if (tName == jnum.Trim())
{
cardid = card.Id;
}
}
var FoundCard = factory.Card(cardid);
string FoundListid = FoundCard.List.Id;
var fromlist = factory.List(FoundListid);
Person p1 = new Person();
p1.Name = "Shaun";
//var FoundList = board.Lists.FirstOrDefault(l => l.Name == "Swim Lane");
if (Item != null)
{
if (mail.Body.ToUpper().Contains("Approved for Print".ToUpper()))
{
//var ToList = factory.List("5db19603e4428377d77963b4");
var ToList = board.Lists.FirstOrDefault(l => l.Name == "Signed Off");
FoundCard.List = ToList;
// from on proof
//MessageBox.Show("Approved for Print");
}
else if (mail.Body.ToUpper().Contains("Awaiting Review".ToUpper()))
{
//var ToList = factory.List("5db19603e4428377d77963b3");
var ToList = board.Lists.FirstOrDefault(l => l.Name == "On Proof");
FoundCard.List = ToList;
// from in progress or to start
// MessageBox.Show("Awaiting Review");
}
else if (mail.Body.ToUpper().Contains("Amends".ToUpper()))
{
var ToList = factory.List("5dc9442eb245e60a39b3d4a7");
FoundCard.List = ToList;
// from on proof
//MessageBox.Show("Amends");
}
else
{
// non job mail
}
}
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
}
}
