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));
}
}
