public ActionResult EditPage(int id)
{
// declare pageVm
PagesVM model;
using (Db db = new Db())
{
//Get the page
PageDTO dto = db.Pages.Find(id);
//confirm page exists
if (dto == null)
{
return(Content("Page does not exists"));
}
//Initialize the pageVm model
model = new PagesVM(dto);
}
// return view with model
return(View(model));
}
public ActionResult EditPage(int id)
{
// Declare PageVM
PageVM model;
using (Db db = new Db())
{
// Get the page
PageDTO dto = db.Pages.Find(id);
// Confirm page exists
if (dto == null)
{
return(Content("The page does not exist."));
}
// Init PageVM
model = new PageVM(dto);
}
// Return view with model
return(View(model));
}
//TODO: make this not a GET method
public ActionResult DeletePage(int id = 0)
{
using (Db db = new Db())
{
PageDTO dto = db.Pages.Find(id);
if (dto == null)
{
return(Content($"Page with id: {id} does not exist!"));
}
if (dto.Slug == "home")
{
return(Content("The home page cannot be deleted!"));
}
db.Pages.Remove(dto);
db.SaveChanges();
TempData["message"] = $"Page '{dto.Title}' removed!";
}
return(RedirectToAction("Index"));
}
// GET: Admin/Pages/PageDetails/id
public ActionResult PageDetails(int id)
{
//Declare PageVM
PageVM pageVM;
using (DbShoppingCard db = new DbShoppingCard())
{
//Get the page
PageDTO dto = db.Pages.Find(id);
//Confirm page exists
if (dto == null)
{
return(Content("The page does not exists"));
}
//init PageVM
pageVM = new PageVM(dto);
}
//Return view with pageVM
return(View(pageVM));
}
public ActionResult PageDetails(int id)
{
//Declare the Page View model
AdminPagesVm model;
using (MyDb db = new MyDb())
{
//Get the Page using the Page Id
PageDTO dTO = db.Pages.Find(id);
//Confirm if the page necessarily exist
if (dTO == null)
{
return(Content("The Page requested does not exist"));
}
//Initialize the Page view model
model = new AdminPagesVm(dTO);
}
//Return the view with the model
return(View(model));
}
public ActionResult EditPage(int id)
{
//Declare page viewmodel
PageVM model;
using (Db db = new Db())
{
//get page
PageDTO dto = db.Pages.Find(id);
//confirm page exists
if (dto == null)
{
return(Content("Page does not exist!"));
}
//init pageVM
model = new PageVM(dto);
}
//return viewmodel
return(View(model));
}
public ActionResult PageDetails(int id)
{
// declare pagevm
PageViewModel model;
using (Db db = new Db())
{
// get the page
PageDTO dto = db.Pages.Find(id);
// confirm page exists
if (dto == null)
{
return(Content("The page does not exist."));
}
// init pagevm
model = new PageViewModel(dto);
}
//redirect
return(View(model));
}
// GET: Admin/Pages/PageDetails/id
public ActionResult PageDetails(int id)
{
// Declare PageVM
PageVM model;
using (Db db = new Db())
{
// Get the page
PageDTO dto = db.Pages.Find(id);
// Confirm page exists
if (dto == null)
{
return(Content("Stranica ne postoji!"));
}
// Init PageVM
model = new PageVM(dto);
}
// Return view with model
return(View(model));
}
public ActionResult PageDetails(int id)
{
//Declare PageVM
PageVM model;
using (Db db = new Db())
{
//Get the page
PageDTO dto = db.Pages.Find(id);
//Confirm page exits
if (dto == null)
{
return(Content("Page doesn't exitsts."));
}
//Init PageVM
model = new PageVM(dto);
}
return(View(model));
}
public ActionResult AddPage(PagesVM model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (Db db = new Db())
{
string slug;
PageDTO dto = new PageDTO();
dto.Title = model.Title;
if (string.IsNullOrWhiteSpace(model.Slug))
{
slug = model.Title.Replace(" ", "-").ToLower();
}
else
{
slug = model.Slug.Replace(" ", "-").ToLower();
}
if (db.Pages.Any(x => x.Title == model.Title) || db.Pages.Any(x => x.Slug == model.Slug))
{
ModelState.AddModelError("", "That slug or title already exist");
return(View(model));
}
dto.Slug = slug;
dto.Body = model.Body;
dto.Sorting = model.Sorting;
dto.HasSidebar = model.HasSidebar;
db.Pages.Add(dto);
db.SaveChanges();
}
TempData["SM"] = "You have added a new page!";
return(RedirectToAction("AddPage"));
}
public ActionResult EditPage(PageViewModel model)
{
if (!ModelState.IsValid)
{
return(View());
}
using (Context context = new Context())
{
int id = model.Id;
string slug;
PageDTO dto = context.Pages.Find(id);
dto.Title = model.Title;
if (model.Slug != "home")
{
if (string.IsNullOrWhiteSpace(model.Slug))
{
slug = model.Title.Replace(" ", "-").ToLower();
}
else
{
slug = model.Slug.Replace(" ", "-").ToLower();
}
if (context.Pages.Where(p => p.Id != id).Any(p => p.Title == model.Title) || context.Pages.Where(p => p.Id != id).Any(p => p.Slug == model.Slug))
{
ModelState.AddModelError(" ", "That Title or Slug already exists.");
return(View(model));
}
dto.Slug = slug;
dto.Body = model.Body;
dto.HasSidebar = model.HasSidebar;
}
context.SaveChanges();
}
TempData["SM"] = "You have edited the page!";
return(RedirectToAction("EditPage"));
}
public ActionResult AddPage(PageVM model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (DB db = new DB())
{
string slug;
PageDTO dto = new PageDTO();
dto.Title = model.Title;
if (string.IsNullOrWhiteSpace(model.Slug))
{
slug = model.Title.Replace(" ", "-").ToLower();
}
else
{
slug = model.Slug;
}
if (db.Pages.Any(x => x.Title == dto.Title) || db.Pages.Any(x => x.Slug == slug))
{
ModelState.AddModelError("", "Title/Slug Already Exists");
return(View(model));
}
dto.Slug = slug;
dto.Body = model.Body;
dto.HasSidebar = model.HasSidebar;
dto.Sorting = 100;
db.Pages.Add(dto);
db.SaveChanges();
}
TempData["SM"] = "Success Fully Added";
return(RedirectToAction("Index"));
}
// GET: Admin/Pages/PageDetails/id
public ActionResult PageDetails(int id)
{
//Declare PageVM
PageVM model;
using (Db db = new Db())
{
//Get the Page
PageDTO dto = db.Pages.Find(id);
//Check for the page
if (dto == null)
{
return(Content("The Page does not exsists."));
}
//Initialize the pageVM
model = new PageVM(dto);
}
//Return the View with Model
return(View(model));
}
public ActionResult BrandView(int brandId = 0)
{
try
{
SupplierBrandModel model = new SupplierBrandModel();
SupplierBrandBLL supplierBLL = new SupplierBrandBLL();
model = supplierBLL.GetBrandById(brandId);
var page = new PageDTO()
{
PageIndex = PageNo, PageSize = int.MaxValue
};
PageOf <StoreModel> storeList = supplierBLL.GetStoreListByBrandId(brandId, 0, LanguageEnum.TraditionalChinese, page);
ViewBag.Brand = model;
ViewBag.StoreList = storeList;
return(View());
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(View());
}
public ActionResult PageDetail(int id)
{
// declare pagevm
PageVM model;
using (Db db = new Db())
{
//get the page and id is primary key
PageDTO dto = db.Pages.Find(id);
//confirm page exist
if (dto == null)
{
return(Content("This Page does not exists"));
}
// Init pageVm
model = new PageVM(dto);
}
//return view with model
return(View(model));
}
public PageOf <PromotionSkuListModel> GetSpuulierSkus(int supplierId, string productName, PageDTO page)
{
return(_dal.GetSpuulierSkus(supplierId, productName, page));
}
public PageOf <PromotionListModel> GetPromotionList(int supplierId, PromotionQuery query, PageDTO page)
{
return(_dal.GetPromotionList(supplierId, query, page));
}
public bool AddUpdatePage([FromBody] PageDTO dto)
{
return(_dataAPI.AddUpdatePage(dto));
}
public PageOf <RefundInfoModel> GetRefundOrderList(RefundQueryInfo queryInfo, PageDTO page, LanguageEnum languageVersion, int receiptCountry)
{
return(dal.GetRefundOrderList(queryInfo, page, languageVersion, receiptCountry));
}
public async Task <IActionResult> GetAllMoviesAsync([FromQuery] PageDTO pageDTO)
{
var nm = await _movieService.GetAllMoviesAsync(pageDTO);
return(Ok(nm));
}
public PageOf <StoreModel> GetStoreListByBrandId(int brandId, int areaId, LanguageEnum languageEnum, PageDTO page)
{
var query = @" (SELECT s.Id
,s.BrandId
,s.AreaId
,p.ProvinceName as AreaName
,s.AddressCN
,s.AddressEN
,s.AddressHK
,s.Status
FROM Store s(nolock) inner join Province p(nolock) on s.AreaId = p.ProvinceId and p.LanguageVersion=@LanguageVersion
WHERE s.BrandId=@BrandId and s.Status=1";
if (areaId > 0)
{
query += " and s.AreaId=@AreaId";
}
query += ") pp ";
string sql = string.Format(@" select * from (select ROW_NUMBER() OVER(order by pp.Id desc) AS RowNum,* from {0}
) as A where A.RowNum BETWEEN (@PageIndex-1)* @PageSize+1 AND @PageIndex*@PageSize ORDER BY RowNum;" ,
query);
sql += string.Format(@" SELECT COUNT(1) FROM {0};", query);
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("BrandId", brandId);
parameters.Append("AreaId", areaId);
parameters.Append("LanguageVersion", (int)languageEnum);
parameters.Append("PageIndex", page.PageIndex);
parameters.Append("PageSize", page.PageSize);
DataSet ds = db.ExecuteSqlDataSet(sql, parameters);
return(new PageOf <StoreModel>()
{
PageIndex = page.PageIndex,
PageSize = page.PageSize,
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]),
Items = DataMapHelper.DataSetToList <StoreModel>(ds)
});
}
public PageDTO SavePage(PageDTO dto)
{
return(QuestionnaireAdminDataManager.Instance.SavePage(dto));
}
public IEnumerable <Movie> GetAllMovies(PageDTO page)
{
return(_movieRepository.GetMoviesByPagination(page.Index, page.PageSize, page.Filter));
}
