public static JArray GetPortsGroupedJson(string langCode = "en", byte portType = 0)
{
var portsGrouped = GetPortsGrouped(langCode, portType);
JTokenWriter pJTokenWriter = new JTokenWriter();
JArray ordersJson = new JArray();
pJTokenWriter.WriteStartArray();
foreach (var item in portsGrouped)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("text");
pJTokenWriter.WriteValue(item.CountryName);
pJTokenWriter.WritePropertyName("children");
pJTokenWriter.WriteStartArray();
foreach (var item1 in item.PortList)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("id");
pJTokenWriter.WriteValue(item1.Key.ToString());
pJTokenWriter.WritePropertyName("text");
pJTokenWriter.WriteValue(item1.Value);
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
ordersJson = (JArray)pJTokenWriter.Token;
return(ordersJson);
}
public void State()
{
using (JsonWriter jsonWriter = new JTokenWriter())
{
Assert.AreEqual(WriteState.Start, jsonWriter.WriteState);
jsonWriter.WriteStartObject();
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
jsonWriter.WritePropertyName("CPU");
Assert.AreEqual(WriteState.Property, jsonWriter.WriteState);
jsonWriter.WriteValue("Intel");
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
jsonWriter.WritePropertyName("Drives");
Assert.AreEqual(WriteState.Property, jsonWriter.WriteState);
jsonWriter.WriteStartArray();
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
jsonWriter.WriteValue("DVD read/writer");
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
jsonWriter.WriteValue(new byte[0]);
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
jsonWriter.WriteEnd();
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
jsonWriter.WriteEndObject();
Assert.AreEqual(WriteState.Start, jsonWriter.WriteState);
}
}
public static string ToJson(this OracleDataReader reader, string cultureInfo)
{
var culture = String.IsNullOrWhiteSpace(cultureInfo) ? CultureInfo.InvariantCulture : new CultureInfo(cultureInfo);
// create json result
using (var writer = new JTokenWriter())
{
writer.Formatting = Newtonsoft.Json.Formatting.Indented;
writer.Culture = culture;
// start array
writer.WriteStartArray();
while (reader.Read())
{
// start row object
writer.WriteStartObject();
for (var i = 0; i < reader.FieldCount; i++)
{
// add row element name
writer.WritePropertyName(reader.GetName(i));
// add row element value
writer.WriteValue(reader.GetValue(i) ?? string.Empty);
}
writer.WriteEndObject(); // end row object
}
// end array
writer.WriteEndArray();
return(writer.Token.ToString());
}
}
public void Example()
{
#region Usage
JTokenWriter writer = new JTokenWriter();
writer.WriteStartObject();
writer.WritePropertyName("name1");
writer.WriteValue("value1");
writer.WritePropertyName("name2");
writer.WriteStartArray();
writer.WriteValue(1);
writer.WriteValue(2);
writer.WriteEndArray();
writer.WriteEndObject();
JObject o = (JObject)writer.Token;
Console.WriteLine(o.ToString());
// {
// "name1": "value1",
// "name2": [
// 1,
// 2
// ]
// }
#endregion
Assert.AreEqual(@"{
""name1"": ""value1"",
""name2"": [
1,
2
]
}", o.ToString());
}
public void WriteTokenWithParent()
{
JObject o = new JObject {
["prop1"] = new JArray(1), ["prop2"] = 1
};
JTokenWriter writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteToken(o.CreateReader());
Assert.AreEqual(WriteState.Array, writer.WriteState);
writer.WriteEndArray();
Console.WriteLine(writer.Token.ToString());
StringAssert.AreEqual(
@"[
{
""prop1"": [
1
],
""prop2"": 1
}
]",
writer.Token.ToString()
);
}
public static JToken GetFileListResultFromResponseXml(string applicationResponseXml)
{
var document = new XmlDocument();
document.LoadXml(applicationResponseXml);
// Only the FileDescriptor element is of interest. The rest is metadata.
var nodeList = document.GetElementsByTagName("c2b:FileDescriptor").Cast <XmlNode>().ToList();
using (var writer = new JTokenWriter())
{
writer.Formatting = Newtonsoft.Json.Formatting.Indented;
writer.Culture = CultureInfo.InvariantCulture;
writer.WriteStartArray();
foreach (var node in nodeList)
{
writer.WriteNordeaFileInfo(node);
}
writer.WriteEndArray();
return(writer.Token);
}
}
private static JToken WriteToJToken(List <Dictionary <string, dynamic> > data, CultureInfo culture)
{
using (var writer = new JTokenWriter())
{
writer.Formatting = Newtonsoft.Json.Formatting.Indented;
writer.Culture = culture;
writer.WriteStartArray(); // root start
foreach (var row in data)
{
writer.WriteStartObject(); // start row object
foreach (var key in row.Keys)
{
writer.WritePropertyName(key);
// null check
if (row[key] != null)
{
writer.WriteValue(row[key]);
}
else //write empty string value for null fields
{
writer.WriteValue("");
}
}
writer.WriteEndObject(); // end row
}
writer.WriteEndArray(); // root array end
return(writer.Token);
}
}
/// <summary>
/// Use this to get json format for Pie chat used in charts.js
/// </summary>
/// <param name="chartData">Dictionary string "For Label Name", int "For Label count"</param>
/// <returns>Json</returns>
public static JObject GetPieChartData(Dictionary <string, int> chartData)
{
if (chartData == null || chartData.Count == 0)
{
return(null);
}
Random randomGen = new Random();
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("labels");
pJTokenWriter.WriteStartArray();
foreach (var item in chartData)
{
pJTokenWriter.WriteValue(item.Key);
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WritePropertyName("datasets");
pJTokenWriter.WriteStartArray(); //datasets array
pJTokenWriter.WriteStartObject(); //datasets Object
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray(); //data array
foreach (var item in chartData)
{
pJTokenWriter.WriteValue(item.Value);
}
pJTokenWriter.WriteEndArray();//data array
pJTokenWriter.WritePropertyName("backgroundColor");
pJTokenWriter.WriteStartArray(); //backgroundColor array
foreach (var item in chartData)
{
pJTokenWriter.WriteValue("rgb(" + randomGen.Next(256) + "," + randomGen.Next(256) + "," + randomGen.Next(256) + ")");
}
pJTokenWriter.WriteEndArray(); //backgroundColor array
pJTokenWriter.WriteEndObject(); //datasets Object
pJTokenWriter.WriteEndArray(); //datasets array
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
private string AssembleChickenNugetProject(IProjectFile[] packageConfigs, IProjectFile[] nuspecs)
{
var writer = new JTokenWriter();
// main obj
writer.WriteStartObject();
// files obj
writer.WritePropertyName("files");
writer.WriteStartObject();
if (packageConfigs.Length > 0)
{
// packages-config array
writer.WritePropertyName("packages-config");
writer.WriteStartArray();
foreach (var packageConfig in packageConfigs)
{
writer.WriteValue(packageConfig.FilePath());
}
writer.WriteEndArray();
}
if (nuspecs.Length > 0)
{
// packages-config array
writer.WritePropertyName("package-nuspec");
writer.WriteStartArray();
foreach (var projectFile in nuspecs)
{
writer.WriteValue(projectFile.FilePath());
}
writer.WriteEndArray();
}
// files obj
writer.WriteEndObject();
// main obj
writer.WriteEndObject();
return(writer.Token.ToString(Formatting.Indented));
}
internal static JObject GetCashReceiptsJson()
{
AccountingEntities db = new AccountingEntities();
var receiptList = db.ArCashDepositViews.OrderByDescending(x => x.CreateDate).ToList();
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray();
foreach (var item in receiptList)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("ReceiptId");
pJTokenWriter.WriteValue(item.ReceiptId);
pJTokenWriter.WritePropertyName("ReceiptCode");
pJTokenWriter.WriteValue(item.ReceiptCode);
pJTokenWriter.WritePropertyName("ReceiptDate");
pJTokenWriter.WriteValue(item.ReceiptDate.ToString("dd/MM/yyyy"));
pJTokenWriter.WritePropertyName("ReceiptAmount");
pJTokenWriter.WriteValue(item.ReceiptAmount.ToString() + " " + item.CurrencySign);
pJTokenWriter.WritePropertyName("Notes");
pJTokenWriter.WriteValue(item.Notes ?? "");
pJTokenWriter.WritePropertyName("Client");
pJTokenWriter.WriteValue(string.IsNullOrEmpty(item.ShipperNameEn) ? item.ConsigneeNameEn : item.ShipperNameEn);
pJTokenWriter.WritePropertyName("CreateDate");
pJTokenWriter.WriteValue(item.CreateDate.ToString("dd/MM/yyyy"));
pJTokenWriter.WritePropertyName("UserName");
pJTokenWriter.WriteValue(item.UserName);
pJTokenWriter.WritePropertyName("PaymentTermEn");
pJTokenWriter.WriteValue(item.PaymentTermEn);
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
public void WriteComment()
{
JTokenWriter writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteComment("fail");
writer.WriteEndArray();
Assert.AreEqual(@"[
/*fail*/]", writer.Token.ToString());
}
public void CurrentToken()
{
using (JTokenWriter jsonWriter = new JTokenWriter())
{
Assert.AreEqual(WriteState.Start, jsonWriter.WriteState);
Assert.AreEqual(null, jsonWriter.CurrentToken);
jsonWriter.WriteStartObject();
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
Assert.AreEqual(jsonWriter.Token, jsonWriter.CurrentToken);
JObject o = (JObject)jsonWriter.Token;
jsonWriter.WritePropertyName("CPU");
Assert.AreEqual(WriteState.Property, jsonWriter.WriteState);
Assert.AreEqual(o.Property("CPU"), jsonWriter.CurrentToken);
jsonWriter.WriteValue("Intel");
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
Assert.AreEqual(o["CPU"], jsonWriter.CurrentToken);
jsonWriter.WritePropertyName("Drives");
Assert.AreEqual(WriteState.Property, jsonWriter.WriteState);
Assert.AreEqual(o.Property("Drives"), jsonWriter.CurrentToken);
jsonWriter.WriteStartArray();
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
Assert.AreEqual(o["Drives"], jsonWriter.CurrentToken);
JArray a = (JArray)jsonWriter.CurrentToken;
jsonWriter.WriteValue("DVD read/writer");
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
Assert.AreEqual(a[a.Count - 1], jsonWriter.CurrentToken);
#if !(NET20 || NET35 || PORTABLE || PORTABLE40) || NETSTANDARD1_3 || NETSTANDARD2_0
jsonWriter.WriteValue(new BigInteger(123));
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
Assert.AreEqual(a[a.Count - 1], jsonWriter.CurrentToken);
#endif
jsonWriter.WriteValue(new byte[0]);
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
Assert.AreEqual(a[a.Count - 1], jsonWriter.CurrentToken);
jsonWriter.WriteEnd();
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
Assert.AreEqual(a, jsonWriter.CurrentToken);
jsonWriter.WriteEndObject();
Assert.AreEqual(WriteState.Start, jsonWriter.WriteState);
Assert.AreEqual(o, jsonWriter.CurrentToken);
}
}
public static JObject GetAccTransByAccId(string accId, string fromDate = null, string toDate = null)
{
List <AccountSummary> accSummary = new List <AccountSummary>();
ReportsAccountingEntities db = new ReportsAccountingEntities();
var spResult = db.GetAccountDetailsByAccId(accId, fromDate == "" ? null : fromDate, toDate == "" ? null : toDate).ToList();
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray();
foreach (var item in spResult)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("AccountId");
pJTokenWriter.WriteValue(item.AccountId);
pJTokenWriter.WritePropertyName("CreateDate");
pJTokenWriter.WriteValue(item.CreateDate.ToString("dd/MM/yyyy"));
pJTokenWriter.WritePropertyName("CreateBy");
pJTokenWriter.WriteValue(item.UserName);
pJTokenWriter.WritePropertyName("DebitAmount");
pJTokenWriter.WriteValue(item.DebitAmount);
pJTokenWriter.WritePropertyName("CreditAmount");
pJTokenWriter.WriteValue(item.CreditAmount);
pJTokenWriter.WritePropertyName("CurrencySign");
pJTokenWriter.WriteValue(item.CurrencySign);
pJTokenWriter.WritePropertyName("TransactionName");
pJTokenWriter.WriteValue(item.TransactionName);
pJTokenWriter.WritePropertyName("TransactionNameAr");
pJTokenWriter.WriteValue(item.TransactionNameAr);
pJTokenWriter.WritePropertyName("ReceiptNotes");
//pJTokenWriter.WriteValue(item.ReceiptNotes);
pJTokenWriter.WriteValue("");
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
internal static JObject GetCarrierRates(System.Web.Mvc.FormCollection form)
{
List <CarrierRateVm> carrRateList = CarrierRateHelper.GetCarrierRatesInquiry(form);
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray();
foreach (var item in carrRateList)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("CarrierRateId");
pJTokenWriter.WriteValue(item.CarrierRateId);
pJTokenWriter.WritePropertyName("CarrierName");
pJTokenWriter.WriteValue(item.CarrierName);
pJTokenWriter.WritePropertyName("ContainerTypeName");
pJTokenWriter.WriteValue(item.ContainerTypeName);
pJTokenWriter.WritePropertyName("FromPort");
pJTokenWriter.WriteValue(item.FromCountryName + " / " + item.FromPortName);
pJTokenWriter.WritePropertyName("ToPort");
pJTokenWriter.WriteValue(item.ToCountryName + " / " + item.ToPortName);
pJTokenWriter.WritePropertyName("FreightCost");
pJTokenWriter.WriteValue(item.FreightCostAmount + " " + item.FreighCurrencySign);
pJTokenWriter.WritePropertyName("ThcCost");
pJTokenWriter.WriteValue(item.ThcCostAmount + " " + item.ThcCurrencySign);
pJTokenWriter.WritePropertyName("ValidToDate");
pJTokenWriter.WriteValue(item.ValidToDate == null ? "" : item.ValidToDate.Value.ToString("dd/MM/yyyy"));
pJTokenWriter.WritePropertyName("CarrierId");
pJTokenWriter.WriteValue(item.CarrierId);
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
public void WriteRawValue()
{
JTokenWriter writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteRawValue("fail");
writer.WriteRawValue("fail");
writer.WriteEndArray();
Assert.AreEqual(@"[
fail,
fail
]", writer.Token.ToString());
}
public static JObject StoredProcXMLToJObject(string xml)
{
XDocument xmlContent;
try
{
xmlContent = XDocument.Load(new System.IO.StringReader(xml));
}
catch (Exception)
{
return(new JObject());
}
if (xmlContent.ElementExists("NewDataSet"))
{
JTokenWriter jWriter = new JTokenWriter();
jWriter.WriteStartObject();
int i = 0;
string tableName = "Table";
while (xmlContent.Element("NewDataSet").ElementExists(tableName))
{
//write a property for each table
jWriter.WritePropertyName(tableName);
//write an array for each collection of table entities
jWriter.WriteStartArray();
foreach (XElement item in xmlContent.Element("NewDataSet").Elements(tableName))
{
jWriter.WriteStartObject();
foreach (XElement prop in item.Elements())
{
jWriter.WritePropertyName(prop.Name.LocalName);
jWriter.WriteValue(prop.Value);
}
jWriter.WriteEndObject();
}
jWriter.WriteEndArray();
i++;
tableName = $"Table{i}";
}
jWriter.WriteEndObject();
return((JObject)jWriter.Token);
}
return(new JObject());
}
public void WriteBigInteger()
{
JTokenWriter writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteValue(new BigInteger(123));
writer.WriteEndArray();
JValue i = (JValue)writer.Token[0];
Assert.AreEqual(new BigInteger(123), i.Value);
Assert.AreEqual(JTokenType.Integer, i.Type);
StringAssert.AreEqual(@"[
123
]", writer.Token.ToString());
}
public static JArray ForceToArray(this JToken token)
{
if (token is JArray)
{
return((JArray)token);
}
if (token is JObject)
{
var writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteToken(new JTokenReader(token));
writer.WriteEndArray();
return((JArray)writer.Token);
}
throw new ArgumentException("token should be either JArray or JObject", nameof(token));
}
public void WriteRaw()
{
JTokenWriter writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteRaw("fail");
writer.WriteRaw("fail");
writer.WriteEndArray();
// this is a bug. write raw shouldn't be autocompleting like this
// hard to fix without introducing Raw and RawValue token types
// meh
Assert.AreEqual(@"[
fail,
fail
]", writer.Token.ToString());
}
public static string BuildJson(string Value, bool leaveOpen = true)
{
JTokenWriter writer = new JTokenWriter();
writer.WriteStartObject();
writer.WritePropertyName("Workflows");
writer.WriteStartArray();
writer.WriteStartObject();
writer.WritePropertyName("FirmID");
writer.WriteValue(470);
writer.WritePropertyName("Procedure");
writer.WriteValue("Accounts.New");
writer.WritePropertyName("Description");
writer.WriteValue(Value);
writer.WritePropertyName("DueDate");
writer.WriteValue(DateTime.Now.ToUniversalTime());
writer.WritePropertyName("App");
writer.WriteValue("Ingestion");
writer.WritePropertyName("Type");
writer.WriteValue("Info");
writer.WritePropertyName("Remediation");
writer.WriteValue("Feed.Acc.Insert");
writer.WritePropertyName("ClosedDate");
if (leaveOpen)
{
writer.WriteValue(DateTime.Now.ToUniversalTime());
}
else
{
writer.WriteValue(string.Empty);
}
writer.WritePropertyName("CreateEmail");
writer.WriteValue("*****@*****.**");
writer.WritePropertyName("Responsibility");
writer.WriteValue("Internal.Ops");
writer.WritePropertyName("Cause");
writer.WriteValue("Feed.Acc.Created");
writer.WritePropertyName("Group_UID");
writer.WriteValue("2CBEF1AC-82C0-4452-B119-A6A18F1BCC41");
writer.WriteEndObject();
writer.WriteEndArray();
writer.WriteEndObject();
return(writer.Token.ToString());
}
public void WriteValueTokenWithParent()
{
JValue v = new JValue(1);
JTokenWriter writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteToken(v.CreateReader());
Assert.AreEqual(WriteState.Array, writer.WriteState);
writer.WriteEndArray();
StringAssert.AreEqual(@"[
1
]", writer.Token.ToString());
}
public void ValueFormatting()
{
byte[] data = Encoding.UTF8.GetBytes("Hello world.");
JToken root;
using (JTokenWriter jsonWriter = new JTokenWriter())
{
jsonWriter.WriteStartArray();
jsonWriter.WriteValue('@');
jsonWriter.WriteValue("\r\n\t\f\b?{\\r\\n\"\'");
jsonWriter.WriteValue(true);
jsonWriter.WriteValue(10);
jsonWriter.WriteValue(10.99);
jsonWriter.WriteValue(0.99);
jsonWriter.WriteValue(0.000000000000000001d);
jsonWriter.WriteValue(0.000000000000000001m);
jsonWriter.WriteValue((string)null);
jsonWriter.WriteValue("This is a string.");
jsonWriter.WriteNull();
jsonWriter.WriteUndefined();
jsonWriter.WriteValue(data);
jsonWriter.WriteEndArray();
root = jsonWriter.Token;
}
CustomAssert.IsInstanceOfType(typeof(JArray), root);
Assert.AreEqual(13, root.Children().Count());
Assert.AreEqual("@", (string)root[0]);
Assert.AreEqual("\r\n\t\f\b?{\\r\\n\"\'", (string)root[1]);
Assert.AreEqual(true, (bool)root[2]);
Assert.AreEqual(10, (int)root[3]);
Assert.AreEqual(10.99, (double)root[4]);
Assert.AreEqual(0.99, (double)root[5]);
Assert.AreEqual(0.000000000000000001d, (double)root[6]);
Assert.AreEqual(0.000000000000000001m, (decimal)root[7]);
Assert.AreEqual(string.Empty, (string)root[8]);
Assert.AreEqual("This is a string.", (string)root[9]);
Assert.AreEqual(null, ((JValue)root[10]).Value);
Assert.AreEqual(null, ((JValue)root[11]).Value);
Assert.AreEqual(data, (byte[])root[12]);
}
public void WriteDuplicatePropertyName()
{
JTokenWriter writer = new JTokenWriter();
writer.WriteStartObject();
writer.WritePropertyName("prop1");
writer.WriteStartObject();
writer.WriteEndObject();
writer.WritePropertyName("prop1");
writer.WriteStartArray();
writer.WriteEndArray();
writer.WriteEndObject();
StringAssert.AreEqual(@"{
""prop1"": []
}", writer.Token.ToString());
}
public void WriteEmptyToken()
{
JObject o = new JObject();
JsonReader reader = o.CreateReader();
while (reader.Read())
{
}
JTokenWriter writer = new JTokenWriter();
writer.WriteStartArray();
writer.WriteToken(reader);
Assert.AreEqual(WriteState.Array, writer.WriteState);
writer.WriteEndArray();
StringAssert.AreEqual(@"[]", writer.Token.ToString());
}
private void SetPostedTransaction(HttpClient http, List <string> lstParameter)
{
string metodo = "api/v1/jobs/Transactions/SetPosted";
int page = 1;
int totalPages = (int)Decimal.Ceiling(lstParameter.Count / 100);
int posicaoLista = 0;
int registrosLidos = 1;
do
{
JTokenWriter writerJson = new JTokenWriter();
writerJson.WriteStartObject();
writerJson.WritePropertyName("Assignments");
writerJson.WriteStartArray();
for (int index = posicaoLista; index < lstParameter.Count; index++)
{
writerJson.WriteStartObject();
writerJson.WritePropertyName("TransactionId");
writerJson.WriteValue(lstParameter[index]);
writerJson.WritePropertyName("PostedDate");
writerJson.WriteValue(DateTime.Now.ToString("yyyy-MM-dd'T'HH:mm:sszzz"));
writerJson.WriteEndObject();
registrosLidos++;
if (registrosLidos > 100)
{
posicaoLista += (registrosLidos - 1);
break;
}
}
writerJson.WriteEndArray();
writerJson.WriteEndObject();
JObject json = (JObject)writerJson.Token;
PostSyncApi(metodo, http, json);
page++;
} while (page <= totalPages);
}
public void State()
{
using (JsonWriter jsonWriter = new JTokenWriter())
{
Assert.AreEqual(WriteState.Start, jsonWriter.WriteState);
jsonWriter.WriteStartObject();
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
jsonWriter.WritePropertyName("CPU");
Assert.AreEqual(WriteState.Property, jsonWriter.WriteState);
jsonWriter.WriteValue("Intel");
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
jsonWriter.WritePropertyName("Drives");
Assert.AreEqual(WriteState.Property, jsonWriter.WriteState);
jsonWriter.WriteStartArray();
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
jsonWriter.WriteValue("DVD read/writer");
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
#if !(NET20 || NET35 || PORTABLE || PORTABLE40) || NETSTANDARD1_3 || NETSTANDARD2_0
jsonWriter.WriteValue(new BigInteger(123));
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
#endif
jsonWriter.WriteValue(new byte[0]);
Assert.AreEqual(WriteState.Array, jsonWriter.WriteState);
jsonWriter.WriteEnd();
Assert.AreEqual(WriteState.Object, jsonWriter.WriteState);
jsonWriter.WriteEndObject();
Assert.AreEqual(WriteState.Start, jsonWriter.WriteState);
}
}
private static object WriteJToken(IEnumerable <List <object> > data, IReadOnlyList <string> headers)
{
using (var writer = new JTokenWriter())
{
writer.Formatting = Formatting.Indented;
writer.Culture = _culture;
writer.WriteStartArray();
foreach (var row in data)
{
writer.WriteStartObject();
for (var i = 0; i < headers.Count; i++)
{
writer.WritePropertyName(headers[i]);
writer.WriteValue(row[i]);
}
writer.WriteEndObject();
}
writer.WriteEndArray();
return(writer.Token);
}
}
public static JObject GetEmpList(System.Web.Mvc.FormCollection form)
{
HREntities db = new HREntities();
var empListDb = db.Employees.Include("Department").OrderBy(x => x.EmpNameEn).ToList();
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray();
foreach (var item in empListDb)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("EmpId");
pJTokenWriter.WriteValue(item.EmpId);
pJTokenWriter.WritePropertyName("EmpCode");
pJTokenWriter.WriteValue(item.EmpCode);
pJTokenWriter.WritePropertyName("EmpNameEn");
pJTokenWriter.WriteValue(item.EmpNameEn);
pJTokenWriter.WritePropertyName("EmpNameAr");
pJTokenWriter.WriteValue(item.EmpNameAr);
pJTokenWriter.WritePropertyName("DepNameEn");
pJTokenWriter.WriteValue(item.Department.DepNameEn);
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
internal static JObject GetExpensesCashOutJson(System.Web.Mvc.FormCollection form)
{
AccountingEntities db = new AccountingEntities();
//Get Only cash out receipts for expenses
var receiptIds = db.CashOutReceiptExpenses.Select(x => x.ReceiptId).Distinct();
var receiptList = (from c in db.CashOutReceipts
join u in db.AspNetUserAccs
on c.CreateBy equals u.Id
join cu in db.CurrencyAccs
on c.CurrencyId equals cu.CurrencyId
where receiptIds.Contains(c.ReceiptId) && c.IsDeleted == false
select new
{
c.ReceiptId,
c.ReceiptDate,
c.ReceiptCode,
c.ReceiptAmount,
c.Notes,
c.CreateDate,
c.CreateBy,
cu.CurrencySign,
u.UserName
}).ToList();
if (!string.IsNullOrEmpty(form["ReceiptDateStart"]))
{
DateTime date = DateTime.Parse(form["ReceiptDateStart"]);
receiptList = receiptList.Where(x => x.ReceiptDate >= date).ToList();
}
if (!string.IsNullOrEmpty(form["ReceiptDateEnd"]))
{
DateTime date = DateTime.Parse(form["ReceiptDateEnd"]);
receiptList = receiptList.Where(x => x.ReceiptDate <= date).ToList();
}
if (!string.IsNullOrEmpty(form["CreateDateStart"]))
{
DateTime date = DateTime.Parse(form["CreateDateStart"]);
receiptList = receiptList.Where(x => x.CreateDate >= date).ToList();
}
if (!string.IsNullOrEmpty(form["CreateDateEnd"]))
{
DateTime date = DateTime.Parse(form["CreateDateEnd"]);
receiptList = receiptList.Where(x => x.CreateDate <= date).ToList();
}
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray();
foreach (var item in receiptList)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("ReceiptId");
pJTokenWriter.WriteValue(item.ReceiptId);
pJTokenWriter.WritePropertyName("ReceiptCode");
pJTokenWriter.WriteValue(item.ReceiptCode);
pJTokenWriter.WritePropertyName("ReceiptDate");
pJTokenWriter.WriteValue(item.ReceiptDate.ToString("dd/MM/yyyy"));
pJTokenWriter.WritePropertyName("ReceiptAmount");
pJTokenWriter.WriteValue(item.ReceiptAmount.ToString() + " " + item.CurrencySign);
pJTokenWriter.WritePropertyName("Notes");
pJTokenWriter.WriteValue(item.Notes);
pJTokenWriter.WritePropertyName("CreateDate");
pJTokenWriter.WriteValue(item.CreateDate.ToString("dd/MM/yyyy"));
pJTokenWriter.WritePropertyName("UserName");
pJTokenWriter.WriteValue(item.UserName);
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
public static JObject GetAllAgentsByCountry(int countryId = 0)
{
EasyFreightEntities db = new EasyFreightEntities();
var selectedAgents = db.Agents.Include("Countries").Where(c => c.CountryId == (countryId > 0 ? countryId : c.CountryId))
.Select(x => new
{
x.AgentAddressEn,
x.AgentCode,
x.AgentId,
x.AgentNameEn,
x.Country.CountryNameEn,
x.CountryId,
x.Email,
x.FaxNumber,
x.PhoneNumber,
x.WebSite
}).ToList();
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray();
foreach (var item in selectedAgents)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("AgentCode");
pJTokenWriter.WriteValue(item.AgentCode);
pJTokenWriter.WritePropertyName("AgentAddressEn");
pJTokenWriter.WriteValue(item.AgentAddressEn);
pJTokenWriter.WritePropertyName("AgentNameEn");
pJTokenWriter.WriteValue(item.AgentNameEn);
pJTokenWriter.WritePropertyName("Country");
pJTokenWriter.WriteValue(item.CountryNameEn);
pJTokenWriter.WritePropertyName("CountryId");
pJTokenWriter.WriteValue(item.CountryId);
pJTokenWriter.WritePropertyName("Email");
pJTokenWriter.WriteValue(item.Email);
pJTokenWriter.WritePropertyName("FaxNumber");
pJTokenWriter.WriteValue(item.FaxNumber);
pJTokenWriter.WritePropertyName("PhoneNumber");
pJTokenWriter.WriteValue(item.PhoneNumber);
pJTokenWriter.WritePropertyName("WebSite");
pJTokenWriter.WriteValue(item.WebSite);
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
