internal async Task <ReturnResponse> CloseTray(PickScan closetray)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("pick_close_tray", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.AddWithValue("@pick_no", closetray.PickNo);
smd.Parameters.AddWithValue("@tray", closetray.TrayNo);
smd.Parameters.AddWithValue("@email_id", closetray.EmailId);
smd.Parameters.AddWithValue("@location_id", closetray.LocationId);
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string json = smd.Parameters["@jsonOutput"].Value.ToString();
smd.Dispose();
ReturnResponse returnResponse = JsonConvert.DeserializeObject <ReturnResponse>(json);
return(returnResponse);
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
internal async Task <ReturnResponse> ProductImageMisMatch(PickScan pIMM)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("pick_image_mismatch", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.AddWithValue("@Barcode", pIMM.Barcode);
smd.Parameters.AddWithValue("@Bincode", pIMM.Bincode);
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string json = smd.Parameters["@jsonOutput"].Value.ToString();
smd.Dispose();
ReturnResponse returnResponse = JsonConvert.DeserializeObject <ReturnResponse>(json);
return(returnResponse);
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
internal async Task <ReturnResponse> ProductNotFound(PickScan pNF)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("pick_not_found", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.AddWithValue("@pick_no", pNF.PickNo);
smd.Parameters.AddWithValue("@pick_line_no", pNF.PickLineNo);
smd.Parameters.AddWithValue("@email_id", pNF.EmailId);
smd.Parameters.AddWithValue("@user_zone", pNF.UserZone);
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string json = smd.Parameters["@jsonOutput"].Value.ToString();
smd.Dispose();
ReturnResponse returnResponse = JsonConvert.DeserializeObject <ReturnResponse>(json);
return(returnResponse);
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
internal async Task <ReturnResponse> ScanBinBarcode(PickScan pickScan)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("pick_scan_bin_barcode", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.AddWithValue("@PickNo", pickScan.PickNo);
smd.Parameters.AddWithValue("@TrayNo", pickScan.TrayNo);
smd.Parameters.AddWithValue("@Barcode", pickScan.Barcode);
smd.Parameters.AddWithValue("@EmailId", pickScan.EmailId);
smd.Parameters.AddWithValue("@PickLineNo", pickScan.PickLineNo);
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string json = smd.Parameters["@jsonOutput"].Value.ToString();
smd.Dispose();
ReturnResponse returnResponse = JsonConvert.DeserializeObject <ReturnResponse>(json);
return(returnResponse);
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
public async Task <JsonResult> ScanBinBarcode([FromBody] PickScan pickScan)
{
try
{
List <ReturnResponse> returnResponse = new List <ReturnResponse>()
{
await _PickLogic.ScanBinBarcode(pickScan).ConfigureAwait(false)
};
if (returnResponse[0].barcode != null)
{
returnResponse[0].images = await _PickLogic.GetImage(returnResponse[0].barcode).ConfigureAwait(false);
}
return(new JsonResult(returnResponse));
}
catch (Exception ee)
{
return(await _PickLogic.SendRespose("False", ee.Message).ConfigureAwait(false));
}
}
