private TableReturn SavePickList(PickListResponseDto pickListInsert, string transcationType) { List <SqlParameter> parms = new List <SqlParameter> { new SqlParameter { ParameterName = PickListStoredProcedure.StoredProcedureParameters[0].ToString(), Value = pickListInsert.PickListNo.AsDbValue() }, new SqlParameter { ParameterName = PickListStoredProcedure.StoredProcedureParameters[1].ToString(), Value = transcationType.AsDbValue() }, new SqlParameter { ParameterName = PickListStoredProcedure.StoredProcedureParameters[2].ToString(), Value = pickListInsert.AssignedUserId.AsDbValue() }, new SqlParameter { ParameterName = PickListStoredProcedure.StoredProcedureParameters[3].ToString(), Value = pickListInsert.LastSentDeviceId.AsDbValue() }, new SqlParameter { ParameterName = PickListStoredProcedure.StoredProcedureParameters[4].ToString(), TypeName = PickListStoredProcedure.StoredProcedureTypeNames[0].ToString(), SqlDbType = SqlDbType.Structured, Value = pickListInsert.PickListDetail.ToList().ToDataTable() }, }; return(_tcContext.Set <TableReturn>().FromSqlRaw(PickListStoredProcedure.Sql, parms.ToArray()).AsEnumerable().FirstOrDefault()); }
public ActionResult DeletePickList(PickListResponseDto pickList) { var request = _pickListRepository.DeletePickList(pickList); if (request.Reason == "OK") { return(new JsonErrorResult(new { Message = request.OutValue }, HttpStatusCode.OK)); } else { return(new JsonErrorResult(new { Message = request.OutValue }, HttpStatusCode.BadRequest)); } }
public bool AddPickList(PickListResponseDto pickListInsert) { var result = SavePickList(pickListInsert, TransactionTypes.Insert.ToString()); if (result.OutValue == "NOK") { throw new ServiceException(new ErrorMessage[] { new ErrorMessage() { Code = string.Empty, Message = $"Unable to create picklist" } }); } else { return(true); } }
public TableReturn UpdatePickList(PickListResponseDto pickListUpdate) { pickListUpdate.PickListDetail = new List <PickListResponseDetailDto>(); return(SavePickList(pickListUpdate, TransactionTypes.Update.ToString())); }
public TableReturn DeletePickList(PickListResponseDto pickListDelete) { return(SavePickList(pickListDelete, TransactionTypes.Delete.ToString())); }
public async Task <ActionResult> AddPickList(PickListResponseDto pickList) { return(Ok(_pickListRepository.AddPickList(pickList))); }