public void Update(InsertCategoryDTO entity, int id)
{
var cat = _unitOfWork.Category.Get(id);
if (!String.IsNullOrEmpty(entity.Name))
{
cat.Name = entity.Name;
}
_unitOfWork.Save();
}
public int Insert(InsertCategoryDTO entity)
{
var cat = new Category
{
Name = entity.Name
};
_unitOfWork.Category.Add(cat);
_unitOfWork.Save();
return(cat.Id);
}
public IActionResult Put(int id, [FromBody] InsertCategoryDTO dto)
{
try
{
_categoryService.Update(dto, id);
return(Ok("Succeffuly upated"));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public IActionResult Post([FromBody] InsertCategoryDTO dto)
{
try
{
_categoryService.Insert(dto);
return(Ok("Secceffuly creteed"));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ActionResult Edit(int id, IFormCollection collection)
{
try
{
var cat = new InsertCategoryDTO
{
Name = collection["Name"]
};
_categoryService.Update(cat, id);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public async Task <ExecuteResult> InsertCategory(InsertCategoryDTO category)
{
List <StoredProcedure> storedProcedures = new List <StoredProcedure>();
storedProcedures.Add(
DbUtil.StoredProcedureBuilder.WithSPName("mscategory_insert")
.AddParam(category.Name)
.AddParam(category.AuditedUserId)
.SP()
);
IEnumerable <ExecuteResultDTO> executeResults = await ExecSPWithTransaction <ExecuteResultDTO>(storedProcedures.ToArray());
return(executeResults.Select(x => new ExecuteResult
{
InstanceId = x.InstanceId,
}).FirstOrDefault());
}
public ActionResult Create(IFormCollection collection)
{
try
{
var category = new InsertCategoryDTO
{
Name = collection["Name"]
};
_categoryService.Insert(category);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public void Delete(InsertCategoryDTO entity)
{
throw new NotImplementedException();
}
