internal async Task <ReturnMessage> ForceAssigment(ForcePickAssig forcePick) { SqlConnection cn = null; try { List <SendResponse> SignalRResponse = new List <SendResponse>(); cn = Connection.GetConnection(); SqlCommand smd = new SqlCommand("pick_force_assignment_create", cn) { CommandType = CommandType.StoredProcedure }; smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; smd.Parameters.Add("@focefulassigmentOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; smd.Parameters.AddWithValue("@pick_no", forcePick.PickNo); smd.Parameters.AddWithValue("@user_zone_list", ToDataTable(forcePick.ZoneWithPicker)); await smd.ExecuteNonQueryAsync().ConfigureAwait(false); string json = smd.Parameters["@jsonOutput"].Value.ToString(); string Signalrjson = smd.Parameters["@focefulassigmentOutput"].Value.ToString(); smd.Dispose(); if (Signalrjson.Length > 1) { SignalRResponse = JsonConvert.DeserializeObject <List <SendResponse> >(Signalrjson); } JArray arr = JArray.Parse(json); return(new ReturnMessage() { data = arr, sendResponse = SignalRResponse }); } catch (Exception) { throw; } finally { Connection.CloseConnection(ref cn); } }
public async Task <JsonResult> ForceAssigment([FromBody] ForcePickAssig forcePick) { try { ReturnMessage returnMessage = await _PickLogic.ForceAssigment(forcePick).ConfigureAwait(false); if (returnMessage.sendResponse.Count > 0) { foreach (SendResponse connectionId in returnMessage.sendResponse) { _hub.Clients.Client(connectionId.ConnectionID).SendAsync("forceassigment", connectionId); } } return(new JsonResult(returnMessage.data)); } catch (Exception ee) { return(await _PickLogic.SendRespose("False", ee.Message).ConfigureAwait(false)); } }