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