public async Task <ActionResult> Edit(int id)
{
CodeRepository codeRepo;
CodeView view = new CodeView()
{
Code = new Code()
{
Active = true
}, CodeCategories = new List <CodeCategory>()
};
try
{
using (DBConnection dbc = new DBConnection(settings.Database.ConnectionString, logger))
{
codeRepo = new CodeRepository(settings, logger, dbc);
view.Code = await codeRepo.FindByPKView(new PrimaryKey()
{
Key = id, IsIdentity = true
});
view.CodeCategories = CodeCategory.GetList();
}
}
catch (Exception ex)
{
throw (Exception)Activator.CreateInstance(ex.GetType(), ex.Message + ex.StackTrace);
}
return(View("Edit", view));
}
public async Task <IActionResult> Edit(int id, [Bind("CategoryId,CategoryName")] CodeCategory codeCategory)
{
if (id != codeCategory.CategoryId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(codeCategory);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CodeCategoryExists(codeCategory.CategoryId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(codeCategory));
}
public async Task <ActionResult> Create(CodeView view)
{
CodeRepository codeRepo;
try
{
using (DBConnection dbc = new DBConnection(settings.Database.ConnectionString, logger))
{
codeRepo = new CodeRepository(settings, logger, dbc);
if (ModelState.IsValid)
{
await codeRepo.Add(view.Code);
return(RedirectToAction("Index", "Code"));
}
view.CodeCategories = CodeCategory.GetList();
return(View("Create", view));
}
}
catch (Exception ex)
{
throw (Exception)Activator.CreateInstance(ex.GetType(), ex.Message + ex.StackTrace);
}
}
public async Task <IActionResult> PutCodeCategory([FromRoute] int id, [FromBody] CodeCategory codeCategory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != codeCategory.CategoryId)
{
return(BadRequest());
}
_context.Entry(codeCategory).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CodeCategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Edit(Category entity)
{
UserLogin session = (UserLogin)Session[CommonConstants.USER_SESSION];
try
{
if (string.IsNullOrEmpty(entity.Name))
{
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
//entity.CreatedBy = session.UserID;
var model = new CodeCategory();
model.Update(entity);
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
catch (DbUpdateException ex)
{
ViewBag["Error"] = ex.Message;
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ViewBag["Error"] = ex.Message;
return(Json(new { Success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ProductCategory(int id, int page = 1, int pageSize = 4)
{
var productcategory = new CodeCategory().ViewDetail(id);
ViewBag.Category = productcategory;
int totalRecord = 0;
var model = new CodeProduct().ListProductCategory(id, ref totalRecord, page, pageSize);
//ViewBag.TagPost = new CodePost().ListPostCategory(id);
ViewBag.Total = totalRecord;
ViewBag.Page = page;
int maxPage = 4;
int totalPage = 0;
totalPage = (int)Math.Ceiling((double)(totalRecord / pageSize));
ViewBag.TotalPage = totalPage;
ViewBag.MaxPage = maxPage;
ViewBag.First = 1;
ViewBag.Last = totalPage;
ViewBag.Next = page + 1;
ViewBag.Prev = page - 1;
return(View(model));
}
public async Task <VmGenericServiceResult> Update(VmCodeCategoryItem vmCodeCategoryItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
CodeCategory r = await repo.Get(vmCodeCategoryItem.Id);
Copy <VmCodeCategoryItem, CodeCategory>(vmCodeCategoryItem, r);
if (r.UpdatedBy.IsNullOrEmpty())
{
r.UpdatedBy = "System";
}
repo.Update(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task Delete(int Id)
{
CodeCategory r = await repo.Get(Id);
r.IsActive = false;
repo.Update(r);
repo.Commit();
}
public void SetViewBag(long?ID = null)
{
//var model = new CodeCategory();
//ViewBag.CategoryID = new SelectList(model.ListAll(), "ID", "Name", ID);
var model = new CodeCategory();
IEnumerable <SelectListItem> userTypeList = new SelectList(model.ListAll(), "ID", "ID");
ViewData["CategoryList"] = userTypeList;
}
public async Task <IActionResult> Create([Bind("CategoryId,CategoryName")] CodeCategory codeCategory)
{
if (ModelState.IsValid)
{
_context.Add(codeCategory);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(codeCategory));
}
public async Task <IActionResult> PostCodeCategory([FromBody] CodeCategory codeCategory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.CodeCategory.Add(codeCategory);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCodeCategory", new { id = codeCategory.CategoryId }, codeCategory));
}
// GET: Admin/Category
public ActionResult Index()
{
try
{
var model = new CodeCategory();
var result = model.ListAllCategory(0);
return(View(result));
}
catch (Exception ex)
{
ViewData["Error"] = ex.Message;
return(View());
}
}
public async void Task4_Put_Update_Category_NoContentResult()
{
//Arrange
_context = new SDCContext(dbContextOptions);
_controller = new CodeCategoriesController(_context);
int newId = 21;
//Act
var category = new CodeCategory()
{
CategoryId = newId,
CategoryName = "Update Bedding"
};
var updatedData = await _controller.PutCodeCategory(newId, category);
//Assert
Assert.IsType <NoContentResult>(updatedData);
}
public JsonResult DataTableGet([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
var context = new ShopBanHangDbContext();
var model = new CodeCategory();
IQueryable <CategoryModel> query = model.ListAllCategory(0).AsQueryable();
var totalCount = query.Count();
// Apply filters
if (!string.IsNullOrEmpty(requestModel.Search.Value))
{
var value = requestModel.Search.Value.Trim();
query = query.Where(p => p.Name.Contains(value));
}
var filteredCount = query.Count();
// Sort
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
orderByString = orderByString == String.Empty ? "name asc" : orderByString;
query = query.OrderBy(orderByString);
// Paging
query = query.Skip(requestModel.Start).Take(requestModel.Length);
var data = query.Select(p => new
{
Id = p.ID,
Name = p.Name,
CreatedDate = p.CreatedDate.ToString("dd-MM-yyyy"),
UserName = p.UserName,
Action = "<br /><p class=\"btn-action\"><a href=\"#\" class=\"detail\"><i class=\"ui-tooltip fa fa-pencil-square-o detail\" style=\"font-size: 22px;\" data-original-title=\"Detail\"></i></a> <a href=\"#\" class=\"remove\" ><i class=\"ui-tooltip fa fa-trash-o remove\" style=\"font-size: 20px;\" data-original-title=\"Delete\" tooltip=\"Delete\"></i></a></p>",
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, filteredCount, totalCount), JsonRequestBehavior.AllowGet));
}
private async void Task5_Delete_Category_OkResult()
{
//Arrange
_context = new SDCContext(dbContextOptions);
_controller = new CodeCategoriesController(_context);
var category = new CodeCategory()
{
CategoryName = "New and Del Pickle",
};
//Act
var resultCreate = await _controller.PostCodeCategory(category);
var okResult = resultCreate.Should().BeOfType <CreatedAtActionResult>().Subject;
var resClient = okResult.Value.Should().BeAssignableTo <CodeCategory>().Subject;
int delId = resClient.CategoryId;
var result = await _controller.DeleteCodeCategory(delId);
//Assert
Assert.IsType <OkObjectResult>(result);
}
public async Task <ActionResult> Create()
{
CodeView view = new CodeView()
{
Code = new Code()
{
Active = true
},
CodeCategories = new List <CodeCategory>()
};
try
{
view.CodeCategories = CodeCategory.GetList();
}
catch (Exception ex)
{
throw (Exception)Activator.CreateInstance(ex.GetType(), ex.Message + ex.StackTrace);
}
return(await System.Threading.Tasks.Task.Run(() => View("Create", view)));
}
public VmGenericServiceResult Insert(VmCodeCategoryItem vmCodeCategoryItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
CodeCategory r = new CodeCategory();
Copy <VmCodeCategoryItem, CodeCategory>(vmCodeCategoryItem, r);
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
var repoEntity = repo.Get(vmCodeCategoryItem.Id);
if (repoEntity != null)
{
Exception ee = new Exception("Id is already existed!");
result.Error = ee;
}
else
{
result.Error = e;
}
}
return(result);
}
public async void Task3_Post_NewCategory_FindName()
{
//Arrange
_context = new SDCContext(dbContextOptions);
_controller = new CodeCategoriesController(_context);
var category = new CodeCategory()
{
CategoryName = "NewPickle",
};
//Act
var result = await _controller.PostCodeCategory(category);
//Assert
var okResult = result.Should().BeOfType <CreatedAtActionResult>().Subject;
var resClient = okResult.Value.Should().BeAssignableTo <CodeCategory>().Subject;
resClient.CategoryName.Should().Be("NewPickle");
//delete JayNew
int newId = _context.CodeCategory.FirstOrDefault(p => p.CategoryName == "NewPickle").CategoryId;
var resultDelete = await _controller.DeleteCodeCategory(newId);
}
public void Get()
{
CodeCategory codeCategory = DataRepository.CodeCategory.Get(1);
Assert.AreEqual("패티", codeCategory.Item);
}
public ActionResult Edit(int id)
{
var category = new CodeCategory().ViewDetail(id);
return(View(category));
}
public ActionResult Categories()
{
var model = new CodeCategory().ListAll();
return(View(model));
}
