public bool UpdateEESCarData(int queueId, ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE carType)
{
bool bOk = false;
try
{
using (OracleConnection con = new DBConnection().getDBConnection())
{
using (OracleCommand command = con.CreateCommand())
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "UPDATE_EES_DETAILS_IN_QUEUE";
command.Parameters.Add("V_QUEUE_ID", OracleDbType.Int64, queueId, ParameterDirection.Input);
command.Parameters.Add("ARG_CAR_TYPE", OracleDbType.Int32, carType, ParameterDirection.Input);
command.ExecuteNonQuery();
bOk = true;
}
}
}
catch (Exception errMsg)
{
//Console.WriteLine(errMsg.Message);
}
return(bOk);
}
public bool UpdateEESCarData(int queueId, ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE carType)
{
if (objQueueDaoService == null)
{
objQueueDaoService = new QueueDaoImp();
}
return(objQueueDaoService.UpdateEESCarData(queueId, carType));
}
public ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE GetCarType(EESData objEESData)
{
bool lowerSensor = false;
bool midSensor = false;
lowerSensor = GetLowerHeightSensorStatus(objEESData);
midSensor = GetMidHeightSensorStatus(objEESData);
ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE carType = ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE.high;
if (lowerSensor && midSensor)
{
carType = ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE.low;
}
else if (!lowerSensor && midSensor)
{
carType = ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE.medium;
}
else if (!lowerSensor && !midSensor)
{
carType = ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE.high;
}
return(carType);
}
public ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE IsExitCarHigh(int queueId)
{
ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE carType = ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE.high;
try
{
using (OracleConnection con = new DBConnection().getDBConnection())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
OracleCommand command = con.CreateCommand();
string sql = "select car_type from L2_CUSTOMERS where EXIT_QUEUE_ID=" + queueId;
command.CommandText = sql;
command.CommandType = CommandType.Text;
carType = (ARCPMS_ENGINE.src.mrs.Global.GlobalValues.CAR_TYPE)Convert.ToInt16(command.ExecuteScalar());
}
}
finally
{
}
return(carType);
}
