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); }