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