public ActionResult Load(int UpitnikId) { DataTable table = Database.HuogUpitnikList(MySession.CurrentUser.Id, UpitnikId); PureJson result = new PureJson(); if (table.Rows.Count != 1) { return new SimpleJsonResult(); } using (SPJsonObject jRoot = new SPJsonObject(new JsonKeyValueWriter(result.StringBuilder))) { jRoot.Add("Status", 0); jRoot.Add("Id", table.Rows[0]["Id"]); jRoot.Add("Naziv", table.Rows[0]["Naziv"]); jRoot.Add("Opis", table.Rows[0]["Opis"]); jRoot.Add("Datum", table.Rows[0]["Datum"]); table = Database.HuogUpitnikVrijednostiList(UpitnikId, null); using (SPJsonArray jA = new SPJsonArray(jRoot.GetWriter, "Vrijednosti")) { foreach (DataRow row in table.Rows) { for (int i = 1; i <= 10; i++) { if (!Utils.IsNull(row["Vrijednost" + i])) { using (SPJsonObject jO = new SPJsonObject(jA.GetWriter)) { jO.Add("A", i); jO.Add("P", row["PitanjeId"]); jO.Add("O", row["Oznaka"]); jO.Add("V", row["Vrijednost" + i]); } } } } } } return new SimpleJsonResult(result); }
public ActionResult SeminarUserList(int? SeminarId, string DateFrom, string DateTo) { PureJson result = new PureJson(); DataTable table = Database.SeminarRegistrationSearch(SeminarId, DateFrom, DateTo); using (SPJsonObject jRoot = new SPJsonObject(new JsonKeyValueWriter(result.StringBuilder))) { jRoot.Add("Status", 0); using (SPJsonArray jA = new SPJsonArray(jRoot.GetWriter, "List")) { foreach (DataRow row in table.Rows) { using (SPJsonObject jO =new SPJsonObject(jRoot.GetWriter)) { foreach (DataColumn column in table.Columns) { if (column.ColumnName == "dateOfBirth" && !Utils.IsNull(row[column.ColumnName])) { DateTime born = (DateTime)row[column.ColumnName]; jRoot.Add(column.ColumnName, Utils.ToISODateString(born)); } else if (column.ColumnName == "dateCreated" && !Utils.IsNull(row[column.ColumnName])) { DateTime dt = (DateTime)row[column.ColumnName]; jRoot.Add(column.ColumnName, Utils.ToISODateString(dt)); } else { jRoot.Add(column.ColumnName, row[column.ColumnName]); } } } } } } return new SimpleJsonResult(result); }