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