internal async Task <JsonResult> PickSetupAll(PickSetup setup)
{
SqlConnection cn = null;
try
{
DataTable dt = new DataTable();
cn = Connection.GetConnection();
if (setup.flag == "select")
{
SqlDataAdapter da = new SqlDataAdapter("select 'True' as [condition], min_bin from pick_setup", cn);
da.Fill(dt);
}
else if (setup.flag == "update")
{
SqlDataAdapter da = new SqlDataAdapter("update pick_setup set min_bin = " + setup.NoOfBin + ";select 'True' as [condition], min_bin from pick_setup", cn);
da.Fill(dt);
}
return(new JsonResult(dt));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
public async Task <JsonResult> PickSetupAll([FromBody] PickSetup setup)
{
try
{
return(await _PickLogic.PickSetupAll(setup).ConfigureAwait(false));
}
catch (Exception ee)
{
return(await _PickLogic.SendRespose("False", ee.Message).ConfigureAwait(false));
}
}
