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); }