public async Task <ActionResult> Create()
{
var PageContentModel = new ManagePageContentsModel();
PageContentModel.PageNameList = new SelectList(await CommonModel.GetLookup("Page"), "Value", "Text");
PageContentModel.SectionNameList = new SelectList(Enumerable.Empty <SelectList>());
return(View(PageContentModel));
}
public async Task <ActionResult> Index()
{
var filter = new FilterModel {
CompId = CurrentUser.CompanyId
};
ManagePageContentsModel PageContentModel = new ManagePageContentsModel();
PageContentModel.MainContent = await _PageContent.GetAllPageContent(filter);
PageContentModel.DynamicContent = new ManagePageContentsModel();
PageContentModel.DynamicContent.PageNameList = new SelectList(await CommonModel.GetLookup("Page"), "Value", "Text");
PageContentModel.DynamicContent.SectionNameList = new SelectList(Enumerable.Empty <SelectList>());
return(View(PageContentModel));
}
public async Task <ActionResult> Create(ManagePageContentsModel PageContent)
{
PageContent.UserId = CurrentUser.UserId;
PageContent.CompanyId = CurrentUser.CompanyId;
ResponseModel response = new ResponseModel();
if (PageContent.ContentId == Guid.Empty)
{
PageContent.EventAction = 'I';
response = await _PageContent.AddUpdatePageContent(PageContent);
}
else
{
PageContent.EventAction = 'U';
response = await _PageContent.AddUpdatePageContent(PageContent);
}
TempData["response"] = response;
return(RedirectToAction("Index"));
}
public async Task <ResponseModel> AddUpdatePageContent(ManagePageContentsModel PageContent)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@ContentId", ToDBNull(PageContent.ContentId));
sp.Add(param);
param = new SqlParameter("@CompId", ToDBNull(PageContent.CompanyId));
sp.Add(param);
param = new SqlParameter("@PageId", ToDBNull(PageContent.PageId));
sp.Add(param);
param = new SqlParameter("@SectionId", ToDBNull(PageContent.SectionId));
sp.Add(param);
param = new SqlParameter("@Description", ToDBNull(PageContent.Description));
sp.Add(param);
param = new SqlParameter("@MetaTitle", ToDBNull(PageContent.MetaTitle));
sp.Add(param);
param = new SqlParameter("@MetaNameDescription", ToDBNull(PageContent.MetaNameDescription));
sp.Add(param);
param = new SqlParameter("@IsActive", (object)(PageContent.IsActive));
sp.Add(param);
param = new SqlParameter("@User", ToDBNull(PageContent.UserId));
sp.Add(param);
param = new SqlParameter("@Action", (object)PageContent.EventAction);
sp.Add(param);
var sql = "USPInsertUpdatePageContent @ContentId,@CompId,@PageId,@SectionId,@Description,@MetaTitle,@MetaNameDescription,@isactive, @User,@Action";
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
else
{
res.IsSuccess = false;
}
return(res);
}
