public MESSAGES_RMAGDC LoadByPrimaryKey(DBConnection Connection, int MESSAGE_RMAG_ID) { MESSAGES_RMAGDC objMESSAGES_RMAG = new MESSAGES_RMAGDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_MESSAGES_RMAGSLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_MESSAGE_RMAG_ID", DbType.Int32, MESSAGE_RMAG_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objMESSAGES_RMAG = FillObject(reader); return(objMESSAGES_RMAG); }
private int Insert(DBConnection Connection, MESSAGES_RMAGDC objMESSAGES_RMAG) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_MESSAGES_RMAGSInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_MESSAGE_RMAG_ID", DbType.Int32, objMESSAGES_RMAG.MESSAGE_RMAG_ID); dbCommandWrapper.AddInParameter("p_MESSAGE_ID", DbType.Int32, objMESSAGES_RMAG.MESSAGE_ID); dbCommandWrapper.AddInParameter("p_RMAG_ID", DbType.Int32, objMESSAGES_RMAG.RMAG_ID); if (Connection.Transaction != null) { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(insertCount); }
private MESSAGES_RMAGDC FillObject(DataRow row) { MESSAGES_RMAGDC objMESSAGES_RMAG = null; objMESSAGES_RMAG = new MESSAGES_RMAGDC(); objMESSAGES_RMAG.MESSAGE_RMAG_ID = (int)row["MESSAGE_RMAG_ID"]; objMESSAGES_RMAG.MESSAGE_ID = (int)row["MESSAGE_ID"]; objMESSAGES_RMAG.RMAG_ID = (int)row["RMAG_ID"]; objMESSAGES_RMAG.CREATED_ON = (DateTime)row["CREATED_ON"]; objMESSAGES_RMAG.CREATED_BY = (int)row["CREATED_BY"]; objMESSAGES_RMAG.MODIFIED_ON = (DateTime)row["MODIFIED_ON"]; objMESSAGES_RMAG.MODIFIED_BY = (int)row["MODIFIED_BY"]; objMESSAGES_RMAG.LOCK_COUNTER = row["LOCK_COUNTER"] == DBNull.Value ? null : (int?)row["LOCK_COUNTER"]; return(objMESSAGES_RMAG); }
public MESSAGES_RMAGDC LoadByPrimaryKey(int MESSAGE_RMAG_ID) { DBConnection objConnection = new DBConnection(); MESSAGES_RMAGDA objMESSAGES_RMAGDA = new MESSAGES_RMAGDA(); MESSAGES_RMAGDC objMESSAGES_RMAGDC = null; try { objConnection.Open(false); objMESSAGES_RMAGDC = objMESSAGES_RMAGDA.LoadByPrimaryKey(objConnection, MESSAGE_RMAG_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objMESSAGES_RMAGDC); }
private MESSAGES_RMAGDC FillObject(IDataReader reader) { MESSAGES_RMAGDC objMESSAGES_RMAG = null; if (reader != null && reader.Read()) { objMESSAGES_RMAG = new MESSAGES_RMAGDC(); objMESSAGES_RMAG.MESSAGE_RMAG_ID = (int)reader["MESSAGE_RMAG_ID"]; objMESSAGES_RMAG.MESSAGE_ID = (int)reader["MESSAGE_ID"]; objMESSAGES_RMAG.RMAG_ID = (int)reader["RMAG_ID"]; objMESSAGES_RMAG.CREATED_ON = (DateTime)reader["CREATED_ON"]; objMESSAGES_RMAG.CREATED_BY = (int)reader["CREATED_BY"]; objMESSAGES_RMAG.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"]; objMESSAGES_RMAG.MODIFIED_BY = (int)reader["MODIFIED_BY"]; objMESSAGES_RMAG.LOCK_COUNTER = reader["LOCK_COUNTER"] == DBNull.Value ? null : (int?)reader["LOCK_COUNTER"]; reader.Close(); reader.Dispose(); } return(objMESSAGES_RMAG); }
private int Update(DBConnection Connection, MESSAGES_RMAGDC objMESSAGES_RMAG) { int updateCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_MESSAGES_RMAGSUpdate"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_MESSAGE_RMAG_ID", DbType.Int32, objMESSAGES_RMAG.MESSAGE_RMAG_ID); dbCommandWrapper.AddInParameter("p_MESSAGE_ID", DbType.Int32, objMESSAGES_RMAG.MESSAGE_ID); dbCommandWrapper.AddInParameter("p_RMAG_ID", DbType.Int32, objMESSAGES_RMAG.RMAG_ID); dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objMESSAGES_RMAG.CREATED_ON); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objMESSAGES_RMAG.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objMESSAGES_RMAG.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objMESSAGES_RMAG.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objMESSAGES_RMAG.LOCK_COUNTER); if (Connection.Transaction != null) { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } if (updateCount == 0) { objMESSAGES_RMAG.IsDirty = IsDirty = true; } return(updateCount); }