/// <summary> /// Удаляет список товаров из БД /// </summary> /// <param name="request"></param> /// <returns></returns> public DefaultResponse RemoveOperatorGoodList(OperatorGoodRemoveRequest request) { var returnValue = new DefaultResponse(); _cnn.Open(); SqlCommand cmd = _cnn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "delete from goodlist where id=@id"; cmd.Parameters.AddWithValue("@id", request.OperatorGoodList); try { cmd.ExecuteNonQuery(); returnValue.ErrorCode = 0; returnValue.Message = string.Empty; } catch (Exception e) { returnValue.ErrorCode = 10; returnValue.Message = e.Message; } finally { _cnn.Close(); } return(returnValue); }
public JsonResult OperatorGoodListRemove(Int16 id) { DefaultResponse defaultResponse = new DefaultResponse(); try { OperatorGoodRemoveRequest operatorGoodRemoveRequest = new OperatorGoodRemoveRequest { OperatorGoodList = id }; HttpResponseMessage responseMessage = HttpClientService.PostAsync("api/values/RemoveOperatorGoodList", operatorGoodRemoveRequest).Result; if (responseMessage.IsSuccessStatusCode) { defaultResponse = responseMessage.Content.ReadAsAsync <DefaultResponse>().Result; if (defaultResponse.ErrorCode == 0 && string.IsNullOrEmpty(defaultResponse.Message)) { return(Json(new { success = true })); } return(Json(new { success = false, error = JsonConvert.SerializeObject(defaultResponse) })); } defaultResponse.ErrorCode = 10; defaultResponse.Message = "Ошибка удаления данных"; } catch (Exception ex) { defaultResponse.ErrorCode = 10; defaultResponse.Message = ex.Message; } return(Json(new { success = false, error = JsonConvert.SerializeObject(defaultResponse) })); }
public DefaultResponse RemoveOperatorPos(OperatorGoodRemoveRequest request) { return(_operatorGoodService.RemoveOperatorGoodList(request)); }