static public int GetId(SqlCommand command, string fltsegment, string flightcode, string flighttime, string flightdate) { object o = DbUtility.ExecuteScalar(command, SP_flr_GetId, SqlHelper.BuildParameter("fltsegment", fltsegment), SqlHelper.BuildParameter("flightcode", flightcode), SqlHelper.BuildParameter("flighttime", flighttime), SqlHelper.BuildParameter("flightdate", flightdate)); if (o == null) { return(-1); } return((int)o); }