public bool validate_live_command_update(Model.ErrorData objErrorData)
{
int validateStatus = 0;
try
{
using (OracleConnection con = new DBConnection().getDBConnection())
{
using (OracleCommand command = con.CreateCommand())
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "CONFIG_PACKAGE.validate_live_command_update";
command.Parameters.Add("cm", OracleDbType.Varchar2, 50, objErrorData.machine, ParameterDirection.Input);
command.Parameters.Add("cm_command", OracleDbType.Varchar2, 50, objErrorData.command, ParameterDirection.Input);
command.Parameters.Add("dest_floor", OracleDbType.Int64, objErrorData.floor, ParameterDirection.Input);
command.Parameters.Add("dest_aisle", OracleDbType.Int64, objErrorData.aisle, ParameterDirection.Input);
command.Parameters.Add("dest_row", OracleDbType.Int64, objErrorData.floor_row, ParameterDirection.Input);
command.Parameters.Add("validate_status", OracleDbType.Int64, validateStatus, ParameterDirection.Output);
command.ExecuteNonQuery();
Int32.TryParse(Convert.ToString(command.Parameters["validate_status"].Value), out validateStatus);
}
}
}
catch (Exception errMsg)
{
Console.WriteLine(errMsg.Message);
}
return(validateStatus == 1);
}
public int inputIdCode(string inputId, ref Model.ErrorData errorData)
{
Func <string, Model.ErrorData, int> validateMovieId = (arg1, arg2) =>
{
if (string.IsNullOrWhiteSpace(arg1))
{
arg2.Errors = "Please enter a valid movie id";
return(-1);
}
else
{
try
{
int inputMovieId = Convert.ToInt32(inputId);
if (inputMovieId < 0)
{
arg2.Errors = "The input Movie Id cannot be negative";
}
return(inputMovieId);
}
catch (Exception exception)
{
arg2.Errors = exception.Message;
return(-1);
}
}
};
return(validateMovieId(inputId, errorData));
}
public bool UpdateLiveCommandOfMachine(Model.ErrorData objErrorData)
{
bool bOk = false;
try
{
using (OracleConnection con = new DBConnection().getDBConnection())
{
OracleCommand command = con.CreateCommand();
string sql = "update L2_TRIGGER_COMMANDS set COMMAND ='" + objErrorData.command + "'"
+ " ,FLOOR =" + objErrorData.floor + " ,AISLE =" + objErrorData.aisle +
" ,FLOOR_ROW =" + objErrorData.floor_row + " ,DONE =" + (objErrorData.done ? 1 : 0)
+ " ,Q_ID =" + objErrorData.queueId
+ " ,SEQ_ID =" + objErrorData.seqId
+ " where MACHINE = '" + objErrorData.machine + "'";
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
bOk = true;
}
}
finally
{
}
return(bOk);
}
public bool UpdateLiveCommandOfMachine(Model.ErrorData objErrorData)
{
if (objErrorDaoService == null)
{
objErrorDaoService = new ErrorDaoImp();
}
return(objErrorDaoService.UpdateLiveCommandOfMachine(objErrorData));
}
public bool validate_live_command_update(Model.ErrorData objErrorData)
{
if (objErrorDaoService == null)
{
objErrorDaoService = new ErrorDaoImp();
}
return(objErrorDaoService.validate_live_command_update(objErrorData));
}
public bool UpdateLiveCommandOfCM(Model.ErrorData objErrorData)
{
bool isValidate = false;
bool isUpdated = false;
lock (triggerUpdateLock)
{
isValidate = validate_live_command_update(objErrorData);
if (isValidate)
{
isUpdated = UpdateLiveCommandOfMachine(objErrorData);
}
}
return(isUpdated);
}
public Model.ErrorData GetCommandOfActiveTrigger(string machine)
{
string query = "select TRIGGER_ID,MACHINE,COMMAND,FLOOR,AISLE,FLOOR_ROW,IS_TRIGGER,Q_ID from l2_trigger_commands where machine= '" + machine + "'"
+ " and done = 0 and is_trigger=1";
Int16 val = 0;
Model.ErrorData objErrorData = null;
try
{
using (OracleConnection con = new DBConnection().getDBConnection())
{
using (OracleCommand command = new OracleCommand(query))
{
command.CommandText = query;
command.Connection = con;
//int.TryParse(command.ExecuteScalar().ToString(), out val);
using (OracleDataReader dreader = command.ExecuteReader())
{
if (dreader.HasRows == true)
{
objErrorData = new Model.ErrorData();
objErrorData.machine = Convert.ToString(dreader["MACHINE"]);
objErrorData.command = Convert.ToString(dreader["COMMAND"]);
objErrorData.floor = int.Parse(Convert.ToString(dreader["FLOOR"]));
objErrorData.aisle = int.Parse(Convert.ToString(dreader["AISLE"]));
objErrorData.floor_row = int.Parse(Convert.ToString(dreader["FLOOR_ROW"]));
objErrorData.queueId = int.Parse(Convert.ToString(dreader["Q_ID"]));
}
}
}
}
}
catch (Exception errMsg)
{
Console.WriteLine(errMsg);
}
return(objErrorData);
}
