//[OutputCache(Duration = 60)] public ActionResult Categories() { string conString = "Data Source=VKT-TAYLANA\\SQLEXPRESS;Initial Catalog=BlogWebSystem;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection connection = new SqlConnection(conString); if (connection.State == ConnectionState.Closed) { connection.Open(); } string listQuery = "SELECT * FROM Category"; SqlCommand list = new SqlCommand(listQuery, connection); SqlDataReader reader = list.ExecuteReader(); List <Models.CategoryModel> Categorymodel = new List <Models.CategoryModel>(); Models.CategoryModel item; while (reader.Read()) { item = new Models.CategoryModel(); item.CategoryId = Convert.ToInt32(reader["CategoryId"]); item.CategoryName = reader["CategoryName"].ToString(); item.CategoryDesc = reader["CategoryDesc"].ToString(); Categorymodel.Add(item); } connection.Close(); reader.Close(); return(View(Categorymodel)); }
public async Task <IHttpActionResult> create(Models.CategoryModel model) { if (!ModelState.IsValid) { return(Json(new { error = true, message = Models.ErrorMessage.getErrorMessage(ModelState) })); } Boolean result = true; try { Category category = new Category(); category.categoryName = model.categoryName; category.status = model.status; System.Web.HttpContext.Current.Application.Lock(); _db.Categories.Add(category); _db.SaveChanges(); System.Web.HttpContext.Current.Application.UnLock(); } catch (Exception e) { result = false; } return(Json(new { result = result })); }
public static CategoryEntity Load(Models.CategoryModel model) { return(new CategoryEntity() { Name = model.Name, PartitionKey = Partition, RowKey = model.Id }); }
public ActionResult Manage(Models.CategoryModel category) { if (ModelState.IsValid || category.Mode == "D") { category.Save(); return(PartialView("_Category")); } return(PartialView("_Manage", category)); }
public static CategoryModel FromBusinessEntity(Business.Entities.Category businessEntity) { CategoryModel model = new Models.CategoryModel(); model.Id = businessEntity.ID; model.Code = businessEntity.Code; model.Description = businessEntity.Description; return(model); }
public async Task <IHttpActionResult> CreateisDuplicateName(Models.CategoryModel model) { Boolean result = false; var nowCategory = _db.Categories.Where(p => p.categoryName == model.categoryName).FirstOrDefault(); if (nowCategory == null) { result = true; } return(Json(new { result = result })); }
public ActionResult Edit(int id, FormCollection collection) { try { Models.CategoryModel categoryModel = new Models.CategoryModel(); UpdateModel(categoryModel); categoryRepository.UpdateCategory(categoryModel); return(RedirectToAction("Index")); } catch { return(View("EditCategory")); } }
public ActionResult PostCategory([FromBody, Bind("categoryString, categoryDescription, titleId")] Models.CategoryModel category) { if (!getRepo.TitleExists(category.TitleId)) { return(StatusCode(StatusCodes.Status406NotAcceptable)); } repo.CreateCategory(new Category { CategoryString = category.CategoryString, CategoryDescription = category.CategoryDescription, TitleId = category.TitleId, Rank = getRepo.GetNumberOfCategories(category.TitleId) + 1 }); repo.Save(); return(StatusCode(StatusCodes.Status202Accepted)); }
public ActionResult Create(ViewModels.CategoryCreateViewModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new EcommerceModel()) { var cat = new Models.CategoryModel { Name = model.Name, }; db.Categories.Add(cat); db.SaveChanges(); } return(RedirectToAction("Index")); }
/// <summary> /// Saves the full category model. /// </summary> /// <param name="model">The full model</param> public void Save(Models.CategoryModel model) { var category = db.Categories.FirstOrDefault(c => c.Id == model.Id); if (category == null) { category = new Data.Category() { Id = Guid.NewGuid() }; db.Categories.Add(category); model.Id = category.Id; } Module.Mapper.Map <Models.CategoryModel, Data.Category>(model, category); db.SaveChanges(); }
public ActionResult Create(CategoryViewModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new SkorModelDB()) { var cat = new Models.CategoryModel { CategoryName = model.CategoryName }; db.CategoriesTable.Add(cat); db.SaveChanges(); return(RedirectToAction("Index")); } }
public async Task <IHttpActionResult> update(Models.CategoryModel model) { if (!ModelState.IsValid) { return(Json(new { error = true, message = Models.ErrorMessage.getErrorMessage(ModelState) })); } Boolean result = true; try { System.Web.HttpContext.Current.Application.Lock(); DAL.Category nowCategory = _db.Categories.Where(p => p.id == model.id).FirstOrDefault(); nowCategory.categoryName = model.categoryName; nowCategory.status = model.status; _db.SaveChanges(); System.Web.HttpContext.Current.Application.UnLock(); } catch (Exception e) { result = false; } return(Json(new { result = result })); }
// GET: Category/Edit/5 public ActionResult Edit(int id) { Models.CategoryModel categoryModel = categoryRepository.GetCategoryByID(id); return(View("EditCategory", categoryModel)); }
public ActionResult ShowManageScreen(Models.ModelRequest categoryRequest) { Models.CategoryModel category = new Models.CategoryModel(categoryRequest); return(PartialView("_Manage", category)); }