protected IrpEntity GetIRPFromReader(BaseEntity baseEntity, IDataReader reader) { if (!reader.IsClosed) { reader.Read(); int irpId = 0; try { pcs = Convert.ToInt32(reader["idnum"]); } catch { } try { IrpEntity irpEntity = new IrpEntity( baseEntity, irpId, reader["IRPFrom"].ToString().Trim(), reader["IRPSubject"].ToString().Trim(), reader["IRPText"].ToString().Trim(), reader["FlightNo"].ToString().Trim(), Convert.ToDateTime(reader["ArrivalDate"])); reader.Close(); reader.Dispose(); disConnect_dbcn_ExcuteReader(); return(irpEntity); } catch { IrpEntity irpEntity = new IrpEntity(); reader.Close(); reader.Dispose(); disConnect_dbcn_ExcuteReader(); return(irpEntity); } } else { IrpEntity irpEntity = new IrpEntity(); reader.Close(); reader.Dispose(); disConnect_dbcn_ExcuteReader(); return(irpEntity); } }
public string buildUpIRP(IrpEntity msgEntity, string msgType, string subType) { string strAWB = ""; strAWB = base.buildUpBase(msgEntity, msgType, subType); //strAWB += "SUBJ: " + msgEntity.msgSubject + "\r\n"; //strAWB += "FROM: " + msgEntity.msgFrom + "\r\n"; //strAWB += "TO: " + msgEntity.msgDestAddr + "\r\n"; strAWB += "Flight Number: " + msgEntity.flightNo + "\r\n"; strAWB += "Arrival Date: " + msgEntity.arrDate.ToShortDateString() + "\r\n"; strAWB += " \r\n"; strAWB += msgEntity.msgBody.ToUpper() + "\r\n"; strAWB += "\r\n"; return(strAWB); }