/*
Kooboo is a content management system based on ASP.NET MVC framework. Copyright 2009 Yardi Technology Limited.
This program is free software: you can redistribute it and/or modify it under the terms of the
GNU General Public License version 3 as published by the Free Software Foundation.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program.
If not, see http://www.kooboo.com/gpl3/.
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.Mvc;
using System.Linq.Expressions;
using Everest.Library.Mvc;
using Everest.Library.Extjs;
using Everest.CmsServices.Models;
namespace Everest.CmsServices.Controllers{
public class WebFormValuesController : CmsExtController
{
private IEverestCmsDataContext dataContext = EverestCmsEntities.GetDataContext();
public ActionResult GetList(string UUID)
{
int start, limit;
this.EnsurePaging(out start, out limit);
Guid formUUID = new Guid(UUID);
Expression<Func<Cms_CustomerFormValues, bool>> condition = s => s.Cms_CustomerForm.UUID == formUUID;
IQueryable<Cms_CustomerFormValues> query = dataContext.Cms_CustomerFormValues.Where(condition).OrderByDescending(val => val.FormValueId);
query = this.OrderByRequest(query);
var queryResult = query.Select<Cms_CustomerFormValues, object>(val => new
{
val.UUID,
val.FormValueId,
val.FormValues,
val.PostDate,
val.Cms_CustomerForm.FormName
});
return this.Json(new ExtJsonReaderObject(queryResult.Skip(start).Take(limit).ToArray(), queryResult.Count()));
}
public ActionResult Delete(string[] UUID)
{
if (UUID != null && UUID.Length > 0)
{
foreach (var requesFormValueUUID in UUID)
{
var formValueUUID = new Guid(requesFormValueUUID);
var valueObj = (from v in dataContext.Cms_CustomerFormValues
where v.UUID == formValueUUID
select v).First();
dataContext.DeleteObject(valueObj);
dataContext.SaveChanges();
}
}
return this.Json(new JsonResultData() { success = true });
}
}
}
|