public int? SeminarSave(Seminar input)
{
string com = input.SeminarId.HasValue ? "tblHuogTecaj_update" : "tblHuogTecaj_insert";
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
using (DbCommand command = GetCommand(com))
{
SetParameterValue(command, "@Title", input.Title);
SetParameterValue(command, "@DateFrom", input.DateFrom);
SetParameterValue(command, "@DateTo", input.DateTo);
SetParameterValue(command, "@Active", input.Active);
SetParameterValue(command, "@Description", input.Description);
if (input.SeminarId.HasValue)
{
SetParameterValue(command, "@Id", input.SeminarId.Value);
}
else
{
GetParameter(command, "@Id").Direction = ParameterDirection.Output;
}
ExecuteNonQuery(command);
if (!input.SeminarId.HasValue)
{
input.SeminarId = (int)GetParameterValue(command, "Id");
}
}
scope.Complete();
}
return input.SeminarId;
}
public ActionResult SeminarSave(Seminar input)
{
PureJson result = new PureJson();
Database.SeminarSave(input);
using (SPJsonObject jRoot = new SPJsonObject(new JsonKeyValueWriter(result.StringBuilder)))
{
jRoot.Add("Status", 0);
using (SPJsonObject jO = new SPJsonObject(jRoot.GetWriter, "Data"))
{
jO.Add("SeminarId", input.SeminarId);
jO.Add("Title", input.Title);
jRoot.Add("DateFrom", input.DateFrom);
jRoot.Add("DateTo", input.DateTo);
jO.Add("Active", input.Active);
jO.Add("Description", input.Description);
}
}
return new SimpleJsonResult(result);
}
