private Cell createTextCell(int columnIndex, int rowIndex, object cellValue)
{
var cell = new Cell();
cell.DataType = CellValues.InlineString;
cell.CellReference = getColumnName(columnIndex) + rowIndex.ToString();
var inlineString = new InlineString();
var t = new System.Text();
t.Text = cellValue.ToString();
inlineString.AppendChild(t);
cell.AppendChild(inlineString);
return(cell);
}
public void UsingObject_Returns_Count()
{
Db.Insert(new Person { Active = true, FirstName = "a", LastName = "a1", DateCreated = DateTime.UtcNow.AddDays(-10) });
Db.Insert(new Person { Active = false, FirstName = "b", LastName = "b1", DateCreated = DateTime.UtcNow.AddDays(-10) });
Db.Insert(new Person { Active = true, FirstName = "c", LastName = "c1", DateCreated = DateTime.UtcNow.AddDays(-3) });
Db.Insert(new Person { Active = false, FirstName = "d", LastName = "d1", DateCreated = DateTime.UtcNow.AddDays(-1) });
var predicate = new { FirstName = new[] { "b", "d" } };
int count = Db.Count<Person>(predicate);
Assert.AreEqual(2, count);
}
public void UsingObject_ReturnsMatching()
{
var id1 = Db.Insert(new Person { Active = true, FirstName = "Sigma", LastName = "Alpha", DateCreated = DateTime.UtcNow });
var id2 = Db.Insert(new Person { Active = false, FirstName = "Delta", LastName = "Alpha", DateCreated = DateTime.UtcNow });
var id3 = Db.Insert(new Person { Active = true, FirstName = "Theta", LastName = "Gamma", DateCreated = DateTime.UtcNow });
var id4 = Db.Insert(new Person { Active = false, FirstName = "Iota", LastName = "Beta", DateCreated = DateTime.UtcNow });
var predicate = new { Active = true };
IList<ISort> sort = new List<ISort>
{
Predicates.Sort<Person>(p => p.LastName),
Predicates.Sort<Person>(p => p.FirstName)
};
IEnumerable<Person> list = Db.GetPage<Person>(predicate, sort, 0, 3);
Assert.AreEqual(2, list.Count());
Assert.IsTrue(list.All(p => p.FirstName == "Sigma" || p.FirstName == "Theta"));
}
public void UsingObject_ReturnsMatching()
{
Db.Insert(new Person { Active = true, FirstName = "a", LastName = "a1", DateCreated = DateTime.UtcNow });
Db.Insert(new Person { Active = false, FirstName = "b", LastName = "b1", DateCreated = DateTime.UtcNow });
Db.Insert(new Person { Active = true, FirstName = "c", LastName = "c1", DateCreated = DateTime.UtcNow });
Db.Insert(new Person { Active = false, FirstName = "d", LastName = "d1", DateCreated = DateTime.UtcNow });
var predicate = new { Active = true, FirstName = "c" };
IEnumerable<Person> list = Db.GetList<Person>(predicate, null);
Assert.AreEqual(1, list.Count());
Assert.IsTrue(list.All(p => p.FirstName == "c"));
}
public static XDocument UpdateProfileImage(ConsumerBase twitter, string accessToken, Stream image, string contentType)
{
var parts = new[] {
MultipartPostPart.CreateFormFilePart("image", "twitterPhoto", contentType, image),
};
HttpWebRequest request = twitter.PrepareAuthorizedRequest(UpdateProfileImageEndpoint, accessToken, parts);
IncomingWebResponse response = twitter.Channel.WebRequestHandler.GetResponse(request);
string responseString = response.GetResponseReader().ReadToEnd();
return XDocument.Parse(responseString);
}
public static XDocument UpdateProfileBackgroundImage(ConsumerBase twitter, string accessToken, string image, bool tile)
{
var parts = new[] {
MultipartPostPart.CreateFormFilePart("image", image, "image/" + Path.GetExtension(image).Substring(1).ToLowerInvariant()),
MultipartPostPart.CreateFormPart("tile", tile.ToString().ToLowerInvariant()),
};
HttpWebRequest request = twitter.PrepareAuthorizedRequest(UpdateProfileBackgroundImageEndpoint, accessToken, parts);
request.ServicePoint.Expect100Continue = false;
IncomingWebResponse response = twitter.Channel.WebRequestHandler.GetResponse(request);
string responseString = response.GetResponseReader().ReadToEnd();
return XDocument.Parse(responseString);
}
/// <summary>
/// Updates the authenticating user's status, also known as tweeting.
/// </summary>
/// <param name="twitter"></param>
/// <param name="accessToken"></param>
/// <param name="status">The text of your status update, typically up to 140 characters. URL encode as necessary. t.co link wrapping may effect character counts.</param>
/// <param name="includeEntities">When set to either true, t or 1, each tweet will include a node called "entities,". This node offers a variety of metadata about the tweet in a discreet structure, including: user_mentions, urls, and hashtags. While entities are opt-in on timelines at present, they will be made a default component of output in the future. See Tweet Entities for more detail on entities.
/// </param>
/// <returns></returns>
public static JObject UpdateStatus(ConsumerBase twitter, string accessToken, String status, bool includeEntities)
{
var parts = new[] {
MultipartPostPart.CreateFormPart("status", status),
MultipartPostPart.CreateFormPart("include_entities", includeEntities.ToString()),
};
HttpWebRequest request = twitter.PrepareAuthorizedRequest(UpdateStatusEndpoint, accessToken, parts);
IncomingWebResponse response = twitter.Channel.WebRequestHandler.GetResponse(request);
using (var responseReader = response.GetResponseReader())
{
var result = responseReader.ReadToEnd();
return JObject.Parse(result);
}
}
/**
<summary>Reads a string from the font file using the specified encoding.</summary>
*/
private string ReadString(
int length,
text::Encoding encoding
)
{
byte[] data = new byte[length];
FontData.Read(data,0,length);
return encoding.GetString(data);
}
public bool Write(Text text)
{
return this.writer.Write(text.Value);
}
