/// <summary> /// This method is used to delete item data. /// </summary> /// <param name="unitOfWork">Object for Unit Of Work</param> /// <param name="model">Item model</param> /// <returns>It will return list of object</returns> public async Task <int> DeleteItem(IUnitOfWork unitOfWork, int id) { _param = new[] { SQLParameters.ID }; _columns = new object[] { id }; var parameter = MultiPurpose.AddParameters(_param, _columns); var result = unitOfWork.StoredProcedureCall.Single <int>(ProcedureNames.DELETE_ITEM_DATA, parameter); return(await Task.FromResult(result)); }
/// <summary> /// This method is used to edit item data. /// </summary> /// <param name="unitOfWork">Object for Unit Of Work</param> /// <param name="model">Item model</param> /// <returns>It will return list of object</returns> public async Task <int> EditItem(IUnitOfWork unitOfWork, Items model) { _param = new[] { SQLParameters.ID, SQLParameters.NAME, SQLParameters.DESCRIPRION, SQLParameters.PRICE }; _columns = new object[] { model.Id, model.Name, model.Descriprion, model.Price }; var parameter = MultiPurpose.AddParameters(_param, _columns); var result = unitOfWork.StoredProcedureCall.Single <int>(ProcedureNames.EDIT_ITEM_DATA, parameter); return(await Task.FromResult(result)); }
public async Task <ActionResult> DeleteItem([FromBody] int id) { var error = new List <Microsoft.AspNetCore.Mvc.ModelBinding.ModelError>(); var data = await _itemProcessor.DeleteItem(_unitOfWork, id); _data = JsonConvert.SerializeObject(data); _response = MultiPurpose.ReturnResponse(_data, error); return(Ok(_response)); }
public async Task <ActionResult> EditItem([FromBody] Items model) { var error = new List <Microsoft.AspNetCore.Mvc.ModelBinding.ModelError>(); if (ModelState.IsValid) { var data = await _itemProcessor.EditItem(_unitOfWork, model); _data = JsonConvert.SerializeObject(data); } else { error = ModelState.Where(a => a.Value.Errors.Count > 0).SelectMany(x => x.Value.Errors).ToList(); } _response = MultiPurpose.ReturnResponse(_data, error); return(Ok(_response)); }